ODBC Tomcat


2004-02-17 01:19:29 AM
jbuilder12
Hi, Anyone know how to get tomcat to "see" an ODBC datasource configured in
/etc/odbc.ini on RedHat Linux.
The source code is:
database1.setConnection(new
com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:TrackingFire",
"SYSDBA", "masterkey", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
The /etc/odbc.ini file contains:
[TrackingFire]
Description = interbase driver
Driver = INTERBASE
Dbname = 192.9.200.148:e:/db/tracking.gdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet =
ReadOnly = No
NoWait = No
The /etc/odbcinst.ini contains:
[INTERBASE]
Description = Interbase/Firebird ODBC Driver
Driver = /usr/lib/OdbcJdbc.so
Setup = /usr/lib/OdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =
The driver works when I query the database on the server manually using isql
I'm getting this error in Tomcat:
com.borland.dx.dataset.DataSetException: Execution of query failed.
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.queryFailed(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.a(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at jobtracktest1.Servlet1.doPost(Servlet1.java:53)