Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #161

Re: LDBC driver

Show all headers | View raw

  To: comp.lang.java.databases
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

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next — Next in thread | Find similar

Thread

Re: LDBC driver "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
  Re: LDBC driver "Silvio Bierman" <silvio.bierman@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
  Re: LDBC driver "Thomas Kellerer" <thomas.kellerer@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
    Re: LDBC driver "Silvio Bierman" <silvio.bierman@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
      Re: LDBC driver "Thomas Kellerer" <thomas.kellerer@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
        Re: LDBC driver "Silvio Bierman" <silvio.bierman@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
      Re: LDBC driver "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
        Re: LDBC driver "Silvio Bierman" <silvio.bierman@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000

csiph-web