Oracle SQL Datamodeler jdbc setup for DB2/400 database

0
votes

What is the correct way to set up Oracle Data Modeler (version 4.0.2.840) to use a (DB2) database on an IBM i (AS/400, iSeries) machine running OS V7.1?

Under the New/Select Database Connection, I selected the JDBC tab, then the "Other ThirdParty Driver", then entered the:

JDBC URL: \xxx.xxx.xxx.xxx\QIBM\ProdData\HTTP\Public\jt400\lib\jt400.jar

Driver Class: com.ibm.as400.access.AS400JDBCDriver

Database Type: DB2/UDB

When I enter a valid Username and Password to test the connection, I get the message:

Status : Failure -Test failed: Driver class not found. Verify the Driver location

I have verified the driver location. I even examined the jar file to verify that the class exists. I've also used the jt400.zip file in the JDBC URL in case that made a difference. It did not.

I also have a copy of the jt400.jar and jt400.zip files in my C:\jt400\lib directory. The path to this directory in in my path and classpath environmental variables.

Any guidance or knowledge will be most appreciated.

1
oraclejdbcibm-midrangedb2-400
JDBC URL: \xxx.xxx.xxx.xxx\QIBM\ProdData\HTTP\Public\jt400\lib\jt400.jar Is that intended to indicate that your process needs to access the JDBC driver through a shared directory from the server in order to access the server's database? Is the directory shared with proper permissions for you? Is the share active in your domain? If you point to your local copy, do you see the same error? - user2338816
I believe I have proper permissions because I can access the file on the remote machine directly via the browser with the URL. I get the same error when I change the JDBC URL to the PC directory of c:\jt400\lib\jt400.jar. But this doesn't seem correct because the database is on the remote system, not the PC. - William60661

1 Answers

1
votes

If you are trying to connect to a DB2 database, your JDBC URL and driver class configurations should reflect that, not that of the AS/400. So try with these configurations:

  • JDBC URL: jdbc:db2://<host>[:<port>]/<database_name>
  • Driver class: com.ibm.db2.jcc.DB2Driver

You will need these 2 JARs as well: db2jcc.jar and db2jcc_license_cu.jar (although I think db2jcc_license_cu.jar is no longer needed.)