Subject | Re: [Firebird-Java] |
---|---|
Author | Rick Fincher |
Post date | 2002-12-19T20:56:57Z |
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
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>
>