Im a newbie and Ive a problem when i try to connect to a SQL2000 server from my bean in
jboss. I get the error that the datasource is not bound.
My jbosscmp-jdbc.xml is as follows :
<jbosscmp-jdbc>
<defaults>
<datasource>MSSQLDS</datasource>
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
</defaults>
<enterprise-beans>
<entity>
<ejb-name>Plant</ejb-name>
<table-name>PLANT</table-name>
<cmp-field>
<field-name>PLANTID</field-name>
<column-name>PLANTID</column-name>
</cmp-field>
.
.
.
.
.
</entity>
</enterprise-beans>
</jbosscmp-jdbc>
Am I missing something here. Im not sure if the tag value is fully qualified MSSQLDS.
In the jboss-3.2.3\server\default\deploy\mssql-ds.xml I have,
<jndi-name>MSSQLDS</jndi-name>
<connection-url>
jdbc:microsoft:sqlserver://servername:1433;DatabaseName=somedb</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
Isnt that definition complete?
What more do I need to do ?
Any help would be greatly appreciated !
Thanx.
-Vinod