I know that with JDBC I can use directly specific db drivers, provided by the db manufacturer. How can I do this? There is any disadvantage to use Java JDBC instead C++ native libraries (e.g. performances)?
Originally posted by Andrea Cacciarru: I know that with JDBC I can use directly specific db drivers, provided by the db manufacturer. How can I do this? There is any disadvantage to use Java JDBC instead C++ native libraries (e.g. performances)?
Andrea, These aren't mutually exclusive. You can use a native library driver with JDBC.
Originally posted by Andrea Cacciarru: There is any disadvantage to use Java JDBC instead C++ native libraries (e.g. performances)?
Depends on the database, and possibly where the application is running relative to the database, and maybe other things.
For example, if you're using Oracle, and if your Java application is running on the database server (and nowhere else), and if you use the OCI driver (a C++ library with a Java wrapper) and if you connect to the database using IPC instead of TCP (assuming your DB's OS supports IPC), then and only then will your application be significantly faster, by eliminating a lot of networking-related overhead. (IPC is "inter-process communication). However, most people can't put their apps on the database server. For them, for Oracle, as of Oracle 9i the native driver isn't significantly faster than the pure Java driver, at least in common usage.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
