RE: [Squirrel-sql-users] Oracle JDBC drivers
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Colin B. <Col...@as...> - 2002-09-13 03:20:59
|
Thanks for finding this. Turns out its a known JDK bug in 1.3 which was fixed in 1.4. I've put up a workaround which will be available in the next beta. Until then if you take a look in the doc directory under the directory in which you installed Squirrel you'll find a file quickstart.html which is the help file. Col -----Original Message----- From: Greg Dorval [mailto:gre...@ho...] Sent: Thursday, 12 September 2002 23:15 To: Colin Bell; squ...@li... Subject: RE: [Squirrel-sql-users] Oracle JDBC drivers Thanks Colin. Unfortunately, the help is not working for me. I originally assumed that it just hadn't been implemented, but upon further investigation, it appears to be a bug. Here is the java error log that clicking Help->Help generates: Exception occurred during event dispatching: java.lang.NullPointerException at javax.swing.text.html.StyleSheet.getRule(Unknown Source) at javax.swing.text.html.StyleSheet$ViewAttributeSet.<init>(Unknown Sour ce) at javax.swing.text.html.StyleSheet.getViewAttributes(Unknown Source) at javax.swing.text.html.BlockView.setPropertiesFromAttributes(Unknown S ource) at javax.swing.text.html.BlockView.setParent(Unknown Source) at javax.swing.plaf.basic.BasicTextUI$RootView.setView(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.setView(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.modelChanged(Unknown Source) at javax.swing.plaf.basic.BasicTextUI$UpdateHandler.propertyChange(Unkno wn Source) at javax.swing.event.SwingPropertyChangeSupport.firePropertyChange(Unkno wn Source) at javax.swing.event.SwingPropertyChangeSupport.firePropertyChange(Unkno wn Source) at javax.swing.JComponent.firePropertyChange(Unknown Source) at javax.swing.text.JTextComponent.setDocument(Unknown Source) at javax.swing.JEditorPane.setPage(Unknown Source) at net.sourceforge.squirrel_sql.client.gui.HtmlViewerSheet.read(HtmlView erSheet.java:86) at net.sourceforge.squirrel_sql.client.gui.HtmlViewerSheet.<init>(HtmlVi ewerSheet.java:66) at net.sourceforge.squirrel_sql.client.gui.FileViewerFactory.getViewer(F ileViewerFactory.java:98) at net.sourceforge.squirrel_sql.client.mainframe.action.ViewFileCommand. execute(ViewFileCommand.java:88) at net.sourceforge.squirrel_sql.client.mainframe.action.ViewHelpAction.a ctionPerformed(ViewHelpAction.java:72) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknow n Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseRelease d(Unknown Source) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) >From: Colin Bell <Col...@as...> >To: "'Greg Dorval'" <gre...@ho...>, >squ...@li... >Subject: RE: [Squirrel-sql-users] Oracle JDBC drivers >Date: Thu, 12 Sep 2002 09:15:48 +1000 > >Hi Greg, > >You need to put the jar file containing the Oracle JDBC drivers either into >your classpath (the environment variable %CLASSPATH%) or specify them in >the >"Extra Class path" tab in driver maintenance. The Help file (accessed >through the Help option on the Help menu) goes into more detail. For Oracle >8 the JDBC jar file is classes12.zip but I don't know what its called for >Oracle9. > >Col > >-----Original Message----- >From: Greg Dorval [mailto:gre...@ho...] >Sent: Thursday, 12 September 2002 6:27 >To: squ...@li... >Subject: [Squirrel-sql-users] Oracle JDBC drivers > > >I'm very new to Squirrel, and am trying to connect to an oracle database, >yet there is a red X icon next to both the Oracle OCI Driver and Oracle >Thin > >Driver in the drivers list, which I presume means that the driver is not >available/installed. > >However, I have both Oracle 8.1.7 and Oracle 9.0.2 clients installed on my >machine including the following jdbc drivers: >Oracle8i: >Oracle JDBC/OCI Driver for JDK 1.1.8.1.6.0.0 >Oracle JDBC/OCI Driver for JDK 1.2.8.1.6.0.0 >Oracle JDBC Thin Driver for JDK 1.1.8.1.6.0.0 >Oracle JDBC Thin Driver for JDK 1.2.8.1.6.0.0 > >Oracle9i: >Oracle JDBC/OCI Driver for JDK 1.1.9.2.0.1.0 >Oracle JDBC/OCI Driver for JDK 1.2.9.2.0.1.0 >Oracle JDBC/OCI Driver for JDK 1.4.9.2.0.1.0 >Oracle JDBC Thin Driver for JDK 1.1.9.2.0.1.0 >Oracle JDBC Thin Driver for JDK 1.2.9.2.0.1.0 >Oracle JDBC Thin Driver for JDK 1.4.9.2.0.1.0 > >I am running squirrel-sql-1.1beta6 > >Java version: >Z:\>java -version >java version "1.3.1_01" >Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_01) >Java HotSpot(TM) Client VM (build 1.3.1_01, mixed mode) > >The following appears at the beginning of my PATH: C:\Program >Files\Oracle\jre\1.3.1\bin; > >Also, the following are the error messages in the squirrel log related to >the oracle jdbc drivers: >1134 [main] WARN net.sourceforge.squirrel_sql.client.db.DataCache - Could >not find JDBC driver class for Oracle Thin Driver: >oracle.jdbc.driver.OracleDriver >1134 [main] WARN net.sourceforge.squirrel_sql.client.db.DataCache - Could >not find JDBC driver class for Oracle OCI Driver: >oracle.jdbc.driver.OracleDriver > >So, if anyone could help me get connected oracle, I would be very grateful! > >Thanks. > >Cheers, >Greg > > > > >_________________________________________________________________ >MSN Photos is the easiest way to share and print your photos: >http://photos.msn.com/support/worldwide.aspx > > > >------------------------------------------------------- >In remembrance >www.osdn.com/911/ >_______________________________________________ >Squirrel-sql-users mailing list >Squ...@li... >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx |