Forum Discussion

jenniferxu99's avatar
jenniferxu99
Regular Visitor
6 years ago

ReadyAPI 2.2 Failed to initialize the connection that uses the [com.ibm.db2.jcc.DB2Driver] driver.

Hi , I try to create ReadyAPI JDBC connection with DB2 database,  I got this error message: Failed to initialize the connection that uses the [com.ibm.db2.jcc.DB2Driver] driver. Connection string...
  • richie's avatar
    richie
    6 years ago

    Hey jenniferxu99 

     

    Apologies - I've only just seen this post - I dont know if you got any further - but DB2 config is fiddly - there's some extra stuff you need to be aware of

     

    1.  which operating system is the DB2 running on - z/OS? Linux? etc. (it makes a difference - you might've noticed some of the SQL commands you use are different if you've used DB2 before (e.g. LTRIM etc.) - your SQL is differnet on different operating systems - and the db connection config is the same.  so you need to determine what operating system is supporting your DB and then speak to a DBA (I'll come back to this in a little while)

     

    2.  You need to determine what version of Java your DB2 instance supports.  You need to install this version on the machine running ReadyAPI! (ensuring you install the right version (e.g. JRE/JDK v8.0) as well as whether it's x86 or 64bit.  If your ReadyAPI! is installed in Program Files directory you're running 64bit, so you need to download and install 64bit JRE and vice versa.  Make sure (I'm assuming Windows) that your 'Path' envnironment variable is updated wiht your Java install

     

    3.  you need to then download the correct driver .jar files for your DB2 version - note - I cann't remember but it's VERY likely this will be operating system dependent.

     

    4.  Speak to your DBA - you have specified the JDBC connection string in your post - there are 2 DB2 default JDBC connection strings installed by default with ReadyAPI! - these may work - they may not.  Whether they work or not is dependent on the DB2 setup.  Speak to a DBA about obtaining the correct details for the DB2 setup you have there - there may be additional parameters that are NOT included in the default JDBC connection strings.  If this is the case the default ones wont work -  you'll have to create a new DB2 connection string in the Preferences  >> JDBC Drivers.

     

    There might be a bit of tweaking - but those are essentially the steps I used to connect my SoapUI instance to to DB2.

     

    hit me back if you have any further queries!

     

    Cheers,

     

    rich

     

richie's avatar
richie
Community Hero
6 years ago

Hey jenniferxu99 

 

Apologies - I've only just seen this post - I dont know if you got any further - but DB2 config is fiddly - there's some extra stuff you need to be aware of

 

1.  which operating system is the DB2 running on - z/OS? Linux? etc. (it makes a difference - you might've noticed some of the SQL commands you use are different if you've used DB2 before (e.g. LTRIM etc.) - your SQL is differnet on different operating systems - and the db connection config is the same.  so you need to determine what operating system is supporting your DB and then speak to a DBA (I'll come back to this in a little while)

 

2.  You need to determine what version of Java your DB2 instance supports.  You need to install this version on the machine running ReadyAPI! (ensuring you install the right version (e.g. JRE/JDK v8.0) as well as whether it's x86 or 64bit.  If your ReadyAPI! is installed in Program Files directory you're running 64bit, so you need to download and install 64bit JRE and vice versa.  Make sure (I'm assuming Windows) that your 'Path' envnironment variable is updated wiht your Java install

 

3.  you need to then download the correct driver .jar files for your DB2 version - note - I cann't remember but it's VERY likely this will be operating system dependent.

 

4.  Speak to your DBA - you have specified the JDBC connection string in your post - there are 2 DB2 default JDBC connection strings installed by default with ReadyAPI! - these may work - they may not.  Whether they work or not is dependent on the DB2 setup.  Speak to a DBA about obtaining the correct details for the DB2 setup you have there - there may be additional parameters that are NOT included in the default JDBC connection strings.  If this is the case the default ones wont work -  you'll have to create a new DB2 connection string in the Preferences  >> JDBC Drivers.

 

There might be a bit of tweaking - but those are essentially the steps I used to connect my SoapUI instance to to DB2.

 

hit me back if you have any further queries!

 

Cheers,

 

rich

 

  • Olga_T's avatar
    Olga_T
    SmartBear Alumni (Retired)
    6 years ago

    Great recommendations, richie, thank you!

     

    jenniferxu99, was this information helpful? We are looking forward to hearing from you.