really nonduarable jms queue
Sorry for long post.
I'm new to JBoss, Firebird and Jaybird. I'm having problem making Jboss and
Jaybird work together.
My environment:
Win 2k, JBoss-4.0.DR2, Firebird 1.5, FirebirdJDBC1.5.0Beta3-1.4, jdk 1.4.
I have copied Firebirdsql.rar and firebird-ds.xml to deploy directory.
Below are snippets of jboss console log, standardjbosscmp-jdbc.xml, firebird-ds.xml.
17:54:01,655 INFO [ServiceConfigurator] Problem configuring service jboss.jca:service=ManagedConnectionPool,name=FirebirdDS org.jboss.mx.util.JBossNotCompliantMBeanException: Error parsing the XML file: at org.jboss.mx.metadata.JBossXMBean10.build(JBossXMBean10.java:117) at org.jboss.mx.metadata.XMLMetaData.build(XMLMetaData.java:270) at org.jboss.mx.modelmbean.XMBean.<init>(XMBean.java:262) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:909) at org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:297) at org.jboss.mx.server.MBeanServerImpl.createMBean(MBeanServerImpl.java:324) at org.jboss.system.ServiceCreator.install(ServiceCreator.java:130) at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:159) at org.jboss.system.ServiceConfigurator.processDependency(ServiceConfigurator.java:447) at org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.java:347) at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:187) at org.jboss.system.ServiceConfigurator.processDependency(ServiceConfigurator.java:447) at org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.java:347) at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:187) at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:116) at org.jboss.system.ServiceController.install(ServiceController.java:229) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172) at $Proxy6.install(Unknown Source) at org.jboss.deployment.SARDeployer.create(SARDeployer.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:272) at $Proxy24.create(Unknown Source) at org.jboss.deployment.XSLSubDeployer.create(XSLSubDeployer.java:486) at org.jboss.deployment.DeploymentInfo.create(DeploymentInfo.java:243) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1036) at $Proxy14.create(Unknown Source) at org.jboss.system.ServiceController.create(ServiceController.java:307) at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.deployment.MainDeployer.create(MainDeployer.java:748) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:593) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:558) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172) at $Proxy9.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405) at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:529) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:200) at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:273) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:233) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1036) at $Proxy1.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:401) at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172) at $Proxy6.start(Unknown Source) at org.jboss.deployment.SARDeployer.start(SARDeployer.java:227) at org.jboss.deployment.DeploymentInfo.start(DeploymentInfo.java:255) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1036) at $Proxy1.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:401) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:798) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:594) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:558) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:542) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45) at org.jboss.mx.server.Invocation.invoke(Invocation.java:70) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544) at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172) at $Proxy7.deploy(Unknown Source) at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:333) at org.jboss.system.server.ServerImpl.start(ServerImpl.java:241) at org.jboss.Main.boot(Main.java:165) at org.jboss.Main$1.run(Main.java:403) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NumberFormatException: For input string: "" at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at java.lang.Integer.valueOf(Unknown Source) at org.jboss.util.propertyeditor.IntegerEditor.setAsText(IntegerEditor.java:28) at org.jboss.mx.metadata.JBossXMBean10.convertValue(JBossXMBean10.java:531) at org.jboss.mx.metadata.JBossXMBean10.buildAttributeInfo(JBossXMBean10.java:452) at org.jboss.mx.metadata.JBossXMBean10.buildMBeanMetaData(JBossXMBean10.java:223) at org.jboss.mx.metadata.JBossXMBean10.build(JBossXMBean10.java:108) ... 148 more
further down
17:54:30,646 INFO [MainDeployer] Deployed package: file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-console.war/ 17:54:30,646 INFO [MainDeployer] Starting deployment of package: file:/G:/jboss-4.0.0DR2/server/default/deploy/web-console.war 17:54:30,646 ERROR [MainDeployer] Could not make local copy for file:/G:/jboss-4.0.0DR2/server/default/deploy/web-console.war java.io.FileNotFoundException: G:\jboss-4.0.0DR2\server\default\tmp\deploy\server\default\deploy\web-console.war\63.web-console.war (Access is denied) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(Unknown Source) at java.io.FileOutputStream.<init>(Unknown Source) at org.jboss.deployment.MainDeployer.copy(MainDeployer.java:1147)
some more
17:54:35,764 INFO [MainDeployer] Starting deployment of package: file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml
17:54:35,774 ERROR [URLDeploymentScanner] MBeanException: Incomplete Deployment listing:
Packages waiting for a deployer:
[{ 'jmx-ejb-adaptor.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/jmx-ejb-adaptor.jar/61.jmx-ejb-adaptor.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' SubDeployer: null }, { 'ejb-management.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/ejb-management.jar/62.ejb-management.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' SubDeployer: null }, { 'build.xml' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/build.xml/64.build.xml' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' SubDeployer: null }]
Incompletely deployed packages:
[{ 'jmx-ejb-adaptor.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/jmx-ejb-adaptor.jar/61.jmx-ejb-adaptor.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' SubDeployer: null }, { 'ejb-management.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/ejb-management.jar/62.ejb-management.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' SubDeployer: null }, { 'build.xml' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/build.xml/64.build.xml' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' SubDeployer: null }]
MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
{ objectName: jboss.system:service=DeploymentInfoURIResolver
state: CREATED
Waiting for me:
jboss.net:service=WS4EEDeployer state: CREATED
} org.jboss.system.ServiceContext@fd645de3,
{ objectName: jboss.net:service=WS4EEDeployer
state: CREATED
I am waiting for:
jboss.net:service=WebServiceEntityResolver state: RUNNING,
jboss.system:service=DeploymentInfoURIResolver state: CREATED,
jboss.net:service=Axis state: RUNNING
Waiting for me:
jboss.ejb:service=EJBDeployer state: CREATED
} org.jboss.system.ServiceContext@118ae5d0,
{ objectName: jboss.jca:service=TxCM,name=FirebirdDS
state: CONFIGURED
I am waiting for:
jboss.jca:service=CachedConnectionManager state: RUNNING,
jboss.jca:service=ManagedConnectionPool,name=FirebirdDS state: NOTCONFIGURABLE,
jboss.tm:service=TransactionManagerService state: RUNNING
} org.jboss.system.ServiceContext@c996c51b,
{ objectName: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS
state: NOTCONFIGURABLE
Waiting for me:
jboss.jca:service=TxCM,name=FirebirdDS state: CONFIGURED
} org.jboss.system.ServiceContext@2f6ee60c,
{ objectName: jboss.ejb:service=EJBDeployer
state: CREATED
I am waiting for:
jboss.net:service=WS4EEDeployer state: CREATED,
jboss:service=WebService state: RUNNING,
jboss.tm:service=TransactionManagerService state: RUNNING
Waiting for me:
jboss.ejb:service=ActivationSpecDeployer state: CREATED
} org.jboss.system.ServiceContext@17342155,
{ objectName: jboss.ejb:service=ActivationSpecDeployer
state: CREATED
I am waiting for:
jboss.ejb:service=EJBEntityResolver state: RUNNING,
jboss.jca:service=RaURIResolver state: RUNNING,
jboss.ejb:service=EJBDeployer state: CREATED
} org.jboss.system.ServiceContext@aaac0461,
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
[{ 'jmx-ejb-adaptor.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/jmx-ejb-adaptor.jar/61.jmx-ejb-adaptor.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' SubDeployer: null }, { 'ejb-management.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/ejb-management.jar/62.ejb-management.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' SubDeployer: null }, { 'build.xml' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/build.xml/64.build.xml' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' SubDeployer: null }]
Incompletely deployed packages:
[{ 'jmx-ejb-adaptor.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/jmx-ejb-adaptor.jar/61.jmx-ejb-adaptor.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/jmx-ejb-adaptor.jar' SubDeployer: null }, { 'ejb-management.jar' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/ejb-management.jar/62.ejb-management.jar' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/ejb-management.jar' SubDeployer: null }, { 'build.xml' URL: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' localURL: 'file:/G:/jboss-4.0.0DR2/server/default/tmp/deploy/server/default/deploy/build.xml/64.build.xml' watching: 'file:/G:/jboss-4.0.0DR2/server/default/deploy/build.xml' SubDeployer: null }]
MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
{ objectName: jboss.system:service=DeploymentInfoURIResolver
state: CREATED
Waiting for me:
jboss.net:service=WS4EEDeployer state: CREATED
} org.jboss.system.ServiceContext@fd645de3,
{ objectName: jboss.net:service=WS4EEDeployer
state: CREATED
I am waiting for:
jboss.net:service=WebServiceEntityResolver state: RUNNING,
jboss.system:service=DeploymentInfoURIResolver state: CREATED,
jboss.net:service=Axis state: RUNNING
Waiting for me:
jboss.ejb:service=EJBDeployer state: CREATED
} org.jboss.system.ServiceContext@118ae5d0,
{ objectName: jboss.jca:service=TxCM,name=FirebirdDS
state: CONFIGURED
I am waiting for:
jboss.jca:service=CachedConnectionManager state: RUNNING,
jboss.jca:service=ManagedConnectionPool,name=FirebirdDS state: NOTCONFIGURABLE,
jboss.tm:service=TransactionManagerService state: RUNNING
} org.jboss.system.ServiceContext@c996c51b,
{ objectName: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS
state: NOTCONFIGURABLE
Waiting for me:
jboss.jca:service=TxCM,name=FirebirdDS state: CONFIGURED
} org.jboss.system.ServiceContext@2f6ee60c,
{ objectName: jboss.ejb:service=EJBDeployer
state: CREATED
I am waiting for:
jboss.net:service=WS4EEDeployer state: CREATED,
jboss:service=WebService state: RUNNING,
jboss.tm:service=TransactionManagerService state: RUNNING
Waiting for me:
jboss.ejb:service=ActivationSpecDeployer state: CREATED
} org.jboss.system.ServiceContext@17342155,
standardjbosscmp-jdbc.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jbosscmp-jdbc> <!-- ===================================================================== --> <!-- --> <!-- Standard JBossCMP-JDBC Configuration --> <!-- --> <!-- ===================================================================== --> <!-- $Id: standardjbosscmp-jdbc.xml,v 1.59 2003/06/26 15:50:31 loubyansky Exp $ --> <jbosscmp-jdbc> <defaults> <datasource>java:/FirebirdDS</datasource> <datasource-mapping>FirebirdDS</datasource-mapping> <create-table>true</create-table> <remove-table>false</remove-table> ...... <type-mapping> <name>Firebird</name> <!-- For use with the Firebirdsql jca-jdbc driver. A version after Beta 1 is strongly recommended, this may involve building from cvs --> <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
firebird-ds.xml
<?xml version="1.0" encoding="UTF-8"?> <!-- ==================================================================== --> <!-- New ConnectionManager setup for firebird dbs using jca-jdbc xa driver--> <!-- Build jmx-api (build/build.sh all) and view for config documentation --> <!-- ==================================================================== --> <connection-factories> <!--FBManager can be used to create and drop databases. Drop is especially useful during testing, since it assures a clean start next time. --> <mbean code="org.firebirdsql.management.FBManager" name="jboss.jca:service=FirebirdManager"> <attribute name="FileName">g:/firebirddata/employee.fdb</attribute> <attribute name="UserName">sysdba</attribute> <attribute name="Password">masterkey</attribute> <attribute name="CreateOnStart">true</attribute> <attribute name="DropOnStop">false</attribute> </mbean> <tx-connection-factory> <jndi-name>FirebirdDS</jndi-name> <xa-transaction/> <adapter-display-name>Firebird Database Connector</adapter-display-name> <config-property name="Database">localhost/3050:g/FirebirdData/employee.fdb</config-property> <user-name>sysdba</user-name> <password>masterkey</password> <!--additional properties. only use one way of setting tx isolation, please <config-property name="TransactionIsolation"></config-property> <config-property name="TransactionIsolationName">TRANSACTION_READ_COMMITTED</config-property> <config-property name="BlobBufferLength"></config-property> <config-property name="Encoding">UNICODE_FSS</config-property> --> <min-pool-size>0</min-pool-size> </tx-connection-factory> </connection-factories>
