Generally speaking, the JDBC-ODBC bridge will significantly under perform
native JDBC drivers. I don't have any hard numbers, but I believe the
difference tends to be on an order of magnitude. That is, the JDBC-ODBC
drivers will perform on the order of 1/10th the speed of native JDBC
drivers.
You can find all sorts of JDBC drivers available here:
http://industry.java.sun.com/products/jdbc/drivers
Look specifically for type 4 drivers, as they will usually perform the best.
-dan
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Lin
Khanmamedov
Sent: Friday, June 08, 2001 9:22 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] any consequences to use JDBC_ODBC bridge?
Hi,
I am a beginner to JBoss. From the online doc, it is suggested not to use
JDBC-ODBC bridge. Does anyone know the reasons and possible consequences if
i use it? I try to use a MS SQL db with JDBC-ODBC bridge (that's the
required db and driver to use) Has anyone have such experience how to set it
up?
Any feedbacks are truly appreciated.
Thanks,
Lin
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
