SQuirreL SQL Client

Email Archive: squirrel-sql-users (read-only)

2003:	_Jan (11)	_Feb (5)	_Mar (10)	_Apr (20)	_May (24)	_Jun (13)	_Jul (6)	_Aug (5)	_Sep (10)	_Oct (10)	_Nov (9)	_Dec (7)
2009:	_Jan (21)	_Feb (36)	_Mar (40)	_Apr (51)	_May (27)	_Jun (13)	_Jul (38)	_Aug (40)	_Sep (5)	_Oct (14)	_Nov (4)	_Dec (7)
2005:	_Jan (5)	_Feb (1)	_Mar (5)	_Apr (10)	_May (10)	_Jun (16)	_Jul (46)	_Aug (36)	_Sep (16)	_Oct (11)	_Nov (12)	_Dec (29)
2010:	_Jan (16)	_Feb (10)	_Mar (38)	_Apr (83)	_May (27)	_Jun (41)	_Jul (57)	_Aug (24)	_Sep (14)	_Oct (22)	_Nov (28)	_Dec (42)
2004:	_Jan (4)	_Feb (10)	_Mar (5)	_Apr (18)	_May (18)	_Jun (14)	_Jul (24)	_Aug (14)	_Sep (6)	_Oct (18)	_Nov (5)	_Dec (3)
2012:	_Jan (30)	_Feb (9)	_Mar (33)	_Apr (15)	_May (13)	_Jun (13)	_Jul (57)	_Aug (20)	_Sep (18)	_Oct (29)	_Nov (28)	_Dec (9)
2001:	_Jan	_Feb	_Mar	_Apr	_May	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov (7)	_Dec (4)
2007:	_Jan (35)	_Feb (18)	_Mar (46)	_Apr (25)	_May (26)	_Jun (24)	_Jul (33)	_Aug (4)	_Sep (41)	_Oct (43)	_Nov (23)	_Dec (42)
2008:	_Jan (26)	_Feb (20)	_Mar (21)	_Apr (18)	_May (28)	_Jun (32)	_Jul (25)	_Aug (28)	_Sep (27)	_Oct (34)	_Nov (16)	_Dec (42)
2013:	_Jan (19)	_Feb (26)	_Mar (44)	_Apr (13)	_May (25)	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec
2006:	_Jan (33)	_Feb (45)	_Mar (42)	_Apr (23)	_May (23)	_Jun (21)	_Jul (19)	_Aug (23)	_Sep (17)	_Oct (50)	_Nov (74)	_Dec (44)
2002:	_Jan (9)	_Feb (4)	_Mar (20)	_Apr (10)	_May (5)	_Jun (2)	_Jul (10)	_Aug (4)	_Sep (15)	_Oct (5)	_Nov (8)	_Dec (2)
2011:	_Jan (52)	_Feb (13)	_Mar (41)	_Apr (14)	_May (24)	_Jun (14)	_Jul (16)	_Aug (15)	_Sep (19)	_Oct (20)	_Nov (35)	_Dec (48)


S	M	T	W	T	F	S
	1	2	3	4	5	6
		(1)	(4)	(5)	(3)
7	8	9	10	11	12	13
	(1)	(1)			(6)	(2)
14	15	16	17	18	19	20
		(1)			(2)	(1)
21	22	23	24	25	26	27
		(1)
28	29	30	31
		(1)

[Squirrel-sql-users] Comment placement in CREATE PACKAGE

From: David Pinho <david.pinho@gm...> - 2012-10-12 08:42

Hi all,

I'm seeing a strange behavior (well strange for me anyway). When
creating a package in an Oracle DB:

If i execute this in SQuirreL:

CREATE OR REPLACE PACKAGE foo AS

/* comment */
c1 CONSTANT INTEGER := 1;

FUNCTION f1 (arg1 IN NUMBER, arg2 IN DATE) RETURN INTEGER;

END foo;
/

It will execute fine and create the package. But if i change the
position of the comment line:

CREATE OR REPLACE PACKAGE foo AS

c1 CONSTANT INTEGER := 1;
/* comment */

FUNCTION f1 (arg1 IN NUMBER, arg2 IN DATE) RETURN INTEGER;

END foo;
/

it will fail with the error:
Query 1 of 4, Rows read: 0, Elapsed time (seconds) - Total: 0.02, SQL
query: 0.02, Reading results: 0
Error: Invalid SQL type: sqlKind = 0
SQLState:  99999
ErrorCode: 17439
Position: 0
Error occured in:
/* comment *


If i run it in SQLPlus it will run just fine. Any ideias what this
might be or how i can get around it?

I'm using Oracle 10.2.0.4.0 and SQuirreL 3.4.0 (Oracle Thin Driver).


Tks,

David




-- 
http://davidpinho.net

Re: [Squirrel-sql-users] Comment placement in CREATE PACKAGE

From: Drav Sloan <holborn-squirrel@re...> - 2012-10-12 10:25

David Pinho wrote:
> I'm seeing a strange behavior (well strange for me anyway). When
> creating a package in an Oracle DB:
> 
> If i execute this in SQuirreL:
> 
> CREATE OR REPLACE PACKAGE foo AS
> 
> /* comment */
> c1 CONSTANT INTEGER := 1;
> 
> FUNCTION f1 (arg1 IN NUMBER, arg2 IN DATE) RETURN INTEGER;
> 
> END foo;
> /
> 
> It will execute fine and create the package. But if i change the
> position of the comment line:
> 
> CREATE OR REPLACE PACKAGE foo AS
> 
> c1 CONSTANT INTEGER := 1;
> /* comment */
> 
> FUNCTION f1 (arg1 IN NUMBER, arg2 IN DATE) RETURN INTEGER;
> 
> END foo;
> /
> 
> it will fail with the error:
> Query 1 of 4, Rows read: 0, Elapsed time (seconds) - Total: 0.02, SQL
> query: 0.02, Reading results: 0
> Error: Invalid SQL type: sqlKind = 0
> SQLState:  99999
> ErrorCode: 17439
> Position: 0
> Error occured in:
> /* comment *
> 
> 
> If i run it in SQLPlus it will run just fine. Any ideias what this
> might be or how i can get around it?
> 
> I'm using Oracle 10.2.0.4.0 and SQuirreL 3.4.0 (Oracle Thin Driver).

I'm running Oracle 10.2.0.4.0 (64-bit), Squirrel 3.4.0 and the
oracle ojdbc 6.0 thin client and both the above run without giving
any errors... 

:/

D.

[Squirrel-sql-users] The graph diagram of a self-referencing table does not shows the corresponding edge

From: Pedro Pastor <pericopb@ya...> - 2012-10-08 08:49

Steps to reproduce the problem:
#
Execute the following SQL sentence against any database:
    create table Employee(
        id integer not null primary key,
        name varchar(50) not null,
        bossId integer,
        foreign key (bossId) references Employee(id)
    )
#
Open SQuirreL, connect to the database, and open the graph
diagram of "Employee" table.

The problem:
    The corresponding SQuirreL's graph diagram to that 
    table does NO show the edge between an employee 
    ("bossId" column) and itself ("id" column).

Re: [Squirrel-sql-users] The graph diagram of a self-referencing table does not shows the corresponding edge

From: Gerd Wagner <gerdhwagner@t-...> - 2012-10-09 09:35

On 08.10.2012 10:49, Pedro Pastor wrote:
> Steps to reproduce the problem:
> #
> Execute the following SQL sentence against any database:
>      create table Employee(
>          id integer not null primary key,
>          name varchar(50) not null,
>          bossId integer,
>          foreign key (bossId) references Employee(id)
>      )
> #
> Open SQuirreL, connect to the database, and open the graph
> diagram of "Employee" table.
>
> The problem:
>      The corresponding SQuirreL's graph diagram to that
>      table does NO show the edge between an employee
>      ("bossId" column) and itself ("id" column).
I confirm that SQuirreL cannot show self-referencing foreign keys yet.

You may file a feature request for it here
http://sourceforge.net/tracker/?atid=393417&group_id=28383

Gerd

[Squirrel-sql-users] Unable to install on Windows Vista

From: rainbow photo <rainbow608@sh...> - 2012-10-05 23:16

I follow the instruction on http://squirrel-sql.sourceforge.net/index.php?page=faq#faq10 and still get the following error:

c:\>java -jar squirrel-sql-3.4.0-install.jar
Exception in thread "main" java.lang.UnsatisfiedLinkError: java.io.WinNTFileSystem.createFileExc
lusively(Ljava/lang/String;Z)Z
        at java.io.WinNTFileSystem.createFileExclusively(Native Method)
        at java.io.File.createNewFile(Unknown Source)
        at com.izforge.izpack.installer.GUIInstaller.checkLockFile(Unknown Source)
        at com.izforge.izpack.installer.GUIInstaller.init(Unknown Source)
        at com.izforge.izpack.installer.GUIInstaller.<init>(Unknown Source)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at java.lang.Class.newInstance0(Unknown Source)
        at java.lang.Class.newInstance(Unknown Source)
        at com.izforge.izpack.installer.Installer.main(Unknown Source)

What shall I do?

[Squirrel-sql-users] Code completion is not working for objects that have qualified name "database"."table"

From: Tomasz Skoczylas <skoczy@gm...> - 2012-10-05 10:18

Attachments: Message as HTML

Squirrel 3.4.0, plugin 1.0, Windows 7 64-bit

When I try using code completion on SQL

select * from "database"."table" where "table". I press CTRL+SPACE here -
code completion popus is not appearing, when I remove doublequotes, it
works. But without doublequotes loading such sqls and pasting such sqls
hangs Squirrel for ages.

Hanging Squirrel without doublequotes I described here:

http://sourceforge.net/mailarchive/forum.php?thread_name=CAGHWbuM%3DP2ctcxWpnFr-TM9FGVhemr-0SRDFUzHzAXbZ%2BDw5tg%40mail.gmail.com&forum_name=squirrel-sql-users

Re: [Squirrel-sql-users] Connection string for Oracle Thin?

From: <siegfried@he...> - 2012-10-05 02:42

<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>OK, progress! Thanks Robert!</div><div><br></div><div>I can now connect and I see a nice display of tabs.</div><div>When I try to expand "TABLE" I'm expecting a list of tables and I see no tables. What is wrong?</div><div><br></div><div>When I click on the SQL tab I enter the following SQL:</div><div>SELECT <a href="http://u.name">u.name</a> AS fall, <a href="http://c.name">c.name</a> AS county FROM  upfall u INNER JOIN county c ON u.county_id = <a href="http://c.id">c.id</a>&nbsp;</div><div><br></div><div>I get&nbsp;</div><div>Error:Closed Connection</div><div>SQL State: 08003</div><div>ErrorCode: 17008</div><div><br></div><div>However, my java program executes this SQL query correctly with the connection string below.</div><div><br></div><div>What am I doing wrong?</div><div>Thanks</div><div>Siegfried</div><div><br></div><div><br></div><div><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: Re: [Squirrel-sql-users] Connection string for Oracle Thin?<br>
From: Robert Manning &lt;<a href="mailto:robert.m.manning@...>
Date: Thu, October 04, 2012 4:52 pm<br>
To: <a href="mailto:squirrel-sql-users@...>
<br>
It should be :<br><br>jdbc:oracle:thin:@192.168.1.131:1521:orcl<br><br>(replace the forward slash '/' with a colon ':')<br><br>The drivers aren't shipped with SQuirreL.&nbsp; They can be located in SQUIRREL_HOME/lib folder - alternatively use the "Extra Classpath" tab to add drivers that are located elsewhere on the machine.&nbsp; SQuirreL has no command line mode - however, one plugin (dbcopy) does have a command-line interface.<br> <br>Rob<br><br><br><div class="gmail_quote">On Thu, Oct 4, 2012 at 3:32 PM, <span dir="ltr">&lt;<a href="mailto:siegfried@..." target="_blank">siegfried@...> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div><span style="font-size:10pt;font-family:Verdana"><div><br></div><div>This fragment of java code successfully connects from my windows 7 host to my oracle linux guest running the oracle database:</div><div><br></div><div> class Conn {<br> public static void main (String[] args) throws Exception<br> {<br> Class.forName ("oracle.jdbc.OracleDriver");<br> Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//<a href="http://192.168.1.131:1521/orcl" target="_blank">192.168.1.131:1521/orcl</a>", "siegfried", "secret");<br> &nbsp;</div><div><br></div><div>Now I am trying to connect with squirrel 3.4.0 and I have downloaded ojdbc6.jar to c:/Program Files/squirrel-sql-3.4.0/lib. Is this necessary or does squirrel already come with this JDBC driver? What is that Extra Classpath tab for?</div> <div><br></div><div>Here is the connection string I am trying to use that is giving me a stack trace. (Sorry, I forgot to save the stack trace! If necescary, I'll fire up the linux guest and database (that takes a while) and get that stack trace).</div> <div><br></div><div><a href="http://jdbc:oracle:thin:@192.168.1.131:1521/orcl" target="_blank">jdbc:oracle:thin:@192.168.1.131:1521/orcl</a>&nbsp;</div><div><br></div><div>Is this the correct syntax? It works for java and squirrel is java so I don't understand why it does not work.</div> <div><br></div><div>orcl is the name of my SID.</div><div><br></div><div>Also, does squirrel have a command line mode so it can be more of a substitute for sqlplus (oracle command line utility) and sqlcmd (MS SQL Server command line utility)?</div> <div><br></div><div>Thanks</div><div>Siegfried</div></span></div> <br>------------------------------------------------------------------------------<br> Don't let slow site performance ruin your business. Deploy New Relic APM<br> Deploy New Relic app performance management and know exactly<br> what is happening inside your Ruby, Python, PHP, Java, and .NET app<br> Try New Relic at no cost today and get our sweet Data Nerd shirt too!<br> <a href="http://p.sf.net/sfu/newrelic-dev2dev" target="_blank">http://p.sf.net/sfu/newrelic-dev2dev</a><br>_______________________________________________<br> Squirrel-sql-users mailing list<br> <a target="_blank" href="mailto:Squirrel-sql-users@...> <a href="https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users</a><br> <br></blockquote></div><br> <hr>------------------------------------------------------------------------------<br>
Don't let slow site performance ruin your business. Deploy New Relic APM<br>
Deploy New Relic app performance management and know exactly<br>
what is happening inside your Ruby, Python, PHP, Java, and .NET app<br>
Try New Relic at no cost today and get our sweet Data Nerd shirt too!<br>
<a href="http://p.sf.net/sfu/newrelic-dev2dev">http://p.sf.net/sfu/newrelic-dev2dev</a><hr>_______________________________________________<br>
Squirrel-sql-users mailing list<br>
<a href="mailto:Squirrel-sql-users@...>
<a href="https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users">https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users</a><br>

</div>
</blockquote></span></body></html>

[Squirrel-sql-users] Connection string for Oracle Thin?

From: <siegfried@he...> - 2012-10-04 19:32

<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div><br></div><div>This fragment of java code successfully connects from my windows 7 host to my oracle linux guest running the oracle database:</div><div><br></div><div>class Conn {<br>  public static void main (String[] args) throws Exception<br>  {<br>   Class.forName ("oracle.jdbc.OracleDriver");<br>   Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//192.168.1.131:1521/orcl", "siegfried", "secret");<br>&nbsp;</div><div><br></div><div>Now I am trying to connect with squirrel 3.4.0 and I have downloaded ojdbc6.jar to   c:/Program Files/squirrel-sql-3.4.0/lib. Is this necessary or does squirrel already come with this JDBC driver? What is that Extra Classpath tab for?</div><div><br></div><div>Here is the connection string I am trying to use that is giving me a stack trace. (Sorry, I forgot to save the stack trace! If necescary, I'll fire up the linux guest and database (that takes a while) and get that stack trace).</div><div><br></div><div>jdbc:oracle:thin:@192.168.1.131:1521/orcl&nbsp;</div><div><br></div><div>Is this the correct syntax? It works for java and squirrel is java so I don't understand why it does not work.</div><div><br></div><div>orcl is the name of my SID.</div><div><br></div><div>Also, does squirrel have a command line mode so it can be more of a substitute for sqlplus (oracle command line utility) and sqlcmd (MS SQL Server command line utility)?</div><div><br></div><div>Thanks</div><div>Siegfried</div></span></body></html>

Re: [Squirrel-sql-users] Connection string for Oracle Thin?

From: Robert Manning <robert.manning@gm...> - 2012-10-04 23:52

Attachments: Message as HTML

It should be :

jdbc:oracle:thin:@192.168.1.131:1521:orcl

(replace the forward slash '/' with a colon ':')

The drivers aren't shipped with SQuirreL.  They can be located in
SQUIRREL_HOME/lib folder - alternatively use the "Extra Classpath" tab to
add drivers that are located elsewhere on the machine.  SQuirreL has no
command line mode - however, one plugin (dbcopy) does have a command-line
interface.

Rob


On Thu, Oct 4, 2012 at 3:32 PM, <siegfried@...> wrote:

>
> This fragment of java code successfully connects from my windows 7 host to
> my oracle linux guest running the oracle database:
>
> class Conn {
> public static void main (String[] args) throws Exception
> {
> Class.forName ("oracle.jdbc.OracleDriver");
> Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//
> 192.168.1.131:1521/orcl", "siegfried", "secret");
>
>
> Now I am trying to connect with squirrel 3.4.0 and I have downloaded
> ojdbc6.jar to c:/Program Files/squirrel-sql-3.4.0/lib. Is this necessary or
> does squirrel already come with this JDBC driver? What is that Extra
> Classpath tab for?
>
> Here is the connection string I am trying to use that is giving me a stack
> trace. (Sorry, I forgot to save the stack trace! If necescary, I'll fire up
> the linux guest and database (that takes a while) and get that stack trace).
>
> jdbc:oracle:thin:@192.168.1.131:1521/orcl
>
> Is this the correct syntax? It works for java and squirrel is java so I
> don't understand why it does not work.
>
> orcl is the name of my SID.
>
> Also, does squirrel have a command line mode so it can be more of a
> substitute for sqlplus (oracle command line utility) and sqlcmd (MS SQL
> Server command line utility)?
>
> Thanks
> Siegfried
>
>
> ------------------------------------------------------------------------------
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

[Squirrel-sql-users] Start time or run time for a query before it has completed

From: Chris Lopes <clopes@ya...> - 2012-10-03 00:04

Attachments: Message as HTML

Hi,

Is there any way to know either of the following:
1) What time an in-progress query was initiated?
2) [related] How long an in-progress query has taken so far?

Obviously the run time of a query is printed out in the log after the query completes, but I'd like to be able to know these things before it completes. (how long have I been waiting so far?)

Thanks