[JBoss-user] Unusual datasource request

[Matthew Van Horn]

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