Re: Problem creating jt400 jdbc connection
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
R: Problem creating jt400 jdbc connection
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@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
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@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