squirrel-sql-users — A subscriber only discussion list for SQuirreL

[Squirrel-sql-users] 2.6 broken on MacOS X?

[pohl <poh...@gm...>]

I am a long-time user of SQuirrelSQL, but only recently
decided to give a more recent version a try.  I have installed
2.6 using the installer jar for MacOS X, after having obliterated
~/.squirrel-sql/  just to be sure I wasn't bitten by any configuration
incompatibilities.

The installation appeared to go ok, but the first time I tried to
connect to a data base (using the oracle thin driver) I got a
nasty exception, and I don't know what it means...



java.lang.NoClassDefFoundError: Could not initialize class
net.sourceforge.squirrel_sql.fw.dialects.DialectFactory
	at net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectInfo.generateQualifiedName(DatabaseObjectInfo.java:166)
	at net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectInfo.<init>(DatabaseObjectInfo.java:77)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$RootNode.createDbo(ObjectTreeModel.java:377)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$RootNode.<init>(ObjectTreeModel.java:372)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel.createRootNode(ObjectTreeModel.java:270)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel.<init>(ObjectTreeModel.java:86)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.<init>(ObjectTree.java:133)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel.createGUI(ObjectTreePanel.java:897)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel.<init>(ObjectTreePanel.java:153)
	at net.sourceforge.squirrel_sql.client.session.mainpanel.ObjectTreeTab.getComponent(ObjectTreeTab.java:83)
	at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.addMainPanelTab(MainPanel.java:201)
	at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init>(MainPanel.java:111)
	at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI(SessionPanel.java:465)
	at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.<init>(SessionPanel.java:125)
	at net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI(SessionInternalFrame.java:168)
	at net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init>(SessionInternalFrame.java:56)
	at net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame(WindowManager.java:367)
	at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:371)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:598)
	at net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:180)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:300)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:210)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:200)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:195)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:187)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

Re: [Squirrel-sql-users] Oracle nls_date_format

[Frank B. <fra...@eu...>]

Hi,

everything works fine :-D
The option -Doracle.jdbc.V8Compatible="true" is the answer to this problem.
Tanks very much for your assistance.

On a side note, many thanks to all who have contributed to this great 
software. It's a pleasure to work with it.

Frank

Re: [Squirrel-sql-users] Oracle nls_date_format

[Robert M. <rob...@gm...>]

Of the 4 options that Oracle recommends in Matt's link, we implemented #3 :

"Alter you application to use getTimestamp rather than getObject. This
is a good solution when possible, however many applications contain
generic code that relies on getObject, so it isn't always possible."

And that is available with the "Interpret DATE columns as TIMESTAMP" option.

Rob

On 10/19/07, Matthew Dahlman <mda...@ja...> wrote:
> It's intentional by Oracle to not return the time with the current Oracle
> JDBC driver. It's also highly annoying to lots of folks that Oracle made
> this change in their 9.2 release.
>
> A workaround is to use an older Oracle JDBC driver. Or you can simulate
> using an older driver by adding something like this to your startup
> params:
>
> java -Doracle.jdbc.V8Compatible="true"
>
> There good info here in the section "What is going on with DATE and
> TIMESTAMP?"
> http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm
>
> Regards,
> Matt Dahlman
>
>
> -----Original Message-----
> From: squ...@li...
> [mailto:squ...@li...] On Behalf Of
> Robert Manning
> Sent: Friday, 19 October, 2007 11:36
> To: Frank Brendel
> Cc: squ...@li...
> Subject: Re: [Squirrel-sql-users] Oracle nls_date_format
>
> On 10/19/07, Frank Brendel <fra...@eu...> wrote:
> > Hi Rob,
> >
> > thanks for your help.
> >
> > >
> > > There is a work-around if you prefer not to use the "correct" data
> > > type (timestamp) to store a time component along with the date.  In
> > > Global Preferences -> DataType Controls -> Date section you can
> > > check "treat DATE as TIMESTAMP" which will cause SQuirreL to
> > > retrieve all java.sql.Date as java.sql.Timestamp instead.  Note
> > > however, that while this works fine for Oracle, I've seen it not
> > > work so well for a database that implements SQL according to the
> > > standard.  So be careful with this setting if you also access
> non-Oracle databases.
> > >
> >
> > I've changed the java code to use java.sql.Date resp.
> > java.sql.Timestamp and it works as you have said. Date gives me
> > '2007-10-19' and Timestamp '2007-10-19 15:35:49.0'.
>
> Oh, no actually I was referring to the Table column type.  Most people
> refuse to convert their table columns from DATES to TIMESTAMP,
> understandably so.  So the "Treat DATE as TIMESTAMP" is used for this
> purpose.   It changes SQuirreL's java code to use getTimestamp() which
> returns java.sql.Timestamp instead of getDate() which returns
> java.sql.Date.
>
> Rob
> Rob
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

Re: [Squirrel-sql-users] Oracle nls_date_format

[Matthew D. <mda...@ja...>]

It's intentional by Oracle to not return the time with the current Oracle
JDBC driver. It's also highly annoying to lots of folks that Oracle made
this change in their 9.2 release.

A workaround is to use an older Oracle JDBC driver. Or you can simulate
using an older driver by adding something like this to your startup
params:

java -Doracle.jdbc.V8Compatible="true"

There good info here in the section "What is going on with DATE and
TIMESTAMP?"
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm

Regards,
Matt Dahlman
 

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Robert Manning
Sent: Friday, 19 October, 2007 11:36
To: Frank Brendel
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Oracle nls_date_format

On 10/19/07, Frank Brendel <fra...@eu...> wrote:
> Hi Rob,
>
> thanks for your help.
>
> >
> > There is a work-around if you prefer not to use the "correct" data 
> > type (timestamp) to store a time component along with the date.  In 
> > Global Preferences -> DataType Controls -> Date section you can 
> > check "treat DATE as TIMESTAMP" which will cause SQuirreL to 
> > retrieve all java.sql.Date as java.sql.Timestamp instead.  Note 
> > however, that while this works fine for Oracle, I've seen it not 
> > work so well for a database that implements SQL according to the 
> > standard.  So be careful with this setting if you also access
non-Oracle databases.
> >
>
> I've changed the java code to use java.sql.Date resp. 
> java.sql.Timestamp and it works as you have said. Date gives me 
> '2007-10-19' and Timestamp '2007-10-19 15:35:49.0'.

Oh, no actually I was referring to the Table column type.  Most people
refuse to convert their table columns from DATES to TIMESTAMP,
understandably so.  So the "Treat DATE as TIMESTAMP" is used for this
purpose.   It changes SQuirreL's java code to use getTimestamp() which
returns java.sql.Timestamp instead of getDate() which returns
java.sql.Date.

Rob
Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Oracle nls_date_format

[Robert M. <rob...@gm...>]

On 10/19/07, Frank Brendel <fra...@eu...> wrote:
> Hi Rob,
>
> thanks for your help.
>
> >
> > There is a work-around if you prefer not to use the "correct" data
> > type (timestamp) to store a time component along with the date.  In
> > Global Preferences -> DataType Controls -> Date section you can check
> > "treat DATE as TIMESTAMP" which will cause SQuirreL to retrieve all
> > java.sql.Date as java.sql.Timestamp instead.  Note however, that while
> > this works fine for Oracle, I've seen it not work so well for a
> > database that implements SQL according to the standard.  So be careful
> > with this setting if you also access non-Oracle databases.
> >
>
> I've changed the java code to use java.sql.Date resp. java.sql.Timestamp and
> it works as you have said. Date gives me '2007-10-19' and
> Timestamp '2007-10-19 15:35:49.0'.

Oh, no actually I was referring to the Table column type.  Most people
refuse to convert their table columns from DATES to TIMESTAMP,
understandably so.  So the "Treat DATE as TIMESTAMP" is used for this
purpose.   It changes SQuirreL's java code to use getTimestamp() which
returns java.sql.Timestamp instead of getDate() which returns
java.sql.Date.

Rob
Rob

Re: [Squirrel-sql-users] Oracle nls_date_format

[Frank B. <fra...@eu...>]

Hi Rob,

thanks for your help.

>
> There is a work-around if you prefer not to use the "correct" data
> type (timestamp) to store a time component along with the date.  In
> Global Preferences -> DataType Controls -> Date section you can check
> "treat DATE as TIMESTAMP" which will cause SQuirreL to retrieve all
> java.sql.Date as java.sql.Timestamp instead.  Note however, that while
> this works fine for Oracle, I've seen it not work so well for a
> database that implements SQL according to the standard.  So be careful
> with this setting if you also access non-Oracle databases.
>

I've changed the java code to use java.sql.Date resp. java.sql.Timestamp and 
it works as you have said. Date gives me '2007-10-19' and 
Timestamp '2007-10-19 15:35:49.0'.

But the work-around doesn't work. I had to uncheck the standard format to see 
the timepart of the timestamp and now the time is always '19.10.2007 
00:00:00'.

Frank

Re: [Squirrel-sql-users] Oracle nls_date_format

[Robert M. <rob...@gm...>]

On 10/19/07, Frank Brendel <fra...@eu...> wrote:
> Hello,
>
> no oracle experts out there?
>
> Anyway I've played a little with java and wrote a script to see wether it's a
> JDBC or SQuirreL problem.
>
> import java.sql.*;
> class dbAccess {
>   public static void main (String args []) throws SQLException
>   {
>         DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
>         Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@XXXX", "xxxxxx", "xxxxx");
>         Statement stmt = conn.createStatement();
>         ResultSet rset = stmt.executeQuery("select sysdate from dual");
>         rset.next();
>         System.out.println (rset.getString(1));
>         stmt.close();
>   }
> }
>
> $ java -Doracle.net.tns_admin=$ORACLE_HOME/network/admin -classpath
> $ORACLE_HOME/jdbc/lib/ojdbc14.jar:./ dbAccess
> 2007-10-19 08:57:53.0
>
> As you can see the JDBC driver gives me the correct date format. I don't even
> have to set the NLS_DATE_FORMAT.
>
> SQuirreL shows me only the date "2007-10-19". But I'm missing the time.

Frank,

sysdate() function returns a column that appears to be a date
according to the driver.  So SQuirreL uses rs.getDate() in this case.
Without regard for standard SQL and now JDBC, Oracle stores time
information in it's DATE columns, instead of requiring you to use the
correct type - that is, a TIMESTAMP.

There is a work-around if you prefer not to use the "correct" data
type (timestamp) to store a time component along with the date.  In
Global Preferences -> DataType Controls -> Date section you can check
"treat DATE as TIMESTAMP" which will cause SQuirreL to retrieve all
java.sql.Date as java.sql.Timestamp instead.  Note however, that while
this works fine for Oracle, I've seen it not work so well for a
database that implements SQL according to the standard.  So be careful
with this setting if you also access non-Oracle databases.

Lastly, SQuirreL uses a type-safe mechanism for reading and writing
records in the database. Treating the Date like a String (getString)
would break down the type-safety that SQuirreL relies on.

Rob

Re: [Squirrel-sql-users] Oracle nls_date_format

[Frank B. <fra...@eu...>]

Hello,

no oracle experts out there?

Anyway I've played a little with java and wrote a script to see wether it's a 
JDBC or SQuirreL problem. 

import java.sql.*;
class dbAccess {
  public static void main (String args []) throws SQLException
  {
        DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
        Connection conn = DriverManager.getConnection 
("jdbc:oracle:thin:@XXXX", "xxxxxx", "xxxxx");
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select sysdate from dual");
        rset.next();
        System.out.println (rset.getString(1));
        stmt.close();
  }
}

$ java -Doracle.net.tns_admin=$ORACLE_HOME/network/admin -classpath 
$ORACLE_HOME/jdbc/lib/ojdbc14.jar:./ dbAccess
2007-10-19 08:57:53.0

As you can see the JDBC driver gives me the correct date format. I don't even 
have to set the NLS_DATE_FORMAT.

SQuirreL shows me only the date "2007-10-19". But I'm missing the time.

Please, any help would be appreciated to get rid of these to_char() stuff.

Frank


Am Freitag, 28. September 2007 09:00:18 schrieben Sie:
> Hi list,
>
>  I can't set the nls_date_format within an oracle session.
>  I've tried to start SQuirreL with the environment
> NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss' and with the java options
> '-Duser.language=de -Duser.country=DE'. Even 'alter session set
> nls_date_format='yyyy-mm-dd hh24:mi:ss' doesn't work.
>
>  Does anybody have an idea?
>
>  Regards
>  Frank
>
>  -------------------------------------------------------------------------
>  This SF.net email is sponsored by: Microsoft
>  Defy all challenges. Microsoft(R) Visual Studio 2005.
>  http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>  _______________________________________________
>  Squirrel-sql-users mailing list
>  Squ...@li...
>  https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Comparing Data across platforms

[Robert M. <rob...@gm...>]

There isn't an easy way to do this at present.  I began building a
differencing plugin a while back, but it's still in the experimental
phase of development. That said, one technique which is fairly labor
intensive is to create a data script for each table, save the script
as a file, then compare the scripts using a graphical diff tool like
WinMerge.  To create a data script, you would right-click on the table
and choose "Scripts -> Create Data Script".  To create a table
structure script, you would use "Scripts -> Create Table Script".  For
this you need to have the SQL Scripts plugin installed which is part
of the "standard" set of plugins.

Rob

On 10/18/07, Hale, Tina <Ha...@ci...> wrote:
>
>
> We currently have a process that allows users to enter data into a Oracle
> Database and have it sync to a DB2 Database on an AS400.  I can currently
> query the data using SQuirrel in both environments.  Is there a way to
> 'join' the two connections to run comparisons queries of the data?
>
>
>
> Tina Hale
> Business Analyst
> Cintas Corporation - IT
>
> Phone : (513) 701-2087
> Fax   : (513) 573-4940
>
> E-mail: ha...@ci...
>
>  This e-mail transmission contains information that is intended to be
> confidential and privileged. If you receive this e-mail and you are not a
> named addressee you are hereby notified that you are not authorized to read,
> print, retain, copy or disseminate this communication without the consent of
> the sender and that doing so is prohibited and may be unlawful. Please reply
> to the message immediately by informing the sender that the message was
> misdirected. After replying, please delete and otherwise erase it and any
> attachments from your computer system. Your assistance in correcting this
> error is appreciated.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

[Squirrel-sql-users] Comparing Data across platforms

[Hale, T. <Ha...@ci...>]

We=20currently=20have=20a=20process=20that=20allows=20users=20to=20enter=20=
data=20into=20a=20Oracle=20Database=20and=20have=20it=20sync=20to
a=20DB2=20Database=20on=20an=20AS400.=20=20I=20can=20currently=20query=20t=
he=20data=20using=20SQuirrel=20in=20both=20environments.=20=20Is
there=20a=20way=20to=20'join'=20the=20two=20connections=20to=20run=20compa=
risons=20queries=20of=20the=20data?
=20
=20

Tina=20Hale
Business=20Analyst
Cintas=20Corporation=20-=20IT=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=

Phone=20:=20(513)=20701-2087
Fax=20=20=20:=20(513)=20573-4940=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20
E-mail:=20...@ci...=20

=20

This=20e-mail=20transmission=20contains=20information=20that=20is=20intend=
ed=20to=20be=20confidential=20and=20privileged.=20=20If=20you=20receive=20=
this=20e-mail=20and=20you=20are=20not=20a=20named=20addressee=20you=20are=20=
hereby=20notified=20that=20you=20are=20not=20authorized=20to=20read,=20pri=
nt,=20retain,=20copy=20or=20disseminate=20this=20communication=20without=20=
the=20consent=20of=20the=20sender=20and=20that=20doing=20so=20is=20prohibi=
ted=20and=20may=20be=20unlawful.=20=20Please=20reply=20to=20the=20message=20=
immediately=20by=20informing=20the=20sender=20that=20the=20message=20was=20=
misdirected.=20=20After=20replying,=20please=20delete=20and=20otherwise=20=
erase=20it=20and=20any=20attachments=20from=20your=20computer=20system.=20=
=20Your=20assistance=20in=20correcting=20this=20error=20is=20appreciated.

Re: [Squirrel-sql-users] Problem with the latest snapshot of Squirrel

[Robert M. <rob...@gm...>]

Hello,

I've reached a conclusion on this issue.  I spent a number of hours
downloading and installing SUSE SLES9 into a vmware image, and I
finally got Informix 10 installed and managed to setup an ANSI
database (no log buffering).  At first I wasn't seeing the issue as I
had created a non-ANSI database.  However, when I created an ANSI
database I managed to get the same behavior you described!!! (Thank
you for waiting so patiently :)  I've determined that it's probably a
jdbc driver bug.  The good news for you is that there appears to be a
simple work-around.  You see, I notice that the problem goes away when
you use the driver that ships with Informix 10 in the
$INFORMIXDIR/extend/krakatoa directory.  It's version is
"2.21.JC4N450" which you can verify in SQuirreL by looking at the
"getDriverVersion" key's value in the metadata tab when you select the
root node in the object tree.  The version of the driver that produces
the bug you encountered - for me, at least - is "3.00.JC3".

cheers,

Rob

On 10/11/07, M=AA Jos=E9 Casany <mjc...@ls...> wrote:
> Hi Rob,
>    thanks a lot for answering.
>    I only have access to an informix 10.0 for windows. This one I could
> upload it for you in an FTP server.
>   Apart from that, one of my students told me that from the IBM web site
> (http://www14.software.ibm.com/webapp/download/search.jsp?S_TACT=3D104CBW=
71&S_CMP=3D&s=3D&k=3DALL&pid=3D&q=3DInformix&x=3D25&y=3D11&pf=3DLinux&b=3D&=
q0=3D)
>  you can download a 3 month trial of the informix 10.0 server for linux.
>
> M=AA Jos=E9
>
> Robert Manning wrote:
>
> >On 10/9/07, M=AA Jos=E9 Casany <mjc...@ls...> wrote:
> >
> >
> >>Hi Rob,
> >>   I am using SQuirrel to access an informix 10.0 database.
> >> I'm the owner of an ANSI database but it seems that I can't see the
> >>list of column names of the tables.
> >> I can only see the column list when the database is NOT ANSI. The syst=
em
> >>does not return any exception or message at all, it simply does not sho=
w
> >>the column
> >>list.
> >>
> >>I would appreciate if you could answer my question.
> >>
> >>
> >
> >I would like to help you, but I don't have access to an Informix 10.0
> >database.  I do have an Informix 11 database server that Doug Lawry
> >helped me setup on my Fedora Core 6 Linux machine.  However, I had to
> >get the software from him because I am not a licensee of Informix.  Is
> >there a way that I could get version 10 also ? (I believe I was
> >getting version 11 through an arrangement between Informix and the
> >Informix User's Group - IUG).  I don't see the problem you are
> >describing with version 11.  I would need to step through the code
> >with a debugger after connecting to the database.
> >
> >Rob
> >
> >
>
> --
> ----------------------
> M=AA Jos=E9 Casany - UPC
> mjc...@ls...
> +34 93 413 78 88
>
>

[Squirrel-sql-users] viewing text columns from mysql

[Stephen M. <ste...@gm...>]

When using the mysql command line tool, and I select a "text" type
column, the output is in a readable format.

When using squirrel version 2.5.1 that same column is displayed in
Hex. I can double click on this field and select "Show ASCII as
chars".

Is there anyway to have the whole column display with "Show ASCII as chars"  ?

-Thanks
Steve More

Re: [Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel - FOUND THE CAUSE

[Pedro A. <pe...@ne...>]

Found the cause: if I use netbeans editor, I don't have a shared clipboard.
If I use plain or the other, it works. 


Guess this is related to the errors I see on the beginning: 


On Mon, Oct 15, 2007 at 04:00:35PM +0100, Pedro Alves wrote:
> 51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.class.path: /usr/local/squirrel/squirrel-sql.jar:/usr/local/squirrel/lib/antlr-2.7.5H3.jar:/usr/local/squirrel/lib/commons-cli.jar:/usr/local/squirrel/lib/commons-logging-1.0.4.jar:/usr/local/squirrel/lib/forms.jar:/usr/local/squirrel/lib/fw.jar:/usr/local/squirrel/lib/hibernate3.jar:/usr/local/squirrel/lib/jxl.jar:/usr/local/squirrel/lib/log4j.jar:/usr/local/squirrel/lib/nanoxml-2.1.jar:/usr/local/squirrel/lib/postgresql-8.2-505.jdbc3.jar:.:/home/pedro/classes:/opt/javamail-1.3.1/lib/mailapi.jar:/opt/jaf-1.0.2/lib/activation.jar:/home/pedro/classes/comm.jar:/usr/local/common/lib/servlet.jar
> 3996 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load com.Ostermiller.Syntax.ToHTMLAntTask$1 in /usr/local/squirrel/plugins/syntax/lib/syntax.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/apache/tools/ant/util/FileNameMapper
> 3998 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load com.Ostermiller.Syntax.ToHTMLAntTask in /usr/local/squirrel/plugins/syntax/lib/syntax.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/apache/tools/ant/taskdefs/MatchingTask
> 7196 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JCFinderFactory$GlobalPathListener in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/api/java/classpath/GlobalPathRegistryListener
> 7209 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeCallableFeature in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/CallableFeature
> 7210 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeConstructor in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Constructor
> 7211 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeJavaDoc in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/JavaDoc
> 7212 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeMethod in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Method
> 7213 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeParameter in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Parameter
> 7215 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeTagValue in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/TagValue
> 7352 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.NbJavaFoldManager$WeakParsingListener in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/modules/javacore/internalapi/ParsingListener
> 7354 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.NbJavaFoldManager in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/modules/javacore/internalapi/ParsingListener

-- 
Pedro Alves
pmg...@gm...

Re: [Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel

[David D. Jr. <dav...@gm...>]

On 10/15/07, Pedro Alves <pe...@ne...> wrote:
> >
> > Any other info I can give? I can test on another windowmanager, fluxbox,
> > for instance
>
> No, doesn't happen on fluxbox.

I'm not a SQuirreL developer, just a Linux and SQuirreL user, so I'm
not able to offer much more help on this.

Maybe you could try KDE or Gnome ...  I'm guessing that it's an
environment issue, not a SQuirreL one, but again, I'm not a SQuirreL
developer.

-Dave

Re: [Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel

[Pedro A. <pe...@ne...>]

On Tue, Oct 16, 2007 at 02:13:29AM +0100, Pedro Alves wrote:
> 
> Any other info I can give? I can test on another windowmanager, fluxbox,
> for instance


No, doesn't happen on fluxbox.

This is what slackware uses (modular X) 


/var/log/packages/xorg-cf-files-1.0.2-noarch-1
/var/log/packages/xorg-docs-1.4-noarch-1
/var/log/packages/xorg-server-1.3.0.0-i486-2
/var/log/packages/xorg-server-xdmx-1.3.0.0-i486-2
/var/log/packages/xorg-server-xnest-1.3.0.0-i486-2
/var/log/packages/xorg-server-xvfb-1.3.0.0-i486-2
/var/log/packages/xorg-sgml-doctools-1.2-noarch-1



Thanks in advance

-- 
Pedro Alves

Re: [Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel

[Pedro A. <pe...@ne...>]

On Mon, Oct 15, 2007 at 05:58:00PM -0500, David Durham, Jr. wrote:
> 
> I don't have any experience with slackware and fvwm, but have had
> issues with cutting and pasting into java apps on *NIX OSes.  In
> general, I think Swing and clipboard integration can be sketchy.  Do
> you have any other Swing apps you can test against?
> 
> -Dave



All other apps work ok, and I use a few... not even the classic mid button
paste work. 


Any other info I can give? I can test on another windowmanager, fluxbox,
for instance


-- 
Pedro Alves

Re: [Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel

[David D. Jr. <dav...@gm...>]

On 10/15/07, Pedro Alves <pe...@ne...> wrote:
> On Mon, Oct 15, 2007 at 09:54:22AM -0500, David Durham, Jr. wrote:
> > > I have version 2.5, java 1.6.0_02, linux; I can't copy/paste from/to
> > > squirrel; it works from inside, but not from the outside. As if it has a
> > > different clipboard.
> >
> > I have a similar setup, I'm running SQuirreL 2.5, Sun's Linux JRE
> > 1.6.0-b105, and Xubuntu Linux 7.04.  I'm able to cut and paste to
> > SQuirreL from everything else (that I've tried).  Just curious, what
> > distro of Linux and/or desktop environment are you using?
> >
> > -Dave
>
> This is a slackware 12 distro, with fvwm as the window manager.

I don't have any experience with slackware and fvwm, but have had
issues with cutting and pasting into java apps on *NIX OSes.  In
general, I think Swing and clipboard integration can be sketchy.  Do
you have any other Swing apps you can test against?

-Dave

Re: [Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel

[Pedro A. <pe...@ne...>]

On Mon, Oct 15, 2007 at 09:54:22AM -0500, David Durham, Jr. wrote:
> > I have version 2.5, java 1.6.0_02, linux; I can't copy/paste from/to
> > squirrel; it works from inside, but not from the outside. As if it has a
> > different clipboard.
> 
> I have a similar setup, I'm running SQuirreL 2.5, Sun's Linux JRE
> 1.6.0-b105, and Xubuntu Linux 7.04.  I'm able to cut and paste to
> SQuirreL from everything else (that I've tried).  Just curious, what
> distro of Linux and/or desktop environment are you using?
> 
> -Dave

This is a slackware 12 distro, with fvwm as the window manager. 

I can paste this additional info from the logs, maybe it helps. I'm using
tiny look&feel but I've tried others with no luck.

Thanks in advance




0    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - #############################################################################################################
47   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - # Starting SQuirreL SQL Client Version 2.5 at 7/17/07 2:32 PM
47   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - #############################################################################################################
50   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - SQuirreL SQL Client Version 2.5 started: Tue Jul 17 14:32:23 WEST 2007
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - Copyright (c) 2001-2007 
Colin Bell, Gerd Wagner, Rob Manning and others
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.vendor: Sun Microsystems Inc.
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.version: 1.6.0_01
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.runtime.name: Java(TM) SE Runtime Environment
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.name: Linux
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.version: 2.6.21.3-smp
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.arch: i386
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.dir: /home/pedro
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.home: /home/pedro
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.home: /usr/lib/jdk1.6.0_01/jre
51   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.class.path: /usr/local/squirrel/squirrel-sql.jar:/usr/local/squirrel/lib/antlr-2.7.5H3.jar:/usr/local/squirrel/lib/commons-cli.jar:/usr/local/squirrel/lib/commons-logging-1.0.4.jar:/usr/local/squirrel/lib/forms.jar:/usr/local/squirrel/lib/fw.jar:/usr/local/squirrel/lib/hibernate3.jar:/usr/local/squirrel/lib/jxl.jar:/usr/local/squirrel/lib/log4j.jar:/usr/local/squirrel/lib/nanoxml-2.1.jar:/usr/local/squirrel/lib/postgresql-8.2-505.jdbc3.jar:.:/home/pedro/classes:/opt/javamail-1.3.1/lib/mailapi.jar:/opt/jaf-1.0.2/lib/activation.jar:/home/pedro/classes/comm.jar:/usr/local/common/lib/servlet.jar
3996 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load com.Ostermiller.Syntax.ToHTMLAntTask$1 in /usr/local/squirrel/plugins/syntax/lib/syntax.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/apache/tools/ant/util/FileNameMapper
3998 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load com.Ostermiller.Syntax.ToHTMLAntTask in /usr/local/squirrel/plugins/syntax/lib/syntax.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/apache/tools/ant/taskdefs/MatchingTask
7196 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JCFinderFactory$GlobalPathListener in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/api/java/classpath/GlobalPathRegistryListener
7209 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeCallableFeature in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/CallableFeature
7210 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeConstructor in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Constructor
7211 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeJavaDoc in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/JavaDoc
7212 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeMethod in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Method
7213 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeParameter in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Parameter
7215 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.JMIUtils$FakeTagValue in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/TagValue
7352 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.NbJavaFoldManager$WeakParsingListener in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/modules/javacore/internalapi/ParsingListener
7354 [main] INFO  net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to load org.netbeans.modules.editor.java.NbJavaFoldManager in /usr/local/squirrel/plugins/syntax/lib/org-netbeans-modules-editor.jar to check if it is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: java.lang.NoClassDefFoundError: org/netbeans/modules/javacore/internalapi/ParsingListener
21298 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin laf created in 6 ms, loaded in 6,588 ms, initialized in 0 ms, total 6,594 ms.
21301 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin syntax created in 5 ms, loaded in 0 ms, initialized in 86 ms, total 91 ms.
21302 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin graph created in 1 ms, loaded in 0 ms, initialized in 3 ms, total 4 ms.
21303 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin codecompletion created in 1 ms, loaded in 0 ms, initialized in 9 ms, total 10 ms.
21309 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin sqlscript created in 1 ms, loaded in 0 ms, initialized in 17 ms, total 18 ms.
21310 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin sqlbookmark created in 6 ms, loaded in 1 ms, initialized in 11 ms, total 18 ms.
21311 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - Plugin editextras created in 2 ms, loaded in 0 ms, initialized in 32 ms, total 34 ms.
5579312 [AWT-EventQueue-1] INFO  net.sourceforge.squirrel_sql.client.Application  - Application shutting down 7/17/07 4:05 PM.
5611399 [AWT-EventQueue-1] INFO  net.sourceforge.squirrel_sql.client.Application  - Application shutdown complete 7/17/07 4:05 PM.


-- 
Pedro Alves
pmg...@gm...

Re: [Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel

[David D. Jr. <dav...@gm...>]

> I have version 2.5, java 1.6.0_02, linux; I can't copy/paste from/to
> squirrel; it works from inside, but not from the outside. As if it has a
> different clipboard.

I have a similar setup, I'm running SQuirreL 2.5, Sun's Linux JRE
1.6.0-b105, and Xubuntu Linux 7.04.  I'm able to cut and paste to
SQuirreL from everything else (that I've tried).  Just curious, what
distro of Linux and/or desktop environment are you using?

-Dave

[Squirrel-sql-users] Clipboard problem - Can't copy paste from/to squirrel

[Pedro A. <pe...@ne...>]

Hello.


I've seen some references to this in the forums but no answers, so here it
goes: 


I have version 2.5, java 1.6.0_02, linux; I can't copy/paste from/to
squirrel; it works from inside, but not from the outside. As if it has a
different clipboard.


Any tips? It's really annoying, I have to use a file to be able to
extract/import info to other apps. I only have this problem with squirrel,
as far as I can tell.


Thanks you

-- 
Pedro Alves

Re: [Squirrel-sql-users] Where does the graph plugin store the graphs?

[Robert M. <rob...@gm...>]

On 10/8/07, Muzietto <mar...@ya...> wrote:
>
> Good morning, Gerd and Rob,
>
> You are both correct. I see now the filename contains my URL. The connection
> string I got to connect to the db is very long. I reckon it must be somehow
> old-fashioned, because I've been using also a more compact syntax with
> Oracle.
>
> Anyway this conn.string is what my dba uses and distributes. I have just
> found a helper site connectionstrings.com and will try to translate the
> string into something more manageable. I could even do a favour to my dba
> ;-)

That is a neat site that I have not seen before.  One thing I noted
however, is a lack of JDBC connection strings - it seems to be giving
only ODBC - style connection strings. For example in the Oracle
section I see no "jdbc:oracle:thin...." strings.  Otherwise, they have
obviously spent a great deal of time compiling what they have.

Rob

Re: [Squirrel-sql-users] Where does the graph plugin store the graphs?

[Muzietto <mar...@ya...>]

Good morning, Gerd and Rob,

You are both correct. I see now the filename contains my URL. The connection
string I got to connect to the db is very long. I reckon it must be somehow
old-fashioned, because I've been using also a more compact syntax with
Oracle.

Anyway this conn.string is what my dba uses and distributes. I have just
found a helper site connectionstrings.com and will try to translate the
string into something more manageable. I could even do a favour to my dba
;-)

I looked for the files everywhere on the hard disk. They're simply not
there. Gotta make my URL shorter.

Thanks a lot for sending me on the right path,

Marco a.k.a Muzietto



Gerd Wagner wrote:
> 
> Hi,
> 
> Muzietto, first of all thanks for compliments and clap. :-)
> 
> 
> Robert Manning wrote:
>> It should just be using the alias name.  Is your alias name that long?
> It is not the alias name but the JDBC-URL. To me looks like you, Muzietto,
> are 
> using a lot of parameters in your URL. Am I right?
> 
> 
> Gerd
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Where-does-the-graph-plugin-store-the-graphs--tf4574147.html#a13091615
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Where does the graph plugin store the graphs?

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

Hi,

Muzietto, first of all thanks for compliments and clap. :-)


Robert Manning wrote:
> It should just be using the alias name.  Is your alias name that long?
It is not the alias name but the JDBC-URL. To me looks like you, Muzietto, are 
using a lot of parameters in your URL. Am I right?


Gerd

Re: [Squirrel-sql-users] Where does the graph plugin store the graphs?

[Robert M. <rob...@gm...>]

It should just be using the alias name.  Is your alias name that long?

Rob

On 10/5/07, Muzietto <mar...@ya...> wrote:
>
> Adding something more to the description: when I use the command
> "rightclick-rename graph" to rename my graph from TEST_SECONDO_GIORNO to
> TEST I see down in the message window the following text:
>
> Rinominato "C:\Documents and
> Settings\c101856\.squirrel-sql\plugins\graph\jdbc_oracle_thin___DESCRIPTION____ADDRESS____
> PROTOCOL___TCP___HOST___ls001s01_01_rac_vip___PORT___2037_____ADDRESS____PROTOCOL
> ___TCP___HOST___ls001s02_01_rac_vip___PORT___2037_____LOAD_BALANCE___yes___CONNECT_
> DATA____SERVER___DEDICATED___SERVICE_NAME___PC0B1SRV___FAILOVER_MODE____TYPE___
> SELECT___METHOD___BASIC___RETRIES___180___DELAY___5_______.TEST_SECONDO_GIORNO.graph.xml"
> in "C:\Documents and
> Settings\c101856\.squirrel-sql\plugins\graph\jdbc_oracle_thin___DESCRIPTION____ADDRESS____
> PROTOCOL___TCP___HOST___ls001s01_01_rac_vip___PORT___2037_____ADDRESS____PROTOCO
> L___TCP___HOST___ls001s02_01_rac_vip___PORT___2037_____LOAD_BALANCE___yes___CONNECT
> _DATA____SERVER___DEDICATED___SERVICE_NAME___PC0B1SRV___FAILOVER_MODE____TYPE
> ___SELECT___METHOD___BASIC___RETRIES___180___DELAY___5_______.TEST.graph.xml"
>
> So it looks like something is being attempted to save. I never saw such a
> long filename; in theory must be OK, but anyhow the XML's aren't in the
> directory. Something seems to go wrong in the creation, but I don't see
> what.
> The overall log does not mention anything going wrong with the graph plugin.

Re: [Squirrel-sql-users] Where does the graph plugin store the graphs?

[Robert M. <rob...@gm...>]

On 10/5/07, Muzietto <mar...@ya...> wrote:
>
> Rob, thanks for replying,
>
> In my case that directory contains a single file format.xml with the DIN
> paper formats, plus one I created myself. [Is this what you mean by
> "essence"?] I cannot find any trace of the tables involved in the graph.

When I save a graph, I see a message in the message panel like this:

Graph "New table graph" saved to
"/home/manningr/.squirrel-sql/plugins/graph/jdbc_postgresql___localhost_5432_dbcopysrc.New_table_graph.graph.xml"

When I open it with an editor I see the tables represented in XML.  An
when I open the session that I created the graph from, it shows as a
tab right next to the SQL tab (I right-clicked on the graph and chose
"Save Graph" previously.

> understand from your words that I must save the graph as raster image using
> the Zoom-Print option. Am I right?

If you want to use it in some other tool, then yes, you should.

Rob