[
https://issues.apache.org/jira/browse/CALCITE-5231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579579#comment-17579579
]
kartik commented on CALCITE-5231:
----------------------------------
Thank you [~libenchao] -
I am able to connect Oracle Database in Deaver using calcite JDBC jar .
Actually DBeaver downloaded wrong jars , which I corrected with calcite-core
jar . Then I am able to connect now .
But I could not execute even a single query it keeps saying *Object 'TABLE'
not found*
2nd issue about fat jar : -
I need to modify code and create customized jar , therefor I cloned calcite git
repo and trying to create fat jar out of that .
> Unable to create Oracle JDBC connection in DBeaver using Calcite-core jar
> -------------------------------------------------------------------------
>
> Key: CALCITE-5231
> URL: https://issues.apache.org/jira/browse/CALCITE-5231
> Project: Calcite
> Issue Type: Bug
> Components: core, jdbc-adapter
> Affects Versions: 1.22.0
> Reporter: kartik
> Priority: Major
> Attachments: Calcite JDBC-DBeaver-connection-Issue.png,
> JDBC-calcite-connection-Error-Message.png
>
>
> I am trying to connect my Oracle database using calcite in DBever.
> Driver class used : org.apache.calcite.jdbc.Driver
> URL - jdbc:oracle:thin:XXXXXXX:1521:<database>
>
> But when I use same same URL and driver with main java program . it works
> fine .
> Connection con= DriverManager.getConnection("jdbc:calcite:schemaType=JDBC;
> schema.jdbcUser=USERNAME; " +
> "schema.jdbcPassword=XXXXXX;
> schema.jdbcUrl=jdbc:oracle:thin:@XXXXXXXXXXXXX:1521:ORCL;
> schema.conformance=ORACLE_10; schema.fun=oracle" );
>
>
> I have cloned calcite project and running main program on that . Please let
> me know if I have done any mistake .
>
> After Oracle , I need to work for mySql using calcite .
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
