Subject How to set encoding of a DataSource to UTF8?
Author firoux
Hi,

I'm trying to get my UTF8-encoded data out from database using
DataSource via JNDI look-up but the output seems to be garbled. I
suspected that this is because there is no encoding information
stored somewhere along the process. What confuses me is that there
is no way to set this property to the resulting DataSource.

I used Resin 2.1.6 and firebirdsql 1.0.1 JDBC driver. The following
is my DataSource configuration excerpted from resin.conf, Any
comments would be appreciated.

=================
<resource-ref>
<res-ref-name>jdbc/test</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<init-param driver-name="org.firebirdsql.jdbc.FBDriver"/>
<init-param
url="jdbc:firebirdsql:127.0.0.1/3050:/opt/db/test.GDB"/>
<init-param user=""/>
<init-param password=""/>
<init-param max-connections="20"/>
<init-param max-idle-time="30"/>
<init-param enable-cache="true"/>
<init-param cache-size="5"/>
<init-param connection-time-out="15"/>
</resource-ref>
==================


Thanks,

Rio