You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Robert M. <rob...@gm...> - 2012-10-13 07:08:51
|
David,
Thank you for the bug report. You should see notification when it is
addressed.
Rob
On Fri, Oct 12, 2012 at 8:09 PM, David Pinho <dav...@gm...> wrote:
> So anyway i pulled the source and the following seems to fix it:
>
> ### Eclipse Workspace Patch 1.0
> #P oracle
> Index:
> src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/tokenizer/OracleQueryTokenizer.java
> ===================================================================
> ---
> src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/tokenizer/OracleQueryTokenizer.java
> (revision
> 6682)
> +++
> src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/tokenizer/OracleQueryTokenizer.java
> (working
> copy)
> @@ -239,7 +239,7 @@
> for (Iterator<String> iter = _queries.iterator();
> iter.hasNext();)
> {
> String next = iter.next();
> - if (next.startsWith(sep))
> + if (next.startsWith(sep) && !next.startsWith("/*"))
> {
> tmp.add(sep);
> String[] parts = next.split(sep + "\\n+");
>
> Tell me what you think...
>
>
> On Fri, Oct 12, 2012 at 4:23 PM, David Pinho <dav...@gm...>
> wrote:
> > Done.
> >
> > Added the stacktrace from SQuirreL logs:
> >
> > 2012-10-12 16:17:28,429 [Thread-5] ERROR
> > net.sourceforge.squirrel_sql.client.session.MessagePanel -
> > privateShowMessage: Exception was Warning: execution completed with
> > warning
> > java.sql.SQLWarning: Warning: execution completed with warning
> > at
> oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:945)
> > at
> oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:993)
> > at
> oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:1008)
> > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:220)
> > at
> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
> > at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
> > at
> oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
> > at
> oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
> > at
> oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
> > at
> net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:410)
> > at
> net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:220)
> > at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
> > at java.lang.Thread.run(Unknown Source)
> >
> >
> > On Fri, Oct 12, 2012 at 12:11 PM, Robert Manning
> > <rob...@gm...> wrote:
> >> That would be a bug in the Oracle plugin's query tokenizer. Can you
> put in
> >> a bug ticket for that here:
> >>
> >> http://sourceforge.net/tracker/?group_id=28383&atid=393414
> >>
> >> Rob
> >>
> >> On Fri, Oct 12, 2012 at 4:42 AM, David Pinho <dav...@gm...>
> wrote:
> >>>
> >>> 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
> >>>
> >>>
> >>>
> ------------------------------------------------------------------------------
> >>> 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
> >>> Squ...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >>
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> 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
> >> Squ...@li...
> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >>
> >
> >
> >
> > --
> > http://davidpinho.net
>
>
>
> --
> http://davidpinho.net
>
>
> ------------------------------------------------------------------------------
> 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|
|
From: David P. <dav...@gm...> - 2012-10-13 00:09:57
|
So anyway i pulled the source and the following seems to fix it:
### Eclipse Workspace Patch 1.0
#P oracle
Index: src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/tokenizer/OracleQueryTokenizer.java
===================================================================
--- src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/tokenizer/OracleQueryTokenizer.java (revision
6682)
+++ src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/tokenizer/OracleQueryTokenizer.java (working
copy)
@@ -239,7 +239,7 @@
for (Iterator<String> iter = _queries.iterator(); iter.hasNext();)
{
String next = iter.next();
- if (next.startsWith(sep))
+ if (next.startsWith(sep) && !next.startsWith("/*"))
{
tmp.add(sep);
String[] parts = next.split(sep + "\\n+");
Tell me what you think...
On Fri, Oct 12, 2012 at 4:23 PM, David Pinho <dav...@gm...> wrote:
> Done.
>
> Added the stacktrace from SQuirreL logs:
>
> 2012-10-12 16:17:28,429 [Thread-5] ERROR
> net.sourceforge.squirrel_sql.client.session.MessagePanel -
> privateShowMessage: Exception was Warning: execution completed with
> warning
> java.sql.SQLWarning: Warning: execution completed with warning
> at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:945)
> at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:993)
> at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:1008)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:220)
> at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
> at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
> at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
> at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:410)
> at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:220)
> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
> at java.lang.Thread.run(Unknown Source)
>
>
> On Fri, Oct 12, 2012 at 12:11 PM, Robert Manning
> <rob...@gm...> wrote:
>> That would be a bug in the Oracle plugin's query tokenizer. Can you put in
>> a bug ticket for that here:
>>
>> http://sourceforge.net/tracker/?group_id=28383&atid=393414
>>
>> Rob
>>
>> On Fri, Oct 12, 2012 at 4:42 AM, David Pinho <dav...@gm...> wrote:
>>>
>>> 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
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> Squ...@li...
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
>
>
> --
> http://davidpinho.net
--
http://davidpinho.net
|
|
From: David P. <dav...@gm...> - 2012-10-12 15:23:47
|
Done. Added the stacktrace from SQuirreL logs: 2012-10-12 16:17:28,429 [Thread-5] ERROR net.sourceforge.squirrel_sql.client.session.MessagePanel - privateShowMessage: Exception was Warning: execution completed with warning java.sql.SQLWarning: Warning: execution completed with warning at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:945) at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:993) at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:1008) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:220) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:410) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:220) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Unknown Source) On Fri, Oct 12, 2012 at 12:11 PM, Robert Manning <rob...@gm...> wrote: > That would be a bug in the Oracle plugin's query tokenizer. Can you put in > a bug ticket for that here: > > http://sourceforge.net/tracker/?group_id=28383&atid=393414 > > Rob > > On Fri, Oct 12, 2012 at 4:42 AM, David Pinho <dav...@gm...> wrote: >> >> 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 >> >> >> ------------------------------------------------------------------------------ >> 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 >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > ------------------------------------------------------------------------------ > 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > -- http://davidpinho.net |
|
From: John <mr...@ya...> - 2012-10-12 14:26:58
|
I'm a Squirrel newb, have 3.4.0 installed on Unix (Ubuntu), and want to connect to a PostgreSQL 8.4 I have on my system. I have the JDBC driver jar file that can with PostgreSQL and can write a simple Java program using the driver to get to my database but Squirrel is saying it can't load the driver class and there's a red X next to the driver. I tried updating the driver in Squirrel and added the jar file I used to run my Java program to the "extra class path" window but Squirrel still says it can't find the org.postgresql.Driver class. I can see the class in the jar and it's the same class I specified in my Java program. What am I doing wrong? |
|
From: Robert M. <rob...@gm...> - 2012-10-12 11:11:25
|
That would be a bug in the Oracle plugin's query tokenizer. Can you put in a bug ticket for that here: http://sourceforge.net/tracker/?group_id=28383&atid=393414 Rob On Fri, Oct 12, 2012 at 4:42 AM, David Pinho <dav...@gm...> wrote: > 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 > > > ------------------------------------------------------------------------------ > 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Drav S. <hol...@re...> - 2012-10-12 10:25:20
|
Drav Sloan wrote:
> > 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...
Oh I lie, I had the wrong statement selected:
Error: ORA-00900: invalid SQL statement
SQLState: 42000
ErrorCode: 900
Position: 0
Error occured in:
/* comment */
FUNCTION f1 (arg1 IN NUMBER, arg2 IN DATE) RETURN INTEGER
Apologies for the noise!
Regards
D.
|
|
From: Drav S. <hol...@re...> - 2012-10-12 10:25:12
|
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. |
|
From: David P. <dav...@gm...> - 2012-10-12 08:42:59
|
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 |
|
From: Gerd W. <ger...@t-...> - 2012-10-09 09:35:11
|
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
|
|
From: Pedro P. <per...@ya...> - 2012-10-08 08:49:28
|
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).
|
|
From: rainbow p. <rai...@sh...> - 2012-10-05 23:16:32
|
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? |
|
From: Tomasz S. <sk...@gm...> - 2012-10-05 10:18:59
|
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 |
|
From: <sie...@he...> - 2012-10-05 02:42:33
|
<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> </div><div><br></div><div>I get </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 <<a href="mailto:rob...@gm...">rob...@gm...</a>><br> Date: Thu, October 04, 2012 4:52 pm<br> To: <a href="mailto:squ...@li...">squ...@li...</a><br> <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. 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.<br> <br>Rob<br><br><br><div class="gmail_quote">On Thu, Oct 4, 2012 at 3:32 PM, <span dir="ltr"><<a href="mailto:sie...@he..." target="_blank">sie...@he...</a>></span> 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> </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> </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:Squ...@li...">Squ...@li...</a><br> <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:Squ...@li...">Squ...@li...</a><br> <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> |
|
From: Robert M. <rob...@gm...> - 2012-10-04 23:52:51
|
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, <sie...@he...> 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
|
|
From: <sie...@he...> - 2012-10-04 19:32:20
|
<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> </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 </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>
|
|
From: Tomasz S. <sk...@gm...> - 2012-10-04 15:51:37
|
I get strange errors in logs. When I paste SQL into editor and this sql contains objects names, squirrel hangs for some time or forever. For example I hava database "A_D_K7_VT_DB02_FINANCE" and view (not table) "T02005_INVC_HDR" inside of it. I can write select * from, but when I paste some SQL with this view name then in log I get info that database '* A_D_DB02_FINANCE*' which is true because database '*A_D_K7_VT_DB02_FINANCE' *exists. Why the names are different? It crushes squirrel almost every time. Can you help? some info JDBC Driver CLASSNAME com.teradata.jdbc.TeraDriver getDriverName com.teradata.jdbc.TeraDriver getDatabaseProductVersion Teradata Database 12.00.03.18 getIdentifierQuoteString " getDriverVersion 14.00.00.14 DRIVER FILES: terajdbc4.jar 860 650 bytes, tdgssconfig.jar 2 405 bytes. LOG: 2012-10-04 17:30:32,410 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoColumnCache - Failed to load columns for table T02005_INVC_HDR com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.14] [Error 3802] [SQLState 42S02] Database 'A_D_DB02_FINANCE' does not exist. at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307) at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102) at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:302) at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:183) at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:121) at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:112) at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:373) at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:315) at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:303) at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1067) at com.teradata.jdbc.TeraDatabaseMetaData$ObtainViewColumnMetaData.executeHelpColumn(TeraDatabaseMetaData.java:3439) at com.teradata.jdbc.TeraDatabaseMetaData$ObtainViewColumnMetaData.processRows(TeraDatabaseMetaData.java:3287) at com.teradata.jdbc.jdbc_4.TDResultSet.setFetchedRowsPostProcessor(TDResultSet.java:379) at com.teradata.jdbc.TeraDatabaseMetaData.getColumns(TeraDatabaseMetaData.java:3242) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1741) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1830) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1297) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1272) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:760) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxHighlightTokenMatcher.isTable(RSyntaxHighlightTokenMatcher.java:119) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxHighlightTokenMatcherProxy.isTable(RSyntaxHighlightTokenMatcherProxy.java:31) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMarker.addToken(SquirrelTokenMarker.java:49) at org.fife.ui.rsyntaxtextarea.TokenMakerBase.addToken(TokenMakerBase.java:104) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:313) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:298) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:287) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.yylex(SquirrelTokenMakerBase.java:683) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.getTokenList(SquirrelTokenMakerBase.java:370) at org.fife.ui.rsyntaxtextarea.TokenMakerBase.getLastTokenTypeOnLine(TokenMakerBase.java:171) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.getLastTokenTypeOnLine(SquirrelTokenMakerBase.java:72) at org.fife.ui.rsyntaxtextarea.RSyntaxDocument.fireInsertUpdate(RSyntaxDocument.java:167) at javax.swing.text.AbstractDocument.handleInsertString(Unknown Source) at javax.swing.text.AbstractDocument.insertString(Unknown Source) at javax.swing.text.PlainDocument.insertString(Unknown Source) at net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxSQLEntryPanel.appendText(RSyntaxSQLEntryPanel.java:222) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.appendSQL(SQLPanel.java:663) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.copySelectedItemToEntryArea(SQLPanel.java:672) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.access$1600(SQLPanel.java:89) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel$CopyLastButton$1.actionPerformed(SQLPanel.java:1122) 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.AWTEventMulticaster.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.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$000(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(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) |
|
From: Robert M. <rob...@gm...> - 2012-10-03 21:13:31
|
Alexandre, Your approach would work, but I think the feature that Chris is looking for would be much appreciated by many. I agree with Gerd that Chris' request is completely reasonable and within the scope of what SQuirreL should do. In fact, in addition to printing the time taken since an in-progress query has been initiated, I've long thought that SQuirreL should have some visual indicator that a query is in progress that captures the user's attention besides the "Running query...". Something like a progress bar or swirling image or such. This has been a prominent feature in other competing clients for some time. Rob On Wed, Oct 3, 2012 at 10:07 AM, Alexandre Peshansky < Ale...@ei...> wrote: > On Wed, Oct 03, 2012 5:17 AM, Gerd Wagner wrote: > > On 03.10.2012 02:04, Chris Lopes wrote: > > > 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?) > > No, we don't have that feature yet. But it makes sense and shouldn't be > > hard to implement. > > > > Could you please post a feature request here: > > http://sourceforge.net/tracker/?atid=393417&group_id=28383 > > What is wrong with just using built-in function for current date and time > right before starting the query? > For instance, in Oracle I would > > select sysdate from dual > > then run the query. > -- > Alexandre Peshansky, MS > Senior Bioinformatics Analyst, Research Informatics Core (RIC) > Einstein-Montefiore Institute for Clinical and Translational Research > (ICTR) > Albert Einstein College of Medicine > 1300 Morris Park Ave, Mazer Bldg., Rm 534 > Bronx, NY 10461 > (718) 430-2440 (Mo, Th, Fr) (718) 920-4885 (Tu & We) > > > > > ------------------------------------------------------------------------------ > 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Alexandre P. <Ale...@ei...> - 2012-10-03 14:22:32
|
On Wed, Oct 03, 2012 5:17 AM, Gerd Wagner wrote: > On 03.10.2012 02:04, Chris Lopes wrote: > > 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?) > No, we don't have that feature yet. But it makes sense and shouldn't be > hard to implement. > > Could you please post a feature request here: > http://sourceforge.net/tracker/?atid=393417&group_id=28383 What is wrong with just using built-in function for current date and time right before starting the query? For instance, in Oracle I would select sysdate from dual then run the query. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, Th, Fr) (718) 920-4885 (Tu & We) |
|
From: Gerd W. <ger...@t-...> - 2012-10-03 09:16:37
|
On 03.10.2012 02:04, Chris Lopes wrote: > 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?) No, we don't have that feature yet. But it makes sense and shouldn't be hard to implement. Could you please post a feature request here: http://sourceforge.net/tracker/?atid=393417&group_id=28383 Thanks Gerd |
|
From: Chris L. <cl...@ya...> - 2012-10-03 00:04:57
|
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 |
|
From: Baxter, B. <bb...@ci...> - 2012-10-02 23:51:41
|
I am upgrading a Squirrel application that was written using 2.6.5a. I have downloaded 3.3. I am getting a lot of compile errors in Eclipse. I found that BaseSessionInternalFrame no longer exists in the client.gui.session and this is causing many of the errors. Where can I find info about changes made from 2.6.5a to 3.3 so that I can modify this project? Many thanks! Betsy |
|
From: Ray M. <Ray...@te...> - 2012-09-27 16:46:34
|
I spent a few hours unsuccessfully trying to connect to a Microsoft SQL server using integrated authentication (Kerberos), following instructions I found on various sites, and the instructions never seemed to work. It turns out Microsoft changed the rules. You now need to add the parameter authenticationScheme=JavaKerberos . See: http://msdn.microsoft.com/en-us/library/gg558122.aspx Sample connection string that works: jdbc:jtds:sqlserver://123.123.123;instance=server1;databaseName=students;integratedSecurity=true;authenticationScheme=JavaKerberos Also in driver properties set "Domain". Do not include the domain in any user name setting. This was tested using Squirrel SQL (Java) with jtds on Mac OSX. Hopefully the previous sentence has the search terms someone might use who needs to know this information. -- Ray Morris Curriculum & eLearning Services Ray...@te... 979-458-6812 |
|
From: MandolinPlayer <man...@gm...> - 2012-09-24 16:45:46
|
I am running Squirrel 3.4.0 on MacOS and things are running great. With one small exception, when I try to select data out of a table with unicode, I get a whole bunch of question marks. Doing some googling on this, the fix is to use a font in the SQL output that support unicode. Awesome. Except for... In Mac, I can't find where to change the font. On a windows or linux install, the Look and Feel plugin makes a fonts tab, but not on Mac. Anyone have any thoughts on this? I'd really like to be able to see the unicode characters on my mac. Thanks! John |
|
From: Gerd W. <ger...@t-...> - 2012-09-17 18:17:30
|
On 15.09.2012 08:12, shensmart wrote: > Hi, > > I have read the description about SQL Entry Completion > Plugin / Code Completion, it seems that this plugin can help > user to complete sql, but I don\'t know how to use it. > > I write a sql such as \'select from \', I think it should > popup a table list foe me, but there is nothing. And I use > ctrl+t , there is just a menu, still cannot find the table > list. I cannot use ctrl+space neither, because I use a > chinese version win7, ctrl+space is occupied by my input > method. The only convenient way to open up the completion popup right now is to use ctrl space. A rather cumbersome alternative would be to open the tools pop up using ctrl t and then to choose the complete code entry. > Can I assign a short key to it? No not yet. What you could try to do is to edit the Resource.properties file inside the codecompletion.jar file of your SQuirreL installation. You should be able to look inside the jar file for example with 7 Zip (http://www.7-zip.org). Gerd |
|
From: Robert M. <rob...@gm...> - 2012-09-12 21:19:34
|
Hi Cris, Can you (or anyone else paying attention to this thread) when you connect to DB2 on Z/OS with SQuirreL, look at the "Metadata" tab in the object tab (click on the root node of the object tree) and tell me the value of the property named "getDatabaseProductName". I need this in order to branch the logic that chooses which SQL statements to use when connected to DB2-UDB, DB2-OS400 or DB2-Z/OS. Thanks, Rob On Sat, Sep 8, 2012 at 3:55 PM, Cristiano Guadagnino <cri...@gm...>wrote: > Robert, > I sent the correct queries for DB2 Z/OS a couple years ago. They are > stilll available on sourceforge: in the "Feature Requests" tracker, ID > 3134781. I could not attach a file so I wrote the queries as a comment. > > Hope you can make something out of it. I am able and willing to test. > > Bye > Cris > > > > > On Sat, Sep 8, 2012 at 12:54 PM, Robert Manning < > rob...@gm...> wrote: > >> Since none of us SQuirreL developers have access to this platform, its >> hard to test. However, if you could look at the "Metadata" tab in the >> object tab (click on the root node of the object tree) and tell us the >> value of the property named "getDatabaseProductName", we may be able to >> update the plugin to use the tables you have suggested. >> >> Rob >> >> On Fri, Sep 7, 2012 at 3:14 PM, Tony (Antonious) Anderson < >> aan...@bc...> wrote: >> >>> When looking through the object tree for Triggers and Indexes, Squirrel >>> attempts to run queries against SYSCAT.TRIGGERS and SYSCAT.INDEXES. These >>> are not valid catalog objects in mainframe DB2. This causes -204, -514, >>> and -516 sql errors in the tool. How would one go about getting Squirrel >>> updated to use the SYSIBM.SYSTRIGGERS and SYSIBM.SYSINDEXES instead?**** >>> >>> ** ** >>> >>> Thanks.**** >>> >>> > |
