INET drivers need 4.10FIX version (info coming to me privately last week).
Use Minerva Pool for the moment(don't know if this version is downloadable)
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=SQLServerPool">
   <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute> <=== or org.minerva.blablabla for JBoss 2.2
   <attribute name="PoolName">SQLServerPool</attribute>
   <attribute name="URL">jdbc:inetdae7:localhost</attribute>
   <attribute name="JDBCUser">sa</attribute>
   <attribute name="Password"></attribute>
</mbean>

JDBC-ODBC have not enough implemented fetaures to be usable, if I am wrong I
would like to know someone that uses it...

Vincent.

> -----Message d'origine-----
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]De la part de Guy Laurent
> Envoy� : dimanche 8 juillet 2001 15:47
> � : [EMAIL PROTECTED]
> Objet : Re: [JBoss-user] [Microsoft][ODBC SQL Server Driver]Optional
> feature not implemented
>
>
> The server log follow for the error in the Subject field when
> using the ODBC
> bridge. Also, see below, I have changed the driver to the inet
> one. Still no
> luck but an error of a similar nature.
>
> [JAWS] java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional
> feature not implemented
> [JAWS]  at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
> [JAWS]  at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
> [JAWS]  at
> sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterNull(JdbcOdbc.java:922)
> [JAWS]  at
> sun.jdbc.odbc.JdbcOdbcPreparedStatement.setNull(JdbcOdbcPreparedSt
> atement.ja
> va:359)
> [JAWS]  at
> org.opentools.minerva.jdbc.PreparedStatementInPool.setNull(Prepare
> dStatement
> InPool.java:92)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCComma
> nd.java:28
> 0)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParamet
> ers(JDBCCr
> eateEntityCommand.java:165)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCComman
> d.java:159
> )
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JD
> BCCreateEn
> tityCommand.java:135)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAW
> SPersisten
> ceManager.java:122)
> [JAWS]  at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersis
> tenceManag
> er.java:207)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(Enti
> tyContaine
> r.java:639)
> [JAWS]  at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(
> EntitySync
> hronizationInterceptor.java:160)
> [JAWS]  at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityI
> nstanceInt
> erceptor.java:87)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT
> .java:135)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInter
> ceptorCMT.
> java:263)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT
> .java:86)
> [JAWS]  at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInter
> ceptor.jav
> a:164)
> [JAWS]  at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [JAWS]  at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(
> JRMPContai
> nerInvoker.java:369)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS]  at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [JAWS]  at java.security.AccessController.doPrivileged(Native Method)
> [JAWS]  at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransp
> ort.java:6
> 43)
> [JAWS]  at java.lang.Thread.run(Thread.java:484)
> [Bean Cache] Resized cache for bean Advert: old capacity = 1000, new
> capacity = 50
>
>
> I have defined that table in my jaxs.xml and im sure the jcml
> file is right.
> Those are also pasted below. Sorry for the amount of text.
>
> [JAWS] java.sql.SQLException: [GUY]Invalid object name 'ADVERT'.
> [JAWS]  at com.inet.tds.a.a(Unknown Source)
> [JAWS]  at com.inet.tds.b.do(Unknown Source)
> [JAWS]  at com.inet.tds.b.executeQuery(Unknown Source)
> [JAWS]  at com.inet.pool.b.executeQuery(Unknown Source)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementA
> ndHandleRe
> sult(JDBCQueryCommand.java:58)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCComman
> d.java:160
> )
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBC
> BeanExists
> Command.java:46)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JD
> BCCreateEn
> tityCommand.java:126)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAW
> SPersisten
> ceManager.java:122)
> [JAWS]  at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersis
> tenceManag
> er.java:207)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(Enti
> tyContaine
> r.java:639)
> [JAWS]  at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(
> EntitySync
> hronizationInterceptor.java:160)
> [JAWS]  at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityI
> nstanceInt
> erceptor.java:87)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT
> .java:135)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInter
> ceptorCMT.
> java:263)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT
> .java:86)
> [JAWS]  at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInter
> ceptor.jav
> a:164)
> [JAWS]  at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [JAWS]  at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(
> JRMPContai
> nerInvoker.java:369)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS]  at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [JAWS]  at java.security.AccessController.doPrivileged(Native Method)
> [JAWS]  at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransp
> ort.java:6
> 43)
> [JAWS]  at java.lang.Thread.run(Thread.java:484)
> [Advert] XAException: tx=XidImpl [FormatId=257, GlobalId=guy//0,
> BranchQual=] errorCode=XAER_NOTA
> [Advert] javax.transaction.xa.XAException: The Xid is not valid.(XidImpl
> [FormatId=257, GlobalId=guy//0, BranchQual=1]) resource
> manager:com.inet.tds.k@56f631
> [Advert]  at com.inet.tds.k.if(Unknown Source)
> [Advert]  at com.inet.tds.k.for(Unknown Source)
> [Advert]  at com.inet.tds.k.end(Unknown Source)
> [Advert]  at org.jboss.tm.TxCapsule.endResource(TxCapsule.java:1147)
> [Advert]  at org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:541)
> [Advert]  at
> org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.java:99)
> [Advert]  at
> org.opentools.minerva.jdbc.xa.XAConnectionFactory$2.closeConnectio
> n(XAConnec
> tionFactory.java:97)
> [Advert]  at
> org.opentools.minerva.jdbc.xa.XAConnectionFactory$2.connectionClos
> ed(XAConne
> ctionFactory.java:82)
> [Advert]  at com.inet.pool.c.a(Unknown Source)
> [Advert]  at com.inet.tds.k.a(Unknown Source)
> [Advert]  at com.inet.pool.a.close(Unknown Source)
> [Advert]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCComman
> d.java:180
> )
> [Advert]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBC
> BeanExists
> Command.java:46)
> [Advert]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JD
> BCCreateEn
> tityCommand.java:126)
> [Advert]  at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAW
> SPersisten
> ceManager.java:122)
> [Advert]  at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersis
> tenceManag
> er.java:207)
> [Advert]  at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
> [Advert]  at java.lang.reflect.Method.invoke(Native Method)
> [Advert]  at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(Enti
> tyContaine
> r.java:639)
> [Advert]  at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(
> EntitySync
> hronizationInterceptor.java:160)
> [Advert]  at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityI
> nstanceInt
> erceptor.java:87)
> [Advert]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT
> .java:135)
> [Advert]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInter
> ceptorCMT.
> java:263)
> [Advert]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT
> .java:86)
> [Advert]  at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInter
> ceptor.jav
> a:164)
> [Advert]  at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [Advert]  at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [Advert]  at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(
> JRMPContai
> nerInvoker.java:369)
> [Advert]  at java.lang.reflect.Method.invoke(Native Method)
> [Advert]  at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [Advert]  at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [Advert]  at java.security.AccessController.doPrivileged(Native Method)
> [Advert]  at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [Advert]  at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
> [Advert]  at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransp
> ort.java:6
> 43)
> [Advert]  at java.lang.Thread.run(Thread.java:484)
> [JAWS] java.sql.SQLException: [GUY]Invalid object name 'ADVERT'.
> [JAWS]  at com.inet.tds.a.a(Unknown Source)
> [JAWS]  at com.inet.tds.b.do(Unknown Source)
> [JAWS]  at com.inet.tds.b.executeQuery(Unknown Source)
> [JAWS]  at com.inet.pool.b.executeQuery(Unknown Source)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementA
> ndHandleRe
> sult(JDBCQueryCommand.java:58)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCComman
> d.java:160
> )
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBC
> BeanExists
> Command.java:46)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JD
> BCCreateEn
> tityCommand.java:126)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAW
> SPersisten
> ceManager.java:122)
> [JAWS]  at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersis
> tenceManag
> er.java:207)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(Enti
> tyContaine
> r.java:639)
> [JAWS]  at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(
> EntitySync
> hronizationInterceptor.java:160)
> [JAWS]  at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityI
> nstanceInt
> erceptor.java:87)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT
> .java:135)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInter
> ceptorCMT.
> java:263)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT
> .java:86)
> [JAWS]  at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInter
> ceptor.jav
> a:164)
> [JAWS]  at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [JAWS]  at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(
> JRMPContai
> nerInvoker.java:369)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS]  at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [JAWS]  at java.security.AccessController.doPrivileged(Native Method)
> [JAWS]  at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransp
> ort.java:6
> 43)
> [JAWS]  at java.lang.Thread.run(Thread.java:484)
> [JAWS] java.lang.RuntimeException: Unable to register with
> TransactionManager: javax.transaction.RollbackException: Already
> marked for
> rollback
> [JAWS]  at
> org.opentools.minerva.jdbc.xa.XAConnectionFactory.prepareObject(XA
> Connection
> Factory.java:279)
> [JAWS]  at
> org.opentools.minerva.pool.ObjectPool.getObject(ObjectPool.java:548)
> [JAWS]  at
> org.opentools.minerva.pool.ObjectPool.getObject(ObjectPool.java:521)
> [JAWS]  at
> org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoo
> lDataSourc
> e.java:165)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection(JDBCComm
> and.java:6
> 79)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCComman
> d.java:152
> )
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JD
> BCCreateEn
> tityCommand.java:135)
> [JAWS]  at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAW
> SPersisten
> ceManager.java:122)
> [JAWS]  at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersis
> tenceManag
> er.java:207)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(Enti
> tyContaine
> r.java:639)
> [JAWS]  at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(
> EntitySync
> hronizationInterceptor.java:160)
> [JAWS]  at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityI
> nstanceInt
> erceptor.java:87)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT
> .java:135)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInter
> ceptorCMT.
> java:263)
> [JAWS]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT
> .java:86)
> [JAWS]  at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInter
> ceptor.jav
> a:164)
> [JAWS]  at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [JAWS]  at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [JAWS]  at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(
> JRMPContai
> nerInvoker.java:369)
> [JAWS]  at java.lang.reflect.Method.invoke(Native Method)
> [JAWS]  at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS]  at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [JAWS]  at java.security.AccessController.doPrivileged(Native Method)
> [JAWS]  at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
> [JAWS]  at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransp
> ort.java:6
> 43)
> [JAWS]  at java.lang.Thread.run(Thread.java:484)
> [Advert] XAException: tx=XidImpl [FormatId=257, GlobalId=guy//0,
> BranchQual=] errorCode=XAER_NOTA
> [Advert] javax.transaction.xa.XAException: The Xid is not valid.(XidImpl
> [FormatId=257, GlobalId=guy//0, BranchQual=1]) resource
> manager:com.inet.tds.k@56f631
> [Advert]  at com.inet.tds.k.if(Unknown Source)
> [Advert]  at com.inet.tds.k.rollback(Unknown Source)
> [Advert]  at org.jboss.tm.TxCapsule.rollbackResources(TxCapsule.java:1557)
> [Advert]  at org.jboss.tm.TxCapsule.rollback(TxCapsule.java:412)
> [Advert]  at
> org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:88)
> [Advert]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInter
> ceptorCMT.
> java:307)
> [Advert]  at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT
> .java:86)
> [Advert]  at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInter
> ceptor.jav
> a:164)
> [Advert]  at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
> [Advert]  at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
> [Advert]  at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(
> JRMPContai
> nerInvoker.java:369)
> [Advert]  at java.lang.reflect.Method.invoke(Native Method)
> [Advert]  at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [Advert]  at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [Advert]  at java.security.AccessController.doPrivileged(Native Method)
> [Advert]  at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [Advert]  at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
> [Advert]  at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransp
> ort.java:6
> 43)
> [Advert]  at java.lang.Thread.run(Thread.java:484)
>
> The mlet for the DB pool using the inet driver.
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=KNET_JDBC"><attribute
> name="DataSourceClass">com.inet.tds.XDataSource</attribute>
>
> <attribute name="PoolName">KNET_JDBC</attribute>
>
> <attribute name="Properties">host=GUY; database=KNET</attribute>
>
> <attribute name="JDBCUser">sa</attribute>
>
> <attribute name="Password">sa</attribute>
>
> <attribute name="MinSize">0</attribute>
>
> <attribute name="MaxSize">2</attribute>
>
> <attribute name="GCEnabled">false</attribute>
>
> <attribute name="GCMinIdleTime">1200000</attribute>
>
> <attribute name="GCInterval">120000</attribute>
>
> <attribute name="InvalidateOnError">false</attribute>
>
> <attribute name="TimestampUsed">false</attribute>
>
> <attribute name="Blocking">true</attribute>
>
> <attribute name="LoggingEnabled">false</attribute>
>
> <attribute name="IdleTimeoutEnabled">false</attribute>
>
> <attribute name="IdleTimeout">1800000</attribute>
>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
>
> </mbean>
>
>
>
> My jaws.xml
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <jaws>
>
> <datasource>java:/KNET_JDBC</datasource>
>
> <type-mapping>MS SQLSERVER</type-mapping>
>
> <default-entity>
>
> <create-table>false</create-table>
>
> <remove-table>false</remove-table>
>
> </default-entity>
>
>
> <enterprise-beans>
>
> <entity>
>
> <ejb-name>Advert</ejb-name>
>
> <table-name>ADVERT</table-name>
>
> <create-table>false</create-table>
>
> <remove-table>false</remove-table>
>
> <cmp-field>
>
> <field-name>id</field-name>
>
> <column-name>ADREF</column-name>
>
> </cmp-field>
>
> <cmp-field>
>
> <field-name>advertReference</field-name>
>
> <column-name>ADVERT_REF</column-name>
>
> </cmp-field>
>
> <cmp-field>
>
> <field-name>title</field-name>
>
> <column-name>ADVERT_TITLE</column-name>
>
> </cmp-field>
>
> <cmp-field>
>
> <field-name>countryCode</field-name>
>
> <column-name>COUNTRYCODE</column-name>
>
> </cmp-field>
>
> <cmp-field>
>
> <field-name>media</field-name>
>
> <column-name>MEDIA</column-name>
>
> </cmp-field>
>
> <cmp-field>
>
> <field-name>datePlaced</field-name>
>
> <column-name>DATE_PLACED</column-name>
>
> </cmp-field>
>
> <cmp-field>
>
> <field-name>responseCount</field-name>
>
> <column-name>RESPONSES</column-name>
>
> </cmp-field>
>
> </entity>
>
> </enterprise-beans>
>
> </jaw>
>
>
> I really hope you can help. If theres anything you need please dont
> hesitate.
>
> Thanks alot!
>
> Guy
>
>
>
>
> ----- Original Message -----
> From: "danch" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, July 08, 2001 3:07 AM
> Subject: Re: [JBoss-user] [Microsoft][ODBC SQL Server Driver]Optional
> feature not implemented
>
>
> > It means you need a different JDBC driver 8^}) Grab one of the inet
> drivers.
> >
> > Seriously, if you look in the server.log there should be the full
> > exception stack trace from where things go wrong on the server. This
> > will tell us what that driver doesn't want to do.
> >
> > I assume this is either version 2.2.x of JBoss or 2.4?
> >
> > -danch
> >
> > Guy Laurent wrote:
> >
> > > Hello,
> > >
> > >
> > >
> > > I get this error when trying to create("") a CMP bean. If
> anybody knows
> > > what this is I would really appreciate help!
> > >
> > >
> > >
> > > Thanks Guy.
> > >
> > >
> > >
> > > javax.ejb.CreateException: Could not create
> > > entity:java.sql.SQLException: [Micro
> > > soft][ODBC SQL Server Driver]Optional feature not implemented
> > >         at
> > > sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Stream
> > > RemoteCall.java:245)
> > >         at
> > > sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:
> > > 220)
> > >         at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122)
> > >         at
> > > org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invokeHom
> > > e(Unknown Source)
> > >         at
> > > org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java
> > > :248)
> > >         at $Proxy0.create(Unknown Source)
> > >         at TestClient.main(TestClient.java:37)
> >
> >
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
> >
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

Reply via email to