headers
Muzietto | 5 Oct 2007 12:07
Picon
Favicon

Where does the graph plugin store the graphs?


Good morning everybody,

Since a couple of days I am using the graph plugin. It's great... First of
all my compliments :clap:to Gerd the author.

I have saved several complex graphs, using rightclick+save graph, but
how/where do I retrieve them? I wasn't able to find this info neither in the
online help, nor browsing nabble.

Thanks,
Muzietto

--

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

-------------------------------------------------------------------------
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/
Permalink | Reply | 8 comments |
headers
Robert Manning | 5 Oct 2007 13:13
Picon
Gravatar

Re: Where does the graph plugin store the graphs?

On 10/5/07, Muzietto <marco_faustinelli <at> yahoo.com> wrote:
>
> Good morning everybody,
>
> Since a couple of days I am using the graph plugin. It's great... First of
> all my compliments :clap:to Gerd the author.
>
> I have saved several complex graphs, using rightclick+save graph, but
> how/where do I retrieve them? I wasn't able to find this info neither in the
> online help, nor browsing nabble.

The essence of the graphs are saved in
<user.home>/.squirrel-sql/plugins/graph/*.xml.  You can also save them
as images (jpg) if you check the "Zoom/Print" option and click the
Save icon in the bottom right corner.

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/
Permalink | Reply | 7 comments |
headers
Muzietto | 5 Oct 2007 14:35
Picon
Favicon

Re: Where does the graph plugin store the graphs?


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. I
understand from your words that I must save the graph as raster image using
the Zoom-Print option. Am I right?

manningr wrote:
> 
> On 10/5/07, Muzietto <marco_faustinelli <at> yahoo.com> wrote:
> 
>> I have saved several complex graphs, using rightclick+save graph, but
>> how/where do I retrieve them? I wasn't able to find this info neither in
>> the
>> online help, nor browsing nabble.
> 
> The essence of the graphs are saved in
> <user.home>/.squirrel-sql/plugins/graph/*.xml.  You can also save them
> as images (jpg) if you check the "Zoom/Print" option and click the
> Save icon in the bottom right corner.
> 
> Rob
> 
--

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

-------------------------------------------------------------------------
(Continue reading)

Permalink | Reply | 6 comments |
headers
Muzietto | 5 Oct 2007 15:09
Picon
Favicon

Re: Where does the graph plugin store the graphs?


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.

Muzietto 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
(Continue reading)

Permalink | Reply | 4 comments |
headers
Robert Manning | 5 Oct 2007 23:38
Picon
Gravatar

Re: Where does the graph plugin store the graphs?

On 10/5/07, Muzietto <marco_faustinelli <at> yahoo.com> 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

-------------------------------------------------------------------------
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/
(Continue reading)

Permalink | Reply | 0 comments |
headers
Robert Manning | 5 Oct 2007 23:46
Picon
Gravatar

Re: Where does the graph plugin store the graphs?

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

Rob

On 10/5/07, Muzietto <marco_faustinelli <at> yahoo.com> 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.

-------------------------------------------------------------------------
(Continue reading)

Permalink | Reply | 3 comments |
headers
Gerd Wagner | 6 Oct 2007 06:21
Picon
Favicon

Re: Where does the graph plugin store the graphs?

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/
Permalink | Reply | 2 comments |
headers
Muzietto | 8 Oct 2007 09:12
Picon
Favicon

Re: Where does the graph plugin store the graphs?


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,
(Continue reading)

Permalink | Reply | 1 comment |
headers
Robert Manning | 8 Oct 2007 11:49
Picon
Gravatar

Re: Where does the graph plugin store the graphs?

On 10/8/07, Muzietto <marco_faustinelli <at> yahoo.com> 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

-------------------------------------------------------------------------
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/
Permalink | Reply | 0 comments |
headers
Pedro Alves | 15 Oct 2007 14:54
Picon

Clipboard problem - Can't copy paste from/to squirrel


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

-------------------------------------------------------------------------
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/
Permalink | Reply | 10 comments |

Gmane