Problem with configuring datasource for CMP 2.0 (Please repl

[kenryu]

hi;
I tried to use CMP with JBOSS 3.0 beta with MS SQL Server 2000 but when I do insert into the database using CMP Bean, it inserts into hypersonic database instead of MS SQL Server. I have used session bean accessing BMP bean to do the same and it works fine.
Below here is the configuration file (mssql2000-service.xml) :




ConnectionURL=jdbc:JSQLConnect://localhost:1433/test
userName = sa


DriverClass=com.jnetdirect.jsql.JSQLDriver

SQLServerDS
java:/TransactionManager


<depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory



MinSize=0
MaxSize=100
BlockingTimeoutMillis=5000
IdleTimeoutMinutes=30
CleanupIntervalMinutes=10
MaxIdleTimeoutPercent=1.0


org.jboss.resource.security.ManyToOnePrincipalMapping


userName=sa
password=

[resmai]

You need to write your own jbosscmp-jdbc.xml which overwrites then standardjbosscmp-jdbc.xml -Tag.

<jbosscmp-jdbc>

<!-- your datasource -->

<!-- default mapping from standardjbosscmp-jdbc.xml -->
<datasource-mapping>mySQL</datasource-mapping>

false


<enterprise-beans>
...
</enterprise-beans>
</jbosscmp-jdbc>

[kenryu]

hi;
Thank's , it's working now. The <datasource-mapping> is one of many problems that I have to figure out in order to get it works. But why I can still use <type-mapping> instead of <datasource-mapping> and still works fine????


^_^

[resmai]

It's just a way to customise to your database.
See~: http://www.jboss.org/online-manual/HTML/ch06s13.html