Earlier this week, I've blogged about how to execute SQL batches with JDBC and jOOQ. This was useful for the MySQL, SQL Server, and Sybase users among you. Today, we'll discuss a slightly more difficult task, how to fetch Oracle 12c implicit cursors - which are essentially the same thing. What's an implicit cursor? Oracle … Continue reading How to Fetch Oracle 12c Implicit Cursors with JDBC and jOOQ
Tag: batch
How to Execute SQL Batches With JDBC and jOOQ
Some databases (in particular MySQL and T-SQL databases like SQL Server and Sybase) support a very nice feature: They allow for running a "batch" of statements in a single statement. For instance, in SQL Server, you can do something like this: -- Statement #1 DECLARE @table AS TABLE (id INT); -- Statement #2 SELECT * … Continue reading How to Execute SQL Batches With JDBC and jOOQ
jOOQ Newsletter: January 22, 2014
Subscribe to the newsletter here Tweet of the Day We are contributing this new section of the newsletter to our followers, users, and customers. Here are: Jose M. Arranz who has had plans to build jOOQ, when he happily discovered that jOOQ already exists https://twitter.com/jmarranz/status/417956223468982272 Majid Azimi who wishes for jOOQ to become the new de facto standard in all … Continue reading jOOQ Newsletter: January 22, 2014
What you Didn’t Know About JDBC Batch
In our previous blog post "10 Common Mistakes Java Developers Make When Writing SQL", we have made a point about batching being important when inserting large data sets. In most databases and with most JDBC drivers, you can get a significant performance improvement when running a single prepared statement in batch mode as such: PreparedStatement … Continue reading What you Didn’t Know About JDBC Batch
JDBC batch operations with jOOQ
So this was requested again, by another jOOQ user - support for an ancient JDBC feature - java.sql.Statement.addBatch(); With JDBC, you can easily execute several statements at once using the addBatch() method. Essentially, there are two modes in JDBC Execute several queries without bind values Execute one query several times with bind values With code, … Continue reading JDBC batch operations with jOOQ