Re: [JBoss-user] SQL Server and Jboss

[Edson Carlos Ericksson Richter]

Have you read %JBOSS_HOME%/log/server.log

??? At normal, there are very useful info about statements used to 
create table, does selects, inserts, updates and deletes...
(if not, see jaws docs about enable logging).

M2c,

Edson Richter



Razi Ansari wrote:

> 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
>
>




_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user