Re: LDBC driver

blueparty wrote:
http://ldbc.sourceforge.net/

Any experiences, opinions, anything to share ?

I don't see the advantage over JDBC.

They say that with JDBC,
# The SQL is different for each databases
# Every JDBC driver behaves differently
# Changes are required for each database
# No time to study all vendor documentation
# No time to test with all databases

However, with JDBC, and especially with JPA, much of the difference between vendors is already abstracted. Also, most products are designed to work with a single database engine; not as many are meant to plug into virtually any RDBMS, and those tend to be written with a generic SQL dialect in the first place.

Where RDBMSes differ the most is in DDL, which is generally outside the scope of the Java program and not such an issue there.

With modern data layers like Hibernate and other JPA solutions, the differences the program does care about are moved off into deployment descriptors. These guys achieve their "independence" by using the same restricted dialect of SQL as you'd use without LDBC if you were to try to be portable.

I can see a niche for it in those few products that are meant to plug into any database, maybe. But for my own work, no thank you. I'll stick with the standard approaches. Last thing I need in my alphabet soup is yet one more layer to go wrong on top of the gazillion layers of abstraction already in place.

--
Lew
.

Relevant Pages

  • Re: Mixing P/R philosophy with OO (within J2EE).
    ... I have observed the work of literally hundreds of Java developers. ... Treating a database like a mere "persistence storage mechanisms" is on ... JDBC - Never before in history were so many database API's ... Topmind, if you're reading this, isn't this a good example of OOP? ...
    (comp.object)
  • Re: What does everyone else do for graphically displaying data?
    ... JDBC API reference cover to cover a couple of times, ... you bind a data grid to a database table so that when you edit the ... put all JDBC code in the Model classes. ... Use something like Hibernate. ...
    (comp.lang.java.databases)
  • Re: how to practice JDBC programming?
    ... I am reading a book to learn JDBC. ... I do have a Oracle expression version installed in my Window XP. ... Oracle is one of the top database systems out there, and Oracle XE is supposed to be very, very easy to use. ... If I'm not mistaken, a sample schema is also installed, (maybe it's an install-option), and for practicing purposes, like jdbc training, it'd be very convenient. ...
    (comp.lang.java.programmer)
  • Re: What about a DBMS that wont be platform-specific
    ... This would be my first time doing this and the database is being ... There is no JDBC driver for Access. ... In Java, you can use databases which provide only ODBC drivers through the JDBC-ODBC ... Sun includes a JDBC-ODBC bridge with their standard distro, ...
    (comp.lang.java.databases)
  • Re: Problem with JDBC MSSQL
    ... >> JDBC from an applet. ... > classes and you can easily use another persistent storage instead of JDBC. ... > JDBC driver talks to the database. ...
    (comp.lang.java.databases)