I downloaded the driver from Microsoft for JDBC connectivity to Win 2000 SQL server.
http://www.microsoft.com/sql/downloads/2000/jdbc.asp
I then added this to my jboss.jcml
The oracle 9i datasource connects fine but then hangs on the MS SQL datasource. I tested the connection as an alternate test using the ODBC driver. It connects fine so I know my database works ok and the URL is correct.
For those of you that don't know the double name in the URL is for a second instance. SQL 7 and 2000 are installed on the same machine.
It hangs with this
cheFactory
[INFO,JaasSecurityManagerService] startService, SecurityProxyFactory=org.jboss.s
ecurity.SubjectSecurityProxyFactory@b33d0a
[INFO,JaasSecurityManagerService] Started
[INFO,JdbcProvider] Starting
[INFO,JdbcProvider] Started
[INFO,MS SQLSERVER2000] Starting
[INFO,MS SQLSERVER2000] XA Connection pool MS SQLSERVER2000 bound to java:/MS SQ
LSERVER2000
I know that when my TNS listener is down I get the same sort of response from the OracleDS so I believe it can't find the machine. Anybody experience similar problems with SQL 2000??
Hope so and that you know how to fix it.
Thanks
Ron
------------------------------
com.microsoft.jdbc.sqlserver.SQLServerDriver,oracle.jdbc.driver.OracleDriver
-----------------------------
Then this for ORACLE
--------------------------------
OracleDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:thin:@(description=(address=(host=bmdrjawanda)(protocol=tcp)(port=1521))(connect_data=(sid=devdwh)))
1200000
developer
10
developer
false
false
false
true
120000
1800000
false
false
1.0
0
------------------------
And this for MS SQL
MS SQLSERVER2000
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:microsoft:sqlserver://bmdiwali2k//bmdiwali2k:1433;user=sa;password=bigboss;selectMethod=cursor
1200000
10
false
false
false
true
120000
1800000
false
false
1.0
0
---------------------
------------------