473,397 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Problem DB2 connect with JDBC

Hello,

Firstly all apologize for my english.

Secondly, I've got some problems to connect to a DB2 database with
JDBC client.

My configuration is :

- DB2 8.1 on an AIX server (name rs26 for the further example)
- Standalone application on Windows XP using JDBC to connect to the
DB2 database

And when I try the connection, I have this error message :

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0106E Connection
is closed. SQLSTATE=08003
[IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003

Do you know why I have this error ?

If some supplementary informations are needed, there is the example :

AIX Server :
-------
I start the database with the command db2start
I know I have a TCP configuration (port 50000) for my database (netsat
command confirms this)
Then I launch db2jstrt 60000 for starting the JDBC applet on 60000
port
Finally, the name of my database's instance is stel71
-------

Windows CLient :
-------
I'am using DB2 JDBC drivers which are provided by DB2 on the AIX
server :
- Driver class : COM.ibm.db2.jdbc.net.DB2Driver (I've the same
problem with ".app" instead of ".net")
- database URL : jdbc:db2://rs26:60000/stel71 (I think it's correct
!)
-------

I hope you have all the informations.

Thanks for your help ...
Nov 12 '05 #1
4 4105
Are you using connection pool?? If yes, check whether the connection is
pool is valid or not..(I guess this may be a problem. correct me if am
wrong)

WantedToBeDBA.
Thiru.

Nov 12 '05 #2
Thank you for your answer !

I don't think I'm using a connection pool but in order to be sure how
can I know if I use a connection pool ?
"Thiru" <Wa***********@gmail.com> wrote in message news:<11**********************@o13g2000cwo.googleg roups.com>...
Are you using connection pool?? If yes, check whether the connection is
pool is valid or not..(I guess this may be a problem. correct me if am
wrong)

WantedToBeDBA.
Thiru.

Nov 12 '05 #3
Are you using any App Servers such as WebLogic, WebSpeare? If so check
the app server configuration file. If its custom designed app then
contact developer or do code walk through

Cheers,
Thiru.
WantedToBeDBA.

Nov 12 '05 #4
In fact, the database has to be connected with another application
(which manage contents, documents ...) and then with a WebSphere
Portal in order to search documents (and another thinks). For the
first application, the connection with the database is done with JDBC.
But it doesn't work and I try to understand why before trying the
connection with WebSphere Portal !

"Thiru" <Wa***********@gmail.com> wrote in message news:<11*********************@g14g2000cwa.googlegr oups.com>...
Are you using any App Servers such as WebLogic, WebSpeare? If so check
the app server configuration file. If its custom designed app then
contact developer or do code walk through

Cheers,
Thiru.
WantedToBeDBA.

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: kaiwing18 | last post by:
Hi , I have a problem relate to java and database. Could anyone answer me ?Please see the following code. import java.sql.*; public class Result { public static void main(String args) {
0
by: sridhar nagabhurshana | last post by:
hello I am trying to connect to mysql database using connector/J jdbc driver this is my code import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;
0
by: Swami | last post by:
Hi, I have installed MQ SQL Server 2000 on my laptop and trying to use SPARTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I wrote a sample Java app to test the connection and I...
6
by: Swami | last post by:
Hi, I have installed MQ SQL Server 2000 on my laptop and trying to use SPRINTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I wrote a sample Java app to test the connection and I...
4
by: Dani | last post by:
Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When read out again the integer looks very different. We...
30
by: aka | last post by:
Hi I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect instance as tcpip node and then the Host DB...
0
by: mailkhurana | last post by:
Hii , I am trying to use a type 2 driver to connect to DB2 0n AIX 5 I have a small java test to class to establish a conneciton with the db .. I am NOT using WAS or any appserver When I try to...
2
by: vikas.bhatia | last post by:
Is this still true? http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983 would...
3
by: mayur1 | last post by:
Hello everybody, I am trying to connect to DB2 V 8.1 on Red Hat Linux V5 from WebSphere Application Server V6 on Windows Server 2003. The problem that i am facing is that its not able to opent...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.