Hello People,
I am using Jboss 2.4 with SQL Server with sun jdbcodbc driver and created
the pool no problems there. When i deploy a CMP enity 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 'Book' 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 'Book'.
Where Book is the name of the CMP-entity bean mentioned in xml descriptiors.
The same bean working with hypersonic database.Am I missing something int
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>
When i run the client this is what I get
javax.ejb.CreateException: Could not create entity:java.sql.SQLException:
[Micro
soft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Book'.
Need advice on this. What have I missed, what am I doing wrong. Could
somebody throw some light.
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
