[
https://issues.apache.org/jira/browse/CALCITE-5231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17578423#comment-17578423
]
kartik commented on CALCITE-5231:
----------------------------------
I tried adding dependency manually in Dbeaver .
It asked to changed URL , I got different error this time in DBeaver log ,
looks like it error is thrown from calcite Jar.
Changed to : *jdbc:oracle:thin:@XXXXXXXXXXXX1521:XXXX*
Tried URL : *jdbc:calcite:@XXXXXXXXXXXX1521:XXXX*
{{<dependency>}}
{{<groupId>org.apache.calcite</groupId>}}
{{ <artifactId>calcite-core</artifactId>}}
{{ <version>1.30.0</version>}}
{{ </dependency>}}
Error Log :
2022-08-11 16:50:48.997 - Could not initialize class
org.apache.calcite.config.CalciteConnectionProperty
java.lang.NoClassDefFoundError: Could not initialize class
org.apache.calcite.config.CalciteConnectionProperty
at
org.apache.calcite.config.CalciteConnectionConfigImpl.typeSystem(CalciteConnectionConfigImpl.java:179)
at
org.apache.calcite.jdbc.CalciteConnectionImpl.<init>(CalciteConnectionImpl.java:133)
at
org.apache.calcite.jdbc.CalciteJdbc41Factory$CalciteJdbc41Connection.<init>(CalciteJdbc41Factory.java:117)
at
org.apache.calcite.jdbc.CalciteJdbc41Factory.newConnection(CalciteJdbc41Factory.java:61)
at
org.apache.calcite.jdbc.CalciteJdbc41Factory.newConnection(CalciteJdbc41Factory.java:46)
at
org.apache.calcite.jdbc.CalciteFactory.newConnection(CalciteFactory.java:55)
at
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at
org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.lambda$0(JDBCDataSource.java:185)
at
org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.lambda$1(JDBCDataSource.java:204)
at
org.jkiss.dbeaver.utils.SecurityManagerUtils.wrapDriverActions(SecurityManagerUtils.java:94)
at
org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.openConnection(JDBCDataSource.java:202)
at
org.jkiss.dbeaver.ext.generic.model.GenericDataSource.openConnection(GenericDataSource.java:136)
at
org.jkiss.dbeaver.model.impl.jdbc.JDBCExecutionContext.connect(JDBCExecutionContext.java:103)
at
org.jkiss.dbeaver.model.impl.jdbc.JDBCRemoteInstance.initializeMainContext(JDBCRemoteInstance.java:100)
at
org.jkiss.dbeaver.model.impl.jdbc.JDBCRemoteInstance.<init>(JDBCRemoteInstance.java:59)
at
org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.initializeRemoteInstance(JDBCDataSource.java:112)
at
org.jkiss.dbeaver.ext.generic.model.GenericDataSource.<init>(GenericDataSource.java:108)
at
org.jkiss.dbeaver.ext.generic.model.meta.GenericMetaModel.createDataSourceImpl(GenericMetaModel.java:90)
at
org.jkiss.dbeaver.ext.generic.GenericDataSourceProvider.openDataSource(GenericDataSourceProvider.java:106)
at
org.jkiss.dbeaver.registry.DataSourceDescriptor.openDataSource(DataSourceDescriptor.java:983)
at
org.jkiss.dbeaver.registry.DataSourceDescriptor.connect(DataSourceDescriptor.java:920)
at org.jkiss.dbeaver.runtime.jobs.ConnectJob.run(ConnectJob.java:70)
at
org.jkiss.dbeaver.runtime.jobs.ConnectionTestJob.run(ConnectionTestJob.java:103)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
> Unable to create Oracle JDBC connection in DBeaver
> --------------------------------------------------
>
> 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)
