It works using 9.4 java8 version. Thanks! On Thu, Jul 25, 2019 at 12:07 PM <alessandro.pas...@genomedics.it> 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 <mlrabb...@gmail.com> > 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 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 binary = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : user = "foo". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : package criteria = "default". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : lob threshold = "32768". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : secure = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : data truncation = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : proxy server = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : secondary URL = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : data compression = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : big decimal = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : thread used = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : cursor hold = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : lazy close = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : driver = "toolbox". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : bidi string type = "5". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : REMOVED = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : REMOVED = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : full open = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : server trace = "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : database name = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : extended metadata = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : cursor sensitivity = > "asensitive". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : behavior override = "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : package ccsid = "13488". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : minimum divide scale = "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : maximum precision = "31". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : maximum scale = "31". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : translate hex = "character". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : toolbox trace = "datastream". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : qaqqinilib = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : login timeout = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : true autocommit = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : bidi implicit reordering = > "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : bidi numeric ordering = > "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : hold input locators = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:862 EDT 2019 > as400@setString: Properties (157835982) : hold statements = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : rollback cursor hold = > "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : variable field compression = > "all". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : query optimize goal = "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : keep alive = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : receive buffer size = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : send buffer size = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : XA loosely coupled support = > "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : translate boolean = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : metadata source = "-1". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : query storage limit = "-1". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : decfloat rounding mode = "half > even". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : autocommit exception = > "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : auto commit = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : ignore warnings = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : secure current user = "true". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : concurrent access resolution = > "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : jvm16 synchronize = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : socket timeout = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : use block update = "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : maximum blocked input rows = > "32000". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : query timeout mechanism = > "qqrytimlmt". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : describe option = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : decimal data errors = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : timestamp format = "iso". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : use drda metadata version = > "false". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : query replace truncated > parameter = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : numeric range error = > "default". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : character truncation = > "default". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : portNumber = "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : enableClientAffinitiesList = > "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : > clientRerouteAlternateServerName = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : > clientRerouteAlternatePortNumber = "". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : maxRetriesForClientReroute = > "-1". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : retryIntervalForClientReroute > = > "-1". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : enableSeamlessFailover = "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > as400@setString: Properties (157835982) : affinityFailbackInterval = > "0". > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 as400: > Driver AS/400 Toolbox for Java JDBC Driver (1235335025) : Using IBM Toolbox > for Java JDBC driver implementation. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Getting > system property: 'com.ibm.as400.access.AS400.proxyServer' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > found in system properties: 'null' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > found in jt400.properties file: 'null' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > not found. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Getting > system property: 'com.ibm.as400.access.JDBC.secureCurrentUser' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > found in system properties: 'null' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > found in jt400.properties file: 'null' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > not found. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Getting > NLV. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 NLV > Locale: en_US > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 NLV for > Locale: en, NLV: 2924 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > Constructing AS400 object, system name: '192.168.1.33' user ID: 'foo' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > CredentialVault(byte[] credential) called > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Getting > system property: 'com.ibm.as400.access.AS400.proxyServer' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > found in system properties: 'null' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > found in jt400.properties file: 'null' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Value > not found. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Setting > GUI available: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 > Checking if properties are frozen: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:863 EDT 2019 Getting > socket properties. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Setting > socket login timeout: 0 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Setting > socket properties: com.ibm.as400.access.SocketProperties@63 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Connecting service: 4 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > CredentialVault(byte[] credential) called > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Not > using native optimizations. Reason follows: > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > onAS400: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > systemNameLocal: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > nativeVersion: 0 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Setting > up AS400 implementation object: > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Enable SSL connections: null > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Native optimizations allowed: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Use > threaded communications: true > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 User > specified CCSID: 0 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 NLV: > 2924 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Socket properties: com.ibm.as400.access.SocketProperties@63 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 DDM > RDB: (null) > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Must > use net sockets: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Must > use supplied profile: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Must > add language library: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 User > ID: 'FOO' > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Validate security... > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Signing-on without prompting... > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > CredentialVault clone called > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > CredentialVault.storedEncodedUsingExternalSeeds called > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > CredentialVault.getClearCredential called > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > CredentialVault.disposeOfCredential called > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > CredentialVault.storedEncodedUsingInternalSeeds called > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Read > security validation reply... > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Security validated successfully. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Sign-on > completed. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Disconnecting temporary connection for validating signon info. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Service > disconnected implementation: as-signon > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 > Establishing connection to system: as-database > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Opening > socket for service 4 to system...192.168.1.33 port:446 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Getting > socket login timeout is set: true > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Getting > so socket login timeout: 0 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:864 EDT 2019 Connect > to port mapper: system '192.168.1.33', port 446, login timeout 0 ms. > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 Setting > socket options... > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 Socket > properties: > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Remote address: /192.168.1.33 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Remote port: 446 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Local address: /192.168.1.20 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Local port: 43688 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Keep alive: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Receive buffer size: 186240 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Send buffer size: 43520 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 So > linger: -1 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 So > timeout: 0 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 TCP > no delay: false > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Starting an inet socket to as-database > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 Sending > exchange random seeds request... > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 Data > stream sent (connID=825865471) ... > 00 00 00 1C 01 00 E0 04 00 00 00 00 00 00 00 00 > 00 08 70 01 00 00 01 6C 29 D9 F5 E9 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:865 EDT 2019 > Receiving exchange random seeds reply... > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:870 EDT 2019 Data > stream data received (connID=825865471) ... > 00 15 D0 02 FF FF 00 0F 12 45 00 06 11 49 00 08 > 00 05 11 3F > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:871 EDT 2019 Data > stream data received (connID=825865471) ... > 06 > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:871 EDT 2019 Failed > to read all of the data stream. > java.lang.Throwable > at com.ibm.as400.access.Trace.logData(Trace.java:776) > at com.ibm.as400.access.Trace.log(Trace.java:836) > at > com.ibm.as400.access.DataStream.readAfterHeader(DataStream.java:249) > at > > com.ibm.as400.access.AS400XChgRandSeedReplyDS.read(AS400XChgRandSeedReplyDS.java:62) > at > > com.ibm.as400.access.AS400ImplRemote.getConnection(AS400ImplRemote.java:1404) > at > com.ibm.as400.access.AS400ImplRemote.connect(AS400ImplRemote.java:493) > at com.ibm.as400.access.AS400.connectService(AS400.java:1416) > at > > com.ibm.as400.access.AS400JDBCConnectionImpl.setProperties(AS400JDBCConnectionImpl.java:3486) > at > > com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1426) > at > > com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1280) > at > com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:403) > at > > org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53) > at > > org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) > at > > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395) > at > > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381) > at > > org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110) > at > > org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563) > at > > org.apache.calcite.adapter.jdbc.JdbcUtils$DialectPool.get(JdbcUtils.java:78) > at > > org.apache.calcite.adapter.jdbc.JdbcSchema.createDialect(JdbcSchema.java:184) > at > > org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(JdbcStoragePlugin.java:102) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at > java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.create(StoragePluginRegistryImpl.java:466) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.createOrUpdate(StoragePluginRegistryImpl.java:131) > at > > org.apache.drill.exec.server.rest.PluginConfigWrapper.createOrUpdateInStorage(PluginConfigWrapper.java:56) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePluginJSON(StorageResources.java:193) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePlugin(StorageResources.java:210) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.base/java.lang.reflect.Method.invoke(Method.java:566) > at > > org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) > at > > org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) > at > org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) > at org.glassfish.jersey.internal.Errors.process(Errors.java:315) > at org.glassfish.jersey.internal.Errors.process(Errors.java:297) > at org.glassfish.jersey.internal.Errors.process(Errors.java:267) > at > > org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) > at > org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) > at > > org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) > at > > org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) > at > org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) > at > org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848) > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) > at > > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) > at > > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180) > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513) > at > > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) > at > > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112) > at > > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > at > > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) > at org.eclipse.jetty.server.Server.handle(Server.java:539) > at > org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333) > at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) > at > org.eclipse.jetty.io > .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283) > at org.eclipse.jetty.io > .FillInterest.fillable(FillInterest.java:108) > at > org.eclipse.jetty.io > .SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589) > at java.base/java.lang.Thread.run(Thread.java:834) > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:872 EDT 2019 > Establishing connection failed: > com.ibm.as400.access.ConnectionDroppedException: Connection was dropped > unexpectedly. > at > com.ibm.as400.access.DataStream.readAfterHeader(DataStream.java:250) > at > > com.ibm.as400.access.AS400XChgRandSeedReplyDS.read(AS400XChgRandSeedReplyDS.java:62) > at > > com.ibm.as400.access.AS400ImplRemote.getConnection(AS400ImplRemote.java:1404) > at > com.ibm.as400.access.AS400ImplRemote.connect(AS400ImplRemote.java:493) > at com.ibm.as400.access.AS400.connectService(AS400.java:1416) > at > > com.ibm.as400.access.AS400JDBCConnectionImpl.setProperties(AS400JDBCConnectionImpl.java:3486) > at > > com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1426) > at > > com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1280) > at > com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:403) > at > > org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53) > at > > org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) > at > > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395) > at > > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381) > at > > org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110) > at > > org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563) > at > > org.apache.calcite.adapter.jdbc.JdbcUtils$DialectPool.get(JdbcUtils.java:78) > at > > org.apache.calcite.adapter.jdbc.JdbcSchema.createDialect(JdbcSchema.java:184) > at > > org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(JdbcStoragePlugin.java:102) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at > java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.create(StoragePluginRegistryImpl.java:466) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.createOrUpdate(StoragePluginRegistryImpl.java:131) > at > > org.apache.drill.exec.server.rest.PluginConfigWrapper.createOrUpdateInStorage(PluginConfigWrapper.java:56) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePluginJSON(StorageResources.java:193) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePlugin(StorageResources.java:210) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.base/java.lang.reflect.Method.invoke(Method.java:566) > at > > org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) > at > > org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) > at > org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) > at org.glassfish.jersey.internal.Errors.process(Errors.java:315) > at org.glassfish.jersey.internal.Errors.process(Errors.java:297) > at org.glassfish.jersey.internal.Errors.process(Errors.java:267) > at > > org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) > at > org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) > at > > org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) > at > > org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) > at > org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) > at > org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848) > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) > at > > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) > at > > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180) > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513) > at > > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) > at > > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112) > at > > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > at > > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) > at org.eclipse.jetty.server.Server.handle(Server.java:539) > at > org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333) > at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) > at > org.eclipse.jetty.io > .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283) > at org.eclipse.jetty.io > .FillInterest.fillable(FillInterest.java:108) > at > org.eclipse.jetty.io > .SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589) > at java.base/java.lang.Thread.run(Thread.java:834) > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:873 EDT 2019 as400: > ConnectionImpl null (1449103795) : Throwing exception. Original exception: > .com.ibm.as400.access.ConnectionDroppedException: Connection was dropped > unexpectedly. > at > com.ibm.as400.access.DataStream.readAfterHeader(DataStream.java:250) > at > > com.ibm.as400.access.AS400XChgRandSeedReplyDS.read(AS400XChgRandSeedReplyDS.java:62) > at > > com.ibm.as400.access.AS400ImplRemote.getConnection(AS400ImplRemote.java:1404) > at > com.ibm.as400.access.AS400ImplRemote.connect(AS400ImplRemote.java:493) > at com.ibm.as400.access.AS400.connectService(AS400.java:1416) > at > > com.ibm.as400.access.AS400JDBCConnectionImpl.setProperties(AS400JDBCConnectionImpl.java:3486) > at > > com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1426) > at > > com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1280) > at > com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:403) > at > > org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53) > at > > org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) > at > > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395) > at > > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381) > at > > org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110) > at > > org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563) > at > > org.apache.calcite.adapter.jdbc.JdbcUtils$DialectPool.get(JdbcUtils.java:78) > at > > org.apache.calcite.adapter.jdbc.JdbcSchema.createDialect(JdbcSchema.java:184) > at > > org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(JdbcStoragePlugin.java:102) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at > java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.create(StoragePluginRegistryImpl.java:466) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.createOrUpdate(StoragePluginRegistryImpl.java:131) > at > > org.apache.drill.exec.server.rest.PluginConfigWrapper.createOrUpdateInStorage(PluginConfigWrapper.java:56) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePluginJSON(StorageResources.java:193) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePlugin(StorageResources.java:210) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.base/java.lang.reflect.Method.invoke(Method.java:566) > at > > org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) > at > > org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) > at > org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) > at org.glassfish.jersey.internal.Errors.process(Errors.java:315) > at org.glassfish.jersey.internal.Errors.process(Errors.java:297) > at org.glassfish.jersey.internal.Errors.process(Errors.java:267) > at > > org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) > at > org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) > at > > org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) > at > > org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) > at > org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) > at > org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848) > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) > at > > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) > at > > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180) > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513) > at > > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) > at > > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112) > at > > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > at > > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) > at org.eclipse.jetty.server.Server.handle(Server.java:539) > at > org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333) > at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) > at > org.eclipse.jetty.io > .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283) > at org.eclipse.jetty.io > .FillInterest.fillable(FillInterest.java:108) > at > org.eclipse.jetty.io > .SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589) > at java.base/java.lang.Thread.run(Thread.java:834) > > Thread[qtp1108639122-114,5,main] Thu Jul 25 11:57:25:874 EDT 2019 as400: > ConnectionImpl null (1449103795) : Throwing exception. Actual exception: > The application requester cannot establish the connection. (Connection was > dropped unexpectedly.) sqlState: 08001 vendor code > -99999.java.sql.SQLNonTransientConnectionException: The application > requester cannot establish the connection. (Connection was dropped > unexpectedly.) > at > com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:881) > at com.ibm.as400.access.JDError.throwSQLException(JDError.java:609) > at com.ibm.as400.access.JDError.throwSQLException(JDError.java:567) > at > > com.ibm.as400.access.AS400JDBCConnectionImpl.setProperties(AS400JDBCConnectionImpl.java:3499) > at > > com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1426) > at > > com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1280) > at > com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:403) > at > > org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53) > at > > org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) > at > > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395) > at > > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381) > at > > org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110) > at > > org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563) > at > > org.apache.calcite.adapter.jdbc.JdbcUtils$DialectPool.get(JdbcUtils.java:78) > at > > org.apache.calcite.adapter.jdbc.JdbcSchema.createDialect(JdbcSchema.java:184) > at > > org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(JdbcStoragePlugin.java:102) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at > java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.create(StoragePluginRegistryImpl.java:466) > at > > org.apache.drill.exec.store.StoragePluginRegistryImpl.createOrUpdate(StoragePluginRegistryImpl.java:131) > at > > org.apache.drill.exec.server.rest.PluginConfigWrapper.createOrUpdateInStorage(PluginConfigWrapper.java:56) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePluginJSON(StorageResources.java:193) > at > > org.apache.drill.exec.server.rest.StorageResources.createOrUpdatePlugin(StorageResources.java:210) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.base/java.lang.reflect.Method.invoke(Method.java:566) > at > > org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) > at > > org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) > at > > org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) > at > > org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) > at > org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) > at org.glassfish.jersey.internal.Errors.process(Errors.java:315) > at org.glassfish.jersey.internal.Errors.process(Errors.java:297) > at org.glassfish.jersey.internal.Errors.process(Errors.java:267) > at > > org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) > at > org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) > at > > org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) > at > > org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) > at > org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) > at > > org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) > at > org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848) > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) > at > > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) > at > > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180) > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513) > at > > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) > at > > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112) > at > > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > at > > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) > at org.eclipse.jetty.server.Server.handle(Server.java:539) > at > org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333) > at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) > at > org.eclipse.jetty.io > .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283) > at org.eclipse.jetty.io > .FillInterest.fillable(FillInterest.java:108) > at > org.eclipse.jetty.io > .SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148) > at > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671) > at > > org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589) > at java.base/java.lang.Thread.run(Thread.java:834) > >