Subject | Transaction mappings in JBoss |
---|---|
Author | Juan Pedro López Sáez |
Post date | 2005-05-19T17:19:04Z |
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
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