[ https://issues.apache.org/jira/browse/CALCITE-5231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17577340#comment-17577340 ]
kartik edited comment on CALCITE-5231 at 8/9/22 10:21 AM: ----------------------------------------------------------- [~zabetak] Thank you for help. I also assume that , it is classpath issue , I have not manually installed jar in DBeaver. Assuming DBeaver downloaded corrects jars before attempting to connect. In other cases like Dremio , Oracle , Mysql etc DBeaver installed corrects jars Error from DBeaver . Can't create driver instance Error creating driver 'Apache Calcite Avatica' instance. Most likely required jar files are missing. You should configure jars in driver settings. Reason: can't load driver class 'org.apache.calcite.jdbc.Driver' Error creating driver 'Apache Calcite Avatica' instance. Most likely required jar files are missing. You should configure jars in driver settings. Reason: can't load driver class 'org.apache.calcite.jdbc.Driver' org.apache.calcite.jdbc.Driver org.apache.calcite.jdbc.Driver was (Author: JIRAUSER294143): [~zabetak] I also assume that , it is classpath issue , I have not manually installed jar in DBeaver. Assuming DBeaver downloaded corrects jars before attempting to connect. In other cases like Dremio , Oracle , Mysql etc DBeaver installed corrects jars Error from DBeaver . Can't create driver instance Error creating driver 'Apache Calcite Avatica' instance. Most likely required jar files are missing. You should configure jars in driver settings. Reason: can't load driver class 'org.apache.calcite.jdbc.Driver' Error creating driver 'Apache Calcite Avatica' instance. Most likely required jar files are missing. You should configure jars in driver settings. Reason: can't load driver class 'org.apache.calcite.jdbc.Driver' org.apache.calcite.jdbc.Driver org.apache.calcite.jdbc.Driver > 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)