Alright so following that logic of Data Type 101 being a binary double, I did the following: select CAST(merchant_id AS DOUBLE) from biz.merchant where merchant_id=85616270
That unfortunately still results in the unknown sql type -101 error. I did want to say that I was able to go onto the CLI and have it list out all the schemas and tables it could find and what it listed was correct so at least we know we are connected to what we should be. -----Original Message----- From: Charles Givre <cgi...@gmail.com> Sent: Wednesday, June 24, 2020 4:55 PM To: user@drill.apache.org Subject: Re: Initial Oracle Setup I looked this up… SQL Data Type 101 is a binary double. https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.oracle.com_database_121_SQLRF_sql-5Felements001.htm-23SQLRF30020&d=DwIFaQ&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=92i9K_mRKLwMJIZS_WhSN_ymKbr9rZoUleISKhZY3sE&s=zj9nUe9KXfBlHIyl4ie5_edWAPRFshIVqbqiRRDh2qs&e= <https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.oracle.com_database_121_SQLRF_sql-5Felements001.htm-23SQLRF30020&d=DwIFaQ&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=92i9K_mRKLwMJIZS_WhSN_ymKbr9rZoUleISKhZY3sE&s=zj9nUe9KXfBlHIyl4ie5_edWAPRFshIVqbqiRRDh2qs&e= > > On Jun 24, 2020, at 4:52 PM, Charles Givre <cgi...@gmail.com> wrote: > > Some more questions… > 1. Are there other tables you can query? I want to see if we can at > least get something to work ;-) (Although we can read the schema via SHOW > TABLES) 2. Can you try the following query: > SELECT CAST(<some field> AS INT) > FROM merchant…. Basically I’m wondering if we force Drill to map the field > to a type, if we can get it to read the data. > > > >> On Jun 24, 2020, at 4:44 PM, Christopher Kane >> <christopher.k...@cardconnect.com.INVALID> wrote: >> >> 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 >> Oracle, I'm not too sure at this point. >> >> -Chris >> >> -----Original Message----- >> From: Charles Givre <cgi...@gmail.com> >> Sent: Wednesday, June 24, 2020 3:30 PM >> To: user <user@drill.apache.org> >> Subject: Re: Initial Oracle Setup >> >> Hey Christopher, >> Can you run a query with individual columns so we can see which column is >> causing the issue? >> Thx, >> --C >> >> >> >>> On Jun 23, 2020, at 5:25 PM, Christopher Kane >>> <christopher.k...@cardconnect.com.INVALID> wrote: >>> >>> Rafael >>> -Okay so doing "show schemas;" (I didn't include the semicolon before) >>> resulted in all of the schemas I was expecting to see be listed, so it's >>> awesome that Drill was actually able to make the connection. So I do think >>> my issue 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 <christopher.k...@cardconnect.com.INVALID> >>> 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 >>> have 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 >>> something 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 you 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.QueryResources - 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.exec.server.rest.RestQueryRunner.submitQuery(RestQu >>> eryRunner.java:181) at >>> org.apache.drill.exec.server.rest.RestQueryRunner.run(RestQueryRunne >>> r.java:70) at >>> org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(Que >>> ryResources.java:96) at >>> org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryRe >>> sources.java:114) at >>> jdk.internal.reflect.GeneratedMethodAccessor16.invoke(Unknown >>> Source) at >>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(D >>> elegatingMethodAccessorImpl.java:43) >>> at java.base/java.lang.reflect.Method.invoke(Method.java:564) >>> at >>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationH >>> andlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:8 >>> 1) at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMetho >>> dDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMetho >>> dDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) >>> at >>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatc >>> herProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherPr >>> ovider.java:205) at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMetho >>> dDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(Resou >>> rceMethodInvoker.java:389) at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resour >>> ceMethodInvoker.java:347) at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resour >>> ceMethodInvoker.java:102) at >>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:3 >>> 26) 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(Reques >>> tScope.java:317) at >>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java >>> :305) at >>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHan >>> dler.java:1154) at >>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.j >>> ava:473) at >>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java: >>> 427) at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContain >>> er.java:388) at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContain >>> er.java:341) at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContain >>> er.java:228) at >>> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:84 >>> 8) at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servle >>> tHandler.java:1780) at >>> org.apache.drill.exec.server.rest.header.ResponseHeadersSettingFilte >>> r.doFilter(ResponseHeadersSettingFilter.java:71) >>> at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servle >>> tHandler.java:1767) at >>> org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter(C >>> srfTokenValidateFilter.java:55) at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servle >>> tHandler.java:1767) at >>> org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(Csr >>> fTokenInjectFilter.java:54) at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servle >>> tHandler.java:1767) at >>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.jav >>> a:583) at >>> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHand >>> ler.java:224) at >>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHand >>> ler.java:1180) at >>> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java >>> :513) at >>> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandl >>> er.java:185) at >>> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandl >>> er.java:1112) at >>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler. >>> java: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 >>> va:251) at >>> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(Abstr >>> actConnection.java:283) at >>> org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108) >>> at >>> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoi >>> nt.java:93) at >>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.execute >>> ProduceConsume(ExecuteProduceConsume.java:303) >>> at >>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produce >>> Consume(ExecuteProduceConsume.java:148) >>> at >>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(Exe >>> cuteProduceConsume.java:136) at >>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPo >>> ol.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.IllegalArgumentException: Unknown SQL type -101 >>> at org.apache.calcite.avatica.SqlType.valueOf(SqlType.java:383) >>> at >>> org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema >>> .java:385) at >>> org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema >>> .java:362) at >>> org.apache.calcite.adapter.jdbc.JdbcTable.getRowType(JdbcTable.java: >>> 117) at >>> org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java: >>> 159) at >>> org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.j >>> ava:99) at >>> org.apache.calcite.sql.validate.DelegatingScope.resolveTable(Delegat >>> ingScope.java:203) at >>> org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(Iden >>> tifierNamespace.java:105) at >>> org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(Ide >>> ntifierNamespace.java:177) at >>> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractN >>> amespace.java:84) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(S >>> qlValidatorImpl.java:1009) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlVa >>> lidatorImpl.java:969) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlVal >>> idatorImpl.java:3129) at >>> org.apache.drill.exec.planner.sql.conversion.DrillValidator.validate >>> From(DrillValidator.java:63) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlVal >>> idatorImpl.java:3111) at >>> org.apache.drill.exec.planner.sql.conversion.DrillValidator.validate >>> From(DrillValidator.java:63) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlV >>> alidatorImpl.java:3383) at >>> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectN >>> amespace.java:60) at >>> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractN >>> amespace.java:84) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(S >>> qlValidatorImpl.java:1009) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlVa >>> lidatorImpl.java:969) at >>> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:216) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpre >>> ssion(SqlValidatorImpl.java:944) at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidat >>> orImpl.java:651) at >>> org.apache.drill.exec.planner.sql.conversion.SqlConverter.validate(S >>> qlConverter.java:189) at >>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validat >>> eNode(DefaultSqlHandler.java:641) at >>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validat >>> eAndConvert(DefaultSqlHandler.java:195) >>> at >>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan >>> (DefaultSqlHandler.java:169) at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillS >>> qlWorker.java:283) at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(Dri >>> llSqlWorker.java:163) at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSq >>> lWorker.java:128) at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWor >>> ker.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 <cgi...@gmail.com> >>> 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 the >>> full stack trace? I'm thinking that can be fixed on the Drill end of >>> things, at least until Calcite fixes that. >>> -- C >>> >>>> On Jun 23, 2020, at 3:58 PM, Christopher Kane >>>> <christopher.k...@cardconnect.com.INVALID> wrote: >>>> >>>> Yes thank you! To your point about using 1.17, I could always take the >>>> config 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=https-3A__issues.apache. >>>> org >>>> _jira_browse_CALCITE-2D3533&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYR >>>> bCB >>>> lPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=g39OzDxVVrucBo3nnaZNaIqoh9S >>>> ZZi dthZ3H6QSOkWE&s=oVohCx-25EZLkSVY7yEV1FtFZ-nNDTnGvek4Sx67nYc&e= >>>> >>>> Everything appears to be setup now but when executing a query for the data >>>> source I setup, I receive >>>> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: >>>> Unknown SQL type -101. Any suggestions there? >>>> >>>> -----Original Message----- >>>> From: Rafael Jaimes III <rafjai...@gmail.com> >>>> 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 >>>> <christopher.k...@cardconnect.com.invalid> wrote: >>>>> >>>>> Wow, I gotta hand it to you, I don't know what I was expecting to happen >>>>> 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 <christopher.k...@cardconnect.com.INVALID> >>>>> 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 check >>>>> out your pre-release, install it like I did 1.17.0 and see what happens! >>>>> >>>>> -----Original Message----- >>>>> From: Charles Givre <cgi...@gmail.com> >>>>> Sent: Tuesday, June 23, 2020 3:23 PM >>>>> To: user <user@drill.apache.org> >>>>> 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=https-3A__github.com_a >>>>> pac >>>>> h >>>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfl >>>>> lmV >>>>> q >>>>> BXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s= >>>>> C8v >>>>> 5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e= >>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_a >>>>> pac >>>>> h >>>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfl >>>>> lmV >>>>> q >>>>> BXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s= >>>>> C8v >>>>> 5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e= >) and build from >>>>> source. >>>>> If you can't do that, I have a pre-release here: >>>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_cg >>>>> ivr >>>>> e >>>>> _drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI >>>>> 0-D >>>>> P >>>>> w&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSN >>>>> loM >>>>> 5 >>>>> zPbmSepKW4FaAKoOwoxYlUk&s=3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H-q >>>>> XY0 >>>>> & >>>>> e= >>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_c >>>>> giv >>>>> r >>>>> e_drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7W >>>>> I0- >>>>> D >>>>> Pw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZS >>>>> Nlo >>>>> M >>>>> 5zPbmSepKW4FaAKoOwoxYlUk&s=3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H- >>>>> qXY >>>>> 0 >>>>> &e= > >>>>> >>>>> >>>>>> On Jun 23, 2020, at 3:21 PM, Christopher Kane >>>>>> <christopher.k...@cardconnect.com.INVALID> wrote: >>>>>> >>>>>> You might have to provide a link for Drill 1.18, I'm not seeing that >>>>>> available on the downloads section of the site. >>>>>> >>>>>> -----Original Message----- >>>>>> From: Christopher Kane <christopher.k...@cardconnect.com.INVALID> >>>>>> 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 >>>>>> trying it out as a POC for something I'm trying to do at work. So you're >>>>>> saying 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 driver? >>>>>> >>>>>> -----Original Message----- >>>>>> From: Charles Givre <cgi...@gmail.com> >>>>>> 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 >>>>>> might solve the issue. >>>>>> >>>>>>> On Jun 23, 2020, at 3:05 PM, Christopher Kane >>>>>>> <christopher.k...@cardconnect.com.INVALID> wrote: >>>>>>> >>>>>>> On both the directory of drill and on startup I am running >>>>>>> Apache Drill 1.17.0 >>>>>>> >>>>>>> -----Original Message----- >>>>>>> From: Charles Givre <cgi...@gmail.com <mailto:cgi...@gmail.com>> >>>>>>> Sent: Tuesday, June 23, 2020 3:03 PM >>>>>>> To: user <user@drill.apache.org <mailto:user@drill.apache.org>> >>>>>>> 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 >>>>>>>> <christopher.k...@cardconnect.com.INVALID> 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 >>>>>>>> stacktrace. Now I will say that the one DBA I was conversing with >>>>>>>> mentioned something about JRE, and I find interesting in this stack >>>>>>>> trace that it seems to be 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=https-3A__www.oracle.com_database_technologies_jdbc-2Ddrivers-2D12c-2Ddownloads.html&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=zddp1Im2FovgkwAQ3SyRaJzBS1FxeOgiwYdViTSn4H4&e= >>>>>>>> >>>>>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.oracle.com_database_technologies_jdbc-2Ddrivers-2D12c-2Ddownloads.html&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=zddp1Im2FovgkwAQ3SyRaJzBS1FxeOgiwYdViTSn4H4&e=> >>>>>>>> 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 page here: >>>>>>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rdbms-2Dstorage-2Dplugin_&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=rzaAsfW2VGICMfzMAhjoT2vZqBRkti6X56uH4Uv1HU0&e= >>>>>>>> >>>>>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rdbms-2Dstorage-2Dplugin_&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=rzaAsfW2VGICMfzMAhjoT2vZqBRkti6X56uH4Uv1HU0&e=> >>>>>>>> and that 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(St >>>>>>>> ora >>>>>>>> ge >>>>>>>> P >>>>>>>> l >>>>>>>> uginRegistryImpl.java:536) at >>>>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.createOrU >>>>>>>> pda >>>>>>>> te >>>>>>>> ( >>>>>>>> S >>>>>>>> toragePluginRegistryImpl.java:132) >>>>>>>> at >>>>>>>> org.apache.drill.exec.server.rest.PluginConfigWrapper.createOrU >>>>>>>> pda >>>>>>>> te >>>>>>>> I >>>>>>>> n >>>>>>>> Storage(PluginConfigWrapper.java:56) >>>>>>>> at >>>>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpda >>>>>>>> teP >>>>>>>> lu >>>>>>>> g >>>>>>>> i >>>>>>>> nJSON(StorageResources.java:212) at >>>>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpda >>>>>>>> teP >>>>>>>> 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.inv >>>>>>>> oke >>>>>>>> (D >>>>>>>> e >>>>>>>> l >>>>>>>> egatingMethodAccessorImpl.java:43) >>>>>>>> at java.base/java.lang.reflect.Method.invoke(Method.java:564) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.ResourceMethodInvoca >>>>>>>> tio >>>>>>>> nH >>>>>>>> a >>>>>>>> n >>>>>>>> dlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.jav >>>>>>>> a:8 >>>>>>>> 1) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResource >>>>>>>> Met >>>>>>>> ho >>>>>>>> d >>>>>>>> D >>>>>>>> ispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResource >>>>>>>> Met >>>>>>>> ho >>>>>>>> d >>>>>>>> D >>>>>>>> ispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDi >>>>>>>> spa >>>>>>>> tc >>>>>>>> h >>>>>>>> e >>>>>>>> rProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatche >>>>>>>> rPr >>>>>>>> ov >>>>>>>> i >>>>>>>> d >>>>>>>> er.java:205) at >>>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResource >>>>>>>> Met >>>>>>>> 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(R >>>>>>>> eso >>>>>>>> ur >>>>>>>> c >>>>>>>> e >>>>>>>> MethodInvoker.java:347) at >>>>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(R >>>>>>>> eso >>>>>>>> ur >>>>>>>> c >>>>>>>> e >>>>>>>> MethodInvoker.java:102) at >>>>>>>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.j >>>>>>>> ava >>>>>>>> :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(R >>>>>>>> equ >>>>>>>> es >>>>>>>> t >>>>>>>> S >>>>>>>> cope.java:317) at >>>>>>>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java: >>>>>>>> 3 >>>>>>>> 05) at >>>>>>>> org.glassfish.jersey.server.ApplicationHandler.handle(Applicati >>>>>>>> onH >>>>>>>> an >>>>>>>> d >>>>>>>> l >>>>>>>> er.java:1154) at >>>>>>>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebCompon >>>>>>>> ent >>>>>>>> .j >>>>>>>> a >>>>>>>> v >>>>>>>> a:473) at >>>>>>>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java: >>>>>>>> 4 >>>>>>>> 2 >>>>>>>> 7) at >>>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletCo >>>>>>>> nta >>>>>>>> in >>>>>>>> e >>>>>>>> r >>>>>>>> .java:388) at >>>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletCo >>>>>>>> nta >>>>>>>> in >>>>>>>> e >>>>>>>> r >>>>>>>> .java:341) at >>>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletCo >>>>>>>> nta >>>>>>>> in >>>>>>>> e >>>>>>>> r >>>>>>>> .java:228) at >>>>>>>> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java: >>>>>>>> 84 >>>>>>>> 8 >>>>>>>> ) >>>>>>>> at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(S >>>>>>>> erv >>>>>>>> le >>>>>>>> t >>>>>>>> H >>>>>>>> andler.java:1780) at >>>>>>>> org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFil >>>>>>>> ter >>>>>>>> (C >>>>>>>> s >>>>>>>> r >>>>>>>> fTokenValidateFilter.java:55) at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(S >>>>>>>> erv >>>>>>>> le >>>>>>>> t >>>>>>>> H >>>>>>>> andler.java:1767) at >>>>>>>> org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilte >>>>>>>> r(C >>>>>>>> sr >>>>>>>> f >>>>>>>> T >>>>>>>> okenInjectFilter.java:54) at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(S >>>>>>>> erv >>>>>>>> le >>>>>>>> t >>>>>>>> H >>>>>>>> andler.java:1767) at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java: >>>>>>>> 583) at >>>>>>>> org.eclipse.jetty.server.session.SessionHandler.doHandle(Sessio >>>>>>>> nHa >>>>>>>> nd >>>>>>>> l >>>>>>>> e >>>>>>>> r.java:224) at >>>>>>>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(Contex >>>>>>>> tHa >>>>>>>> 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(Session >>>>>>>> Han >>>>>>>> dl >>>>>>>> e >>>>>>>> r >>>>>>>> .java:185) at >>>>>>>> org.eclipse.jetty.server.handler.ContextHandler.doScope(Context >>>>>>>> Han >>>>>>>> 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(HandlerWrapper. >>>>>>>> java:134) at >>>>>>>> org.eclipse.jetty.server.Server.handle(Server.java:539) >>>>>>>> at >>>>>>>> org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:33 >>>>>>>> 3) >>>>>>>> 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:10 >>>>>>>> 8) >>>>>>>> at >>>>>>>> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelE >>>>>>>> ndP >>>>>>>> oi >>>>>>>> n >>>>>>>> t >>>>>>>> .java:93) at >>>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.ex >>>>>>>> ecu >>>>>>>> te >>>>>>>> P >>>>>>>> r >>>>>>>> oduceConsume(ExecuteProduceConsume.java:303) >>>>>>>> at >>>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.pr >>>>>>>> odu >>>>>>>> ce >>>>>>>> C >>>>>>>> o >>>>>>>> nsume(ExecuteProduceConsume.java:148) >>>>>>>> at >>>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.ru >>>>>>>> n(E >>>>>>>> xe >>>>>>>> c >>>>>>>> u >>>>>>>> teProduceConsume.java:136) at >>>>>>>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThr >>>>>>>> ead >>>>>>>> Po >>>>>>>> o >>>>>>>> l >>>>>>>> .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.RuntimeException: Rule description >>>>>>>> 'JDBC_DREL_ConverterJDBC.QA2 Oracle' is not valid at >>>>>>>> org.apache.calcite.plan.RelOptRule.<init>(RelOptRule.java:104) >>>>>>>> at >>>>>>>> org.apache.calcite.rel.convert.ConverterRule.<init>(ConverterRule. >>>>>>>> ja >>>>>>>> v >>>>>>>> a >>>>>>>> :78) at >>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$JdbcDrelConv >>>>>>>> ert >>>>>>>> er >>>>>>>> R >>>>>>>> u >>>>>>>> le.<init>(JdbcStoragePlugin.java:224) >>>>>>>> at >>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$DrillJdbcCon >>>>>>>> ven >>>>>>>> ti >>>>>>>> o >>>>>>>> n >>>>>>>> .<init>(JdbcStoragePlugin.java:119) >>>>>>>> at >>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(JdbcS >>>>>>>> tor >>>>>>>> ag >>>>>>>> e >>>>>>>> P >>>>>>>> lugin.java:103) at >>>>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.ne >>>>>>>> wIn >>>>>>>> st >>>>>>>> a >>>>>>>> n >>>>>>>> ce0(Native Method) at >>>>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.ne >>>>>>>> wIn >>>>>>>> st >>>>>>>> a >>>>>>>> n >>>>>>>> ce(NativeConstructorAccessorImpl.java:62) >>>>>>>> at >>>>>>>> java.base/jdk.internal.reflect.DelegatingConstructorAccessorImp >>>>>>>> l.n >>>>>>>> ew >>>>>>>> I >>>>>>>> n >>>>>>>> stance(DelegatingConstructorAccessorImpl.java:45) >>>>>>>> at >>>>>>>> java.base/java.lang.reflect.Constructor.newInstanceWithCaller(C >>>>>>>> ons >>>>>>>> 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(St >>>>>>>> ora >>>>>>>> ge >>>>>>>> P >>>>>>>> l >>>>>>>> uginRegistryImpl.java:528) >>>>>>>> ... 56 common frames omitted >>>>>>>> >>>>>>>> -----Original Message----- >>>>>>>> From: Charles Givre <cgi...@gmail.com> >>>>>>>> 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 <rafjai...@gmail.com> >>>>>>>>> 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 >>>>>>>>> <christopher.k...@cardconnect.com.invalid> 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 >>>>>>>>>> connection string with an incorrect password results in the >>>>>>>>>> following message: Please retry: Error while creating / updating >>>>>>>>>> storage : java.sql.SQLException: Cannot create >>>>>>>>>> PoolableConnectionFactory (ORA-01017: invalid username/password; >>>>>>>>>> logon denied ). Now updating the connection string to use the >>>>>>>>>> correct password results in the following message: Please retry: >>>>>>>>>> Error while creating / updating storage : Rule description >>>>>>>>>> 'JDBC_DREL_ConverterJDBC.QA2 Oracle' 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 anything useful. At this point I'm kind of grasping at >>>>>>>>>> straws as to what my issue 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 Apache Drill documentation and >>>>>>>>>> I've also added this line to my drill-override.conf, >>>>>>>>>> drill.exec.sys.store.provider.local.path = "ojdbc7.jar". But I'm >>>>>>>>>> assuming if any of that wasn't setup correctly, I wouldn't be able >>>>>>>>>> to get an error message back from Oracle saying that my password was >>>>>>>>>> incorrect. Any help in regards to this would be greatly appreciated. >>>>>>>>>> >>>>>>>>>> Christopher Kane >>>>>>>>>> Software Test Engineer | Clover, CardConnect, FiServ >>>>>>>>>> ck...@clover.com<mailto:ck...@clover.com>, >>>>>>>>>> christopher.k...@cardconnect.com<mailto:Christopher.Kane@cardconnect. >>>>>>>>>> com>, >>>>>>>>>> christopher.ka...@firstdata.com<mailto:Christopher.Kane2@firstdata. >>>>>>>>>> c >>>>>>>>>> o >>>>>>>>>> m>, >>>>>>>>>> m>christopher.ka...@fiserv.com<mailto:Christopher.Kane1@fiser >>>>>>>>>> m>v.c >>>>>>>>>> m>om >>>>>>>>>> m>> >>>>>>>>>> >>>>>>>>>> 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 responsible 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 >>>>>>>>>> communication 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 responsible 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 communication 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 responsible 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 communication 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 responsible 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 communication 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 responsible 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 communication 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 >>>>> responsible 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 communication 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 >>>>> responsible 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 communication 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 >>>> responsible 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 communication 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 >>> responsible 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 communication 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 >>> responsible 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 communication 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 >> responsible 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 >> communication 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 responsible 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 communication in error, please notify CardConnect immediately by replying to this message and then delete this message and any attachments from your computer.
