Sun advises against using the JDBC-ODBC bridge
for production purposes.  Besides not being very
efficient, it is single-threaded.  But Microsoft
themselves have had problems getting their ODBC
driver to work in multi-threaded mode -- see the
knowledge base.  One supposed fix supplied by
Microsoft was to make the calls into the ODBC
driver synchronized.  Some possible alternatives
(no recommendation intended):
http://www.jboss.org/documentation/mssql.htm#INSTALL-DRIVER
http://www.weblogic.com/docs51/techstart/install_jmsq4.html
http://www.jturbo.com/products.html

-----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

Reply via email to