This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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 Murach's Java Servlets and JSP this week in the Servlets 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();
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: OS390 JDBC Connection to DB2 from JSP
 
Similar Threads
JDBC:DB2 getConnection syntax
JDBC Connection to DB2 on OS/390
JDBC applets
java.sql.SQLException: No suitable driver
As/400 Db2 Jdbc