I faced the problem also.
I cime back to using Minerva Pool DataSource instead of the inet one :
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="URL">jdbc:inetdae7:localhost</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="Password"></attribute>
etc...
</mbean>
This is for 2.4, on 2.2 change the package to minerva.
What remains a ? for me, it's that the doco explain it using inet
datasource.
BTW, have you a full license ? (I tried with the demo version, maybe a
problem...)
Have you tried 4.00 or previous versions ?
Have you strong relationships with the support to ask them the sources to
debug this problem ourselves, or ask them to look at the jboss code, I mean
they could have a return on investment,...
Vincent.
> -----Message d'origine-----
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]De la part de Mark
> Crowley
> Envoy� : mercredi 4 juillet 2001 20:01
> � : [EMAIL PROTECTED]
> Objet : [JBoss-user] CMP Entity Bean using Opta2000 Driver - Has Anyone
> got this to work???
>
>
> I and a number of other Opta2000 users are trying
> without success to create CMP Entity bean. The bean
> deploys correctly, the datasource starts happily and
> JBoss creates the necessary table (proving the
> datasource is setup and working correctly), but when
> ever the bean is accessed (for example using a finder
> method) the following exception is generated (looging
> has been turned on as well):
>
> [MSADictionary] [TDS Driver]XA_CONNECTION_GET
> [MSADictionary] SQL Server 7 unicode mode
> [MSADictionary] Single Server License
> [MSADictionary] Driver: i-net OPTA 2000 4.10
> [MSADictionary] Statement.close
> [MSADictionary] SELECT server,catalog,chartID FROM
> ChartData
> [MSADictionary] Statement.close
> [MSADictionary] [TDS Driver]XA_CONNECTION_FREE
> [MSADictionary] javax.transaction.xa.XAException: The
> Xid is not valid.(XidImpl [FormatId=257,
> GlobalId=ZEBEDEE//0, BranchQual=1]) resource
> manager:com.inet.tds.k@785d65
> [ChartData] XAException: tx=XidImpl [FormatId=257,
> GlobalId=ZEBEDEE//0, BranchQual=] errorCode=XAER_NOTA
> [ChartData] javax.transaction.xa.XAException: The Xid
> is not valid.(XidImpl [FormatId=257,
> GlobalId=ZEBEDEE//0, BranchQual=1]) resource
> manager:com.inet.tds.k@785d65
> [ChartData] at com.inet.tds.k.if(Unknown Source)
>
> We have been in touch with the tech-support for the
> driver who eventually came to the following
> conclusion:
>
> "The exception occurs because there is a rollback of
> the transaction with a specific XID but no transaction
> has been started. There seem be a bug in JBoss. JBoss
> is calling a rollback for a DT without starting a DT".
>
> I find it hard to believe there arent 1000's of people
> complaining about this, and therefore believe there is
> no bug, just a problem in my set up.
>
> My environment is
>
> OS: Win2K
> App Server: JBoss 2.2.2 with Tomcat 3.2.2
> JDBC: Opta2000 Tds driver 4.10
>
> Has anybody actually managed to get a CMP Entity bean
> working in JBoss with the Opta driver?
>
> Any thoughts, help, pointers would be much
> appreciated.
>
> Thanks in advance.
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
>
> _______________________________________________
> 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
