Subject Transaction mappings in JBoss
Author Juan Pedro López Sáez
Hello everybody.

I'm using Jaybird 1.5.5 and JBoss 4.0.1

Is there any way to set the TPB mappings in the standard firebird-ds.xml
file? It looks like this:

----------------------------------------------
<connection-factories>

<tx-connection-factory>

<jndi-name>jdbc/myDb</jndi-name>

<track-connection-by-tx>true</track-connection-by-tx>

<xa-transaction/>

<rar-name>firebirdsql.rar</rar-name>

<connection-definition>javax.sql.DataSource</connection-definition>

<config-property name="Database"
type="java.lang.String">db.gdb</config-property>

<user-name>user</user-name>

<password>passwd</password>

<config-property
name="TransactionIsolationName">TRANSACTION_READ_COMMITTED</config-property>

<min-pool-size>0</min-pool-size>

<max-pool-size>20</max-pool-size>

<check-valid-connection-sql>SELECT CAST(1 AS INTEGER) FROM
rdb$database</check-valid-connection-sql>

<metadata>
<type-mapping>Firebird</type-mapping>
</metadata>

</tx-connection-factory>
</connection-factories>
------------------------------------------------------

I've tried without success the following:

config-property name="TRANSACTION_READ_COMMITED"
type="java.lang.String">isc_tpb_read_committed,
isc_tpb_rec_version,isc_tpb_write,isc_tpb_nowait</config-property>

Related to this: any hint to set the connection encoding?

<config-property name="charSet"
type="java.lang.String">ISO8859_1</config-property>
<config-property name="Encoding"
type="java.lang.String">ISO8859_1</config-property>
<config-property name="lc_ctype"
type="java.lang.String">ISO8859_1</config-property>


Thank you very much.

Juan Pedro Lopez