JDBC
-
Enterprise Java
Using the JDBC Insert Features in Oracle
Introduction In this article I will show an example of how to use the JDBC bulk insert features supported by…
Read More » -
Enterprise Java
How does the MySQL JDBC driver handle prepared statements
Prepared statement types While researching for the Statement Caching chapter in my High-Performance Java Persistence book, I got the chance…
Read More » -
Enterprise Java
Why you should always use connection pooling with Oracle XE
Introduction Oracle Express Edition is the free version of Oracle Enterprise Edition and its smaller size makes it very convenient…
Read More » -
Enterprise Java
Installing PostgreSQL PL/Java as a PostgreSQL Extension
In 2011 I wrote a series of articles on PostgreSQL PL/Java. The basic information is still solid but there is…
Read More » -
Core Java
What’s Even Harder Than Dates and Timezones? Dates and Timezones in SQL / JDBC!
There was an interesting discussion recently on the jOOQ mailing list about jOOQ’s current lack of out-of-the-box support for TIMESTAMP…
Read More » -
Enterprise Java
Let’s Review How to Insert Clob or Blob via JDBC
LOBs are a PITA in all databases, as well as in JDBC. Handling them correctly takes a couple of lines…
Read More » -
Enterprise Java
How to FlatMap a JDBC ResultSet with Java 8?
You’re not into the functional mood yet? Then the title might not resonate with you – but the article will!…
Read More » -
Enterprise Java
SELECT statements batch fetching with JDBC and Hibernate
Introduction Now that I covered Hibernate batch support for INSERT, UPDATE and DELETE statements, it’s time to analyze SELECT statements…
Read More » -
Enterprise Java
Hack up a Simple JDBC ResultSet Cache Using jOOQ’s MockDataProvider
Some queries shouldn’t hit the database all the time. When you query for master data (such as system settings, languages,…
Read More »
