dataverse DB2 Iseries JDBC Connection
I'm trying to connect Dataverse 3.2to an Iseries DB2 database using JDBC. The driver is installed
(jt400.jar file) here: /opt/dataverse-3.2.0/lib/java/db/db2i
The DB URL is set as jdbc:as400://"HOST NAME*"/;prompt=false;translate binary=true and the DB Driver com.ibm.as400.access.AS400JDBCDriver
I get an error as follows:
" No suitable driver found for jdbc:as400://"HOST NAME"/;prompt=false;translate binary =true
*DB host name is inserted
Thanks in advance
-
Hi Kevin,
have you populated the driver's path in the DbDriverClasspath property?
Also, its not clear whether /opt/dataverse-3.2.0/ is the Dataverse installation directory but if it is, the recommendation is to not install drivers in folders within the Dataverse installation directory. Rather the Dataverse install's site folder structure should be used, see the help article here:
[Edit: ^ Updated URL]
Regards,
Adrian
-
Thanks Adrian - I can't open the help article for some reason?
I used the help functionality originally which gave the location for the driver file as detailed above.
http://192.168.254.87:8081/docs/dist/help/Default.htm#h-tech-guides/database-connection-urls.htm -
Strange. The preview site's help is accessible from the wider internet (and I just checked it is still up and running).
Maybe something to do with the routing of *.lavastorm.com from your site?
The navigation within the help is Input Connectors > JDBC Query > Advanced database connection
which should display this text
-
Thanks Adrian, possibly a lavastorm.com routing I've tried a number of ways but no success.
Using the example of the file location /opt/dataverse-3.2.0/lib/java/macaccess/uclanload.jar should we be using:/opt/dataverse-3.2.0/lib/java/DB2access/jt400.jar
with the same value in the DBDriverClassPath as above?
Thanks -
The folders under the Dataverse install directory are for drivers that are shipped with the application.
The page you are referring to includes this information:
When the property value {{%ls.appDataDir%}} is substituted it should identify the site folder of the Dataverse instance. You can check how it is being resolved by configuring a Create Data node with the following in the 'Data' property:
path
{{%ls.appDataDir%}}
e.g.
When run it should give you the path to the site folder. Your driver should then be placed in a sub-directory of this folder, at: lib/java/db/<driverName>
You can then either use the system property in in the DbDriverClasspath property (it will automatically resolved when the node is run) or you can manually enter the resolved path
Please sign in to leave a comment.
Comments
9 comments