How to add Connection properties to your JBoss DataSource ?
- Details
- Published: 27 December 2008
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>
