Hello People,
I have a problem related to SQL server and Jboss. Appreciate you time.
I have installed the driver for SQL server in jboss and created the pool no
problems there. When i deploy the a CMP-entity bean it is getting deployed,
but the server output doesnt show that the table is being created as it
should.
for example ==== [JAWS] Created table 'Booktb' successfully.
And when i run the client program it throws
javax.ejb.CreateException: Could not create entity:java.sql.SQLException:
[Micro
soft][ODBC SQL Server Driver][SQL Server]Invalid object name 'BookB'.
Where BookB is the name of the CMP-entity bean mentioned in xml
descriptiors.
The same bean is working with hypersonic database.Am I missing something in
the sql server setup.Here are the jaws.xml and stadardjaws.xml
***
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute name="PoolName">SQLServerPool</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="URL">jdbc:odbc:jboss</attribute>
<attribute name="JDBCUser">dbusername</attribute>
*****
<datasource>java:/SQLServerPool</datasource>
<type-mapping>MS SQLSERVER</type-mapping>
<debug>false</debug>
Need advice on this.
Thanks
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
