Data360 Analyze

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:

https://d3sa-preview.infogixsaas.com/docs/dist/help/Default.htm#e-node-help/Acquisition/jdbc-query.html#Advanced

[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:

Thanks Adrian, will take a look on Monday. Have a great weekend.

/opt/dataverse-3.2.0/Dataverse/site-7731/ is the path returned.

So the driver should be installed at  /opt/dataverse-3.2.0/Dataverse/site-7731/lib/java/db/DB2i/jt400.jar 

thanks

Yes, and the DbDriverClasspath set to  /opt/dataverse-3.2.0/Dataverse/site-7731/lib/java/db/DB2i

I'll try that Adrian - thanks