Could someone point me to some docs or an example on setting up a datasource for either oracle or sqlserver.? I am using JBoss 3.0 and my ejbs are picking up the default hsql driver.
I have created a sqlserver2000db-service.xml and added a the following to the standardjbosscmp-jdbc.xml.
java:/dbPool
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<time-out>300</time-out>
<pk-constraint>true</pk-constraint>
<fk-constraint>false</fk-constraint>
<row-locking>false</row-locking>
We using BMP instead of CMP. Any suggestions on how I may resolve this problem?
Thanks