Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle9iAS to Sybase DB - frustrating

Oracle9iAS to Sybase DB - frustrating

From: Wells <wshammou-(noSpam)_at_optonline.net>
Date: Thu, 01 Jul 2004 05:15:06 GMT
Message-ID: <u5NEc.57787$OT6.23514069@news4.srv.hcvlny.cv.net>


Hi all,
Firstly, sorry if this is the wrong group to post to, I couldn't find one specific to 9iAS.
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. Received on Thu Jul 01 2004 - 00:15:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US