Hello all!
I tried to use a datasource (SQL Server 2000) for my JBoss - and the result is this
error:
ObjectName: jboss.jca:service=DataSourceBinding,name=TEST
State: NOTYETINSTALLED
Depends On Me:
jboss.mq:service=PersistenceManager
Don't know, what's the problem. I put the msql-jdk2-service.xml in the correct
directory (deploy/jms), the 3 driver libs in the lib (for MSSQL 2000 there are 3 libs
necessary, not a single one) dir and I wrote the file for the database connections into
the deploy dir (the original hsqldb-ds.xml also is in the dir or even more errors
occure):
<xa-datasource>
<jndi-name>MSSQL2000XADS</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</xa-datasource-class>
<xa-datasource-property
name="ServerName">12.0.0.12</xa-datasource-property>
<xa-datasource-property
name="DatabaseName">TEST</xa-datasource-property>
<xa-datasource-property
name="SelectMethod">cursor</xa-datasource-property>
<xa-datasource-property
name="User">TEST</xa-datasource-property>
<xa-datasource-property
name="Password">test</xa-datasource-property>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional)
-->
<type-mapping>MS SQLSERVER2000</type-mapping>
</xa-datasource>
What's the problem here? Is it the server name? I wasn't sure what to insert
there, so I took the IP adress from the computer where the database is installed. Perhaps
this is the problem?
Please help - it's urgent and I've no idea...
Thanks
Benji
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4120371#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...