Hello,

I have the same problem

jaunot@...

Thanks

--- In Firebird-Java@y..., "Leos Urban" <leos.urban@i...> wrote:
> Hello,
> I want to use type 4 JCA/XA driver, Firebird (1.0) with Tomcat
(4.0.4) as
> Tomcat Resource.
>
> 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</valu
e>
> </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:/databas
e/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.
>
> Could you help me?
> Thanks.
> Leos