Hi Leos,

Yes, I'm using it with Tomcat, but I'm using the standard character set. I
have seen this question discussed a lot on firebird-java, but it wasn't an
issue for me so I don't know what the solution was.

I think you are on the right track with lc_ctype but you will probably have
to set it in your application because the Tomcat realm specifications don't
support passing that parameter.

If you signup and post to firebird-java@yahoogroups.com you can get some
help. The developers of the driver are on there and are a great help.

Sorry I couldn't help you more.

That's the only criticism I have of the driver- there aren't any good docs
yet.

Rick

----- Original Message -----
From: "Leos Urban" <leos.urban@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, July 11, 2002 2:46 AM
Subject: Re: [ib-support] InterClient, Tomcat Resource, JSP and charset


> 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
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>