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