[Kevin_L]

Hi all,

I am having difficulty connecting to my DB2 V.8 Personal Developer Edition server with myEclipse.
It displayed Error..window with this following message.
“COM.ibm.db2.jdbc.net.DB2Driver”

I am using this url.
jdbc:db2//localhost:5021/CMA3

I already used Configuration Assistant for jdbc connection for CMA2 database and it is working fine.

Please help me.. here are some background info…

OS: WinXP
Eclipse: 3.0
Plugins: NONE but myEclipse
MyEclipse: Beta 2
JDK: 1.4.2_05
Application server: JBOSS 3.2.5
Elipse Log: There is any under <workspace>/.metadata/.log

Should I get the new JDBC driver for DB2 V.8 Personal Developer Edition???

[Scott Anderson]

Kevin,

There has been a *ton* of work done to the DB tools since 3.8 Beta 2. In order not disrupt your current environment, I’d suggest downloading and installing a fresh version of Eclipse 3.0.1 and MyEclipse 3.8.2 and then configuring them to work with your database to see if that resolves the issue. If it does, you can then point the new installation to your old workspace to change over.

[Kevin_L]

Hi Scott,

I did as you told me. Now I have new error message
“Error while trying to login to database: IO Exception opening socket to server localhost on port 1527. The DB2 Server may be down.”

I think I now have correct driver since I created new driver by choosing the driver from IBM installation under java folder.
I would like again mentioned that I already used configuration assistant to test JDBC connection with the username and password and it went fine. Thus the connection is working and listening perfectly.

AM I using the wrong port number?
~K~

[Scott Anderson]

AM I using the wrong port number?

I really have no idea what the port number should be for your DB2 instance, since that’s a configuration setting within DB2. Also, I don’t know what the default is. I’ll forward this thread over to someone with more database experience. In the meantime, can you check your config and ensure that you’re indeed running on the port you’re trying to connect to?

[Kevin_L]

I found out that the default port number that IBD DB2 is listening is 50000. So I tried that….
It didn’t display error message ….but it doesn’t connect to the database either..its keeping saying..
logging into the database logging into the database…NON Stop.. I have to manually cancel it.

I found out from this link..
http://www.awprofessional.com/articles/article.asp?p=170336&seqNum=2

Something is missing… Hope you guys can help me out..I will dig more information too..If I find it, I will post it here.. :):)

Funny! I also tried myEclipse with PostgreSQL 8.0 beta 2 and it went great…now I am having problem with IBM DB2????

~K~

[Kevin_L]

Hi again,

I would like to inform you guys that I now have correct port number. It is 50000.
I was successfuly connect Aqua Data Studio with this port number. That tool is awesome too. I highly recommend it. Anyway, looks like the problem is with myEclipse…Its not how I setup my DB2 Server. It is working with Aqua Data Studio and I also wrote small java application to connect to it.. and it works fine. ….The only conclusion I have from my testing is that …the problem relies on myEclipse side…..

~K~

[Scott Anderson]

Kevin,

Thanks for looking into it deeper. I’ve asked Jeff to follow up further.

[support-jeff]

Kevin –

I am using this url.
jdbc:db2//localhost:5021/CMA3

Please try the following URL:
jdbc:db2://localhost:50000/CMA3

I believe the colon before the URI (//localhost) is required.

If this does not resolve the issue, please post any Eclipse error log messages you are receiving.

[Kevin_L]

Thanks Jeff!

You are right…..It is working now! Awesome!….

~K~

[Author]

Posts