JDBC Drivers, Please Help

[fatcodeguy]

Hi, I'm having troubles connecting to a Sybase database using jConnect (JDBC). I don't know where to put the jConnect-5_5 folder, what to set the classpath to, and how to load the drivers\set up the connection. Any help GREATLY appreciated.

Thanks

 

[qyllr]

hello,

try the following sybase sites for some info...

install guide

http://my.sybase.com/detail?id=1009772#MARKER-9-137

new features with 5.2

http://my.sybase.com/detail?id=1009761

hth,
q.

 

[JMCraig]

Hi,

It doesn't matter much where you put the bulk of the files that are part of the jConnect distribution. I find it convenient to put jconn2.jar file right into the %JAVAHOME%\jre\lib\ext directory. That means you don't generally have to mess with CLASSPATH issues (one of the really annoying characteristics of Java IMHO).

Sybase also has a jConnect programmer's guide available on line (just find the manuals for jConnect, it'll be there with them).

One thing that's rather buried is the use of the FAKE_METADATA property on a connection: I recommend using it so you don't find your programs dying because Sybase doesn't use so-called CATALOG names.

BOL,
John J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net