squirrel-sql-users

[Squirrel-sql-users] Cloudscape Schemas in Networked Mode

[Eric T. <eto...@de...>]

Has anyone had luck with Cloudscape? I'm able to connect to it in 
Embedded mode and browse the schemas and do queries. However, in 
Networked mode I get an error when I browse the schemas. It shows the 
schemas but when I expand them it throws an error. I can still do 
queries fine with it though. I have tried both version 1.1 and 1.2 Beta 6.

Regards,
Eric

Re: [Squirrel-sql-users] Cloudscape Schemas in Networked Mode

[Gerd W. <bir...@t-...>]

Hi Eric,

could you send me a stacktrace.

Thanks

Gerd

Eric Townson wrote:
> Has anyone had luck with Cloudscape? I'm able to connect to it in 
> Embedded mode and browse the schemas and do queries. However, in 
> Networked mode I get an error when I browse the schemas. It shows the 
> schemas but when I expand them it throws an error. I can still do 
> queries fine with it though. I have tried both version 1.1 and 1.2 Beta 6.
> 
> Regards,
> Eric
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software development plans!
> Take this survey and enter to win a one-year sub to SourceForge.net
> Plus IDC's 2005 look-ahead and a copy of this survey
> Click here to start!  http://www.idcswdc.com/cgi-bin/survey?id=105hix
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] Cloudscape Schemas in Networked Mode

[Gerd W. <bir...@t-...>]

Hi Eric,

it looks like your driver is using the Java Transaction API interface 
classes. You can download a zip with these classes here:
http://java.sun.com/products/jta/
You should add this zip to the extra classpath in SQuirreL's driver 
definition. At least the error you posted should be gone after that.

Whenever your stacktrace starts with java.lang.NoClassDefFoundError this 
hints to missing classes.

Gerd


Eric Townson wrote:
> Thanks Gerd. I've attached the stack trace. Let me know if I can help 
> further.
> 
> Regards,
> 
> Eric Townson
> 
> 
> 
> Gerd Wagner wrote:
> 
>> Hi Eric,
>>
>> could you send me a stacktrace.
>>
>> Thanks
>>
>> Gerd
>>
>> Eric Townson wrote:
>>
>>> Has anyone had luck with Cloudscape? I'm able to connect to it in 
>>> Embedded mode and browse the schemas and do queries. However, in 
>>> Networked mode I get an error when I browse the schemas. It shows the 
>>> schemas but when I expand them it throws an error. I can still do 
>>> queries fine with it though. I have tried both version 1.1 and 1.2 
>>> Beta 6.
>>>
>>> Regards,
>>> Eric
>>>
>>>
>>> -------------------------------------------------------
>>> SF.Net email is sponsored by: Tell us your software development plans!
>>> Take this survey and enter to win a one-year sub to SourceForge.net
>>> Plus IDC's 2005 look-ahead and a copy of this survey
>>> Click here to start!  http://www.idcswdc.com/cgi-bin/survey?id=105hix
>>> _______________________________________________
>>> Squirrel-sql-users mailing list
>>> Squ...@li...
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>>
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Tell us your software development plans!
>> Take this survey and enter to win a one-year sub to SourceForge.net
>> Plus IDC's 2005 look-ahead and a copy of this survey
>> Click here to start!  http://www.idcswdc.com/cgi-bin/survey?id=105hix
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>> .
>>
> 
> ------------------------------------------------------------------------
> 
> 0    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - SQuirreL SQL Client Version 1.2beta6 started: Tue Apr 26 17:23:16 EDT 2005
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - Copyright (c) 2001-2003 Colin Bell and others
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.vendor: Sun Microsystems Inc.
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.version: 1.5.0_02
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.name: Windows XP
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.version: 5.1
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.arch: x86
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.dir: C:\DWExpress\squirrel
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.home: C:\Documents and Settings\Eric
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.home: C:\Program Files\Java\jre1.5.0_02
> 16   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.class.path: .\squirrel-sql.jar;.\lib\commons-cli.jar;.\lib\forms.jar;.\lib\fw.jar;.\lib\log4j.jar;.\lib\nanoxml-2.1.jar;
> 132516 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.db.DriverMaintSheet  - Error occured trying to load class com.ibm.db2.jcc.t2zos.w
> java.lang.NoClassDefFoundError: javax/transaction/Synchronization
> 	at java.lang.ClassLoader.defineClass1(Native Method)
> 	at java.lang.ClassLoader.defineClass(Unknown Source)
> 	at java.security.SecureClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.access$100(Unknown Source)
> 	at java.net.URLClassLoader$1.run(Unknown Source)
> 	at java.security.AccessController.doPrivileged(Native Method)
> 	at java.net.URLClassLoader.findClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:119)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:90)
> 	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverClassLoader.getDriverClasses(SQLDriverClassLoader.java:42)
> 	at net.sourceforge.squirrel_sql.client.db.DriverMaintSheet$ListDriversButton.actionPerformed(DriverMaintSheet.java:681)
> 	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> 	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
> 	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
> 	at java.awt.Component.processMouseEvent(Unknown Source)
> 	at javax.swing.JComponent.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.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.run(Unknown Source)
> 132735 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.db.DriverMaintSheet  - Error occured trying to load class sqlj.runtime.profile.util.CustomizerHarness$Log
> java.lang.NoClassDefFoundError: sqlj/framework/error/ErrorLog
> 	at java.lang.ClassLoader.defineClass1(Native Method)
> 	at java.lang.ClassLoader.defineClass(Unknown Source)
> 	at java.security.SecureClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.access$100(Unknown Source)
> 	at java.net.URLClassLoader$1.run(Unknown Source)
> 	at java.security.AccessController.doPrivileged(Native Method)
> 	at java.net.URLClassLoader.findClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:119)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:90)
> 	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverClassLoader.getDriverClasses(SQLDriverClassLoader.java:42)
> 	at net.sourceforge.squirrel_sql.client.db.DriverMaintSheet$ListDriversButton.actionPerformed(DriverMaintSheet.java:681)
> 	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> 	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
> 	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
> 	at java.awt.Component.processMouseEvent(Unknown Source)
> 	at javax.swing.JComponent.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.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.run(Unknown Source)
> 132750 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.db.DriverMaintSheet  - Error occured trying to load class sqlj.runtime.profile.util.ProfilePrinter$SilentInfo
> java.lang.NoClassDefFoundError: sqlj/framework/error/Info
> 	at java.lang.ClassLoader.defineClass1(Native Method)
> 	at java.lang.ClassLoader.defineClass(Unknown Source)
> 	at java.security.SecureClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.access$100(Unknown Source)
> 	at java.net.URLClassLoader$1.run(Unknown Source)
> 	at java.security.AccessController.doPrivileged(Native Method)
> 	at java.net.URLClassLoader.findClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:119)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:90)
> 	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverClassLoader.getDriverClasses(SQLDriverClassLoader.java:42)
> 	at net.sourceforge.squirrel_sql.client.db.DriverMaintSheet$ListDriversButton.actionPerformed(DriverMaintSheet.java:681)
> 	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> 	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
> 	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
> 	at java.awt.Component.processMouseEvent(Unknown Source)
> 	at javax.swing.JComponent.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.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.run(Unknown Source)
> 132797 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.db.DriverMaintSheet  - Error occured trying to load class COM.ibm.db2os390.dsn.JARLoader
> java.lang.NoClassDefFoundError: com/ibm/jvm/classloader/Shareable
> 	at java.lang.ClassLoader.defineClass1(Native Method)
> 	at java.lang.ClassLoader.defineClass(Unknown Source)
> 	at java.security.SecureClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.defineClass(Unknown Source)
> 	at java.net.URLClassLoader.access$100(Unknown Source)
> 	at java.net.URLClassLoader$1.run(Unknown Source)
> 	at java.security.AccessController.doPrivileged(Native Method)
> 	at java.net.URLClassLoader.findClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:119)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at java.lang.ClassLoader.loadClass(Unknown Source)
> 	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:90)
> 	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverClassLoader.getDriverClasses(SQLDriverClassLoader.java:42)
> 	at net.sourceforge.squirrel_sql.client.db.DriverMaintSheet$ListDriversButton.actionPerformed(DriverMaintSheet.java:681)
> 	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> 	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
> 	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
> 	at java.awt.Component.processMouseEvent(Unknown Source)
> 	at javax.swing.JComponent.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.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.run(Unknown Source)
> 164860 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree  - Error: TABLE
> com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
> 	at com.ibm.db2.jcc.c.rc.mb(rc.java:3419)
> 	at com.ibm.db2.jcc.c.rc.c(rc.java:290)
> 	at com.ibm.db2.jcc.c.rc.next(rc.java:277)
> 	at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:858)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableTypeExpander.createChildren(TableTypeExpander.java:73)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.loadChildren(ObjectTree.java:808)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.execute(ObjectTree.java:759)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.expandNode(ObjectTree.java:397)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.access$600(ObjectTree.java:65)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$ExpansionController.run(ObjectTree.java:716)
> 	at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
> 	at java.lang.Thread.run(Unknown Source)

Re: [Squirrel-sql-users] Cloudscape Schemas in Networked Mode

[Gerd W. <bir...@t-...>]

Hi Eric,

to load the source do a

cvs -z3 -d:pserver:ano...@cv...:/cvsroot/squirrel-sql 
co -P sql12

The sources you need are in
sql12/app/src
and
sql12/fw/src

The jars are in
sql12/app/lib
and
sql12/fw/lib

The class you need to run is
net.sourceforge.squirrel_sql.client.Main

If Eclipse copies properties files and icons to your bin path during 
compile than a simple compile from the IDE should be enough. If not 
consider to use the build script
sql12/build/build.xml

If you find a fix please send it to me.


You may also send me your zip.

Gerd



Eric Townson wrote:
> Thanks again Gerd! This has it down to just one error now. I've attached 
> a new log file. Let me know if you need me to load the SQuirreL source 
> and do any tracing. I am a Java programmer and use Eclipse as my IDE.
> 
> I'm not sure if you've messed much with Cloudscape. If it would help I 
> can send you a zip of a folder with just the libs you need for it along 
> with batch files to run it in networked mode and a sample  database. 
> But, it's also pretty trivial to get going with it. The download from 
> IBM is only 16 MB or so.
> 
> Regards,
> Eric
> 
> Gerd Wagner wrote:
> 
>> Hi Eric,
>>
>> it looks like your driver is using the Java Transaction API interface 
>> classes. You can download a zip with these classes here:
>> http://java.sun.com/products/jta/
>> You should add this zip to the extra classpath in SQuirreL's driver 
>> definition. At least the error you posted should be gone after that.
>>
>> Whenever your stacktrace starts with java.lang.NoClassDefFoundError 
>> this hints to missing classes.
>>
>> Gerd
> 
> 
> ------------------------------------------------------------------------
> 
> 0    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - =======================================================
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - SQuirreL SQL Client Version 1.2beta6 started: Wed Apr 27 22:21:34 EDT 2005
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - Copyright (c) 2001-2003 Colin Bell and others
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.vendor: Sun Microsystems Inc.
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.version: 1.5.0_02
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.name: Windows XP
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.version: 5.1
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.arch: x86
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.dir: C:\DWExpress\squirrel
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.home: C:\Documents and Settings\Eric
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.home: C:\Program Files\Java\jre1.5.0_02
> 15   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.class.path: .\squirrel-sql.jar;.\lib\commons-cli.jar;.\lib\forms.jar;.\lib\fw.jar;.\lib\jta.jar;.\lib\log4j.jar;.\lib\nanoxml-2.1.jar;
> 12906 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree  - Error: TABLE
> com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
> 	at com.ibm.db2.jcc.c.rc.mb(rc.java:3419)
> 	at com.ibm.db2.jcc.c.rc.c(rc.java:290)
> 	at com.ibm.db2.jcc.c.rc.next(rc.java:277)
> 	at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:858)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableTypeExpander.createChildren(TableTypeExpander.java:73)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.loadChildren(ObjectTree.java:808)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.execute(ObjectTree.java:759)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.expandNode(ObjectTree.java:397)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.access$600(ObjectTree.java:65)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$ExpansionController.run(ObjectTree.java:716)
> 	at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
> 	at java.lang.Thread.run(Unknown Source)
> 42593 [AWT-EventQueue-0] INFO  net.sourceforge.squirrel_sql.client.Application  - Application shutting down 4/27/05 10:22 PM.
> 42796 [AWT-EventQueue-0] INFO  net.sourceforge.squirrel_sql.client.Application  - Application shutdown complete 4/27/05 10:22 PM.

Re: [Squirrel-sql-users] Cloudscape Schemas in Networked Mode

[Eric T. <eto...@de...>]

I found the resolution to this mystery. It turns out you must set 
autocommit off for the schema browsing to work properly with Cloudscape 
in networked mode. And you also need to reference the Java Transaction 
API interface classes as discovered by Gerd. As he pointed out previous 
you can download a zip with these classes here:

 http://java.sun.com/products/jta/

You must add this zip to the extra classpath in SQuirreL's driver 
definition.

FYI -- this same IBM Type 4 Driver, db2jcc.jar, works for both 
Cloudscape and DB2. SQuirreL by default uses the Type 2 driver. I've 
tested SQuirreL with the Type 4 driver and it appears to work fine.

Regards,
Eric