Problems with XADatasource

[fstarsinic]

I'm trying to use SQLServer and creating an XADatasource. I'm not using any ejb's except a JMS Bean.

I am trying to use just plain old jdbc and not 2-phase commit jdbc. i'm noticing that some of my sql inserts are not getting committed. then when i add commit() methods to my code, i get messages that say i cannot do commit()s because of JDBC 2.0.

how can i somehow just do autocommit(true) kind of jdbc.
can i not use the XADatasource. is there some other kind i can use?
thanks,
frank

[fstarsinic]

ok, i answered my own question. instead of wanting to use an XADatasource i modified jboss.jcml to use a JDBCDataSource and now all my SQL code works again!!!

so, i'm using this...


org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

instead of this...


org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl


hope this helps someone else