0 Replies Latest reply on Nov 3, 2003 6:28 PM by bobc

    Jboss 2.47 jboss.jcml charset property

    bobc Newbie

      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