Oracle Rest SQL Driver

Hello , 

I'm trying to connect to oracle db over rest  with https://www.oracle.com/database/technologies/appdev/sqldev/rest-driver-readme.html

I've added custom driver  with users drivers , resolved multitude of missing dependencies and i'm stuck with :


2022-03-02 18:19:43,449 [5745268]   INFO - ution.rmi.RemoteProcessSupport - "C:\Program Files\JetBrains\DataGrip 2021.3.4\jbr\bin\java" -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Xmx750m -Xms128m -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\DataGrip 2021.3.4\lib\util.jar;C:\Program Files\JetBrains\DataGrip 2021.3.4\lib\org_codehaus_groovy_groovy.jar;C:\Program Files\JetBrains\DataGrip 2021.3.4\plugins\DatabaseTools\lib\jdbc-console.jar;C:\Users\Kuba\Downloads\oracle.dbtools.jdbcrest-0.1.0.249.0854.jar;D:\win 10 08.02.2022\sqlcl\lib\ext\dbtools-liquibase.jar;D:\win 10 08.02.2022\sqlcl\lib\ext\dbtools-modeler-cli-ext.jar;D:\win 10 08.02.2022\sqlcl\lib\ext\dbtools-modeler-common.jar;D:\win 10 08.02.2022\sqlcl\lib\ext\liquibase-core.jar;D:\win 10 08.02.2022\sqlcl\lib\antlr-runtime.jar;D:\win 10 08.02.2022\sqlcl\lib\commons-codec.jar;D:\win 10 08.02.2022\sqlcl\lib\commons-logging.jar;D:\win 10 08.02.2022\sqlcl\lib\dbtools-common.jar;D:\win 10 08.02.2022\sqlcl\lib\dbtools-data.jar;D:\win 10 08.02.2022\sqlcl\lib\dbtools-datapump.jar;D:\win 10 08.02.2022\sqlcl\lib\dbtools-http.jar;D:\win 10 08.02.2022\sqlcl\lib\dbtools-net.jar;D:\win 10 08.02.2022\sqlcl\lib\dbtools-sqlcl.jar;D:\win 10 08.02.2022\sqlcl\lib\guava-with-lf.jar;D:\win 10 08.02.2022\sqlcl\lib\httpclient5.jar;D:\win 10 08.02.2022\sqlcl\lib\httpcore5.jar;D:\win 10 08.02.2022\sqlcl\lib\jackson-annotations.jar;D:\win 10 08.02.2022\sqlcl\lib\jackson-core.jar;D:\win 10 08.02.2022\sqlcl\lib\jackson-jr-objects.jar;D:\win 10 08.02.2022\sqlcl\lib\jackson-jr-stree.jar;D:\win 10 08.02.2022\sqlcl\lib\jansi.jar;D:\win 10 08.02.2022\sqlcl\lib\javax.activation-api.jar;D:\win 10 08.02.2022\sqlcl\lib\javax.json.jar;D:\win 10 08.02.2022\sqlcl\lib\jaxb-api.jar;D:\win 10 08.02.2022\sqlcl\lib\jdbcrest.jar;D:\win 10 08.02.2022\sqlcl\lib\jline3.jar;D:\win 10 08.02.2022\sqlcl\lib\low-level-api.jar;D:\win 10 08.02.2022\sqlcl\lib\ojdbc8.jar;D:\win 10 08.02.2022\sqlcl\lib\oracle.dbtools.jdbcrest-0.1.0.249.0854.jar;D:\win 10 08.02.2022\sqlcl\lib\oraclepki.jar;D:\win 10 08.02.2022\sqlcl\lib\orai18n-mapping.jar;D:\win 10 08.02.2022\sqlcl\lib\orai18n-utility.jar;D:\win 10 08.02.2022\sqlcl\lib\orai18n.jar;D:\win 10 08.02.2022\sqlcl\lib\orajsoda.jar;D:\win 10 08.02.2022\sqlcl\lib\osdt_cert.jar;D:\win 10 08.02.2022\sqlcl\lib\osdt_core.jar;D:\win 10 08.02.2022\sqlcl\lib\slf4j-api.jar;D:\win 10 08.02.2022\sqlcl\lib\slf4j-jdk14.jar;D:\win 10 08.02.2022\sqlcl\lib\sshd-common.jar;D:\win 10 08.02.2022\sqlcl\lib\sshd-contrib.jar;D:\win 10 08.02.2022\sqlcl\lib\sshd-core.jar;D:\win 10 08.02.2022\sqlcl\lib\sshd-scp.jar;D:\win 10 08.02.2022\sqlcl\lib\sshd-sftp.jar;D:\win 10 08.02.2022\sqlcl\lib\ST4.jar;D:\win 10 08.02.2022\sqlcl\lib\ucp.jar;D:\win 10 08.02.2022\sqlcl\lib\xdb.jar;D:\win 10 08.02.2022\sqlcl\lib\xmlparserv2_sans_jaxp_services.jar;C:\Users\Kuba\Desktop\ords.war;C:\Users\Kuba\Downloads\httpclient-4.5.jar;C:\Users\Kuba\Downloads\httpclient-4.5.13.jar;C:\Users\Kuba\Downloads\httpcomponents-client-5.1.3-bin.zip;C:\Users\Kuba\Downloads\httpcore-4.4.15.jar;C:\Users\Kuba\Downloads\jackson-databind-2.13.1.jar" com.intellij.database.remote.RemoteJdbcServer oracle.dbtools.jdbc.Driver 
2022-03-02 18:19:43,913 [5745732]   INFO - ution.rmi.RemoteProcessSupport - Port/ServicesPort/ID: 35276/59415/RemoteDriverImpld31d5fe1 
2022-03-02 18:19:43,913 [5745732]   INFO - ution.rmi.RemoteProcessSupport -  
2022-03-02 18:19:43,939 [5745758]   INFO - .DatabaseConnectionEstablisher - Connecting to: *********************
2022-03-02 18:19:43,939 [5745758]   INFO - .DatabaseConnectionEstablisher - Auth provider: user-pass 
2022-03-02 18:19:43,939 [5745758]   INFO - atabaseCredentialsAuthProvider - Connecting as: *************
2022-03-02 18:19:44,634 [5746453]   WARN - .DatabaseConnectionEstablisher - Connecting to: *****************
2022-03-02 18:19:44,634 [5746453]   WARN - .DatabaseConnectionEstablisher - 'org.apache.http.client.methods.HttpPost oracle.dbtools.http.Session.createPost(java.net.URI)' 
2022-03-02 18:19:44,634 [5746453]   INFO - ution.rmi.RemoteProcessSupport - Terminating: 127.0.0.1:35276/RemoteDriverImpld31d5fe1 

 

Is there a way for me to debug that ?  Oracle side is clear becouse i can connect to it with  this driver via sql developer 

 

 

 

 

 

 

 

1 comment
Avatar
Yuriy Vinogradov
Comment actions Permalink

You can try to enable JDBC driver log, may be there will be some useful info.

0

Please sign in to leave a comment.