Oracle9iAS to Sybase - Frustrating -
07-01-2004
, 12:19 AM
Hi all,
Firstly, sorry if this is the wrong group to post to.
Hopefully someone can help me with this problem.
I have a JSP/Servlets application which I want to deploy to Oracle 9iAS. I
have to use Sybase as the DB but I am having a hard time setting up the JDBC
Data Source.
According to the documentation I found, Oracle recommends using the
DataDirect drivers for Sybase. The problem is that when I deploy, the
DataSource class is never found and the JNDI Location is also never found.
What is the JNDI Location? And how do I set up the DataSource, Driver and
JDBC URL?
I am using the following:
DataSource: com.ddtek.jdbcx.sybase.SybaseDataSource
Driver : com.ddtek.jdbc.sybase.SybaseDriver
Can someone please tell me how to set up a JDBC connection pool in 9iAS to
sybase, what drivers to use and which directory to put them in. Also how to
setup the JNDI Location?
This is Oracle 9iAS 9.0.3.0 on Sun Solaris and Sybase ASE 12.5 also in Sun
Solaris.
Thanks so much.
Wells...
PS: I am working from memory here so sorry that I can't provide more exact
details. |