Clever Geek Handbook

JBoss 3.2.2 and JDBC update

Moved many databases from SQL Server 2000 to 2008. One of the applications are on JBoss 3.2.2 and now they cannot connect to the database. Specific error: "Input Stream Tabular Data (TDS) Remote Procedure Call (RPC). Parameter 1 ("): Data type 0x38 is unknown. "I have been looking around for a while on Google search because I am using MS SQL Server 2000 driver for JDBC. and this driver will not work with MSSql Server 2008. It will connect but will not work.

So my question is how to get Jboss to use the new MSSql JDBC server driver version 2.

I'm not familiar with JBoss at all. The new driver comes with a JAR but I'm not sure how to tell JBoss to use that instead of the old driver.

Thank you in advance for your help.

+2


source to share


1 answer


Most often, in order for the JDBC driver class to be available to JBoss, the jar driver is copied into the lib

default server configuration directory (assuming you are working with the configuration, of course).



So in order for JBoss to use the new driver, remove the old jar from the directory lib

(if it doesn't look at running the script and finds where it was added to $ CLASSPATH from), replace it with the new driver, update your mssql-ds.xml if necessary (especially <connection-url>

and <driver-class>

, check driver documentation), restart Jboss.

+4


source






More articles:


All Articles