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

Re: [Squirrel-sql-users] Version 3.3.0

[Erwan D. <erw...@gm...>]

I do also use squirrel 3.3.0 against db2 on iseries, without any problem.
Please give us more info.
Also, did you try to uninstall and reinstall?
Erwan

Joe Repoley <Joe...@st...> a écrit :

>Since I updated to this version, whenever I do a select, I get the following message:  java.lang.NullPointerException.  I am connecting to DB2 on the iSeries.
> 
> 
>Joe Repoley
>Senior Systems Analyst
>Information Technology
>(209) 937-7269
> 
>Effective July 15, 2011, the City of Stockton will begin using new e-mail addresses. My new e-mail address will be Joe...@st....  Please make changes to your system(s) or list(s) to continue receiving communications from the City of Stockton.
>
>------------------------------------------------------------------------------
>Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
>infrastructure or vast IT resources to deliver seamless, secure access to
>virtual desktops. With this all-in-one solution, easily deploy virtual 
>desktops for less than the cost of PCs and save 60% on VDI infrastructure 
>costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
>_______________________________________________
>Squirrel-sql-users mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Cannot display search results with Cassandra query

[Tommy Li <Tom...@au...>]

Hi,

I am using SquirrelSQL 3.2.1, with cassandra-jdbc driver http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/

Also, I put other cassandra dependency jars to the SquirrelSQL lib folder.

I can successfully make a connection to my local cassandra instance jdbc:cassandra://localhost:9160/mykeyspace.

When I issue a query 'select name, phone, address from company', it shows the query is successfully executed with 3 rows returned.  However, it is not displaying the rows in the results table.

Any idea?

-Tommy

Re: [Squirrel-sql-users] delete a SQL statement from my SQL history

[selim ok <se...@gm...>]

Hi There,

I just see your post as I searched on google how to remove squirrel SQL
history.
After I realized how to do, I want to post my answer to help others, who
will possibly search the same topic on google or somewhere else.

It need a bit manual work:

Under linux (possibly the same for other platforms) squirrel creates a
directory on your home folder, which called .squirrel-sql (attention:
directories starts with a dot may be hidden). In this folder there is a
file called sql_history.xml, which contains all SQL history until now
stored. But the last executed commands are not saved until the squirrel
client gui closed. If you entered some sensible commands, you have to
terminate the gui and after then you can remove the content of the
sql_history.xml file. So the SQL History is removed.

Cheers,
Selim


From: Thorsten Berninger <thorsten.berninger@go...> - 2011-05-16 10:39

Hi everybody,

I would like to delete a SQL statement from my SQL history (100).
I used SQuirreL to change my password (sp_password 'old', 'new')
and now can everybody see my new password in the SQL history.


Bye the way: why is it not possible to search in the help menu?

best regards

Re: [Squirrel-sql-users] Lot of mess in squirrel-sql.bat when JAVA installed on 64bit Win7 in C:\Program files (x86)\java

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

Ben,

On 03.01.2012 15:13, Ben Stover wrote:
 > set IZPACK_JAVA="%JAVA_HOME%"
 >
 > in the 4th line (mind the new quotes). as suggested by Erwan DUROSELLE-2
 > seems to work.
Is done in SVN and will be available in future releases.

Gerd

Re: [Squirrel-sql-users] Lot of mess in squirrel-sql.bat when JAVA installed on 64bit Win7 in C:\Program files (x86)\java

[Ben S. <bxs...@ya...>]

set IZPACK_JAVA="%JAVA_HOME%" 

in the 4th line (mind the new quotes). as suggested by Erwan DUROSELLE-2 seems to work.

As already posted byErwan DUROSELLE-2  this bug was already reported in
ID: 3026995 64-bit windows problem 

Could you fix it with the next release?
Implementation cost is tiny.

Thank you
Ben


--Original Message Text---
From: Robert Manning
Date: Fri, 30 Dec 2011 11:07:23 -0500

Hi Ben,

Can you propose changes to the script that allows it to work in your environment ?  

Rob

On Fri, Dec 30, 2011 at 5:31 AM, Ben Stover <bxs...@ya...> wrote:
I have a 64bit Win7 where I installed Java JDK in folder C:\Program Files (x86)\Java
which is the default folder for 32bit programs in 64bit Win7.

Now I downloaded and extracted squirrel v3.3.0 plain standard and started squirrel-sql.bat as

squirrel-sql.bat --user-settings-dir  D:\database\squirrel\myset

The batch procedure which is provided seems to have a lot of trouble with dealing with JAVA installation folders containing 
brackets like ( and ).

The mess starts in the first statement when

set IZPACK_JAVA=%JAVA_HOME%
is evaluated to
set IZPACK_JAVA=C:\Program Files (x86)\Java\jdk

At first the batch script aborts and tells me

\Java\jdk\v1.6.x\bin\javaw.exe was unexpected at this time.

because set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe" in line 13 is interpreting the closing ")" as close of the if 
statement.

When I change the statement to

set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe"

(which prevents evaluating the closing ")") then the next abort shows up:

'""C:\Program' is not recognized as an internal or external command,

because of

"%LOCAL_JAVA%" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7

which is evalauted to

""C:\Program Files (x86)\Java\jdk"" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7

Mind the double quotes and the blank which is now seen as a delimiter token.

...and so far. I doubt that someone run this script ever on 64bit Win7 with 32bit Java (which is NOT unusual).

Could someone review the script?

Thank you
Ben






------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Lot of mess in squirrel-sql.bat when JAVA installed on 64bit Win7 in C:\Program files (x86)\java

[Erwan D. <erw...@gm...>]

This problem and it's solution has been filed a while ago as bug *ID:
3026995* ***64-bit windows problem *

Erwan

2011/12/30 Erwan DUROSELLE <erw...@gm...>

> I had the same problem on a the same Win7 64 bits with 32 bit Java.
> IIRC, the solution was to add double quotes to %JAVA_HOME%:
>
> set IZPACK_JAVA="%JAVA_HOME%"
>
> I'll check that at work on monday.
> Erwan
>
>
> Le 30/12/2011 11:31, Ben Stover a écrit :
>
>  I have a 64bit Win7 where I installed Java JDK in folder C:\Program Files
>> (x86)\Java
>> which is the default folder for 32bit programs in 64bit Win7.
>>
>> Now I downloaded and extracted squirrel v3.3.0 plain standard and started
>> squirrel-sql.bat as
>>
>> squirrel-sql.bat --user-settings-dir  D:\database\squirrel\myset
>>
>> The batch procedure which is provided seems to have a lot of trouble with
>> dealing with JAVA installation folders containing brackets like ( and ).
>>
>> The mess starts in the first statement when
>>
>> set IZPACK_JAVA=%JAVA_HOME%
>> is evaluated to
>> set IZPACK_JAVA=C:\Program Files (x86)\Java\jdk
>>
>> At first the batch script aborts and tells me
>>
>> \Java\jdk\v1.6.x\bin\javaw.exe was unexpected at this time.
>>
>> because set LOCAL_JAVA="%IZPACK_JAVA%\bin\**javaw.exe" in line 13 is
>> interpreting the closing ")" as close of the if statement.
>>
>> When I change the statement to
>>
>> set LOCAL_JAVA="%IZPACK_JAVA%\bin\**javaw.exe"
>>
>> (which prevents evaluating the closing ")") then the next abort shows up:
>>
>> '""C:\Program' is not recognized as an internal or external command,
>>
>> because of
>>
>> "%LOCAL_JAVA%" -cp "%SQUIRREL_SQL_HOME%\lib\**versioncheck.jar"
>> JavaVersionChecker 1.6 1.7
>>
>> which is evalauted to
>>
>> ""C:\Program Files (x86)\Java\jdk"" -cp "%SQUIRREL_SQL_HOME%\lib\**versioncheck.jar"
>> JavaVersionChecker 1.6 1.7
>>
>> Mind the double quotes and the blank which is now seen as a delimiter
>> token.
>>
>> ...and so far. I doubt that someone run this script ever on 64bit Win7
>> with 32bit Java (which is NOT unusual).
>>
>> Could someone review the script?
>>
>> Thank you
>> Ben
>>
>>
>>
>>
>

Re: [Squirrel-sql-users] Lot of mess in squirrel-sql.bat when JAVA installed on 64bit Win7 in C:\Program files (x86)\java

[Erwan D. <erw...@gm...>]

I had the same problem on a the same Win7 64 bits with 32 bit Java.
IIRC, the solution was to add double quotes to %JAVA_HOME%:

set IZPACK_JAVA="%JAVA_HOME%"

I'll check that at work on monday.
Erwan


Le 30/12/2011 11:31, Ben Stover a écrit :
> I have a 64bit Win7 where I installed Java JDK in folder C:\Program Files (x86)\Java
> which is the default folder for 32bit programs in 64bit Win7.
>
> Now I downloaded and extracted squirrel v3.3.0 plain standard and started squirrel-sql.bat as
>
> squirrel-sql.bat --user-settings-dir  D:\database\squirrel\myset
>
> The batch procedure which is provided seems to have a lot of trouble with dealing with JAVA installation folders containing brackets like ( and ).
>
> The mess starts in the first statement when
>
> set IZPACK_JAVA=%JAVA_HOME%
> is evaluated to
> set IZPACK_JAVA=C:\Program Files (x86)\Java\jdk
>
> At first the batch script aborts and tells me
>
> \Java\jdk\v1.6.x\bin\javaw.exe was unexpected at this time.
>
> because set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe" in line 13 is interpreting the closing ")" as close of the if statement.
>
> When I change the statement to
>
> set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe"
>
> (which prevents evaluating the closing ")") then the next abort shows up:
>
> '""C:\Program' is not recognized as an internal or external command,
>
> because of
>
> "%LOCAL_JAVA%" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7
>
> which is evalauted to
>
> ""C:\Program Files (x86)\Java\jdk"" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7
>
> Mind the double quotes and the blank which is now seen as a delimiter token.
>
> ...and so far. I doubt that someone run this script ever on 64bit Win7 with 32bit Java (which is NOT unusual).
>
> Could someone review the script?
>
> Thank you
> Ben
>
>
>

Re: [Squirrel-sql-users] Lot of mess in squirrel-sql.bat when JAVA installed on 64bit Win7 in C:\Program files (x86)\java

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

Hi Ben,

Can you propose changes to the script that allows it to work in your
environment ?

Rob

On Fri, Dec 30, 2011 at 5:31 AM, Ben Stover <bxs...@ya...> wrote:

> I have a 64bit Win7 where I installed Java JDK in folder C:\Program Files
> (x86)\Java
> which is the default folder for 32bit programs in 64bit Win7.
>
> Now I downloaded and extracted squirrel v3.3.0 plain standard and started
> squirrel-sql.bat as
>
> squirrel-sql.bat --user-settings-dir  D:\database\squirrel\myset
>
> The batch procedure which is provided seems to have a lot of trouble with
> dealing with JAVA installation folders containing brackets like ( and ).
>
> The mess starts in the first statement when
>
> set IZPACK_JAVA=%JAVA_HOME%
> is evaluated to
> set IZPACK_JAVA=C:\Program Files (x86)\Java\jdk
>
> At first the batch script aborts and tells me
>
> \Java\jdk\v1.6.x\bin\javaw.exe was unexpected at this time.
>
> because set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe" in line 13 is
> interpreting the closing ")" as close of the if statement.
>
> When I change the statement to
>
> set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe"
>
> (which prevents evaluating the closing ")") then the next abort shows up:
>
> '""C:\Program' is not recognized as an internal or external command,
>
> because of
>
> "%LOCAL_JAVA%" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar"
> JavaVersionChecker 1.6 1.7
>
> which is evalauted to
>
> ""C:\Program Files (x86)\Java\jdk"" -cp
> "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7
>
> Mind the double quotes and the blank which is now seen as a delimiter
> token.
>
> ...and so far. I doubt that someone run this script ever on 64bit Win7
> with 32bit Java (which is NOT unusual).
>
> Could someone review the script?
>
> Thank you
> Ben
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] Lot of mess in squirrel-sql.bat when JAVA installed on 64bit Win7 in C:\Program files (x86)\java

[Ben S. <bxs...@ya...>]

I have a 64bit Win7 where I installed Java JDK in folder C:\Program Files (x86)\Java
which is the default folder for 32bit programs in 64bit Win7.

Now I downloaded and extracted squirrel v3.3.0 plain standard and started squirrel-sql.bat as

squirrel-sql.bat --user-settings-dir  D:\database\squirrel\myset

The batch procedure which is provided seems to have a lot of trouble with dealing with JAVA installation folders containing brackets like ( and ).

The mess starts in the first statement when 

set IZPACK_JAVA=%JAVA_HOME%
is evaluated to
set IZPACK_JAVA=C:\Program Files (x86)\Java\jdk

At first the batch script aborts and tells me 

\Java\jdk\v1.6.x\bin\javaw.exe was unexpected at this time.

because set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe" in line 13 is interpreting the closing ")" as close of the if statement.

When I change the statement to

set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe"

(which prevents evaluating the closing ")") then the next abort shows up:

'""C:\Program' is not recognized as an internal or external command,

because of 

"%LOCAL_JAVA%" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7

which is evalauted to

""C:\Program Files (x86)\Java\jdk"" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7

Mind the double quotes and the blank which is now seen as a delimiter token.

...and so far. I doubt that someone run this script ever on 64bit Win7 with 32bit Java (which is NOT unusual).

Could someone review the script?

Thank you
Ben

Re: [Squirrel-sql-users] Problem in Connecting to DB Using Squirrel

[Stefan W. <ste...@ao...>]

Maybe, you can't reach the local database.

Have you a firewall on your PC

You can try the following MS-Dos command

/telnet localhost 1433/

to check, if you can reach the database on your localhost.

If you wait long enough, did you ever get any error message from SQuirreL?



Stefan

Am 2011-12-26 06:23, schrieb Jayachandran, Vinod:
>
> Hi ,
>
> I have a problem in connecting to MS SQL Server 2008 from windows 7.
> I made sure the Driver for MSSQL Server is active/enabled. Please see 
> screenshot below
>
>
>
> I specified all the necessary details for aliases
>
>
>
> When I try to connect, it simply hangs and I am forced to close it 
> from Task Manager.
>
> Any help is highly appreciated.
>
> Thanks,
>
> VJ
>
>
> ------------------------------------------------------------------------------
> Write once. Port to many.
> Get the SDK and tools to simplify cross-platform app development. Create
> new or port existing apps to sell to consumers worldwide. Explore the
> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
> http://p.sf.net/sfu/intel-appdev
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Dump Entire SQLServer database

[Gabriele B. <br...@ed...>]

Is it possible with Squirrel?

-- 
Gabriele Dr. Brosulo
  Responsabile Web
  EdiSoft Srl

[Squirrel-sql-users] SQuirreL not displaying color

[Conor F. <cf...@de...>]

Hi,

After installing a plugin to solve a different issue, the color highlighting feature of squirrel no longer worked. After searching Google to try and enable color coding, I tried installing the syntax.jar plugin hoping that would let me see color highlighting. When I restart SQuirreL, It looks like its installing updates but when the program starts it still says that it is uninstalled.

Is the reason no color is displayed that I am missing the syntax.jar plugin? If so, is there a reason it does not install correctly?

Thanks for your time

Conor

Re: [Squirrel-sql-users] Run Oracle scripts on Squirrel SQL

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

SQuirreL (just like Oracle's SQL-Plus) needs to know when you have finished
you anonymous procedure.  That is usually done by adding a line at the end
of your procedure with a sinlge slash  (/) character.  For example:

DECLARE
v1  NUMBER(3);

BEGIN
  v1 := 3;
  select 1 from dual
END;
/

Note: you will need to highlight the entire procedure since there are 2 eol
characters between the semi-colon of the number declaration and the BEGIN
keyword.


Rob


On Thu, Dec 22, 2011 at 7:53 AM, Matheus Garcia <
mat...@al...> wrote:

> Hi all,
>
> I'm used to create and run SQL scripts in Microsoft SQL Server with
> Query Analyser tool, something simple just like declaring some
> variables, setting their values and using them on sql queries. Like the
> following example:
>
> DECLARE
>   @foo INTEGER
> SET @foo = 1
> INSERT INTO mytable (foofield) value (@foo)
>
> Although I saw it's possible to do something like that in Oracle PL-SQL,
> I couldn't run any samples I got on internet in SQuirrel SQL. My oracle
> connection is correctly configured, I can run simple sql commands, but
> when I try to somethibng like the  the following code:
>
> DECLARE
> v1  NUMBER(3);
>
> BEGIN
>   v1 := 3;
>   select 1 from dual
> END;
>
> the DECLARE keywork appears in red, and when I try to run I got the
> following error: "java.lang.IllegalArgumentException: No SQL selected
> for execution."
>
> Could any of you please give me some help on doing that? Or running
> scripts these way is not supported on Squirrel?
>
> Best regards,
> Matheus
>
>
>
>
>
> ------------------------------------------------------------------------------
> Write once. Port to many.
> Get the SDK and tools to simplify cross-platform app development. Create
> new or port existing apps to sell to consumers worldwide. Explore the
> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
> http://p.sf.net/sfu/intel-appdev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Run Oracle scripts on Squirrel SQL

[Matheus G. <mat...@al...>]

I think the fact your error message was more clear is because distinct
oracle version or setup, here we use 10.2.0.4.0. Problem really was with
the select, using SELECT INTO worked like a charm!

Special thanks, you saved me a lot of time.

Matheus

Em Qui, 2011-12-22 às 14:47 +0000, Drav Sloan escreveu:

> Matheus Garcia wrote:
> > First of all, forgot to say, but I was using 3.1, now I upgraded to
> > 3.3.0. Running on Linux.
> 
> Well you are now on latest version with 3.3.0 :)
> 
> > I tried
> > SELECT :var FROM dual
> > and squirrel asked me for the value of var, very good, thanks!
> >
> > Then I tried the code:
> > DECLARE
> > v1  NUMBER(3);
> > BEGIN
> > v1 := 3;
> > select v1 from dual
> > END;
> > /
> >
> > After adding the slash in the end, instead of
> > "java.lang.IllegalArgumentException: No SQL selected for execution.",
> > I'm getting the following error:
> >
> > Error: ORA-06550: line 7, column 1:
> > PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> > the following:
> 
> You _may_ need to load the oracle plugin, which again is under
> Plugins -> Summary and is simply called 'oracle' (but as far
> as I know that just enables things like the database output window).
> 
> If I run the statement:
> 
> DECLARE
> v1  NUMBER(3);
> BEGIN
> v1 := 3;
> select v1 from dual
> END;
> /
> 
> I get:
> 
> Error: ORA-06550: line 5, column 2:
> PLS-00428: an INTO clause is expected in this SELECT statement
> 
> SQLState:  65000
> ErrorCode: 6550
> Position: 991
> 
> 
> 
> 
> 
> .. all procedural oracle code uses SELECT INTO. However, if I do:
> 
> DECLARE
> v1  NUMBER(3);
> BEGIN
> select 3 into v1 from dual;
> dbms_output.put_line(v1||chr(13));
> END;
> /
> 
> I get '3' in the oracle output window ('View Oracle Database Output'
> quick icon opens this up)
> 
> Regards
> 
> D.


-- 
Matheus Garcia Barbosa de Figueiredo
Tel.: (31) 2108 - 7018
Analista de Sistemas
Gerência de Desenvolvimento de Sistemas - GDS
Gerência-Geral de Sistemas de Informação - GSI
Assembleia Legislativa de Minas Gerais - ALMG

Re: [Squirrel-sql-users] Run Oracle scripts on Squirrel SQL

[Drav S. <hol...@re...>]

Matheus Garcia wrote:
> First of all, forgot to say, but I was using 3.1, now I upgraded to
> 3.3.0. Running on Linux.

Well you are now on latest version with 3.3.0 :)

> I tried
> SELECT :var FROM dual
> and squirrel asked me for the value of var, very good, thanks!
>
> Then I tried the code:
> DECLARE
> v1  NUMBER(3);
> BEGIN
> v1 := 3;
> select v1 from dual
> END;
> /
>
> After adding the slash in the end, instead of
> "java.lang.IllegalArgumentException: No SQL selected for execution.",
> I'm getting the following error:
>
> Error: ORA-06550: line 7, column 1:
> PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> the following:

You _may_ need to load the oracle plugin, which again is under
Plugins -> Summary and is simply called 'oracle' (but as far
as I know that just enables things like the database output window).

If I run the statement:

DECLARE
v1  NUMBER(3);
BEGIN
v1 := 3;
select v1 from dual
END;
/

I get:

Error: ORA-06550: line 5, column 2:
PLS-00428: an INTO clause is expected in this SELECT statement

SQLState:  65000
ErrorCode: 6550
Position: 991





.. all procedural oracle code uses SELECT INTO. However, if I do:

DECLARE
v1  NUMBER(3);
BEGIN
select 3 into v1 from dual;
dbms_output.put_line(v1||chr(13));
END;
/

I get '3' in the oracle output window ('View Oracle Database Output'
quick icon opens this up)

Regards

D.

Re: [Squirrel-sql-users] Run Oracle scripts on Squirrel SQL

[John H. <jh...@im...>]

On Thu, 22 Dec 2011, Drav Sloan wrote:

> Matheus Garcia wrote:
>> when I try to run I got the
>> following error: "java.lang.IllegalArgumentException: No SQL selected
>> for execution."
>
> Make sure you leave no gaps in your SQL

or make sure you select (highlight) the entire block you want executed 
before hitting Run.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   "Bother," said Pooh as he struggled with /etc/sendmail.cf, "it never
   does quite what I want. I wish Christopher Robin was here."
                                            -- Peter da Silva in a.s.r
-----------------------------------------------------------------------
  3 days until Christmas

Re: [Squirrel-sql-users] Run Oracle scripts on Squirrel SQL

[Matheus G. <mat...@al...>]

Thanks for replying, Drav.

First of all, forgot to say, but I was using 3.1, now I upgraded to
3.3.0. Running on Linux.

I tried
SELECT :var FROM dual
and squirrel asked me for the value of var, very good, thanks!

Then I tried the code:
DECLARE
v1  NUMBER(3);
BEGIN
v1 := 3;
select v1 from dual
END;
/

After adding the slash in the end, instead of
"java.lang.IllegalArgumentException: No SQL selected for execution.",
I'm getting the following error:

Error: ORA-06550: line 7, column 1:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of
the following:

   begin case declare end exception exit for goto if loop mod
   null pragma raise return select update while with
   <an identifier> <a double-quoted delimited-identifier>
   <a bind variable> << close current delete fetch lock insert
   open rollback savepoint set sql execute commit forall merge
   pipe

SQLState:  65000
ErrorCode: 6550

Searching on internet for error PLS-00103 lead me to the following
question in stack overflow:
http://stackoverflow.com/questions/2289723/statement-execute-returns-error-with-slash-at-the-end-of-pl-sql

Where I can extract from the answers and comments:

"As the message indicates, the compiler doesn't want to encounter the
symbol "/", so just remove it. That simple. Let me explain. When using
sqlplus or an SQL worksheet in sqldev, you do well appending your PL/SQL
blocks with the slash. However, when using the procedure editor (native
to sqldev), you'll have to remove it. (...)"

"In SQL Developer you would need to click the "Run Script (F5)" button
to create all of your triggers (not the main "Run Statement" button)"

So, if I understood it correctly, I think squirrel should have another
option to run (oracle) scrips, is it? Or am I missing something?

Matheus

Em Qui, 2011-12-22 às 13:26 +0000, Drav Sloan escreveu:

> Matheus Garcia wrote:
> > Although I saw it's possible to do something like that in Oracle PL-SQL,
> > I couldn't run any samples I got on internet in SQuirrel SQL. My oracle
> > connection is correctly configured, I can run simple sql commands, but
> > when I try to somethibng like the  the following code:
> > 
> > DECLARE
> > v1  NUMBER(3);
> > 
> > BEGIN
> >    v1 := 3;
> >    select 1 from dual
> > END;
> > 
> > the DECLARE keywork appears in red, and when I try to run I got the
> > following error: "java.lang.IllegalArgumentException: No SQL selected
> > for execution."
> 
> Make sure you leave no gaps in your SQL and make sure you follow
> your procedural code with a /
> 
> DECLARE
> v1  NUMBER(3);
> BEGIN
>    v1 := 3;
>    select v1 from dual
> END;
> /
> 
> The above should now run :)
> 
> Also you can do parameters like MSQL:
> 
> First off make sure you have SQL Parametrisation turned on (found
> under Plugins -> Summary (and called sqlparam).
> 
> Then you can do
> 
> SELECT :var FROM dual
> 
> and Squirrel should ask you for the value of :var.
> 
> Regards
> 
> D.


-- 
Matheus Garcia Barbosa de Figueiredo
Tel.: (31) 2108 - 7018
Analista de Sistemas
Gerência de Desenvolvimento de Sistemas - GDS
Gerência-Geral de Sistemas de Informação - GSI
Assembleia Legislativa de Minas Gerais - ALMG

Re: [Squirrel-sql-users] Run Oracle scripts on Squirrel SQL

[Drav S. <hol...@re...>]

Matheus Garcia wrote:
> Although I saw it's possible to do something like that in Oracle PL-SQL,
> I couldn't run any samples I got on internet in SQuirrel SQL. My oracle
> connection is correctly configured, I can run simple sql commands, but
> when I try to somethibng like the  the following code:
> 
> DECLARE
> v1  NUMBER(3);
> 
> BEGIN
>    v1 := 3;
>    select 1 from dual
> END;
> 
> the DECLARE keywork appears in red, and when I try to run I got the
> following error: "java.lang.IllegalArgumentException: No SQL selected
> for execution."

Make sure you leave no gaps in your SQL and make sure you follow
your procedural code with a /

DECLARE
v1  NUMBER(3);
BEGIN
   v1 := 3;
   select v1 from dual
END;
/

The above should now run :)

Also you can do parameters like MSQL:

First off make sure you have SQL Parametrisation turned on (found
under Plugins -> Summary (and called sqlparam).

Then you can do

SELECT :var FROM dual

and Squirrel should ask you for the value of :var.

Regards

D.

[Squirrel-sql-users] Run Oracle scripts on Squirrel SQL

[Matheus G. <mat...@al...>]

Hi all,

I'm used to create and run SQL scripts in Microsoft SQL Server with
Query Analyser tool, something simple just like declaring some
variables, setting their values and using them on sql queries. Like the
following example:

DECLARE
   @foo INTEGER
SET @foo = 1
INSERT INTO mytable (foofield) value (@foo)

Although I saw it's possible to do something like that in Oracle PL-SQL,
I couldn't run any samples I got on internet in SQuirrel SQL. My oracle
connection is correctly configured, I can run simple sql commands, but
when I try to somethibng like the  the following code:

DECLARE
v1  NUMBER(3);

BEGIN
   v1 := 3;
   select 1 from dual
END;

the DECLARE keywork appears in red, and when I try to run I got the
following error: "java.lang.IllegalArgumentException: No SQL selected
for execution."

Could any of you please give me some help on doing that? Or running
scripts these way is not supported on Squirrel? 

Best regards,
Matheus

[Squirrel-sql-users] Connection to Progress database hosted by an ASP

[<GC...@br...>]

Hi, 

Can I use Squirrel SQL to connect to a Progress database that is hosted by 
an application service provider?  If it is possible, what database driver 
should I use? 

Thanks,

Gloria 

Re: [Squirrel-sql-users] login to oracle as sysdba

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

It works fine for me on OS X. I brought up this same issue some months back. I didn't find the the menu on my own, but once Rob pointed me to it then it worked fine. (And it still does. I just checked.)

Perhaps Slavo was right-clicking on the driver instead of on the alias.

-Matt

On 2 Dec 2011, at 11:25, Robert Manning wrote:

> I suspect there is an issue with popup menus on Mac OS X.  I believe I have seen this for myself.  I will check again.
> 
> Rob
> 
> On Fri, Dec 2, 2011 at 12:51 PM, Stefan Willinger <ste...@ao...> wrote:
> Slavo,
> 
> please can you tell us, if you can use the pop-up menu of the result
> table? (Right click on the result table of a query)
> 
> Because, there is the same code to trigger the pop-up menu.
> 
> Thanks.
> 
> Stefan
> 
> Am 2011-11-30 10:37, schrieb Stefan Willinger:
> > Hi,
> >
> > in the past, we had the same issue on Microsoft Windows XP.
> >
> > Maybe, this depends on Mac OS X.
> >
> > This works fine on my Ubuntu and Windows machines.
> >
> > As Rob mentioned, the "workflow" is not much intuitive. So, we may add
> > command buttons for adding and deleting driver properties.
> >
> > Stefan.
> >
> >
> > Am 2011-11-25 15:15, schrieb Slavomir Kocka:
> >> Hi Rob,
> >>
> >> Actually right-click is not allowed on properties table...
> >> That was my initial attempt to add it...
> >>
> >> I used "brute force" to add it by manipulating XML config, but this
> >> could be fixed (if there was right click)
> >>
> >> Just summary:
> >> * property is working with that driver, and it obviously is there
> >> * right click on properties does not work... at least, in place, where
> >> I was looking for
> >> * Used Sqirrel SQL 3.2.2 and now 3.3 issue is still there...
> >> * I'm using Mac OS X, however I don't think, it is platform dependend.
> >> And, I've enabled right click on my mouse ;-)
> >>
> >> Thank you.
> >>
> >> Squirrel is my favorite sql client for many years. :)
> >>
> >> Slavo
> >>
> >>
> >> On Fri, Nov 25, 2011 at 2:44 PM, Robert Manning
> >> <rob...@gm...>   wrote:
> >>> It's not super-intuitive, however you can right-click on the properties
> >>> table to access a popup menu that will allow you to add the property.
> >>>
> >>> Rob
> >>>
> >>> On Fri, Nov 25, 2011 at 3:42 AM, Slavomir Kocka<sla...@gm...>
> >>> wrote:
> >>>> Hi,
> >>>>
> >>>> Could you help me to log into Oracle as Sysdba?
> >>>>
> >>>> I found Rob's answer to set driver property "internal_logon" to "sysdba".
> >>>>
> >>>> My issue is, that there actually is not this property.
> >>>> Only property I see is: "remarksReporting"
> >>>>
> >>>> I use driver Ojdbc6 11.2
> >>>> and driver class is oracle.jdbc.driver.OracleDriver
> >>>>
> >>>> Any ideas?
> >>>>
> >>>> Thanks.
> >>>>
> >>>> Slavo
> >>>>
> >>>>
> >>>> ------------------------------------------------------------------------------
> >>>> All the data continuously generated in your IT infrastructure
> >>>> contains a definitive record of customers, application performance,
> >>>> security threats, fraudulent activity, and more. Splunk takes this
> >>>> data and makes sense of it. IT sense. And common sense.
> >>>> http://p.sf.net/sfu/splunk-novd2d
> >>>> _______________________________________________
> >>>> Squirrel-sql-users mailing list
> >>>> Squ...@li...
> >>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >> ------------------------------------------------------------------------------
> >> All the data continuously generated in your IT infrastructure
> >> contains a definitive record of customers, application performance,
> >> security threats, fraudulent activity, and more. Splunk takes this
> >> data and makes sense of it. IT sense. And common sense.
> >> http://p.sf.net/sfu/splunk-novd2d
> >> _______________________________________________
> >> Squirrel-sql-users mailing list
> >> Squ...@li...
> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >>
> > ------------------------------------------------------------------------------
> > All the data continuously generated in your IT infrastructure
> > contains a definitive record of customers, application performance,
> > security threats, fraudulent activity, and more. Splunk takes this
> > data and makes sense of it. IT sense. And common sense.
> > http://p.sf.net/sfu/splunk-novd2d
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
> 
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure 
> contains a definitive record of customers, application performance, 
> security threats, fraudulent activity, and more. Splunk takes this 
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d_______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Error in 'create table' script

[Fabiano PS B. <fa...@pe...>]

Do you have enought control over the DDL generation process to
'bypass' unkown mappings? Or it is entirelly processed by hibernate?

Ex:
I think it would be better to have a script with invalid colums types
wich we could finish manually than to have nothing.

create table test (
  id NUMERIC(15,4) /*unable to map - using original mapping*/,
  ...

I will fill the feature request as you suggested.

Regards,

Fabiano

On Tue, Dec 6, 2011 at 9:26 AM, Robert Manning
<rob...@gm...> wrote:
> At the moment there is no quick work-around for this.  It's questionable how
> helpful this would be given that the JDBC-ODBC bridge is considered
> "experimental" and "unsupported".  In other words, this driver could very
> well be giving nonsense values for field types, lengths, precision, scale,
> null-ability, etc.  In any case, you can submit a feature request here, and
> I will look into beefing up the generic dialect (which is used when no other
> dialect is appropriate):
>
> http://sourceforge.net/tracker/?atid=393417&group_id=28383
>
> Rob
>
>
> On Tue, Dec 6, 2011 at 5:02 AM, Fabiano PS Bonin
> <fa...@pe...> wrote:
>>
>> Hi all!
>>
>> I´m using Squirrel to connect to a legacy DBASE IV database using
>> "JDBC ODBC Bridge", provided with Squirrel.
>>
>> My plan is to get the DDL (create table) of the tables in the legacy
>> database and recreate them in my own database (Firebird), and later
>> have an ETL tool populating these tables with fresh data.
>>
>> When i try to get the create table script, i get this error:
>>
>> JDBC-ODBC Bridge doesn't provide all of the necessary metadata. The
>> script may be incomplete.
>> org.hibernate.MappingException: No Dialect mapping for JDBC type: 8
>>
>> The problem is happening with 'numeric' colums (at least).
>>
>> So my questions are:
>>
>> * Can i override this mapping somehow?
>> * Is there some fast workaround available?
>> * If changing hibernate dialect works, where should i put the
>> hibernate.cfg.xml file so Squirrel loads it, and which dialect should
>> i use to be able to have this mapping working?
>>
>> Regards,
>>
>> Fabiano
>>
>>
>> ------------------------------------------------------------------------------
>> Cloud Services Checklist: Pricing and Packaging Optimization
>> This white paper is intended to serve as a reference, checklist and point
>> of
>> discussion for anyone considering optimizing the pricing and packaging
>> model
>> of a cloud services business. Read Now!
>> http://www.accelacomm.com/jaw/sfnl/114/51491232/
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

Re: [Squirrel-sql-users] Error in 'create table' script

[Fabiano PS B. <fa...@pe...>]

Wow!

A JDBC driver for DBASE! Amazing!

I downloaded, registered in Squirrel, etc..., and i can browse the
DBASE database using it.

Now the column which was NUMERIC (type 8) with JDBC-ODBC bridge is
INTEGER (type 4), and it is working.

BUT when i try to generate the 'create table' script, i get this error:

Driver class jstels.jdbc.dbf.DBFDriver2 successfully registered for
driver definition: DBASE
org.hibernate.MappingException: No Dialect mapping for JDBC type: 8

Type 8 is now associated with a column of DOUBLE type name.

Regards,

Fabiano

On Tue, Dec 6, 2011 at 9:39 AM, Andreas Oswald <cpt...@gm...> wrote:
> Hi Fabiano,
>
> perhaps you should try to use a "real" JDBC driver for dbase? You
> probably will have better chances for metadata retrieval with a real
> JDBC driver.
>
> You can download one free for trial at
> http://software.filestube.com/download,e13cb438,StelsDBF+JDBC+Driver.html I
> haven't found an open source driver yet but I shall keep my eyes open.
>
> Andreas
>
>
> Am 06.12.2011 11:02, schrieb Fabiano PS Bonin:
>> Hi all!
>>
>> I´m using Squirrel to connect to a legacy DBASE IV database using
>> "JDBC ODBC Bridge", provided with Squirrel.
>>
>> My plan is to get the DDL (create table) of the tables in the legacy
>> database and recreate them in my own database (Firebird), and later
>> have an ETL tool populating these tables with fresh data.
>>
>> When i try to get the create table script, i get this error:
>>
>> JDBC-ODBC Bridge doesn't provide all of the necessary metadata. The
>> script may be incomplete.
>> org.hibernate.MappingException: No Dialect mapping for JDBC type: 8
>>
>> The problem is happening with 'numeric' colums (at least).
>>
>> So my questions are:
>>
>> * Can i override this mapping somehow?
>> * Is there some fast workaround available?
>> * If changing hibernate dialect works, where should i put the
>> hibernate.cfg.xml file so Squirrel loads it, and which dialect should
>> i use to be able to have this mapping working?
>>
>> Regards,
>>
>> Fabiano
>>
>> ------------------------------------------------------------------------------
>> Cloud Services Checklist: Pricing and Packaging Optimization
>> This white paper is intended to serve as a reference, checklist and point of
>> discussion for anyone considering optimizing the pricing and packaging model
>> of a cloud services business. Read Now!
>> http://www.accelacomm.com/jaw/sfnl/114/51491232/
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
>
> ------------------------------------------------------------------------------
> Cloud Services Checklist: Pricing and Packaging Optimization
> This white paper is intended to serve as a reference, checklist and point of
> discussion for anyone considering optimizing the pricing and packaging model
> of a cloud services business. Read Now!
> http://www.accelacomm.com/jaw/sfnl/114/51491232/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Error in 'create table' script

[Andreas O. <cpt...@gm...>]

Hi Fabiano,

perhaps you should try to use a "real" JDBC driver for dbase? You 
probably will have better chances for metadata retrieval with a real 
JDBC driver.

You can download one free for trial at 
http://software.filestube.com/download,e13cb438,StelsDBF+JDBC+Driver.html I 
haven't found an open source driver yet but I shall keep my eyes open.

Andreas


Am 06.12.2011 11:02, schrieb Fabiano PS Bonin:
> Hi all!
>
> I´m using Squirrel to connect to a legacy DBASE IV database using
> "JDBC ODBC Bridge", provided with Squirrel.
>
> My plan is to get the DDL (create table) of the tables in the legacy
> database and recreate them in my own database (Firebird), and later
> have an ETL tool populating these tables with fresh data.
>
> When i try to get the create table script, i get this error:
>
> JDBC-ODBC Bridge doesn't provide all of the necessary metadata. The
> script may be incomplete.
> org.hibernate.MappingException: No Dialect mapping for JDBC type: 8
>
> The problem is happening with 'numeric' colums (at least).
>
> So my questions are:
>
> * Can i override this mapping somehow?
> * Is there some fast workaround available?
> * If changing hibernate dialect works, where should i put the
> hibernate.cfg.xml file so Squirrel loads it, and which dialect should
> i use to be able to have this mapping working?
>
> Regards,
>
> Fabiano
>
> ------------------------------------------------------------------------------
> Cloud Services Checklist: Pricing and Packaging Optimization
> This white paper is intended to serve as a reference, checklist and point of
> discussion for anyone considering optimizing the pricing and packaging model
> of a cloud services business. Read Now!
> http://www.accelacomm.com/jaw/sfnl/114/51491232/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Error in 'create table' script

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

At the moment there is no quick work-around for this.  It's questionable
how helpful this would be given that the JDBC-ODBC bridge is considered
"experimental" and "unsupported".  In other words, this driver could very
well be giving nonsense values for field types, lengths, precision, scale,
null-ability, etc.  In any case, you can submit a feature request here, and
I will look into beefing up the generic dialect (which is used when no
other dialect is appropriate):

http://sourceforge.net/tracker/?atid=393417&group_id=28383

Rob


On Tue, Dec 6, 2011 at 5:02 AM, Fabiano PS Bonin <
fa...@pe...> wrote:

> Hi all!
>
> I´m using Squirrel to connect to a legacy DBASE IV database using
> "JDBC ODBC Bridge", provided with Squirrel.
>
> My plan is to get the DDL (create table) of the tables in the legacy
> database and recreate them in my own database (Firebird), and later
> have an ETL tool populating these tables with fresh data.
>
> When i try to get the create table script, i get this error:
>
> JDBC-ODBC Bridge doesn't provide all of the necessary metadata. The
> script may be incomplete.
> org.hibernate.MappingException: No Dialect mapping for JDBC type: 8
>
> The problem is happening with 'numeric' colums (at least).
>
> So my questions are:
>
> * Can i override this mapping somehow?
> * Is there some fast workaround available?
> * If changing hibernate dialect works, where should i put the
> hibernate.cfg.xml file so Squirrel loads it, and which dialect should
> i use to be able to have this mapping working?
>
> Regards,
>
> Fabiano
>
>
> ------------------------------------------------------------------------------
> Cloud Services Checklist: Pricing and Packaging Optimization
> This white paper is intended to serve as a reference, checklist and point
> of
> discussion for anyone considering optimizing the pricing and packaging
> model
> of a cloud services business. Read Now!
> http://www.accelacomm.com/jaw/sfnl/114/51491232/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>