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": "jdbc:as400://93.63.150.44;prompt=false",
>   "username": "xxx",
>   "password": "xxx",
>   "caseInsensitiveTableNames": false,
>   "enabled": true
> }
>
> Best
> Alessandro
>
>
> -Messaggio originale-
> Da: Matt Rabbitt 
> Inviato: giovedì 25 luglio 2019 18:02
> A: user@drill.apache.org
> Oggetto: Problem creating jt400 jdbc connection
>
> 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
> application requester cannot establish the connection. (Connection was
> dropped unexpectedly.))
>
> I am using jtopen v9.8 jt400.jar, connecting to an AS400 (not totally sure
> what version).  The JDBC driver works in other applications for me like
> DBeaver and jdbcsql.zip.  Config below:
>
> {type: "jdbc",
>   enabled: true,
>   driver: "com.ibm.as400.access.AS400JDBCDriver",
>   url:"jdbc:as400://192.168.1.33:446;prompt=false;translate
> binary=true;naming=sql;toolbox trace=datastream;trace=true",
>   username:"foo",
>   password:"bar"}
>
> The trace outputs a message "Failed to read all of the data stream." before
> failing.  Full trace below:
>
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019  as400:
> Driver AS/400 Toolbox for Java JDBC Driver (1235335025) : connect called
> with URL: jdbc:as400://192.168.1.33:446;prompt=false;translate
> binary=true;naming=sql;toolbox trace=datastream;trace=true.
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : access = "all".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : block size = "32".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : block criteria = "2".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : date format = "".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : date separator = "".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : decimal separator = "".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : errors = "basic".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : extended dynamic = "false".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : libraries = "".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : naming = "sql".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : package = "".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : package add = "true".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : package cache = "false".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : package clear = "false".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : package error = "warning".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : package library = "".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : password = "".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@setString: Properties  (157835982) : prefetch = "true".
> Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
>  as400@set

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
application requester cannot establish the connection. (Connection was
dropped unexpectedly.))

I am using jtopen v9.8 jt400.jar, connecting to an AS400 (not totally sure
what version).  The JDBC driver works in other applications for me like
DBeaver and jdbcsql.zip.  Config below:

{type: "jdbc",
  enabled: true,
  driver: "com.ibm.as400.access.AS400JDBCDriver",
  url:"jdbc:as400://192.168.1.33:446;prompt=false;translate
binary=true;naming=sql;toolbox trace=datastream;trace=true",
  username:"foo",
  password:"bar"}

The trace outputs a message "Failed to read all of the data stream." before
failing.  Full trace below:

Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019  as400:
Driver AS/400 Toolbox for Java JDBC Driver (1235335025) : connect called
with URL: jdbc:as400://192.168.1.33:446;prompt=false;translate
binary=true;naming=sql;toolbox trace=datastream;trace=true.
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : access = "all".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : block size = "32".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : block criteria = "2".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : date format = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : date separator = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : decimal separator = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : errors = "basic".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : extended dynamic = "false".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : libraries = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : naming = "sql".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : package = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : package add = "true".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : package cache = "false".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : package clear = "false".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : package error = "warning".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : package library = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : password = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : prefetch = "true".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : prompt = "false".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : remarks = "system".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : sort = "hex".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : sort language = "ENU".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : sort table = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : sort weight = "shared".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : time format = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : time separator = "".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : trace = "true".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : transaction isolation = "read
uncommitted".
Thread[qtp1108639122-114,5,main]  Thu Jul 25 11:57:25:862 EDT 2019
 as400@setString: Properties  (157835982) : translate