drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Rabbitt <mlrabb...@gmail.com>
Subject Re: Problem creating jt400 jdbc connection
Date Thu, 25 Jul 2019 16:33:27 GMT
It works using 9.4 java8 version.  Thanks!

On Thu, Jul 25, 2019 at 12:07 PM <alessandro.pasqua@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 <mlrabbitt@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)
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message