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(RestQueryRunner.java:181)
>> at
>> org.apache.drill.exec.server.rest.RestQueryRunner.run(RestQueryRunner.java:70)
>> at
>> org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(QueryResources.java:96)
>> at
>> org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:114)
>> at jdk.internal.reflect.GeneratedMethodAccessor16.invoke(Unknown Source) at
>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.base/java.lang.reflect.Method.invoke(Method.java:564)
>> 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$CachedChain.doFilter(ServletHandler.java:1780)
>> at
>> org.apache.drill.exec.server.rest.header.ResponseHeadersSettingFilter.doFilter(ResponseHeadersSettingFilter.java:71)
>> at
>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1767)
>> at
>> org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter(CsrfTokenValidateFilter.java:55)
>> at
>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1767)
>> at
>> org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(CsrfTokenInjectFilter.java:54)
>> at
>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1767)
>> at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
>> 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: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.java:99)
>> at
>> org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203)
>> at
>> org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105)
>> at
>> org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
>> at
>> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1009)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:969)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3129)
>> at
>> org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFrom(DrillValidator.java:63)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3111)
>> at
>> org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFrom(DrillValidator.java:63)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3383)
>> at
>> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
>> at
>> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1009)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:969)
>> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:216)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:944)
>> at
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:651)
>> at
>> org.apache.drill.exec.planner.sql.conversion.SqlConverter.validate(SqlConverter.java:189)
>> at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:641)
>> at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(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(DrillSqlWorker.java:283)
>> at
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163)
>> at
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:128)
>> at
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.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=BYRbCB
>>> lPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=g39OzDxVVrucBo3nnaZNaIqoh9SZZi
>>> 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_apac
>>>> h
>>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmV
>>>> q
>>>> BXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s=C8v
>>>> 5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e=
>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apac
>>>> h
>>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmV
>>>> 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_cgivr
>>>> e
>>>> _drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-D
>>>> P
>>>> w&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM
>>>> 5
>>>> zPbmSepKW4FaAKoOwoxYlUk&s=3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H-qXY0
>>>> &
>>>> e=
>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_cgiv
>>>> r
>>>> e_drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-
>>>> D
>>>> Pw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNlo
>>>> 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(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.java:
>>>>>>> 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(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.
>>>>>>> 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(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$JdbcDrelConvert
>>>>>>> er
>>>>>>> R
>>>>>>> u
>>>>>>> le.<init>(JdbcStoragePlugin.java:224)
>>>>>>> at
>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$DrillJdbcConven
>>>>>>> ti
>>>>>>> o
>>>>>>> n
>>>>>>> .<init>(JdbcStoragePlugin.java:119)
>>>>>>> at
>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(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 <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@fiserv.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.
