It's not a secret anymore!*
The moose likes JDBC and the fly likes DB2 access from browser using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 access from browser using JDBC" Watch "DB2 access from browser using JDBC" New topic
Author

DB2 access from browser using JDBC

Fred Guo
Greenhorn

Joined: Nov 20, 2000
Posts: 4
My project needs to access DB2 using JDBC. It runs on different machine (Unix, Solaris) from DB2 (AIX). After unix administrator installed DB2 client software and modified the global profile (adding db2profile there), I can run a stand-alone program to access DB2. However, if I integrate the program into a web application and run it from browser, it can't load jdbc driver. Since our web server dose not have servlet engine, we need using a cgi batch file to wrap the env. varibles. I set all necessary env. varibles in the batch file. It seems web server can not communicate with DB2, or create a DB2 instance.
Please help me to fix the problem. Thanks.
Fred
Bala Ramachandran
Greenhorn

Joined: Aug 20, 2001
Posts: 12
Originally posted by Fred Guo:
My project needs to access DB2 using JDBC. It runs on different machine (Unix, Solaris) from DB2 (AIX). After unix administrator installed DB2 client software and modified the global profile (adding db2profile there), I can run a stand-alone program to access DB2. However, if I integrate the program into a web application and run it from browser, it can't load jdbc driver. Since our web server dose not have servlet engine, we need using a cgi batch file to wrap the env. varibles. I set all necessary env. varibles in the batch file. It seems web server can not communicate with DB2, or create a DB2 instance.
Please help me to fix the problem. Thanks.
Fred

Fred,
I am trying to access DB2 UDB in AIX from a sstand-alone Java program in a Sun machine. But I get a SQL exception:
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01.
Can you help me solve this ?
Thanks
Bala.
Surya Bahadur
Ranch Hand

Joined: Sep 28, 2000
Posts: 88
Hi
Have you tried using db2jstrt followed by the port number you specified in the JDBC Url.
Surya
Fred Guo
Greenhorn

Joined: Nov 20, 2000
Posts: 4
What type jdbc driver is used? if you use net driver, you have to make sure the listener of the DB started, which port it listen to. If you use app driver, you need to install UDB client software on the machine that your program is running.
Fred
Bala Ramachandran
Greenhorn

Joined: Aug 20, 2001
Posts: 12
Originally posted by Fred Guo:
What type jdbc driver is used? if you use net driver, you have to make sure the listener of the DB started, which port it listen to. If you use app driver, you need to install UDB client software on the machine that your program is running.
Fred

Hi,
I have tried both the 'app' driver as well as the 'net' driver.
When I use the 'app' driver, I get the message "No suitable driver found". I have installed the UDB client on the Sun machine (from where I am trying to run the Java program).
So I switched to the 'net' driver. I will have to check that the db2jstrt is running on the server in the port '6789'. In that case will my conenction URL also have '6789' as the port number instead of '50000' that I used for 'app' driver ?
Thanks
Bala.
Bala Ramachandran
Greenhorn

Joined: Aug 20, 2001
Posts: 12
Originally posted by Fred Guo:
What type jdbc driver is used? if you use net driver, you have to make sure the listener of the DB started, which port it listen to. If you use app driver, you need to install UDB client software on the machine that your program is running.
Fred

Hi,
When I use the 'app' driver, I get the message "No suitable driver found". I have the UDB client installed on the client machine and have the db2java.zip in the classpath.
I downloaded the Sun Solaris version of the UDB client and installed it on the Sun machine.
What does this message mean ?
Thanks
Bala.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: DB2 access from browser using JDBC