Hi Leos,

InterClient 2.01 doesn't support alternate character sets. You need to
download the type 4 JCA/XA driver from the Firebird project at
sourceforge.net. There is a discussion group specifically for this driver
at Firebird-Java@yahoogroups.com.

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.

It also directly connects to Firebird and Interbase without using IBServer.

Rick

> Hello,
> I want to use InterClient (2.01), Firebird (1.0) with Tomcat (4.0.4) as
> Tomcat Resource.
> In configuration file server.xml I have defined connection parameters:
>
> <Resource name="jdbc/icdiakonis" auth="Container"
> type="javax.sql.DataSource" />
> <ResourceParams name="jdbc/icdiakonis" >
> <parameter>
> <name>driverClassName</name><value>interbase.interclient.Driver</value>
> </parameter>
> <parameter> <name>user</name><value>sysdba</value> </parameter>
> <parameter> <name>password</name><value>masterkey</value> </parameter>
> <parameter> <name>charSet</name><value>UTF8</value> </parameter>
> <parameter>
>

<name>driverName</name><value>jdbc:interbase://localhost:3060/C:/database/id

> um2.gdb</value> </parameter>
>
> In web.xml is:
> <resource-ref>
> <description>JDBC pool</description>
> <res-ref-name>jdbc/icdiakonis</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> It works fine but only with non-international characters (database is
> created as UNICODE_FSS).
> All international characters are displayed on web page incorrectly.
> It looks as if parameter charSet is ignored, because when I connect
> "normally" (without Tomcat resource), data are OK.
> Do you have some tip how to set charset in server.xml with Interclient ??
>
> Thanks.
> Leos