You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Benchao Li (Jira)" <ji...@apache.org> on 2022/08/14 03:58:00 UTC
[jira] [Commented] (CALCITE-5231) Unable to create Oracle JDBC connection in DBeaver using Calcite-core jar
[ https://issues.apache.org/jira/browse/CALCITE-5231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579314#comment-17579314 ]
Benchao Li commented on CALCITE-5231:
-------------------------------------
[~kartik.kudada@exate.com] It seems that you have already know the reason, it looks like a packaging problem.
As [~zabetak] has already pointed out, it may be a problem of DBeaver that it cannot download the jars recursively. You could do this by yourself. For example, you can create a maven project, and add {{calcite-core}} dependency to it, then package it into a fat jar with all the dependencies including the indirect dependencies from {{calcite-core}}.
About releasing the fat-jar from Calcite by default, I think it would be a good idea. I didn't use Calcite that way in the past, but I'm open to that, and would like to hear more use cases with Calcite.
> 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)