I used to be able to specify the charset property in jboss.jcml when I was using jboss 2.47. Now, I am moving to jboss 3.0 and would like to know how to include the charset property in the xml for the datasource.

With jboss 2.47, I have these lines in jboss.jcml and it worked correctly.

<!-- datasource for Sybase -->

sqlserver1
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:sybase:Tds:10.2.3.4:5000/thaiDB?HostName=PacServer
<!--attribute name="JDBCUser">sa</attribute-->
<!--attribute name="Password">saPasswd</attribute-->
10
100
user=sa;password=saPasswd;charSet=cp874
true
5000
true


(note charset=cp874 above)

However, now I am using jboss 3.0 and the datasource xml would not allow me to include the charset property.

My datasource xml is as follow:


...


<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->


sqlserver1



<!-- Sybase jConnect URL for the database.
NOTE: The hostname and port of made up values. The optional
database name is provided, as well as some additinal Driver
parameters.
-->
<config-property name="ConnectionURL" type="java.lang.String">
jdbc:sybase:Tds:10.2.3.4:5000/thaiDB
</config-property>
<config-property name="DriverClass" type="java.lang.String">
com.sybase.jdbc2.jdbc.SybDataSource
</config-property>
<config-property name="UserName" type="java.lang.String">
sa
</config-property>
<config-property name="Password" type="java.lang.String">
saPasswd
</config-property>



<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">
jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper




<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->


10
100
5000
15
ByContainer



<depends optional-attribute-name="CachedConnectionManager">
jboss.jca:service=CachedConnectionManager


<depends optional-attribute-name="JaasSecurityManagerService">
jboss.security:service=JaasSecurityManager


java:/TransactionManager

<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer





Anyone has any idea how I can specify charset in this xml file?

Much appreciated.

Bob