-
1. Re: persistence.xml does not deploy
wdfink May 27, 2012 7:54 AM (in response to ora7)Could you attach the ds.xml and the logfile?
-
2. Re: persistence.xml does not deploy
ora7 May 27, 2012 12:48 PM (in response to wdfink)I have read in the internet https://community.jboss.org/wiki/SetUpAFirebirdDatasource
it does not work to use the standard firebird-ds.xml simply to replace the rarname
<rar-name>firebirdsql.rar</rar-name>
to <rar-name>jaybird.rar</rar-name>
I use now this firebird-dx.xml. It is a solution for JBoss 4, also valid for version 6?
<?xml version="1.0" encoding="UTF-8"?>
<datasources><local-tx-datasource>
<jndi-name>TitanDS</jndi-name>
<connection-url>jdbc:firebirdsql:localhost/3050:titan</connection-url>
<driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
<user-name>SYSDBA</user-name>
<password>masterkey</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<track-statements></track-statements>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>Firebird</type-mapping>
</metadata></local-tx-datasource>
</datasources>This does deploy. What I can't tell is, if the data acces works.
I simple example have to test this would help me.
-
3. Re: persistence.xml does not deploy
wdfink May 29, 2012 4:52 AM (in response to ora7)I miss the persistence.xml and the logfile.
But does https://community.jboss.org/message/738332 helps?
-
4. Re: persistence.xml does not deploy
ora7 May 29, 2012 2:32 PM (in response to wdfink)It is only a warnig. I have removed the java prefix. The warning comes again.
20:24:19,847 WARN [org.jboss.profileservice.deployment.hotdeploy.HDScanner] Scan failed:
org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
DeployersImpl.java:1370DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "persistence.unit:unitName=physics.ear/physics-ejb.jar#physicsdb" is missing the following dependencies:
Dependency "jboss.jca:name=PhysicsDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=PhysicsDS,service=DataSourceBinding' **")
DEPLOYMENTS IN ERROR:
Deployment "jboss.jca:name=PhysicsDS,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jca:name=PhysicsDS,service=DataSourceBinding' **
at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(
) [:2.2.2.GA]
DeployersImpl.java:1316at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(
) [:2.2.2.GA]
MainDeployerImpl.java:968at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(
) [:2.2.2.GA]
MainDeployerPlugin.java:82at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.checkComplete(
) [:6.1.0.Final]
ProfileControllerContext.java:138at org.jboss.profileservice.dependency.ProfileControllerContext$DelegateDeployer.checkComplete(
) [:0.2.2]
HDScanner.java:246at org.jboss.profileservice.deployment.hotdeploy.HDScanner$HDScanAction.deploy(
) [:0.2.2]
HDScanner.java:192at org.jboss.profileservice.deployment.hotdeploy.HDScanner$HDScanAction.complete(
) [:0.2.2]
TwoPCActionWrapper.java:57at org.jboss.profileservice.management.TwoPCActionWrapper.doComplete(
) [:0.2.2]
AbstractTwoPhaseModificationAction.java:74at org.jboss.profileservice.management.actions.AbstractTwoPhaseModificationAction.complete(
) [:0.2.2]
AbstractTwoPhaseModificationAction.java:95at org.jboss.profileservice.management.actions.AbstractTwoPhaseModificationAction.prepare(
) [:0.2.2]
ModificationSession.java:87at org.jboss.profileservice.management.ModificationSession.prepare(
) [:0.2.2]
AbstractActionController.java:234at org.jboss.profileservice.management.AbstractActionController.internalPerfom(
) [:0.2.2]
AbstractActionController.java:213at org.jboss.profileservice.management.AbstractActionController.performWrite(
) [:0.2.2]
AbstractActionController.java:150at org.jboss.profileservice.management.AbstractActionController.perform(
) [:0.2.2]
at org.jboss.profileservice.management.AbstractActionController.perform(
AbstractActionController.java:135) [:0.2.2]
HDScanner.java:146at org.jboss.profileservice.deployment.hotdeploy.HDScanner.scan(
) [:0.2.2]
HDScanner.java:90at org.jboss.profileservice.deployment.hotdeploy.HDScanner.run(
) [:0.2.2]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [:1.7.0_04]
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source) [:1.7.0_04]
at java.util.concurrent.FutureTask.runAndReset(Unknown Source) [:1.7.0_04]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) [:1.7.0_04]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [:1.7.0_04]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [:1.7.0_04]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [:1.7.0_04]
at java.lang.Thread.run(Unknown Source) [:1.7.0_04]
physics-dx.xml content which is deployed
<?
?>
<!-- $Id: firebird-ds.xml 84886 2009-02-27 17:48:44Z scott.stark@jboss.org $ -->
<!-- ==================================================================== -->
<!-- New ConnectionManager setup for firebird dbs using jca-jdbc xa driver-->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- ==================================================================== -->
<
>
<!--FBManager can be used to create and drop databases.
Drop is especially useful during testing, since it
assures a clean start next time. -->
>
>
>
>
>
>
>
>
>
/>
<!-- uncomment to enable interleaving <interleaving/> -->
>
>
>
>
<!--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>
-->
>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
>
>
>
</
>
persistencex.xml content
<?
?>
<
"http://java.sun.com/xml/ns/persistence"
"http://www.w3.org/2001/XMLSchema-instance"
"http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
>
>
>
>
/>
/>
>
>
</
>
Thanks for Your patience.
-
5. Re: persistence.xml does not deploy
ora7 Jun 1, 2012 8:39 AM (in response to ora7)I changed in the persistence.xml
<?
?>
<
"http://java.sun.com/xml/ns/persistence"
"http://www.w3.org/2001/XMLSchema-instance"
"http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
>
>
>
>
/>
<!-- EntityManager-Zugriff per JNDI aktivieren -->
/>
/>
/>
>
>
</
>
I think the Firebird data acces does really not work. I must create the entity manager
manually. And I get a strange error message of Firebird:
Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long, error code: HY000
4:25:09,540 INFO [org.hibernate.impl.SessionFactoryImpl] building session factory
14:25:09,541 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [materialized_blob] overrides previous : org.hibernate.type.MaterializedBlobType@160e1337
14:25:09,541 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [clob] overrides previous : org.hibernate.type.ClobType@760f8b30
14:25:09,542 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [java.sql.Clob] overrides previous : org.hibernate.type.ClobType@760f8b30
14:25:09,542 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [wrapper_characters_clob] overrides previous : org.hibernate.type.CharacterArrayClobType@767b38dd
14:25:09,542 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [materialized_clob] overrides previous : org.hibernate.type.MaterializedClobType@13d271f0
14:25:09,542 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [wrapper_materialized_blob] overrides previous : org.hibernate.type.WrappedMaterializedBlobType@5d364dba
14:25:09,542 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [characters_clob] overrides previous : org.hibernate.type.PrimitiveCharacterArrayClobType@18291e25
14:25:09,542 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [blob] overrides previous : org.hibernate.type.BlobType@337a1b87
14:25:09,542 INFO [org.hibernate.type.BasicTypeRegistry] Type registration [java.sql.Blob] overrides previous : org.hibernate.type.BlobType@337a1b87
14:25:09,543 INFO [org.hibernate.impl.SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
14:25:09,544 INFO [org.hibernate.validator.engine.resolver.DefaultTraversableResolver] Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
14:25:09,547 INFO [org.hibernate.validator.engine.resolver.DefaultTraversableResolver] Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
14:25:09,548 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] Running hbm2ddl schema export
14:25:09,549 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] exporting generated schema to database
14:25:09,551 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null:
org.firebirdsql.jca.FBResourceException: Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long, error code: HY000Reason: Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long
at org.firebirdsql.jca.FBManagedConnection.<init>(
FBManagedConnection.java:91) [:2.1.6JDK_1.6 (build: CVSTag=Jaybird_2_1_6 date=200807191859)]at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(
FBManagedConnectionFactory.java:477) [:2.1.6JDK_1.6 (build: CVSTag=Jaybird_2_1_6 date=200807191859)]at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(
InternalManagedConnectionPool.java:648) [:6.1.0.Final]at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(
InternalManagedConnectionPool.java:272) [:6.1.0.Final]at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(
JBossManagedConnectionPool.java:747) [:6.1.0.Final]at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(
BaseConnectionManager2.java:403) [:6.1.0.Final]at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(
TxConnectionManager.java:414) [:6.1.0.Final]at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(
BaseConnectionManager2.java:496) [:6.1.0.Final]at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(
BaseConnectionManager2.java:941) [:6.1.0.Final]at org.firebirdsql.jdbc.FBDataSource.getConnection(
FBDataSource.java:95) [:2.1.6JDK_1.6 (build: CVSTag=Jaybird_2_1_6 date=200807191859)]at org.hibernate.connection.DatasourceConnectionProvider.getConnection(
DatasourceConnectionProvider.java:92) [:3.6.6.Final]at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(
SuppliedConnectionProviderConnectionHelper.java:51) [:3.6.6.Final]at org.hibernate.tool.hbm2ddl.SchemaExport.execute(
SchemaExport.java:263) [:3.6.6.Final]at org.hibernate.tool.hbm2ddl.SchemaExport.create(
SchemaExport.java:219) [:3.6.6.Final]at org.hibernate.impl.SessionFactoryImpl.<init>(
SessionFactoryImpl.java:372) [:3.6.6.Final]at org.hibernate.cfg.Configuration.buildSessionFactory(
Configuration.java:1872) [:3.6.6.Final]at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(
Ejb3Configuration.java:906) [:3.6.6.Final]at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(
HibernatePersistence.java:57) [:3.6.6.Final]at javax.persistence.Persistence.createEntityManagerFactory(
Persistence.java:48) [:1.0.0.Final]at javax.persistence.Persistence.createEntityManagerFactory(
Persistence.java:32) [:1.0.0.Final]at org.physics.PhysicistManagerRemote.<init>(
PhysicistManagerRemote.java:29) [:]at sun.reflect.NativeConstructorAccessorImpl.newInstance0(
Native Method) [:1.7.0_04]at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [:1.7.0_04]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [:1.7.0_04]
at java.lang.reflect.Constructor.newInstance(Unknown Source) [:1.7.0_04]
at java.lang.Class.newInstance0(Unknown Source) [:1.7.0_04]
at java.lang.Class.newInstance(Unknown Source) [:1.7.0_04]
at org.jboss.ejb3.instantiator.impl.Ejb31SpecBeanInstantiator.create(
Ejb31SpecBeanInstantiator.java:80) [:1.0.0-alpha-5]at org.jboss.ejb3.EJBContainer.construct(
EJBContainer.java:1048) [:1.7.21]at org.jboss.ejb3.stateless.StatelessContainer.createBeanContext(
StatelessContainer.java:123) [:1.7.21]at org.jboss.ejb3.pool.AbstractPool.createBeanContext(
AbstractPool.java:94) [:1.7.21]at org.jboss.ejb3.pool.AbstractPool.create(
AbstractPool.java:81) [:1.7.21]at org.jboss.ejb3.InfinitePool.get(
InfinitePool.java:62) [:1.7.21]at org.jboss.ejb3.InfinitePool.get(
InfinitePool.java:57) [:1.7.21]at org.jboss.ejb3.pool.ThreadlocalPool.create(
ThreadlocalPool.java:54) [:1.7.21]at org.jboss.ejb3.pool.ThreadlocalPool.get(
ThreadlocalPool.java:86) [:1.7.21]at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(
StatelessInstanceInterceptor.java:58) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.core.context.SessionInvocationContextAdapter.proceed(
SessionInvocationContextAdapter.java:95) [:1.7.21]at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInOurTx(
CMTTxInterceptor.java:247) [:0.0.2]at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.required(
CMTTxInterceptor.java:349) [:0.0.2]at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(
CMTTxInterceptor.java:209) [:0.0.2]at org.jboss.ejb3.tx2.aop.CMTTxInterceptorWrapper.invoke(
CMTTxInterceptorWrapper.java:52) [:0.0.2]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(
TxPropagationInterceptor.java:76) [:1.0.0.GA]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.tx.NullInterceptor.invoke(
NullInterceptor.java:42) [:1.0.4]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(
Ejb3AuthenticationInterceptorv2.java:182) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.ENCPropagationInterceptor.invoke(
ENCPropagationInterceptor.java:41) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(
BlockContainerShutdownInterceptor.java:67) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.core.context.CurrentInvocationContextInterceptor.invoke(
CurrentInvocationContextInterceptor.java:47) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(
CurrentInvocationInterceptor.java:67) [:1.0.1]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(
EJB3TCCLInterceptor.java:86) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(
StatelessContainer.java:392) [:1.7.21]at org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(
IsLocalInterceptor.java:88) [:1.7.21]at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(
IsLocalInterceptor.java:75) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.ejb3.async.impl.interceptor.AsynchronousClientInterceptor.invoke(
AsynchronousClientInterceptor.java:143) [:1.7.21]at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(
MethodInvocation.java:102) [jboss-aop.jar:2.2.2.GA]at org.jboss.aspects.remoting.PojiProxy.invoke(
PojiProxy.java:62) [:1.0.1.GA]at $Proxy267.invoke(Unknown Source) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(
SessionProxyInvocationHandlerBase.java:185) [:1.0.11]at $Proxy266.getPhysicists(Unknown Source) at org.physics.PhysicistManagerBean.search(
PhysicistManagerBean.java:59)at sun.reflect.NativeMethodAccessorImpl.invoke0(
Native Method) [:1.7.0_04]at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [:1.7.0_04]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [:1.7.0_04]
at java.lang.reflect.Method.invoke(Unknown Source) [:1.7.0_04]
at org.apache.el.parser.AstValue.invoke(
AstValue.java:196) [:6.1.0.Final]at org.apache.el.MethodExpressionImpl.invoke(
MethodExpressionImpl.java:276) [:6.1.0.Final]at com.sun.faces.facelets.el.TagMethodExpression.invoke(
TagMethodExpression.java:102) [:2.0.3-]at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(
MethodBindingMethodExpressionAdapter.java:84) [:2.0.3-]at com.sun.faces.application.ActionListenerImpl.processAction(
ActionListenerImpl.java:98) [:2.0.3-]at javax.faces.component.UICommand.broadcast(
UICommand.java:311) [:2.0.3-]at javax.faces.component.UIViewRoot.broadcastEvents(
UIViewRoot.java:781) [:2.0.3-]at javax.faces.component.UIViewRoot.processApplication(
UIViewRoot.java:1246) [:2.0.3-]at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(
InvokeApplicationPhase.java:77) [:2.0.3-]at com.sun.faces.lifecycle.Phase.doPhase(
Phase.java:97) [:2.0.3-]at com.sun.faces.lifecycle.LifecycleImpl.execute(
LifecycleImpl.java:114) [:2.0.3-]at javax.faces.webapp.FacesServlet.service(
FacesServlet.java:308) [:2.0.3-]Is there anyone who can give me a working firebird-ds.xml? Thanks, I think I have to give
my plan using JBoss with Firebird.
-
6. Re: persistence.xml does not deploy
ora7 Jun 1, 2012 3:08 PM (in response to ora7)1 of 1 people found this helpfulThis physics-dx.xml does work without error messages:
- You cannot set autocommit true
I had to change <local-tx-datasource/> through <no-tx-datasource/>
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<!--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">${jboss.server.data.dir}${/}firebird${/}physics.fdb</attribute>
<attribute name="UserName">einstein</attribute>
<attribute name="Password">relativity</attribute>
<attribute name="CreateOnStart">true</attribute>
<attribute name="DropOnStop">false</attribute>
</mbean><no-tx-datasource>
<jndi-name>PhysicsDS</jndi-name>
<connection-url>jdbc:firebirdsql:localhost/3050:${jboss.server.data.dir}${/}firebird${/}physics.fdb</connection-url>
<driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
<user-name>einstein</user-name>
<password>relativity</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<track-statements></track-statements>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>Firebird</type-mapping>
</metadata>
</no-tx-datasource>
</datasources>In the query I get now a not mapped exception. Looking forward for the next mistake.
-
7. Re: persistence.xml does not deploy
ora7 Jun 1, 2012 3:43 PM (in response to ora7)I works now with the @PersistenceContext annotation.
@PersistenceContext
private EntityManager entityManager;
Without manually creation the entityManager over the factory creates a mapping exception.
-
8. Re: persistence.xml does not deploy
ora7 Jun 1, 2012 3:54 PM (in response to ora7)With the annotation the <local-tx-database/> tag works too.
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<!--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">${jboss.server.data.dir}${/}firebird${/}physics.fdb</attribute>
<attribute name="UserName">einstein</attribute>
<attribute name="Password">relativity</attribute>
<attribute name="CreateOnStart">true</attribute>
<attribute name="DropOnStop">false</attribute>
</mbean><local-tx-datasource>
<jndi-name>PhysicsDS</jndi-name>
<connection-url>jdbc:firebirdsql:localhost/3050:${jboss.server.data.dir}${/}firebird${/}physics.fdb</connection-url>
<driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
<user-name>einstein</user-name>
<password>relativity</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<track-statements></track-statements>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>Firebird</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>