Hi Bill,
In future please reply to the list, not just to me.
It looks like you're a victim of bad error handling in SQuirreL. I
installed Firebird 1.5rc3 and JayBird JDBC 1.0 and got a stack trace
(see below) in the command window when I tried to add a new driver using
the supplied firebirdsql.jar. It worked with the supplied
firebirdsql-full.jar. I don't know the JayBird build process but it
looks like you need one or more thirdparty jars. In the jaybird/lib
directory there are 3 jars - jaas.jar, log4j-core.jar,
mini-concurrent.jar and mini-j2ee.jar
In the next version of SQuirreL this error will display in a dialog, not
in the command window.
java.lang.NoClassDefFoundError: javax/resource/ResourceException
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Class.java:1590)
at java.lang.Class.getConstructor0(Class.java:1762)
at java.lang.Class.newInstance0(Class.java:276)
at java.lang.Class.newInstance(Class.java:259)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.registerSQLDriver(SQLDriverManager.java:61)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager$MyDriverListener.propertyChange(SQLDriverManager.java:163
at
java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:252)
at
net.sourceforge.squirrel_sql.fw.util.PropertyChangeReporter.firePropertyChange(PropertyChangeReporter.java:52)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriver.setJarFileNames(SQLDriver.java:267)
at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet.applyFromDialog(DriverMaintSheet.java:257)
at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet.performOk(DriverMaintSheet.java:238)
at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet.access$100(DriverMaintSheet.java:68)
at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet$2.actionPerformed(DriverMaintSheet.java:364)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1817)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5134)
at java.awt.Component.processEvent(Component.java:4931)
at java.awt.Container.processEvent(Container.java:1566)
at java.awt.Component.dispatchEventImpl(Component.java:3639)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Component.dispatchEvent(Component.java:3480)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
at java.awt.Container.dispatchEventImpl(Container.java:1609)
at java.awt.Window.dispatchEventImpl(Window.java:1590)
at java.awt.Component.dispatchEvent(Component.java:3480)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)
--
Colin Bell
http://squirrel-sql.sf.net
----- Original Message -----
From: "Surowiec, William" <Wil...@th...>
Date: Tuesday, June 10, 2003 11:39 pm
Subject: RE: [Squirrel-sql-users] adding new drivers
> Thanks for the reply Colin. Here is what I know and what I'm doing
> (with the
> distinct possibility of a disjoint set):
>
> Windows 2000 Pro, I keep it up to date with all Microsoft
> recommend updates.
> Java j2sdk1.4.1_02
> Firebird type 4 Interbase jdbc, jar dated about 3/15/03 (I d/l cvs
> tree,rebuild, test, use). I wish to move to the newer firebird
> versions, so these
> newer jdbc connections become important to me.
> SQuirreL SQL Client Version 1.1final1 (copy from help about)
>
> I know English, at least my version of it, is as precise as a
> sprinkling can
> distributing water. I define the driver:
>
> 1) click the plus at the top of the driver panel
> 2) select the extra tab on the pop up panel
> 3) press add button
> 4) navigate to my firebirdsql.jar
> 5) press the open button
> 6) the jar appears on the extra tab
> 7) press the list drivers button
> 8) org.firebirdsql.jdbc.FBDriver appears in the class name
> 9) I select and fill in name: (firebird)
> 10) I select and fill in sample url (localhost:c:/gscc2.gdb)
> 11) press the ok button (it highlights and stays highlighted as
> long as my
> mouse is over it).
>
>
> It seems as if nothing has happened. The dialog box stays up. The
> driverspanel has not been updated. Pressing the + on the alias
> panel, I get an add
> alias popup. Firebird is not an option in the combo box.
>
> Not sure what to do next short of read code or ask if I am doing
> somethingdumb or have missed something.
>
> I do thank you for enduring the obvious pain supporting anything
> offered to
> the public must cause. I hope not to be a pest.
>
> I will play on my end. Possibly the firebird jar needs more
> supporting jars.
> While I try _not_ to add stuff to my classpath or jre lib
> directory (I find
> installing my stuff on client machines to be far harder) I will
> try that
> approach to see what I see. Unfortunately, jury duty starts
> tomorrow and I
> am already under water.
>
> Thank you again,
>
> Bill
>
>
|