By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,507 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

Problem DB2 connect with JDBC

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.