Jonathan Bruce's Blog

JDBC 4.0, and JDBC Performance at JavaOne 2004

I look forward to seeing many of you at JavaOne 2004, especially at our two talks that will cover JDBC 4.0 and how to maximize how the best performance with your JDBC enabled applications. Our session and BOF should give you an excellent opportunity to learn about the bleeding edge proposals and learn how to maximize your productivity with JDBC. A long time JDBC expert, and a good friend John Goodson from DataDirect Technologies will be joining me at these talks.

In this my first BLOG entry, I wanted to muse quickly on the challenges that face the JDBC developers. As an API that has been around since the early Java days, we are commited to bringing the wealth of language improvements introduced in J2SE 1.5 (Tiger) to benefit all developers. Exciting features such as Generics and Annotations finally give us the tools to take some of the drugery out of day to day JDBC applications.

I have also added the ability to post comments to this posting, so if there are things you'd like to hear about, particularily at our BOF, post a message below or drop me an email.

Until next time...

Comments

• Great, but...
  The stuff that's coming up in JDBC 4.0 looks great, but I'm still waiting for wider support for JDBC 3.0! For example, I'm stunned that there isn't a JDBC 3.0 driver from IBM!

  Don't get me wrong, there are JDBC 3.0 drivers out there for quite a lot of databases (searching on Sun's website revealed 30 drivers), but you have to pay for a sizable portion of them (DataDirect ARE excellent, but not exactly cheap)..

  Posted by: archangel on June 09, 2004 at 04:21 AM

• Great, but...
  IBM DB2 8.1 from fixpack 4 and beyond supports JDBC 3.0.

  Regards
  Lance

  Posted by: lancea on June 09, 2004 at 08:46 AM

• Layers
  Jonathon -- not sure if I can make it to the session or BOF, but will try! I happen to like JDBC, but what I see is a need for a standardized layer over it to make it a bit more developer-friendly.

  With competion from JDO, Hibernate, proposed EJB 3.0 stuff, and other persistence solutions, JDBC looks more complex in some ways (in addition to what the other poster mentioned in lack of driver support for new JDBC versions). And lots of people use JDBC in lots of different ways, some good, some bad.

  Simple O/R mapping, higher-level objects or DAOs, or some kind of abstraction layer is needed to mitigate the need for raw JDBC coding in 80% of JDBC apps. Best Practices and recommended layer libraries would be a great start.

  A recent article I saw attempted an implementation in Java of the PowerBuilder "DataWindow". Many people seemed to think it was a good idea. I haven't used it myself, but it looked interesting. Any kind of objects that make it easier to connect, create statements, do error-handling, and use/wrap the ResultSet would be helpful. Hope this helps!

  Posted by: gerryg on June 09, 2004 at 09:07 AM

• Layers
  Thank you for the feedback - I hope you will agree that we are on the right track in harmonizing the EoD thrust across a familiy of JSRs that include EJB, JAX-RPC and JAX-B and that my presentation at JavaOne will shed the appropriate amount of light to whet you appetite sufficiently.

  Posted by: jonbruce on June 09, 2004 at 03:15 PM

• Layers
  I'll put the session on my shortlist.

  What does EoD stand for? I know it only as End-of-Day.

  I work for a large organization (thousands) in a large IT department (150 or so), and while we have numerous Java apps and webapps, we have only 1 application using EJBs that I know of. We have a couple that use non-descriptor XML and one or two experimenting with Web Services to integrate with a new portal product we bought. In other words, I hope the presentation is really about JDBC, not EJBs and XML-related stuff. But I am glad that Java technologies are not being developed entirely in a vacuum.

  Posted by: gerryg on June 10, 2004 at 08:31 AM

• Layers
  Quick clarification per your request: EoD equates to Ease-of-Development.

  Posted by: jonbruce on June 10, 2004 at 08:34 AM

• Preview
  Will a preview of the upcoming features be available in the near future to those not able to attend Java One? The JSR itself does a very good job of outlining exactely what will be addressed, but would like to see "what you have so far".

  Posted by: rbijelonic on June 10, 2004 at 09:00 AM

• Hi,

  I have develop an unload tool in Java, but the performance is not good. I have 12 CPU and I use 3 thread, Java is slower than a single thread C app.

  I try optimize only for Oracle using Oracle object like Datum and process the conversion to JavaObject in the second thread, I manage double of rows but It is no good.

  I change some param from connection, statement etc.. I use byte instead int. ...

  Speed of C program is better than Java. You know an idea in order to improve my Java Unload Database Tool
  

  Posted by: barbyware on February 15, 2005 at 05:14 AM

This work is licensed under a Creative Commons License.