This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes OS390 JDBC Connection to DB2 from JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OS390 JDBC Connection to DB2 from JSP" Watch "OS390 JDBC Connection to DB2 from JSP" New topic
Author

OS390 JDBC Connection to DB2 from JSP

Bill Cochrane
Greenhorn

Joined: Jan 22, 2002
Posts: 1
I am trying to connect to DB2 from a JSP. I'm using Websphere Application Server 4.0 running under OS390. I keep getting a server-side error (I don't yet know how to see what the error is).
Do I use the following driver?
"COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver"
or since I am not (yet) using SQLJ should it be:
"COM.ibm.db2os390.jdbc.DB2Driver" ?
My URL is: "jdbc b2os390 BT1" where DBT1 is the local DBT instance.
Omitting the try/catch statements I have:
String db2Driver = "ibm.sql.DB2Driver";
String url = "jdbc b2os390 BT1";
Connection con;
Class.forName(db2Driver);
con = DriverManager.getConnection (url);
.
.
.
con.close();
 
 
subject: OS390 JDBC Connection to DB2 from JSP
 
Similar Threads
java.sql.SQLException: No suitable driver
JDBC:DB2 getConnection syntax
JDBC Connection to DB2 on OS/390
JDBC applets
As/400 Db2 Jdbc