Re: Problem creating jt400 jdbc connection

2019-07-25 Thread Matt Rabbitt
It works using 9.4 java8 version. Thanks! On Thu, Jul 25, 2019 at 12:07 PM wrote: > Hi Matt, I tried with 9.4 jt400.rar and it works for me > With this parameters > > { > "type": "jdbc", > "driver": "com.ibm.as400.access.AS400JDBCDriver", > "url":

R: Problem creating jt400 jdbc connection

2019-07-25 Thread alessandro.pasqua
Hi Matt, I tried with 9.4 jt400.rar and it works for me With this parameters { "type": "jdbc", "driver": "com.ibm.as400.access.AS400JDBCDriver", "url": "jdbc:as400://93.63.150.44;prompt=false", "username": "xxx", "password": "xxx", "caseInsensitiveTableNames": false, "enabled": true

Problem creating jt400 jdbc connection

2019-07-25 Thread Matt Rabbitt
Is anyone successfully using the jt400 jdbc driver with Drill? I am trying to add a storage plugin but when I go to create it in the web gui I'm getting an error: Please retry: Error while creating / updating storage : java.sql.SQLException: Cannot create PoolableConnectionFactory (The