RE: [Squirrel-sql-users] adding new drivers

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
> 
>