Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Tomcat ODBC.INI

1 view
Skip to first unread message

Kog

unread,
Feb 16, 2004, 8:39:52 AM2/16/04
to
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)

0 new messages