JDBC driver not supported for DB2_UDB_AS400

[Former Member]

Hi All!

We are doing a NW 7.3 dual stack (BI Usage) upgrade (from 7.0 EHP1) on a V7R1 system i.

We are getting this error:

com.sap.sql.log.OpenSQLException caught: JDBC driver not supported for

DB2_UDB_AS400 database...

Can you tell me which Java\driver is supported in this environment?

/qopensys/QIBM/ProdData/JavaVM/jdk14/64bit

/qopensys/QIBM/ProdData/JavaVM/jdk50/64bit

/qopensys/QIBM/ProdData/JavaVM/jdk60/64bit

We had to change <SID>ofr's JAVA_HOME environment variable to jdk60

(from jdk14) to get the STARTUP to run. But then we received the error

above during the configuration phase...

Thanks,

Diana

[Former Member · Accepted solution]

Hi Diane,

I think, you are a bit on the wrong way ...

As you are installing 7.3 SAP is using Java 1.6. SAP uses the SAPJVM only. So, the following ones cannot be used:

/qopensys/QIBM/ProdData/JavaVM/jdk14/64bit

/qopensys/QIBM/ProdData/JavaVM/jdk50/64bit

/qopensys/QIBM/ProdData/JavaVM/jdk60/64bit

You do seem to have issues with the JT400 driver:

com.sap.sql.log.OpenSQLException caught: JDBC driver not supported for

DB2_UDB_AS400 database...

You do need this one:

jt400_7_x_jdbc40_jdk6

and not this one:

jt400_7_x_jdbc30_jdk4

I would hope, that you used the last one, because that would explain your issue ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de

[Former Member · Accepted solution]

Hi Volker,

My JDBC_DRIVER_VERSION_INFO_01.OUT shows:

IBM Toolbox for Java:

Open Source Software, JTOpen 7.4, codebase 5770-SS1 V7R1M0.05 2011/04/25 @CA

Supports JDBC version 4.0

Toolbox driver version 9.5

Any ideas?

Diana

[Former Member · Accepted solution]

Hi Diane,

ok, then I think, there is something screwed up with the JVMs ...

You do face this:

DB2_UDB_AS400 database...

...

We had to change <SID>ofr's JAVA_HOME environment variable to jdk60

(from jdk14) to get the STARTUP to run. But then we received the error

above during the configuration phase...

Where did you place the new JT open driver to ?

You are at the very beginning and therefore most of the stuff is running with the old Java and therefore, you still do need the old JDK3 driver as well ...

btw: it is recommended to split the doublestack before your upgrade ...

I guess, this will end up in a longer oss ticket as upgrading double stack systems is really not a funny thing ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de

[Former Member · Accepted solution]

Thanks Volker,

We have decided to seperate our stacks before the upgrade as you suggested as we have successfully upgraded our ABAP only stacks.

Thanks again.

Diana

[former_member195641 · Accepted solution]

Hello Diana,

just a question from my side. Why you did not opened a customer ticket at SAP for this?

I can't and wouldn't decalare an error-free software. But if the development don't get the information about the bug it will definitely not be fixed.

Best regards,

René Lang

SAP on IBM i Development

[Former Member · Accepted solution]

Hi Rene,

We do have a message open (0000910305) with no response yet.

Thanks,

Diana

Edited by: Diana Wetmore on Nov 3, 2011 1:42 PM

[former_member195641 · Accepted solution]

Hello Diana,

I picked up the ticket and re-routed to the right component (BC-OP-AS4). It's back on you with some questions. Please also explain if the system is still splitted and what is still possible to recreate the problem.

Thanks, René