0 Replies Latest reply on Jul 4, 2002 4:32 AM by Péter Vary

    Setting properties for mm.mysql driver

    Péter Vary Newbie

      Hullo!

      I'm trying to use mm.mysql-2.0.14 driver in my JBoss-2.4.4(_Tomcat-4.0.1).
      I need to set up some driver properties namely:
      ("useUnicode", "true");
      ("characterEncoding", "ISO-8859-1");

      If I use DriverManager everything's all rigth.

      But what I want to use is the Connection Pool. It's working all right, but the result srings are not encoded in ISO-8859-2, even if I set the "Properties" attribute
      like this:
      <attribute name="Properties">
      useUnicode=true;characterEncoding=ISO-8859-2
      </attribute>

      I have the jboss.jcml file like this:

      <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=DefaultDS">
      <attribute name="PoolName">DefaultDS</attribute>
      <attribute name="DataSourceClass">
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      </attribute>
      <attribute name="Properties">
      useUnicode=true;characterEncoding=ISO-8859-2
      </attribute>
      <attribute name="URL">
      jdbc:mysql://localhost/secret
      </attribute>
      <attribute name="GCMinIdleTime">1200000</attribute>
      <attribute name="MaxSize">10</attribute>
      <attribute name="JDBCUser">secret</attribute>
      <attribute name="Password">secret</attribute>
      <attribute name="GCEnabled">false</attribute>
      <attribute name="InvalidateOnError">false</attribute>
      <attribute name="TimestampUsed">false</attribute>
      <attribute name="Blocking">true</attribute>
      <attribute name="GCInterval">120000</attribute>
      <attribute name="IdleTimeout">1800000</attribute>
      <attribute name="IdleTimeoutEnabled">false</attribute>
      <attribute name="LoggingEnabled">true</attribute>
      <attribute name="MaxIdleTimeoutPercent">
      1.0
      </attribute>
      <attribute name="MinSize">0</attribute>
      </mbean>

      Do you have any suggestions, how should I configure my DBPool?

      Thanks in advance,
      Peter Váry