This 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.