1 Reply Latest reply on Mar 18, 2003 3:33 PM by Ricardo

    CHARSET setting

    Dobri Newbie

      Hi!
      I am using JBoss3.0.0 and Sybase DB(driver JConnect5.5).
      I do not know how to set CHARSET property in jboss.
      Perhaps it is a character set conversion
      that needs to occur if windows 1253 has to take place in
      showing the result list from a search.

      I have tried to set :
      <config-property name="CHARSET" type="java.lang.String">windows_1253</config-property>

      in sybase-service.xml, but an exception is thrown during the deployment.
      (15:09:04,591 WARN [RARDeployment] The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory'
      has no setter for config property 'CHARSET'
      15:09:04,591 ERROR [LocalTxConnectionManager] Starting failed
      java.lang.IllegalArgumentException: The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory
      ' has no setter for config property 'CHARSET'
      at org.jboss.resource.connectionmanager.RARDeployment.setManagedConnectionFactoryAttribute(RARDeployment.java:65
      8))

      Here is my sybase-service.xml :

      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->



      <!-- ======================================================================-->
      <!-- New ConnectionManager setup for Sybase ASE/ASA jConnect driver -->
      <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
      <!-- ===================================================================== -->
      <!--classpath ARCHIVE="jconn2.jar" CODEBASE="../lib/" /-->



      <!--uncomment out this line if you are using the SybaseDSRealm above
      SybaseDbRealm
      -->

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


      SybaseDB



      <!-- The 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:Server:5000/okt2</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.sybase.jdbc2.jdbc.SybDriver</config-property>
      <config-property name="UserName" type="java.lang.String">niki11</config-property>
      <config-property name="Password" type="java.lang.String">niki11</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-->


      0
      10
      5000
      15
      ByContainer



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


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


      java:/TransactionManager

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