From user-return-11213-apmail-drill-user-archive=drill.apache.org@drill.apache.org Wed Jun 24 20:44:19 2020 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by minotaur.apache.org (Postfix) with SMTP id 6A5A719A49 for ; Wed, 24 Jun 2020 20:44:19 +0000 (UTC) Received: (qmail 21945 invoked by uid 500); 24 Jun 2020 20:44:18 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 21898 invoked by uid 500); 24 Jun 2020 20:44:17 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 21882 invoked by uid 99); 24 Jun 2020 20:44:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Jun 2020 20:44:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 9479C18139D for ; Wed, 24 Jun 2020 20:44:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.202 X-Spam-Level: X-Spam-Status: No, score=-0.202 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=cardconnect.com Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 44B91yOnXhsF for ; Wed, 24 Jun 2020 20:44:13 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=40.107.94.77; helo=nam10-mw2-obe.outbound.protection.outlook.com; envelope-from=christopher.kane@cardconnect.com; receiver= Received: from NAM10-MW2-obe.outbound.protection.outlook.com (mail-mw2nam10on2077.outbound.protection.outlook.com [40.107.94.77]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id D8B2FBB8F2 for ; Wed, 24 Jun 2020 20:44:12 +0000 (UTC) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=krlkkFZ5B1tXBz2hfMUbsZ0WfMqN9nDTXLGkxAtiBJw7baDopTfxYcQqz/LYyrij3F38Xq1Yn4qcBQDzML/f4vnLIkWAyc6e37165KJNPP+RqDHMQAkjavh0U5m+75lYaAdYzJVPRZ8tAv5m3oOZkGkBBgPF6h4H7JwX8fUKUxxaZXwtRd22oruSvdUuCBi40HGNga41qUvcx+P093vUm20z8J+/EJuEGH4cqyiSy+vCHxeW5lf2joYhPPFXyQqSh2IGOeYKm0CpUH3hGC5E/i/pdnE4SedhxC6KPGB0mGZWADHapBif+zt4toWpu3ch1xbP/8nXtKcKs4/AFv7YFA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=OVaBQvN7sV70p0tvU8ocIsk3gqwB91k2wS16Ek6T7Hk=; b=Pl2E/HlQOSaZM6NHK8Y3cS8b5KMdF/K55g856B1X2plUQsHjtpBy4FWrMA0OdB6hi4LaSFS/rYtpoeTN9aMKjeLOu/ThhBiKJWg+Pi604lhqdDl3EY/kY7MViVSASZOmpnzo5Baf8V9XPSLAhEi1Y+K+M/jP1+RvfxMdLUtT3Z5a2yV8w5iQNGP4krOmJDDrvKyltyU1t3pBIYIbp+cQaNHkVFC3sUOuk4YgX6MxRpFSXYFvpKsWO8LVqB34rDl6YhrtXXdIKhxWnWNGYqcvTGDbbSBz6AnCwC+eVkiPO4MJj2mHmWEtZyHZ5Hwj+pqgKdqH8rZG8iksaju5eyd0kA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=cardconnect.com; dmarc=pass action=none header.from=cardconnect.com; dkim=pass header.d=cardconnect.com; arc=none X-ASF-DKIM-Sig: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cardconnect.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=OVaBQvN7sV70p0tvU8ocIsk3gqwB91k2wS16Ek6T7Hk=; b=Z5aWFWGRtfQi84ifL0RMLiUms7ZLVQvzd3cK//97OA6umS7zOzcfOz6e3tlWy7HAmBeia91lsL0c0LuY47J8QrorByJ8n6inLL73EOnc+1Bq49cVZcspU5a/Suao+XyATBNsE2vjbh6ywOooISFUR/ZbL3QJLKyDVNN8SfO+G2I= Received: from MN2PR18MB3438.namprd18.prod.outlook.com (2603:10b6:208:16d::23) by MN2PR18MB3462.namprd18.prod.outlook.com (2603:10b6:208:268::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3109.23; Wed, 24 Jun 2020 20:44:04 +0000 Received: from MN2PR18MB3438.namprd18.prod.outlook.com ([fe80::8d0c:75e6:a886:98ba]) by MN2PR18MB3438.namprd18.prod.outlook.com ([fe80::8d0c:75e6:a886:98ba%7]) with mapi id 15.20.3131.021; Wed, 24 Jun 2020 20:44:04 +0000 From: Christopher Kane To: "user@drill.apache.org" Subject: RE: Initial Oracle Setup Thread-Topic: Initial Oracle Setup Thread-Index: AdZJg6/tg4qi5PKFSrS9IsTnqHsAWgAC5sJJAAASwFAAAFTNgAAABUnwAABFOIAAAAPqIAAAU7uQAAAUZAAAAEFZgAAAPTqQAAAy5oAAAHQVoAABXlOAAAFVFLAAADeqUAAudxQAAAKCkAA= Date: Wed, 24 Jun 2020 20:44:04 +0000 Message-ID: References: <55597B3D-A4B3-45D3-A4E7-C94A3C1D001B@gmail.com> <5AF07277-9D0C-494C-8ABC-67D8456E738A@gmail.com> <671F9B28-0904-4E5A-84A9-8520FC40ED9F@gmail.com> <37406C87-866E-4756-BEC1-D264AD2A9EAB@gmail.com> <8E065DC1-F108-4E75-90E3-2A162E7CC96D@gmail.com> In-Reply-To: <8E065DC1-F108-4E75-90E3-2A162E7CC96D@gmail.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: drill.apache.org; dkim=none (message not signed) header.d=none;drill.apache.org; dmarc=none action=none header.from=cardconnect.com; x-originating-ip: [98.115.92.118] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 04fce472-32f9-4564-acf8-08d8187f55a2 x-ms-traffictypediagnostic: MN2PR18MB3462: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:1824; x-forefront-prvs: 0444EB1997 x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 8/9jFiCj1aWeXIppBbm4sqkBQJZ0duAIzbrcF1gHEgUMBo0kf1Lun5BSSempjo0n2XdTr6P8wyFcIZRYOxhNxGPBvzmiK9PuiL/BPzgEhCOL0JXqbfd/d6Hm6G9j1H2cu0z6sRSKQfcX2ufVXZ0VxlSZL7qONlA3hHCTacZv5gNf/7kGBtKsjhT52N7DGY8xPxq+s6OlIiMS0i5D1FILltMx9faKNMFnq1qg5hKnwYZU9R7EowJcbdjoGe91gxLeelLzWQNzEnh7gKJwQYVCzj0T3k4vjKWXlB6Dg6p3mc4e1zghEvOc1GUw9rmV6S/Zo+WJ9eiizpKLHv63taG6qL8tjHM9eThsi02OI9j2XFNUoddPP80/mZZMe+TRxBxRWTGdBoSHnzyPBgLb9inGRw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:MN2PR18MB3438.namprd18.prod.outlook.com;PTR:;CAT:NONE;SFTY:;SFS:(4636009)(346002)(366004)(376002)(39850400004)(136003)(396003)(53546011)(7696005)(86362001)(18074004)(6916009)(83380400001)(66446008)(33656002)(3480700007)(2906002)(44832011)(64756008)(26005)(66556008)(66476007)(8936002)(71200400001)(8676002)(966005)(52536014)(478600001)(5660300002)(6506007)(7116003)(30864003)(66946007)(19627235002)(186003)(316002)(55016002)(9686003)(76116006)(559001)(579004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: mebJ1mB0XPsthefJep7lZ2rd1I2wMo6r0drOfCGjRXpFr+5y3EEQLj4opQVlkNslFJIjbgrRWj34ghWboUvA70AMLtfh/N9LdTf8DwW2Wab1952n/Brbv2I9N0nt/NIZ0uMmCDhA1XKRzUcFBH9+fET4cXOjItxBcMM4fnGcqAl+ER7bFkAdG48wMDovFI+f82vyzz4QV84pR7IkTsYQje0w76b+tk2G0TIMEudPARt3X5hmFpxqa/C2huXJlB3hrUaRWrVoxDCDNKVIhy1HdvMYlhJtJb8srChjic8zddAVExzCOj0xhIRemuvykXwLEMEIdxLY0dCpJyNQJbG+7QIleCrBz5kdRIqSGaeLUylCt1jnvuSVkg8828/+mJPOtg6qjzNSxeTwhKytDvlAXPxe7uL1iLG74fjdmuIl9k5gAzXaA0lfLjpvhJKfeU2HZURqYB7VnBPYBvkTR6ZvIu3t2f4dvnqYBU4AsD7KUrc= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: cardconnect.com X-MS-Exchange-CrossTenant-Network-Message-Id: 04fce472-32f9-4564-acf8-08d8187f55a2 X-MS-Exchange-CrossTenant-originalarrivaltime: 24 Jun 2020 20:44:04.6084 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: c1d81733-b11d-4e19-88ee-24fd3beb4787 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: vuhhVQmYFSIGqTgK0DvOjqV6pcjZ319cfMbqrsIyQa9mQ/fbZIBIeWz32b12PBuJnhhGBKCO2PaQ0g869Ap6DbbRlP111gFH3FFkEbkW7pfTBe/fwO7YM0zXGkdx/Whg X-MS-Exchange-Transport-CrossTenantHeadersStamped: MN2PR18MB3462 Hey Charles, I ran a couple of different queries selecting only a single column from the= table and it seems multiple columns are all giving me the same unknown sql= type -101 error. The stacktrace also appears to be the same per column, so to me it appears = that the issue is maybe with the format of the data itself coming from Orac= le, I'm not too sure at this point. -Chris -----Original Message----- From: Charles Givre Sent: Wednesday, June 24, 2020 3:30 PM To: user Subject: Re: Initial Oracle Setup Hey Christopher, Can you run a query with individual columns so we can see which column is c= ausing the issue? Thx, --C > On Jun 23, 2020, at 5:25 PM, Christopher Kane wrote: > > Rafael > -Okay so doing "show schemas;" (I didn't include the semicolon before) re= sulted in all of the schemas I was expecting to see be listed, so it's awes= ome that Drill was actually able to make the connection. So I do think my i= ssue might be with the data types of the columns in the table I'm trying to= query. > > Charles > -here are the data types on the table "merchant": NUMBER, VARCHAR2, DATE,= TIMESTAMP(6) WITH TIME ZONE. > -if I had to take a guess, I would bet money that the problem child here = is the timestamp data type. > > -----Original Message----- > From: Christopher Kane > Sent: Tuesday, June 23, 2020 5:19 PM > To: user@drill.apache.org > Subject: RE: Initial Oracle Setup > > Rafael > -I am running this in embedded mode on my Windows Laptop and I believe I = have access to the shell but I'm not too familiar with the syntax so I'll h= ave to look that up and I'll let you know what I get. > > Charles > -I'm glad you were able to find something about that error because I was = having a tough time finding something related to it. I actually thought som= ething similar and actually changed my query to only return the merchant_id= of the merchant because I thought maybe there was a column that Drill didn= 't know how to handle. I will take a look at the stackoverflow link that yo= u sent me and will let you know what I come up with. > -Here is the stacktrace for the VALIDATION ERROR: > 2020-06-23 17:15:56,017 [qtp409347742-245] ERROR o.a.d.e.server.rest.Quer= yResources - Query from Web UI Failed: {} > org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR:= Unknown SQL type -101 > > > [Error Id: def7533c-bb11-48da-b770-28c6730a1799 ] at org.apache.drill.exe= c.server.rest.RestQueryRunner.submitQuery(RestQueryRunner.java:181) > at org.apache.drill.exec.server.rest.RestQueryRunner.run(RestQueryRunner.= java:70) > at org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(Query= Resources.java:96) > at org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryReso= urces.java:114) > at jdk.internal.reflect.GeneratedMethodAccessor16.invoke(Unknown Source) = at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Deleg= atingMethodAccessorImpl.java:43) > at java.base/java.lang.reflect.Method.invoke(Method.java:564) > at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHan= dlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) > at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodD= ispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) > at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodD= ispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) > at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatche= rProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.ja= va:205) > at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodD= ispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) > at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(Resourc= eMethodInvoker.java:389) > at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resource= MethodInvoker.java:347) > at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resource= MethodInvoker.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(RequestS= cope.java:317) > at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:3= 05) > at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandl= er.java:1154) > at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.jav= a:473) > at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:42= 7) > 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$CachedChain.doFilter(ServletH= andler.java:1780) > at org.apache.drill.exec.server.rest.header.ResponseHeadersSettingFilter.= doFilter(ResponseHeadersSettingFilter.java:71) > at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletH= andler.java:1767) > at org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter(Csr= fTokenValidateFilter.java:55) > at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletH= andler.java:1767) > at org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(CsrfT= okenInjectFilter.java:54) > at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletH= andler.java:1767) > at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:= 583) > at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandle= r.java:224) > at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandle= r.java:1180) > at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:5= 13) > 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.ja= va: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(Abstrac= tConnection.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.executePr= oduceConsume(ExecuteProduceConsume.java:303) > at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceCo= nsume(ExecuteProduceConsume.java:148) > at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(Execu= teProduceConsume.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:832) > Caused by: java.lang.IllegalArgumentException: Unknown SQL type -101 at o= rg.apache.calcite.avatica.SqlType.valueOf(SqlType.java:383) > at org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema.j= ava:385) > at org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema.j= ava:362) > at org.apache.calcite.adapter.jdbc.JdbcTable.getRowType(JdbcTable.java:11= 7) > at org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:15= 9) > at org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.jav= a:99) > at org.apache.calcite.sql.validate.DelegatingScope.resolveTable(Delegatin= gScope.java:203) > at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(Identi= fierNamespace.java:105) > at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(Ident= ifierNamespace.java:177) > at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNam= espace.java:84) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(Sql= ValidatorImpl.java:1009) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlVali= datorImpl.java:969) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValid= atorImpl.java:3129) > at org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFr= om(DrillValidator.java:63) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValid= atorImpl.java:3111) > at org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFr= om(DrillValidator.java:63) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlVal= idatorImpl.java:3383) > at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNam= espace.java:60) > at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNam= espace.java:84) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(Sql= ValidatorImpl.java:1009) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlVali= datorImpl.java:969) > at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:216) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpress= ion(SqlValidatorImpl.java:944) > at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidator= Impl.java:651) > at org.apache.drill.exec.planner.sql.conversion.SqlConverter.validate(Sql= Converter.java:189) > at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateN= ode(DefaultSqlHandler.java:641) > at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateA= ndConvert(DefaultSqlHandler.java:195) > at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(D= efaultSqlHandler.java:169) > at org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSql= Worker.java:283) > at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(Drill= SqlWorker.java:163) > at org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlW= orker.java:128) > at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorke= r.java:93) > at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:593) > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:274) > at .......(:0) > > > > -----Original Message----- > From: Charles Givre > Sent: Tuesday, June 23, 2020 4:35 PM > To: user@drill.apache.org > Subject: Re: Initial Oracle Setup > > One more thing... > > Could you run the query that is producing the VALIDATION ERROR and send t= he full stack trace? I'm thinking that can be fixed on the Drill end of th= ings, at least until Calcite fixes that. > -- C > >> On Jun 23, 2020, at 3:58 PM, Christopher Kane wrote: >> >> Yes thank you! To your point about using 1.17, I could always take the c= onfig from 1.18 and copy it over and see if that fixes my issue. >> >> I think the only thing I'm having an issue with now I think is related >> to this: >> https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__issues.apache.org >> _jira_browse_CALCITE-2D3533&d=3DDwIFAg&c=3DrE3mhBYFJfJGqQ7WI0-DPw&r=3DBY= RbCB >> lPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=3Dg39OzDxVVrucBo3nnaZNaIqoh9SZZi >> dthZ3H6QSOkWE&s=3DoVohCx-25EZLkSVY7yEV1FtFZ-nNDTnGvek4Sx67nYc&e=3D >> >> Everything appears to be setup now but when executing a query for the da= ta source I setup, I receive org.apache.drill.common.exceptions.UserRemoteE= xception: VALIDATION ERROR: Unknown SQL type -101. Any suggestions there? >> >> -----Original Message----- >> From: Rafael Jaimes III >> Sent: Tuesday, June 23, 2020 3:43 PM >> To: user@drill.apache.org >> Subject: Re: Initial Oracle Setup >> >> Glad you got it working with the new version regardless! >> >> On Tue, Jun 23, 2020 at 3:38 PM Christopher Kane wrote: >>> >>> Wow, I gotta hand it to you, I don't know what I was expecting to happe= n but I got a Success! So that's awesome, thank you so much for your help! = I am going to quickly run a test query on this data source now and see what= happens. >>> >>> -----Original Message----- >>> From: Christopher Kane >>> Sent: Tuesday, June 23, 2020 3:31 PM >>> To: user@drill.apache.org >>> Subject: RE: Initial Oracle Setup >>> >>> Yeah I am not the most familiar with building from source, so I'll chec= k out your pre-release, install it like I did 1.17.0 and see what happens! >>> >>> -----Original Message----- >>> From: Charles Givre >>> Sent: Tuesday, June 23, 2020 3:23 PM >>> To: user >>> Subject: Re: Initial Oracle Setup >>> >>> It hasn't been released yet, so you'd have to d/l from github >>> (https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__github.com_apac >>> h >>> e_drill&d=3DDwIFAg&c=3DrE3mhBYFJfJGqQ7WI0-DPw&r=3DBYRbCBlPlEiTy68EGn8lf= llmV >>> q >>> BXbraSyDLC7XDswJU&m=3Db6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s=3DC= 8v >>> 5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e=3D >>> >> h >>> e_drill&d=3DDwIFAg&c=3DrE3mhBYFJfJGqQ7WI0-DPw&r=3DBYRbCBlPlEiTy68EGn8lf= llmV >>> q >>> BXbraSyDLC7XDswJU&m=3Db6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s=3DC= 8v >>> 5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e=3D >) and build from >>> source. >>> If you can't do that, I have a pre-release here: >>> https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__github.com_cgivr >>> e >>> _drill_releases_tag_1.18.0-2DSNAPSHOT&d=3DDwIFAg&c=3DrE3mhBYFJfJGqQ7WI0= -D >>> P >>> w&r=3DBYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=3Db6gHt-qP_soEwZSNl= oM >>> 5 >>> zPbmSepKW4FaAKoOwoxYlUk&s=3D3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H-qXY0 >>> & >>> e=3D >>> >> r >>> e_drill_releases_tag_1.18.0-2DSNAPSHOT&d=3DDwIFAg&c=3DrE3mhBYFJfJGqQ7WI= 0- >>> D >>> Pw&r=3DBYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=3Db6gHt-qP_soEwZSN= lo >>> M >>> 5zPbmSepKW4FaAKoOwoxYlUk&s=3D3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H-qXY >>> 0 >>> &e=3D > >>> >>> >>>> On Jun 23, 2020, at 3:21 PM, Christopher Kane wrote: >>>> >>>> You might have to provide a link for Drill 1.18, I'm not seeing that a= vailable on the downloads section of the site. >>>> >>>> -----Original Message----- >>>> From: Christopher Kane >>>> Sent: Tuesday, June 23, 2020 3:14 PM >>>> To: user@drill.apache.org >>>> Subject: RE: Initial Oracle Setup >>>> >>>> I'm all for it honestly, I've never used Apache Drill before and am tr= ying it out as a POC for something I'm trying to do at work. So you're sayi= ng in addition to the driver required by whichever RDBMS you're setting up,= there is an Apache Drill JDBC plugin that works in combination with the dr= iver? >>>> >>>> -----Original Message----- >>>> From: Charles Givre >>>> Sent: Tuesday, June 23, 2020 3:11 PM >>>> To: user@drill.apache.org >>>> Subject: Re: Initial Oracle Setup >>>> >>>> Another qq: Would you be willing to try Drill 1.18? There were some = significant changes made to the JDBC plugin in 1.18 and I wonder if that mi= ght solve the issue. >>>> >>>>> On Jun 23, 2020, at 3:05 PM, Christopher Kane wrote: >>>>> >>>>> On both the directory of drill and on startup I am running Apache >>>>> Drill 1.17.0 >>>>> >>>>> -----Original Message----- >>>>> From: Charles Givre > >>>>> Sent: Tuesday, June 23, 2020 3:03 PM >>>>> To: user > >>>>> Subject: Re: Initial Oracle Setup >>>>> >>>>> One more question.. what version of Drill are you using? >>>>> >>>>> >>>>>> On Jun 23, 2020, at 3:01 PM, Christopher Kane wrote: >>>>>> >>>>>> Rafael >>>>>> -I did place it in the jars/3rdparty folder. >>>>>> >>>>>> Storage Plugin Config: >>>>>> { >>>>>> "type": "jdbc", >>>>>> "enabled": true, >>>>>> "driver": "oracle.jdbc.driver.OracleDriver", >>>>>> "url": "jdbc:oracle:thin:username/password@chris-ora-scan:1521/chris= _app" >>>>>> } >>>>>> (it's been modified to remove sensitive information) >>>>>> >>>>>> Charles >>>>>> -I did turn Verbose on as you instructed, below is the full stacktra= ce. Now I will say that the one DBA I was conversing with mentioned somethi= ng about JRE, and I find interesting in this stack trace that it seems to b= e a RunTime exception. >>>>>> -I'm not sure if I was aware they were at a version 10? This is the = link I was using to download the JDBC driver: https://urldefense.proofpoint= .com/v2/url?u=3Dhttps-3A__www.oracle.com_database_technologies_jdbc-2Ddrive= rs-2D12c-2Ddownloads.html&d=3DDwIFAg&c=3DrE3mhBYFJfJGqQ7WI0-DPw&r=3DBYRbCBl= PlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=3D8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbA= JL9oQht0s&s=3Dzddp1Im2FovgkwAQ3SyRaJzBS1FxeOgiwYdViTSn4H4&e=3D and the only options I see available and relevant are either ojdbc7= .jar or ojdbc6.jar. At this point I've tried both but am willing to change = my configuration while troubleshooting. In addition the recommended driver = for Oracle by Apache seems to be ojdbc7.12.1.0.2.jar referenced from this p= age here: https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__drill.apac= he.org_docs_rdbms-2Dstorage-2Dplugin_&d=3DDwIFAg&c=3DrE3mhBYFJfJGqQ7WI0-DPw= &r=3DBYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=3D8cPWOW4PY_sKPTUxECbL9X= acM9DQCSnBbAJL9oQht0s&s=3DrzaAsfW2VGICMfzMAhjoT2vZqBRkti6X56uH4Uv1HU0&e=3D = and tha= t is the one I am currently using, ojdbc7.jar from the 12.1.0.2 release of = Oracle Database. >>>>>> >>>>>> 2020-06-23 14:52:37,017 [qtp377017996-50] ERROR >>>>>> o.a.d.e.server.rest.StorageResources - Unable to create/ update >>>>>> plugin: QA2 Oracle >>>>>> org.apache.drill.common.exceptions.ExecutionSetupException: >>>>>> Failure setting up new storage plugin configuration for config >>>>>> org.apache.drill.exec.store.jdbc.JdbcStorageConfig@7d9c9e53 >>>>>> at >>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.create(Stora >>>>>> ge >>>>>> P >>>>>> l >>>>>> uginRegistryImpl.java:536) at >>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.createOrUpda >>>>>> te >>>>>> ( >>>>>> S >>>>>> toragePluginRegistryImpl.java:132) >>>>>> at >>>>>> org.apache.drill.exec.server.rest.PluginConfigWrapper.createOrUpda >>>>>> te >>>>>> I >>>>>> n >>>>>> Storage(PluginConfigWrapper.java:56) >>>>>> at >>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpdateP >>>>>> lu >>>>>> g >>>>>> i >>>>>> nJSON(StorageResources.java:212) at >>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpdateP >>>>>> lu >>>>>> g >>>>>> i >>>>>> n(StorageResources.java:233) at >>>>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Na >>>>>> ti >>>>>> v >>>>>> e >>>>>> Method) at >>>>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Nat >>>>>> iv >>>>>> e >>>>>> M >>>>>> ethodAccessorImpl.java:62) at >>>>>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke >>>>>> (D >>>>>> e >>>>>> l >>>>>> egatingMethodAccessorImpl.java:43) >>>>>> at java.base/java.lang.reflect.Method.invoke(Method.java:564) >>>>>> at >>>>>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocatio >>>>>> nH >>>>>> a >>>>>> n >>>>>> dlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:8 >>>>>> 1) >>>>>> at >>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMet >>>>>> ho >>>>>> d >>>>>> D >>>>>> ispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) >>>>>> at >>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMet >>>>>> ho >>>>>> d >>>>>> D >>>>>> ispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) >>>>>> at >>>>>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispa >>>>>> tc >>>>>> h >>>>>> e >>>>>> rProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherPr >>>>>> ov >>>>>> i >>>>>> d >>>>>> er.java:205) at >>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMet >>>>>> ho >>>>>> d >>>>>> D >>>>>> ispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) >>>>>> at >>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(Res >>>>>> ou >>>>>> r >>>>>> c >>>>>> eMethodInvoker.java:389) at >>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Reso >>>>>> ur >>>>>> c >>>>>> e >>>>>> MethodInvoker.java:347) at >>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Reso >>>>>> ur >>>>>> c >>>>>> e >>>>>> MethodInvoker.java:102) at >>>>>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java >>>>>> :3 >>>>>> 2 >>>>>> 6 >>>>>> ) 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(Requ >>>>>> es >>>>>> t >>>>>> S >>>>>> cope.java:317) at >>>>>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java= : >>>>>> 3 >>>>>> 05) at >>>>>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationH >>>>>> an >>>>>> d >>>>>> l >>>>>> er.java:1154) at >>>>>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent >>>>>> .j >>>>>> a >>>>>> v >>>>>> a:473) at >>>>>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java: >>>>>> 4 >>>>>> 2 >>>>>> 7) at >>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletConta >>>>>> in >>>>>> e >>>>>> r >>>>>> .java:388) at >>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletConta >>>>>> in >>>>>> e >>>>>> r >>>>>> .java:341) at >>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletConta >>>>>> in >>>>>> e >>>>>> r >>>>>> .java:228) at >>>>>> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java: >>>>>> 84 >>>>>> 8 >>>>>> ) >>>>>> at >>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv >>>>>> le >>>>>> t >>>>>> H >>>>>> andler.java:1780) at >>>>>> org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter >>>>>> (C >>>>>> s >>>>>> r >>>>>> fTokenValidateFilter.java:55) at >>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv >>>>>> le >>>>>> t >>>>>> H >>>>>> andler.java:1767) at >>>>>> org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(C >>>>>> sr >>>>>> f >>>>>> T >>>>>> okenInjectFilter.java:54) at >>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv >>>>>> le >>>>>> t >>>>>> H >>>>>> andler.java:1767) at >>>>>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.jav= a: >>>>>> 583) at >>>>>> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHa >>>>>> nd >>>>>> l >>>>>> e >>>>>> r.java:224) at >>>>>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHa >>>>>> nd >>>>>> l >>>>>> e >>>>>> r.java:1180) at >>>>>> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java= : >>>>>> 5 >>>>>> 13) at >>>>>> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHan >>>>>> dl >>>>>> e >>>>>> r >>>>>> .java:185) at >>>>>> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHan >>>>>> dl >>>>>> e >>>>>> r >>>>>> .java:1112) at >>>>>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler. >>>>>> j >>>>>> a >>>>>> va:141) at >>>>>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrappe= r. >>>>>> 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. >>>>>> ja >>>>>> v >>>>>> a >>>>>> :251) at >>>>>> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(Abs >>>>>> tr >>>>>> a >>>>>> c >>>>>> tConnection.java:283) at >>>>>> org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108) >>>>>> at >>>>>> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndP >>>>>> oi >>>>>> n >>>>>> t >>>>>> .java:93) at >>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.execu >>>>>> te >>>>>> P >>>>>> r >>>>>> oduceConsume(ExecuteProduceConsume.java:303) >>>>>> at >>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produ >>>>>> ce >>>>>> C >>>>>> o >>>>>> nsume(ExecuteProduceConsume.java:148) >>>>>> at >>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(E >>>>>> xe >>>>>> c >>>>>> u >>>>>> teProduceConsume.java:136) at >>>>>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThread >>>>>> Po >>>>>> o >>>>>> l >>>>>> .java:671) at >>>>>> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPoo= l. >>>>>> java:589) at java.base/java.lang.Thread.run(Thread.java:832) >>>>>> Caused by: java.lang.RuntimeException: Rule description >>>>>> 'JDBC_DREL_ConverterJDBC.QA2 Oracle' is not valid at >>>>>> org.apache.calcite.plan.RelOptRule.(RelOptRule.java:104) >>>>>> at >>>>>> org.apache.calcite.rel.convert.ConverterRule.(ConverterRule. >>>>>> ja >>>>>> v >>>>>> a >>>>>> :78) at >>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$JdbcDrelConvert >>>>>> er >>>>>> R >>>>>> u >>>>>> le.(JdbcStoragePlugin.java:224) >>>>>> at >>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$DrillJdbcConven >>>>>> ti >>>>>> o >>>>>> n >>>>>> .(JdbcStoragePlugin.java:119) >>>>>> at >>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.(JdbcStor >>>>>> ag >>>>>> e >>>>>> P >>>>>> lugin.java:103) at >>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newIn >>>>>> st >>>>>> a >>>>>> n >>>>>> ce0(Native Method) at >>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newIn >>>>>> st >>>>>> a >>>>>> n >>>>>> ce(NativeConstructorAccessorImpl.java:62) >>>>>> at >>>>>> java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.n >>>>>> ew >>>>>> I >>>>>> n >>>>>> stance(DelegatingConstructorAccessorImpl.java:45) >>>>>> at >>>>>> java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Cons >>>>>> tr >>>>>> u >>>>>> c >>>>>> tor.java:500) at >>>>>> java.base/java.lang.reflect.Constructor.newInstance(Constructor.java= : >>>>>> 4 >>>>>> 81) at >>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.create(Stora >>>>>> ge >>>>>> P >>>>>> l >>>>>> uginRegistryImpl.java:528) >>>>>> ... 56 common frames omitted >>>>>> >>>>>> -----Original Message----- >>>>>> From: Charles Givre >>>>>> Sent: Tuesday, June 23, 2020 2:51 PM >>>>>> To: user@drill.apache.org >>>>>> Subject: Re: Initial Oracle Setup >>>>>> >>>>>> One more thing... >>>>>> Did you try with the current Oracle JDBC driver? I believe they are= at version 10 now. >>>>>> Thanks, >>>>>> -- C >>>>>> >>>>>>> On Jun 23, 2020, at 1:59 PM, Rafael Jaimes III wrote: >>>>>>> >>>>>>> Hi Chris, >>>>>>> >>>>>>> You put the JDBC driver in the 3rd party folder? >>>>>>> >>>>>>> You're right you might be onto something if you get the password >>>>>>> failed message. Can you post the exact text (JSON) of the storage >>>>>>> plugin config? >>>>>>> >>>>>>> -Rafael >>>>>>> >>>>>>> On Tue, Jun 23, 2020 at 1:56 PM Christopher Kane >>>>>>> wrote: >>>>>>>> >>>>>>>> Hey Everyone, >>>>>>>> >>>>>>>> I'm looking to setup and create a new Oracle Storage Plugin for my= local Apache Drill instance. I have determined that a correct oracle conne= ction string with an incorrect password results in the following message: P= lease retry: Error while creating / updating storage : java.sql.SQLExceptio= n: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/pas= sword; logon denied ). Now updating the connection string to use the correc= t password results in the following message: Please retry: Error while crea= ting / updating storage : Rule description 'JDBC_DREL_ConverterJDBC.QA2 Ora= cle' is not valid. >>>>>>>> >>>>>>>> I have confirmed with our DBAs and through my own testing that my = connection string is correct. When attempting to google anything related to= the message 'JDBC_DREL_Converter' unfortunately I am not able to find anyt= hing useful. At this point I'm kind of grasping at straws as to what my iss= ue is at this point. In addition I also have the correct oracle thin driver= installed, which was the recommend one from the RDBMS page within the Apac= he Drill documentation and I've also added this line to my drill-override.c= onf, drill.exec.sys.store.provider.local.path =3D "ojdbc7.jar". But I'm ass= uming if any of that wasn't setup correctly, I wouldn't be able to get an e= rror message back from Oracle saying that my password was incorrect. Any he= lp in regards to this would be greatly appreciated. >>>>>>>> >>>>>>>> Christopher Kane >>>>>>>> Software Test Engineer | Clover, CardConnect, FiServ >>>>>>>> ckane@clover.com, >>>>>>>> Christopher.Kane@cardconnect.com>>>>>>> com>, >>>>>>>> Christopher.Kane2@firstdata.com>>>>>>> c >>>>>>>> o >>>>>>>> m>, >>>>>>>> m>Christopher.Kane1@fiserv.com>>>>>>> m>om >>>>>>>> m>> >>>>>>>> >>>>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachme= nts are proprietary and confidential information protected from disclosure = and intended only for the use of the recipient(s) named above. If the reade= r of this message is not the intended recipient, or an employee or agent re= sponsible for delivering this message to the intended recipient, you are he= reby notified that any dissemination, distribution or copying of this messa= ge or any attachments is strictly prohibited. If you have received this com= munication in error, please notify CardConnect immediately by replying to t= his message and then delete this message and any attachments from your comp= uter. >>>>>> >>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachment= s are proprietary and confidential information protected from disclosure an= d intended only for the use of the recipient(s) named above. If the reader = of this message is not the intended recipient, or an employee or agent resp= onsible for delivering this message to the intended recipient, you are here= by notified that any dissemination, distribution or copying of this message= or any attachments is strictly prohibited. If you have received this commu= nication in error, please notify CardConnect immediately by replying to thi= s message and then delete this message and any attachments from your comput= er. >>>>> >>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments= are proprietary and confidential information protected from disclosure and= intended only for the use of the recipient(s) named above. If the reader o= f this message is not the intended recipient, or an employee or agent respo= nsible for delivering this message to the intended recipient, you are hereb= y notified that any dissemination, distribution or copying of this message = or any attachments is strictly prohibited. If you have received this commun= ication in error, please notify CardConnect immediately by replying to this= message and then delete this message and any attachments from your compute= r. >>>> >>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments = are proprietary and confidential information protected from disclosure and = intended only for the use of the recipient(s) named above. If the reader of= this message is not the intended recipient, or an employee or agent respon= sible for delivering this message to the intended recipient, you are hereby= notified that any dissemination, distribution or copying of this message o= r any attachments is strictly prohibited. If you have received this communi= cation in error, please notify CardConnect immediately by replying to this = message and then delete this message and any attachments from your computer= . >>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments = are proprietary and confidential information protected from disclosure and = intended only for the use of the recipient(s) named above. If the reader of= this message is not the intended recipient, or an employee or agent respon= sible for delivering this message to the intended recipient, you are hereby= notified that any dissemination, distribution or copying of this message o= r any attachments is strictly prohibited. If you have received this communi= cation in error, please notify CardConnect immediately by replying to this = message and then delete this message and any attachments from your computer= . >>> >>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments a= re proprietary and confidential information protected from disclosure and i= ntended only for the use of the recipient(s) named above. If the reader of = this message is not the intended recipient, or an employee or agent respons= ible for delivering this message to the intended recipient, you are hereby = notified that any dissemination, distribution or copying of this message or= any attachments is strictly prohibited. If you have received this communic= ation in error, please notify CardConnect immediately by replying to this m= essage and then delete this message and any attachments from your computer. >>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments a= re proprietary and confidential information protected from disclosure and i= ntended only for the use of the recipient(s) named above. If the reader of = this message is not the intended recipient, or an employee or agent respons= ible for delivering this message to the intended recipient, you are hereby = notified that any dissemination, distribution or copying of this message or= any attachments is strictly prohibited. If you have received this communic= ation in error, please notify CardConnect immediately by replying to this m= essage and then delete this message and any attachments from your computer. >> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments ar= e proprietary and confidential information protected from disclosure and in= tended only for the use of the recipient(s) named above. If the reader of t= his message is not the intended recipient, or an employee or agent responsi= ble for delivering this message to the intended recipient, you are hereby n= otified that any dissemination, distribution or copying of this message or = any attachments is strictly prohibited. If you have received this communica= tion in error, please notify CardConnect immediately by replying to this me= ssage and then delete this message and any attachments from your computer. > > THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are= proprietary and confidential information protected from disclosure and int= ended only for the use of the recipient(s) named above. If the reader of th= is message is not the intended recipient, or an employee or agent responsib= le for delivering this message to the intended recipient, you are hereby no= tified that any dissemination, distribution or copying of this message or a= ny attachments is strictly prohibited. If you have received this communicat= ion in error, please notify CardConnect immediately by replying to this mes= sage and then delete this message and any attachments from your computer. > THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are= proprietary and confidential information protected from disclosure and int= ended only for the use of the recipient(s) named above. If the reader of th= is message is not the intended recipient, or an employee or agent responsib= le for delivering this message to the intended recipient, you are hereby no= tified that any dissemination, distribution or copying of this message or a= ny attachments is strictly prohibited. If you have received this communicat= ion in error, please notify CardConnect immediately by replying to this mes= sage and then delete this message and any attachments from your computer. THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are p= roprietary and confidential information protected from disclosure and inten= ded only for the use of the recipient(s) named above. If the reader of this= message is not the intended recipient, or an employee or agent responsible= for delivering this message to the intended recipient, you are hereby noti= fied that any dissemination, distribution or copying of this message or any= attachments is strictly prohibited. If you have received this communicatio= n in error, please notify CardConnect immediately by replying to this messa= ge and then delete this message and any attachments from your computer.