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 Websphere and the fly likes WebSphere Studio JDBC Connection Problem 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 » Products » Websphere
Bookmark "WebSphere Studio JDBC Connection Problem" Watch "WebSphere Studio JDBC Connection Problem" New topic
Author

WebSphere Studio JDBC Connection Problem

Christian Haag
Greenhorn

Joined: Jan 15, 2002
Posts: 6
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?
ulrike b
Greenhorn

Joined: Jun 18, 2002
Posts: 3
Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

Hallo Christian,
have you solved this problem by now?
I have the same problem with Oracle8i 1.7.0.
With SQL+ I get a connection to my database
on the server, but not with WebSphere Studio?
Can you help me?
Ulrike
shiva shankar
Ranch Hand

Joined: Jun 10, 2001
Posts: 84
Do you know what version of db2 the websphere portal requires ? Check out the version of JDBC too. If its JDBC 2 u need to upgrade it
Regds
calimer22
Greenhorn

Joined: Jun 24, 2002
Posts: 1
If someone have a solution because I have the same problem and I don't find the solution
quasifu
Greenhorn

Joined: Jul 11, 2002
Posts: 1
You must add the classes to your classpath, then restart your studio or WSAD. For example, if you are trying to connect to an Oracle db, you must add classes12.zip to your classpath in your system environment, then reopen studio or wsad.
dinis
Greenhorn

Joined: Aug 20, 2002
Posts: 1
Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

i got the same error message if someone solved it or got an idea?
Nigel Kat
Greenhorn

Joined: Jun 25, 2002
Posts: 16
I'm getting the same thing when going from WSAD running under NT to a Sybase ASE V12.5 server on a RS/6000.
I've verified the server & can connect just fine from code run outside of WSAD, which would prove that the drivers (jConnect V5.5) are loaded into the classpath since I don't do any cp definitions at runtime.
The Sybase ASE V12.5 and the UDB V7 options are included in the connection wizard under WSAD. I believe I saw a couple others in this message that are also there.
I posted a similar message to the IBM WSAD board about a month ago while they had one of the WSAD developers answering the quesions, but I never saw a response. I figured it was because I was heading to a Sybase server.
If anybody comes up with anything, please post.
Thx
Kat
>^..^<
Nigel Kat
Greenhorn

Joined: Jun 25, 2002
Posts: 16
In working with my WAS admin, they opened a PMR for this issue to IBM. The following:
****************
Thank-you for reporting this issue to WebSphere Studio Application
Developer Support and Services. I have opened a defect report JR 17393 for
investigation on this issue. As a workaround has been provided. May we
close the pmr?
**************
was the intial response from the IBM rep, note the defect report number for follow-up on a future patch/fix pack. If you would like to add your issues to this or open a separate one and reference this report number, contact the IBM site for problem reports.
The work around we received is:
******************
I noticed that when selecting the JDBC driver to equal jConnect 5.x JDBC Driver rather than Other Sybase Driver I receive the same error message you are seeing. I was able to connect to the Sybase bye selecting the JDBC driver to use Other Sybase Driver and configure the database connection wizard appropriately:
=====================
Connection name: Con1
Database myDatabaseName
User ID: myUserId
Pasword:******
Database ventor type: Sybase Adaptive Server Enterprise, V12
JDBC driver: Other Sybase Driver
JDBC driver class: com.sybase.jdbc2.jdbc.SybDriver
Class location: C:\jconn2.jar <---I used jconnect55.zip<br /> Connection URL: jdbc:sybase:Tds:[HOST]:[PORT]/[DATABASE NAME]<br /> =====================<br /> *************************<br /> There are 'other' drivers for the products shown in the previous posts as well. Try using some of those & see if you can get the connection to work.<br /> Good Luck!!<br /> >^..^<
Kat
Rainer Typke
Greenhorn

Joined: Nov 27, 2002
Posts: 1
I had the same problem as the original poster.
The solution was quite simple:
Pick the driver for the right OS, i. e. NOT the one on the client, but that of the server where the database runs.
In my case, I had to pick the "IBM DB2 APP driver for SOLARIS" even though I am running WSAD on Windows NT.
Piotr Gucwa
Greenhorn

Joined: Nov 29, 2002
Posts: 1
Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?


I had the same problem and solved it by selecting "Other DB2 Driver",
also entered in right places:
COM.ibm.db2.jdbc.app.DB2Driver
C:\Program Files\SQLLIB\java\db2java.zip
jdbc b2:<my database>
pg
Phil The Thrill
Greenhorn

Joined: Dec 10, 2002
Posts: 1
Hi,
I took a look at your solution...

I had the same problem and solved it by selecting "Other DB2 Driver",
also entered in right places:
COM.ibm.db2.jdbc.app.DB2Driver
C:\Program Files\SQLLIB\java\db2java.zip
jdbc b2:

and I gave it a try but it doesn't work. The error I get is "No Suitable Driver"
any ideas?
Kumar Sampath
Greenhorn

Joined: Aug 13, 2003
Posts: 3
URGENT !!! URGENT !!! URGENT !!!
Hi
I am using the Webspshere studio Application developer 5.0 and iam very much new to the websphere studio application developer 5.0.When i try to debug on server ,its trying to start the test enviornment server but in the middle i am getting error in the console as follows:-
java.lang.NoDefClassFoundException
Exception in thread "main"
I can come to a conclusion that its relAted to some runtime environment.
Do i need to install Java SDK version 1.3 or greater also?
I WOULD APPRECIATE IF ANYONE CAN HELP ME OUT AS I NEED FINISH THIS WITH TIGHT DEADLINES.

Regards
Sampath
Vidya Ram
Ranch Hand

Joined: Apr 22, 2003
Posts: 62
Hi all,
I'm replying to a very old thread because there is no solution posted for this problem yet and I have the same problem. When I try for JDBC DB2 8.1 connection in WSAD5.0, I get an error "No suitable driver".
I made sure that the classpath is set properly in the system environment.
Any help?
TIA,
Vidya.
Originally posted by Phil The Thrill:
Hi,
I took a look at your solution...

and I gave it a try but it doesn't work. The error I get is "No Suitable Driver"
any ideas?
Vidya Ram
Ranch Hand

Joined: Apr 22, 2003
Posts: 62
I got the solution to this "No suitable driver" problem. Its because of the incompatibility in the version of db2locale.dll file in WSAD and DB28.x. The solution is posted in the following IBM link:
http://www-1.ibm.com/support/docview.wss?uid=swg21111633
-Vidya.
Brian Kennedy
Greenhorn

Joined: Oct 15, 2003
Posts: 1
Regarding 'no suitable driver found'. I was receiving same message 'not a db2 database' and decided to switch to 'other db2 driver' as suggested in several posts. I noticed that when I did this, the error message switched to 'no suitable driver' from 'not a db2 database'. Then I noticed the 'db2' node in the connection url string had been dropped by the wizard when you select 'other db2 driver'. So I added it back in and BINGO Houston we have connection! jdbc b2:SAMPLE

Hope this may help someone else. I've been struggling with this off and on for some time made all the more frustrtating as I was able to connect Visual Age for Java but wanted to migrate to WASD. This concept might also apply to newer versions of the WASD and database? Don't know but you might try.
Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
I did get a "no suitable driver found" exception when connection from WSAD5.1 to a remote DB2 DB(V 7.2.10). I have a DB2 Client running on my Windows machine and there is a directory called Java12 in which there is a script to enable jdbc 2.0 which should be executed before acessing the DB. If i remember correctly its called "usejdbc2.bat".you can give it a try.
Good Luck
Praveen
virendra balaut
Greenhorn

Joined: Dec 04, 2003
Posts: 2
Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

have u solved this problem i m havng same problem in window
nowait shen
Greenhorn

Joined: Jul 27, 2003
Posts: 11
hi,Vidya Ram
Thanks for your great message~~~
I had been stuck in the problem for almost one afternoon before I finally saw your message~
I think IBM should put the link of this error-handling page right on the DB2's homepage!!
suria
Greenhorn

Joined: Aug 31, 2002
Posts: 6
Vidhya, nice work. Helped me @ right time. Tks for the effort.
Balaji Narasimhulu
Greenhorn

Joined: Oct 04, 2005
Posts: 4
Vidhya,

The solution you posted solved the problem.

Regards,
Balaji
Jignesh Patel
Ranch Hand

Joined: Nov 03, 2001
Posts: 626

but this solutions works for DB2 not for SQL Server 2000.
I am trying to use sqljbcd driver 2005 for connection and it says problem for loading driver.

Any idea?
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

Check to see if you have a usejdbc2.bat file on your computer, and if you do, run it.

Sounds like a driver issue to me.

-Cameron
 
Consider Paul's rocket mass heater.
 
subject: WebSphere Studio JDBC Connection Problem
 
Similar Threads
Not able to generate entity bean classes for table with reflexive relationship.
WSAD Connectivity to remote Oracle 8i db for enity ejb mapping
WebSphere Studio JDBC Connection Problem
WebSphere 4 doesn�t start
WSA 5.1 problem connecting to DB2 9.1