# ERROR：The JDBC storage plugin failed while trying setup the SQL query

**URL:** <https://community.dremio.com/t/error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4320>\
**Category:** Uncategorized\
**Created:** [October 15, 2019, 8:22am UTC](https://community.dremio.com/t/error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4320 "2019-10-15T08:22:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![beidouyunyun](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/beidouyunyun/32/2335_2.png) [@beidouyunyun](https://community.dremio.com/u/beidouyunyun)\
**Post date:** [October 15, 2019, 8:22am UTC](https://community.dremio.com/t/error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4320/1 "2019-10-15T08:22:53Z")

</div>

2019-10-15 16:17:05,225 [e1 - 225a0efe-f530-0866-737c-2be7a93a4b00:frag:1:0] INFO c.d.exec.store.jdbc.JdbcRecordReader - User Error Occurred [ErrorId: 7925fc7b-d5bd-407a-8ac1-24e9b9374713]  
com.dremio.common.exceptions.UserException: The JDBC storage plugin failed while trying setup the SQL query.  
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:776) ~[dremio-common-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]  
at com.dremio.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:226) [dremio-ce-jdbc-plugin-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]  
at com.dremio.exec.store.CoercionReader.setup(CoercionReader.java:109) [dremio-sabot-kernel-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]  
at com.dremio.sabot.op.scan.ScanOperator$1.run(ScanOperator.java:225) [dremio-sabot-kernel-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]  
at com.dremio.sabot.op.scan.ScanOperator$1.run(ScanOperator.java:221) [dremio-sabot-kernel-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]  
at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0\_211]  
at javax.security.auth.Subject.doAs(Subject.java:422) [na:1.8.0\_211]  
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1836) [hadoop-common-2.8.3.jar:na]

---

<div class="post-metadata">

**Author:** ![beidouyunyun](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/beidouyunyun/32/2335_2.png) [@beidouyunyun](https://community.dremio.com/u/beidouyunyun)\
**Post date:** [October 15, 2019, 8:32am UTC](https://community.dremio.com/t/error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4320/2 "2019-10-15T08:32:21Z")

</div>

[7bccca3f-9728-426c-ab69-568744a0fe09.zip](https://community.dremio.com/uploads/short-url/uNPTTxRad1epQj9aDT5LZ8ODuxr.zip) (8.6 KB)

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [October 15, 2019, 5:37pm UTC](https://community.dremio.com/t/error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4320/3 "2019-10-15T17:37:20Z")

</div>

@beidouyunyun

I see the error is from the below source  
\> {

> ```
> "name": "shentong",
> "type": "SHENTONG"
> } 
> 
> ```

Is this a custom ARP connector. Also DBA\_JOBS is an Oracle system table. Are you trying to see this dictionary via Dremio?
