Subject Re: [ib-support] InterClient, Tomcat Resource, JSP and charset
Author Leos Urban
Hi,
I downloaded and tested the type 4 JCA/XA driver from the Firebird project
and
have the same efect.
I dont know how to specify charset for DB in tomcat resouce specification.

In server.xml is:
<Resource name="jdbc/icdiakonis" auth="Container"
type="javax.sql.DataSource" />
<ResourceParams name="jdbc/icdiakonis" >
<parameter>
<name>driverClassName</name><value>org.firebirdsql.jdbc.FBDriver</value>
</parameter>
<parameter> <name>user</name><value>sysdba</value> </parameter>
<parameter> <name>password</name><value>masterkey</value> </parameter>
<parameter> <name>lc_ctype</name><value>UNICODE_FSS</value> </parameter>
<parameter>
<name>driverName</name><value>jdbc:firebirdsql:localhost/3050:/database/idum
2.gdb</value> </parameter>
</ResourceParams>

Specification of "lc_ctype" did not work, when I accessed to non-english
characters, then I got some error from server and/or driver . But when I
read from "english" tables (RDB$RELATIONS) , it worked OK.

I tested also change driverName to
"?lc_ctype=UNICODE_FSS&user=sysdba&password=masterkey".
This crash Tomcat on start (reading config).
And when use "?lc_ctype=UNICODE_FSS&user=sysdba&password=masterkey"
then I cannot connect to server.

> It works well, supports alternate characters, and has built-in connection
> pooling. No one is supporting the open source version of InterClient
> anymore so this is the way to go for the future.

Do you use it with Tomcat?

Thanks.
Leos