A quick look at the localtx wrapper begin() code looks like the only way to get an SQLException is if the driver throws it when you call con.setAutoCommit(false). Are you sure FileMakerPro supports transactions and setting autocommit off? If not you will have to use the NoTxConnectionManager with the LocalTx adapter.
If you get this working please submit your *-servie.xml file, I'll add it to the examples. thanks david jencks On 2002.12.16 01:00:50 -0500 Matthew Van Horn wrote: > Is there anyone out there that could give me a pointer or two towards > setting up Filemaker Pro as a DataSource in JBoss. > Please don't ask "Why Filemaker?", as I'm not too keen on using it > myself, but I have no choice. > Sorry for the long post, but maybe someone can give me a clue here as > to what I need to change. I don't really know what any of this means. > Thanks in advance, > Matt > > The stacktrace: > 14:56:54,991 WARN [TxCapsule] XAException: tx=XidImpl [FormatId=257, > GlobalId=mattvan.local.//0, BranchQual=] errorCode=XA_UNKNOWN(0) > javax.transaction.xa.XAException: Error trying to start local tx: > javax.resource.ResourceException: SQLException > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConne > ctionEventListener.start(LocalTxConnectionManager.java:506) > at org.jboss.tm.TxCapsule.startResource(TxCapsule.java:1232) > at org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:726) > at > org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:102) > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConne > ctionEventListener.enlist(LocalTxConnectionManager.java:320) > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:255) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:814) > at > org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(Loca > lDataSource.java:102) > at > viperfishenterprise.ATJ_CandidateBean.makeConnection(ATJ_CandidateBean.j > ava:112) > at > viperfishenterprise.ATJ_CandidateBean.setEntityContext(ATJ_CandidateBean > .java:80) > at > org.jboss.ejb.EntityEnterpriseContext.<init>(EntityEnterpriseContext.jav > a:76) > at > org.jboss.ejb.plugins.EntityInstancePool.create(EntityInstancePool.java: > 86) > at > org.jboss.ejb.plugins.AbstractInstancePool.get(AbstractInstancePool.java > :209) > at > org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanc > eInterceptor.java:78) > at > org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterce > ptor.java:79) > at > org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreatio > nInterceptor.java:44) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterce > ptor.java:111) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:178) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java: > 52) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor > .java:105) > at > org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129) > at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487) > at org.jboss.ejb.Container.invoke(Container.java:730) > at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382 > ) > at java.lang.reflect.Method.invoke(Native Method) > at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:236) > at sun.rmi.transport.Transport$1.run(Transport.java:147) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:143) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:491) > 14:56:55,240 WARN [TxCapsule] XAException: tx=XidImpl [FormatId=257, > GlobalId=mattvan.local.//0, BranchQual=] errorCode=XA_UNKNOWN(0) > javax.transaction.xa.XAException: wrong xid in commit: expected: null, > got: XidImpl [FormatId=257, GlobalId=mattvan.local.//0, BranchQual=1] > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConne > ctionEventListener.commit(LocalTxConnectionManager.java:548) > at org.jboss.tm.TxCapsule.commitResources(TxCapsule.java:1714) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:393) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:201) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java: > 52) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor > .java:105) > at > org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129) > at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487) > at org.jboss.ejb.Container.invoke(Container.java:730) > at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382 > ) > at java.lang.reflect.Method.invoke(Native Method) > at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:236) > at sun.rmi.transport.Transport$1.run(Transport.java:147) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:143) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:491) > > Here is the filemaker-service.xml file I cobbled together from the > examples: > (Mostly I just copied the MySQL example) > > <?xml version="1.0" encoding="UTF-8"?> > <server> > <mbean > code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" > name="jboss.jca:service=LocalTxCM,name=FilemakerDS"> > > <depends optional-attribute-name="ManagedConnectionFactoryName"> > <!--embedded mbean--> > <mbean code="org.jboss.resource.connectionmanager.RARDeployment" > name="jboss.jca:service=LocalTxDS,name=FilemakerDS"> > <attribute name="JndiName">FilemakerDS</attribute> > <attribute name="ManagedConnectionFactoryProperties"> > <properties> > <config-property name="ConnectionURL" > type="java.lang.String">jdbc:fmpro:http://192.168.1.2:8008</config- > property> > <config-property name="DriverClass" > type="java.lang.String">com.fmi.jdbc.JdbcDriver</config-property> > <config-property name="UserName" > type="java.lang.String"></config-property> > <config-property name="Password" > type="java.lang.String"></config-property> > </properties> > </attribute> > > <depends > optional-attribute- > name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss > LocalTransaction JDBC Wrapper</depends> > </mbean> > </depends> > > <depends optional-attribute-name="ManagedConnectionPool"> > <mbean > code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" > name="jboss.jca:service=LocalTxPool,name=MySqlDS"> > <attribute name="MinSize">0</attribute> > <attribute name="MaxSize">50</attribute> > <attribute name="BlockingTimeoutMillis">5000</attribute> > <attribute name="IdleTimeoutMinutes">15</attribute> > <attribute name="Criteria">ByContainer</attribute> > </mbean> > </depends> > > <depends > optional-attribute- > name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager > </depends> > <depends > optional-attribute- > name="JaasSecurityManagerService">jboss.security:service=JaasSecurityMan > ager</depends> > > <attribute > name="TransactionManager">java:/TransactionManager</attribute> > > <depends>jboss.jca:service=RARDeployer</depends> > </mbean> > </server> > > > > ------------------------------------------------------- > This sf.net email is sponsored by: > With Great Power, Comes Great Responsibility > Learn to use your power at OSDN's High Performance Computing Channel > http://hpc.devchannel.org/ > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
