Menu

#1242 Alias properties unavailable for Oracle Thin Driver

SQuirreL
closed
nobody
None
5
2018-03-07
2016-03-18
No

Alias properties display an empty screen for Oracle Thin Driver aliases.
Here is the error in the logs :
2016-03-18 09:52:12,650 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.client.session.schemainfo.SessionStartupTimeHintController$4@76abb444,notifier=null,catchExceptions=false,when=1458291132614] on sun.awt.X11.XToolkit@f644783
java.lang.NoClassDefFoundError: oracle.jdbc.OracleConnection
at oracle.jdbc.driver.ClassRef.get(ClassRef.java:95)
at oracle.jdbc.driver.OracleDriver.getPropertyInfo(OracleDriver.java:661)
at net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.DriverPropertiesController.<init>(DriverPropertiesController.java:91)
at net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.AliasPropertiesController.loadTabs(AliasPropertiesController.java:96)
at net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.AliasPropertiesController.<init>(AliasPropertiesController.java:89)
at net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.AliasPropertiesController.showAliasProperties(AliasPropertiesController.java:34)
at net.sourceforge.squirrel_sql.client.mainframe.action.AliasPropertiesCommand.execute(AliasPropertiesCommand.java:22)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SessionStartupTimeHintController$4.run(SessionStartupTimeHintController.java:67)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleConnection
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at oracle.jdbc.driver.ClassRef.get(ClassRef.java:92)
... 22 more</init></init>

Discussion

  • Aaron Optimizer Digulla

    The workaround is to copy the Oracle driver into the lib folder of SQuirreL.

    The correct solution would be to use the driver classpath when opening the dialog or avoid internal methods or use reflection to get the data.

     
  • Gerd Wagner

    Gerd Wagner - 2018-03-05

    Sorry, I can't reproduce your problem. I downloaded ojdbc7.jar from here
    http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html
    added it to the drivers "Extra Class Path" and Alias properties show up alright.

    Could you give some more details about your environment.
    Gerd

     
  • Xavier Poinsard

    Xavier Poinsard - 2018-03-06

    I can't reproduce the problem anymore (new laptop, new version of Squirrel, new Oracle driver).
    You can close it.

     
  • Gerd Wagner

    Gerd Wagner - 2018-03-07
    • status: open --> closed
     
  • Gerd Wagner

    Gerd Wagner - 2018-03-07

    Closed on user request.

     

Log in to post a comment.

Auth0 Logo