How to add Connection properties to your JBoss DataSource ?

JBoss recipe of the day

You can include connection properties in your DataSource configuration that will get passed in the DriverManager.getConnection(props) call. Here's how to do it:

Local Datasource

<local-tx-datasource>
    ...

    <connection-property name="char.encoding">UTF-8</connection-property>
    <!-- Tells an Oracle 10g driver to properly implement clobs. -->
    <connection-property name="SetBigStringTryClob">true</connection-property>

..
</local-tx-datasource>


XA Datasource

<xa-datasource-property name="ConnectionProperties">SetBigStringTryClob=true</xa-datasource-property>

Related articles available on mastertheboss.com

How to deploy a DataSource in jboss at application level ?

  Do you need to deploy your DataSource along with your Enterpri

JBoss Datasource HA

This tutorial has been updated for the new release of JBoss Appli

JBoss run out of Connections ?

Have you got No ManagedConnections available error message ? well

How to connect to a DataSource from a remote client?

  If you want to connect to your JBoss Connection Pool from a re

JBoss Datasource configuration

A Datasource is a Java Naming and Directory Interface (JNDI) obje

How do I get the list of Datasources available ?

JBOSS AS 4/5 Users You can use either twiddle: $ twiddle.sh que

Follow us on Twitter