Custom JDCB Driver doesn't work with Database Tab

Created April 22, 2019 21:03

I'm building a JDBC Driver for a proprietary database. In trying the JDCB driver out in the Database Tab and doing "Test Connection" I'm simply getting a "Failed" message without an error. I haven't found anything particularly helpful in the idea.log. Are there any other logging places I can look, or other debugging I could do?

Here's what my idea.log does show. I added some log statements to see what was being called in my driver. con: = Connection methods. dmd: = DatabaseMetadata methods

```

2019-04-22 13:51:59,651 [  93263]   INFO - ution.rmi.RemoteProcessSupport - /usr/local/jre/bin/java -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath /opt/intellij-ue-2018.3/lib/util.jar:/opt/intellij-ue-2018.3/lib/trove4j.jar:/opt/intellij-ue-2018.3/lib/groovy-all-2.4.15.jar:/opt/intellij-ue-2018.3/plugins/DatabaseTools/lib/jdbc-console.jar:/opt/intellij-ue-2018.3/plugins/DatabaseTools/lib/dekaf-single-2.0.0.387.jar:/my_driver.jar com.intellij.database.remote.RemoteJdbcServer mydriver.MyDriver
2019-04-22 13:52:00,367 [  93979]   INFO - ution.rmi.RemoteProcessSupport - Port/ID: 51493/RemoteDriverImpl47c25590
2019-04-22 13:52:00,438 [  94050]   INFO - ution.rmi.RemoteProcessSupport -
2019-04-22 13:52:00,440 [  94052]   INFO - urce.DatabaseConnectionManager - No user name provided (may be in url)
2019-04-22 13:52:00,441 [  94053]   INFO - urce.DatabaseConnectionManager - Connecting to: /myurl
2019-04-22 13:52:29,540 [ 123152]   INFO - ution.rmi.RemoteProcessSupport - con: isClosed
2019-04-22 13:52:29,544 [ 123156]   INFO - ution.rmi.RemoteProcessSupport - con: getMetaData
2019-04-22 13:52:29,548 [ 123160]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDriverName
2019-04-22 13:52:29,548 [ 123160]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDriverVersion
2019-04-22 13:52:29,548 [ 123160]   INFO - ution.rmi.RemoteProcessSupport - Driver: mydriver.MyDriver 1.0
2019-04-22 13:52:29,548 [ 123160]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDatabaseProductName
2019-04-22 13:52:29,571 [ 123183]   INFO - ution.rmi.RemoteProcessSupport - con: getMetaData
2019-04-22 13:52:29,572 [ 123184]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDatabaseMajorVersion
2019-04-22 13:52:29,572 [ 123184]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDatabaseMinorVersion
2019-04-22 13:52:29,572 [ 123184]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDatabaseProductName
2019-04-22 13:52:29,572 [ 123184]   INFO - ution.rmi.RemoteProcessSupport - getDatabaseProductName: MyDriver
2019-04-22 13:52:29,573 [ 123185]   INFO - ution.rmi.RemoteProcessSupport - getDatabaseMajorVersion.getDatabaseMinorVersion: 1.0
2019-04-22 13:52:29,573 [ 123185]   INFO - ution.rmi.RemoteProcessSupport - con: getMetaData
2019-04-22 13:52:29,573 [ 123185]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDriverMajorVersion
2019-04-22 13:52:29,573 [ 123185]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDriverMinorVersion
2019-04-22 13:52:29,574 [ 123186]   INFO - ution.rmi.RemoteProcessSupport - Detected: MyDriver 1.0
2019-04-22 13:52:29,663 [ 123275]   INFO - ution.rmi.RemoteProcessSupport - con: getMetaData
2019-04-22 13:52:29,702 [ 123314]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDatabaseProductName
2019-04-22 13:52:29,703 [ 123315]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDatabaseProductVersion
2019-04-22 13:52:29,703 [ 123315]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDriverName
2019-04-22 13:52:29,704 [ 123316]   INFO - ution.rmi.RemoteProcessSupport - dmd: getDriverVersion
2019-04-22 13:52:29,704 [ 123316]   INFO - ution.rmi.RemoteProcessSupport - dmd: getJDBCMajorVersion
2019-04-22 13:52:29,705 [ 123317]   INFO - ution.rmi.RemoteProcessSupport - dmd: getJDBCMinorVersion
2019-04-22 13:52:29,705 [ 123317]   INFO - ution.rmi.RemoteProcessSupport - dmd: getIdentifierQuoteString
2019-04-22 13:52:29,705 [ 123317]   INFO - ution.rmi.RemoteProcessSupport - dmd: getExtraNameCharacters
2019-04-22 13:52:29,706 [ 123318]   INFO - ution.rmi.RemoteProcessSupport - dmd: supportsMixedCaseIdentifiers
2019-04-22 13:52:29,706 [ 123318]   INFO - ution.rmi.RemoteProcessSupport - dmd: storesUpperCaseIdentifiers
2019-04-22 13:52:29,706 [ 123318]   INFO - ution.rmi.RemoteProcessSupport - dmd: storesLowerCaseIdentifiers
2019-04-22 13:52:29,706 [ 123318]   INFO - ution.rmi.RemoteProcessSupport - dmd: storesMixedCaseIdentifiers
2019-04-22 13:52:29,707 [ 123319]   INFO - ution.rmi.RemoteProcessSupport - dmd: supportsMixedCaseQuotedIdentifiers
2019-04-22 13:52:29,707 [ 123319]   INFO - ution.rmi.RemoteProcessSupport - dmd: storesUpperCaseQuotedIdentifiers
2019-04-22 13:52:29,707 [ 123319]   INFO - ution.rmi.RemoteProcessSupport - dmd: storesLowerCaseQuotedIdentifiers
2019-04-22 13:52:29,707 [ 123319]   INFO - ution.rmi.RemoteProcessSupport - dmd: storesMixedCaseQuotedIdentifiers
2019-04-22 13:52:29,713 [ 123325]   INFO - ution.rmi.RemoteProcessSupport - con: isClosed
2019-04-22 13:52:29,714 [ 123326]   INFO - ution.rmi.RemoteProcessSupport - con: getAutoCommit
2019-04-22 13:52:29,716 [ 123328]   INFO - ution.rmi.RemoteProcessSupport - con: close 
2019-04-22 13:52:29,719 [ 123331]   INFO - ution.rmi.RemoteProcessSupport - Terminating: 51493/RemoteDriverImpl47c25590
2019-04-22 13:52:29,774 [ 123386]   INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)
```

1 comment

Kai Hackemesser

Created May 17, 2022 00:47

I have a similar situation. I want to set up a JDBC driver of Informix V4.50.8 drivers for IDEA to use in the Database section. I was looking up what jar files the projects loads (jdbc-4.50.8.jar and bson-4.4.2.jar), added them to the Driver Files section. The driver class is picked automatically (com.informix.jdbc.IfxDriver). But when I test the new driver with my database, it throws a classnotfound at me:

Driver class 'com.informix.jdbc.IfxDriver' not found No driver files provided.

[edit]

A full restart of IDEA made this work.

Please sign in to leave a comment.