No CROSS JOIN in MS Access

For the upcoming jOOQ 3.3, we're now integrating support for the MS Access database through the JDBC-ODBC bridge, which is included in the JDK up until Java SE 7. Note that it will be removed in Java 8! Alternative access to access databases (pun intended) can be obtained through a hack involving ucanaccess, which is basically combining the … Continue reading No CROSS JOIN in MS Access

jOOQ Newsletter: February 12, 2014

Subscribe to the newsletter here Tweet of the Day Our followers, users and customers are shouting to the world. Here are: Breandan Considine who, thanks to jOOQ, has lost over ten pounds and can now write queries at the speed of thought! (He must have lost that weight because he forgot to eat while enjoying coding with … Continue reading jOOQ Newsletter: February 12, 2014

Why Everyone Hates Operator Overloading

... no, don't tell me you like Perl. Because you don't. You never did. It does horrible things. It makes your code look like... Perl made heavy use of operator overloading and used operators for a variety of things. A similar tendency can be seen in C++ and Scala. See also people comparing the two. … Continue reading Why Everyone Hates Operator Overloading

Java 8 Friday Goodies: Lambdas and SQL

At Data Geekery, we love Java. And as we're really into jOOQ's fluent API and query DSL, we're absolutely thrilled about what Java 8 will bring to our ecosystem. We have blogged a couple of times about some nice Java 8 goodies, and now we feel it's time to start a new blog series, the... … Continue reading Java 8 Friday Goodies: Lambdas and SQL

You’re Very Likely to Have Gotten SQL Date Time Arithmetic Wrong!

You're very likely to have gotten SQL date time arithmetic wrong. And why is that? Google it! You'll quickly find blog posts like these: Date / Time Arithmetic with Oracle 9 / 10 How does one add a day/hour/minute/second to a date value? Orace Date Arithmetic Tips And they're all advocating stuff like this: SYSDATE … Continue reading You’re Very Likely to Have Gotten SQL Date Time Arithmetic Wrong!

JDBC 4.0’s Lesser-known Clob.free() and Blob.free() Methods

When I talk about jOOQ at conferences, I always show this slide containing a bunch of very common JDBC mistakes that people often commit: Can you find the bugs? Some of them are obvious, such as: Line 4: Syntax errors resulting from bad concatenation on line 3 Line 7: Syntax errors and SQL injection risk … Continue reading JDBC 4.0’s Lesser-known Clob.free() and Blob.free() Methods