Memo: Re: JDBC to outside DB's

[keith.mccully@xxxxxxxxxx]

Hi Woody,

jconn2.jar worked fine when I ran a server side class on the AS400 to access
Sybase within UNIX on an HP box.
I havn't used it via WebSphere but you would need to install jconn2.jar on the
AS400 and define the location in the servlet classpath.

Cheers,

Keith





"Woody Sturges" <wsturges@bjc.org> on 26 Sep 2001 18:10






To:   java400-l@midrange.com
cc:     (bcc: Keith MCCULLY/HIBM/HSBC)
Subject:  Re: JDBC to outside DB's





Ahhh...  That's the info I need.  Please define 'install'.  I have the Sybase
JConnect JDBC driver (jconn2.jar).  Where do I put it, and how do I configure
the IbmConnMgr (WebSphere) to see it?

Much thanks!
Woody

>>> keith.mccully@hsbcam.com 09/26/01 09:59AM >>>



You can use JDBC on the AS400 to execute a stored procedure within Sybase. This
will 'pull' the data to the AS400 but you must first install a JDBC driver for
Sybase on the AS400.

Keith






"Woody Sturges" <wsturges@bjc.org> on 26 Sep 2001 15:54






To:   java400-l@midrange.com
cc:     (bcc: Keith MCCULLY/HIBM/HSBC)
Subject:  JDBCto outside DB's





  Is it possible to use JDBC under WebSphere (AS400, V4R5) to connect to
a Sybase DB (ASE v11.9.2 or 12.0)?  I'd like to be able to link to both
DB's (AS400 and Sybase) in various servlets.

Any help is appreciated,
Woody Sturges
Boone Hospital Center

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.



************************************************************
This message originated from the Internet. Its originator
may, or may not be who they claim to be, and the information
contained herein may, or may not be accurate.
************************************************************






__________________________________________________________________

This transmission has been issued by a member of the HSBC group ("HSBC")
for the information of the addressee only and should not be reproduced
and / or distributed to any other person. Each page attached hereto must
be read in conjunction with any disclaimer which forms part of it.
This transmission is neither an offer nor the solicitation of an offer
to sell or purchase any investment. Its contents are based on information
obtained from sources believed to be reliable but HSBC makes no
representation and accepts no responsibility or liability as to its
completeness or accuracy.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.