Subject Re: [Firebird-Java]
Author Rick Fincher
Hi Alessandro,

How are you using this? Why are you using a JNDI resource instead of a JNDI
dataSource? What version of Tomcat, and JayBird are you using?

The parameter "charSet" is not valid for JayBird.

You may be able to change:
<parameter><name>driverName</name><value>jdbc:firebirdsql:127.0.0.1/3050:/db
/off.gdb</value></parameter

To:
<parameter><name>driverName</name><value>jdbc:firebirdsql:127.0.0.1/3050:/db
/off.gdb?&lc_ctype=ISO8859_1</value></parameter

This might get things working for you.

Rick

----- Original Message -----

> I'm trying to configure a JNDI resource under tomcat, but I get an
> Unable to get connection, DataSource invalid: "null" exception
> when a JSP try to use the connection.
> The driver is correctly installed because it works if I call the
DriverManager
> directly with a scriptlet.
> Thanks in advance!
> Alessandro Fiorino
>
> This is the definition I put in the <Context>
> <Resource name="jdbc/off" auth="Container" type="javax.sql.DataSource"/>
>
> <ResourceParams name="jdbc/off">
> <parameter><name>user</name><value>SYSDBA</value></parameter>
>
<parameter><name>password</name><value>masterkey</value></parameter>
>
>
<parameter><name>driverClassName</name><value>org.firebirdsql.jdbc.FBDriver<
/value></parameter>
> <parameter><name>charSet</name><value>ISO8859_1</value></parameter>
>
>
<parameter><name>driverName</name><value>jdbc:firebirdsql:127.0.0.1/3050:/db
/off.gdb</value></parameter>
> </ResourceParams>
>