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

Re: [Squirrel-sql-users] Informix: unable to create any stored procedures or functions

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

Up to now SQuirrel always removed line comments "--..." and removed 
multi line comments "/*...*/" by default. The default could be changed 
at menu File --> New Session Properties --> tab SQL --> checkbox "Remove 
multi line comment (/*...*/) from SQL before sending to database".

I just added the same option for line comments, too. Excerpt from our 
change log:
New Session properties and database specific Query tokenizers now have 
an option to keep SQuirreL from removing line comments "--..." before 
sending SQLs to database.
See menu File --> New Session Properties --> tab SQL --> checkbox 
"Remove line comment (--...) from SQL before sending to database"

I just released a new snapshot with the feature:
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210604_1443/

It would be nice if you could give it a try.

Gerd



Am 04.06.21 um 01:01 schrieb info:
> Comments in Informix stored procedures are lost if not surrounded with 
> curly braces.
> This created through Squirrel results in the comment lines 1 and 3 lost. 
> dbaccess creates all 3 of them.
> 
> create procedure tttt();
> -- comment1
> {comment2
> comment2}
> /*comment3
> comment3*/
> end procedure;
> 
> Thank you,
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Informix: unable to create any stored procedures or functions

[info <in...@dr...>]

Comments in Informix stored procedures are lost if not surrounded with 
curly braces.
This created through Squirrel results in the comment lines 1 and 3 lost. 
dbaccess creates all 3 of them.

create procedure tttt();
-- comment1
{comment2
comment2}
/*comment3
comment3*/
end procedure;

Thank you,

Re: [Squirrel-sql-users] Informix: unable to create any stored procedures or functions

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

Please go to menu File --> New Session Properties --> tab SQL --> 
Statement Separator.

If the statement separator is ; change it to something else.

Gerd

Am 02.06.21 um 16:30 schrieb info:
> Hello all:
> 
> The following code works fine in Informix 14.10 dbaccess:
> 
> create table aat (id serial, b lvarchar(1024));
> 
> create procedure aap (v_b like aat.b) -- tried int, integer
>      insert into aat(b) values(v_b);
> end procedure;
> 
> But when I try to execute it from Squirrel 4.1.0 (each statement 
> separately) it always gives me a syntax error for the parameter data 
> type of the 2nd statement:
> 
> Error: A syntax error has occurred. SQLState:  42000 ErrorCode: -201 
> Position: 30 Error occurred in: create procedure use0.aap(in v_id int) 
> returning lvarchar(1024)
> 
> The position changes but the error is always the same and it points at 
> the parameter declaration.
> 
> Do I have to change any settings in the driver/alias? I am using 
> jdbc-4.10.12.jar.
> 
> Thank you!
> 
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Now Interbase, was Re: Informix: unable to create any stored procedures or functions

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

Please go to menu File --> New Session Properties --> tab SQL --> 
Statement Separator.

If the statement separator is ; change it to something else.

Gerd

Am 02.06.21 um 23:19 schrieb info:
> Same problem with Interbase. No stored procedure can be created through 
> Squirrel!
> With this script, the procedure should be created successfully but it 
> errors out:
> 
> --drop table tt
> create table tt(id int not null, a varchar(10), b timestamp)
> alter table tt add constraint pk_tt primary key (id)
> 
> create procedure tt_ins(AA varchar(10))
> as
> BEGIN
>      INSERT INTO tt (ID, a, b) VALUES (GEN_ID(G_TT, 1), :AA, 
> CURRENT_TIMESTAMP);
> END;
> 
> /*
> Error: [interclient][interbase]Dynamic SQL Error
> [interclient][interbase]SQL error code = -104
> [interclient][interbase]Unexpected end of command
> SQLState:  ICI00
> ErrorCode: 335544569
> Error occurred in:
> create procedure tt_ins(AA varchar(10))
> as
> BEGIN
>      INSERT INTO tt (ID, a, b) VALUES (GEN_ID(G_TT, 1), :AA, 
> CURRENT_TIMESTAMP)
> */
> 
> Then I take this body and paste it into IBConsole. It creates the SP 
> successfully. Then I take the SP body from the Metadata tab of the 
> properties in IBConsole and paste it back into Squirrel:
> 
> CREATE PROCEDURE TT_INS
> (
>    AA VARCHAR(10)
> )
> AS
> BEGIN EXIT; END ;
> /*
> Error: [interclient][interbase]Dynamic SQL Error
> [interclient][interbase]SQL error code = -104
> [interclient][interbase]Unexpected end of command
> SQLState:  ICI00
> ErrorCode: 335544569
> Error occurred in:
> CREATE PROCEDURE TT_INS
> (
>    AA VARCHAR(10)
> )
> AS
> BEGIN EXIT
> */
> 
> ALTER PROCEDURE TT_INS
> (
>    AA VARCHAR(10)
> )
> AS
> BEGIN
>      INSERT INTO tt (ID, a, b) VALUES (GEN_ID(G_TT, 1), :AA, 
> CURRENT_TIMESTAMP);
> END;
> 
> I did not try to execute the ALTER part because even the CREATE failed.
> This is occurring with Interbase.Interclient.jar that came with 
> Interbase dev edition 2020.
> 
> Thank you!
> 
> 
> On 2021-06-02 10:30 AM, info wrote:
>> Hello all:
>>
>> The following code works fine in Informix 14.10 dbaccess:
>>
>> create table aat (id serial, b lvarchar(1024));
>>
>> create procedure aap (v_b like aat.b) -- tried int, integer
>>     insert into aat(b) values(v_b);
>> end procedure;
>>
>> But when I try to execute it from Squirrel 4.1.0 (each statement 
>> separately) it always gives me a syntax error for the parameter data 
>> type of the 2nd statement:
>>
>> Error: A syntax error has occurred. SQLState:  42000 ErrorCode: -201 
>> Position: 30 Error occurred in: create procedure use0.aap(in v_id int) 
>> returning lvarchar(1024)
>>
>> The position changes but the error is always the same and it points at 
>> the parameter declaration.
>>
>> Do I have to change any settings in the driver/alias? I am using 
>> jdbc-4.10.12.jar.
>>
>> Thank you!
>>
> 
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Now Interbase, was Re: Informix: unable to create any stored procedures or functions

[info <in...@dr...>]

Same problem with Interbase. No stored procedure can be created through 
Squirrel!
With this script, the procedure should be created successfully but it 
errors out:

--drop table tt
create table tt(id int not null, a varchar(10), b timestamp)
alter table tt add constraint pk_tt primary key (id)

create procedure tt_ins(AA varchar(10))
as
BEGIN
     INSERT INTO tt (ID, a, b) VALUES (GEN_ID(G_TT, 1), :AA, 
CURRENT_TIMESTAMP);
END;

/*
Error: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -104
[interclient][interbase]Unexpected end of command
SQLState:  ICI00
ErrorCode: 335544569
Error occurred in:
create procedure tt_ins(AA varchar(10))
as
BEGIN
     INSERT INTO tt (ID, a, b) VALUES (GEN_ID(G_TT, 1), :AA, 
CURRENT_TIMESTAMP)
*/

Then I take this body and paste it into IBConsole. It creates the SP 
successfully. Then I take the SP body from the Metadata tab of the 
properties in IBConsole and paste it back into Squirrel:

CREATE PROCEDURE TT_INS
(
   AA VARCHAR(10)
)
AS
BEGIN EXIT; END ;
/*
Error: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -104
[interclient][interbase]Unexpected end of command
SQLState:  ICI00
ErrorCode: 335544569
Error occurred in:
CREATE PROCEDURE TT_INS
(
   AA VARCHAR(10)
)
AS
BEGIN EXIT
*/

ALTER PROCEDURE TT_INS
(
   AA VARCHAR(10)
)
AS
BEGIN
     INSERT INTO tt (ID, a, b) VALUES (GEN_ID(G_TT, 1), :AA, 
CURRENT_TIMESTAMP);
END;

I did not try to execute the ALTER part because even the CREATE failed.
This is occurring with Interbase.Interclient.jar that came with 
Interbase dev edition 2020.

Thank you!


On 2021-06-02 10:30 AM, info wrote:
> Hello all:
>
> The following code works fine in Informix 14.10 dbaccess:
>
> create table aat (id serial, b lvarchar(1024));
>
> create procedure aap (v_b like aat.b) -- tried int, integer
>     insert into aat(b) values(v_b);
> end procedure;
>
> But when I try to execute it from Squirrel 4.1.0 (each statement 
> separately) it always gives me a syntax error for the parameter data 
> type of the 2nd statement:
>
> Error: A syntax error has occurred. SQLState:  42000 ErrorCode: -201 
> Position: 30 Error occurred in: create procedure use0.aap(in v_id int) 
> returning lvarchar(1024)
>
> The position changes but the error is always the same and it points at 
> the parameter declaration.
>
> Do I have to change any settings in the driver/alias? I am using 
> jdbc-4.10.12.jar.
>
> Thank you!
>

[Squirrel-sql-users] Informix: unable to create any stored procedures or functions

[info <in...@dr...>]

Hello all:

The following code works fine in Informix 14.10 dbaccess:

create table aat (id serial, b lvarchar(1024));

create procedure aap (v_b like aat.b) -- tried int, integer
     insert into aat(b) values(v_b);
end procedure;

But when I try to execute it from Squirrel 4.1.0 (each statement 
separately) it always gives me a syntax error for the parameter data 
type of the 2nd statement:

Error: A syntax error has occurred. SQLState:  42000 ErrorCode: -201 
Position: 30 Error occurred in: create procedure use0.aap(in v_id int) 
returning lvarchar(1024)

The position changes but the error is always the same and it points at 
the parameter declaration.

Do I have to change any settings in the driver/alias? I am using 
jdbc-4.10.12.jar.

Thank you!

Re: [Squirrel-sql-users] Mariadb not handling 'create table' script correctly

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

Thanks for your quick feedback.
Gerd

Am 24.05.21 um 22:40 schrieb Roger Hill:
> Hi Gerd.
> 
> I tested it just now. It is now correct.
> 
> Many thanks
> Roger
> 
> ---
> ***************************
> Roger Hill
> ***************************
> 
> On 2021-05-24 16:25, Gerd Wagner wrote:
>> Am 20.05.21 um 11:20 schrieb Roger Hill:
>>> Hi.
>>>
>>> Using Squirrel 4.2 (same issue with 4.1).
>>>
>>> If I have a table in Mariadb that has a decimal column, say 
>>> 'dollarvalue decimal(15,2)', when I generate a 'create table' script, 
>>> Squirrel is generating the column as 'dollarvalue decimal not null', 
>>> i.e is dropping the (15,2).
>>
>> Is fixed in our Git repository and available in this snapshot
>> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210524_2220/ 
>>
>>
>> Gerd
>>
>>>
>>>
>>> Both DBeaver and DbVis generate the script correctly, and if i look 
>>> at the 'Columns' tab in Squirrel when the table is highlighted in the 
>>> Object list, it shows correctly.
>>>
>>>
>>> So the detailed definition is being lost somewhere in the script 
>>> generation, as far as I can see.
>>>
>>>
>>> Or is it me, doing something stupid?
>>>
>>>
>>> Cheers, thanks for a great tool.
>>>
>>> Roger

[Squirrel-sql-users] Fwd: Mariadb not handling 'create table' script correctly

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

Am 20.05.21 um 11:20 schrieb Roger Hill:
> Hi.
> 
> Using Squirrel 4.2 (same issue with 4.1).
> 
> If I have a table in Mariadb that has a decimal column, say  
> 'dollarvalue decimal(15,2)', when I generate a 'create table' script, 
> Squirrel is generating the column as 'dollarvalue decimal not null', i.e 
> is dropping the (15,2).

Is fixed in our Git repository and available in this snapshot
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210524_2220/

Gerd

> 
> 
> Both DBeaver and DbVis generate the script correctly, and if i look at 
> the 'Columns' tab in Squirrel when the table is highlighted in the 
> Object list, it shows correctly.
> 
> 
> So the detailed definition is being lost somewhere in the script 
> generation, as far as I can see.
> 
> 
> Or is it me, doing something stupid?
> 
> 
> Cheers, thanks for a great tool.
> 
> Roger

Re: [Squirrel-sql-users] Snowflake (cloud platform) support

[Tom V. <tom...@gm...>]

**update to below issue
It seems that the problem can be fixed by adding an ALTER SESSION command
in the Keep-alive section like so:

--
https://docs.snowflake.com/en/sql-reference/parameters.html#client-metadata-request-use-connection-ctx
alter session set CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX = true;

(thanks to this article
https://community.snowflake.com/s/article/Improve-Performance-of-JDBC-Metadata-Operations
)

cheers
Tom

Op vr 21 mei 2021 om 00:49 schreef Tom Verweij <tom...@gm...>:

> Hi squirrel users!
>
> I'm trying to get my 4.2 squirrel to behave with the Snowflake cloud
> platform.
> I'm using their jdbc driver (
> https://docs.snowflake.com/en/user-guide/jdbc-download.html#downloading-the-driver
> ).
> The driver configures OK and I can connect to a clients db authenticating
> via the browserbased SSO option (as described in their docs)
>
> However it looks like the metadata (particularly schemas) doesn't load
> correctly.
> The symptom is that I see all schemas of all databases as children under
> each database.
> e.g.
> db1
> \ba
> \ba
> db2
> \ba
> \ba
>
> where it should be
> db1
> \ba
> db2
> \ba
>
> this issue is replicated into tables etc..
>
> Also, when trying to write some SQL squirrel pretty quickly hangs a long
> time. It seems to me this is related to the object cache not being build
> correctly from the metadata.
>
> Has anyone been able to correctly connect to a snowflake instance with
> multiple databases/schemas displaying ok?
> Happy to provide more info.
>
> regards
> Tom
>

[Squirrel-sql-users] Snowflake (cloud platform) support

[Tom V. <tom...@gm...>]

Hi squirrel users!

I'm trying to get my 4.2 squirrel to behave with the Snowflake cloud
platform.
I'm using their jdbc driver (
https://docs.snowflake.com/en/user-guide/jdbc-download.html#downloading-the-driver
).
The driver configures OK and I can connect to a clients db authenticating
via the browserbased SSO option (as described in their docs)

However it looks like the metadata (particularly schemas) doesn't load
correctly.
The symptom is that I see all schemas of all databases as children under
each database.
e.g.
db1
\ba
\ba
db2
\ba
\ba

where it should be
db1
\ba
db2
\ba

this issue is replicated into tables etc..

Also, when trying to write some SQL squirrel pretty quickly hangs a long
time. It seems to me this is related to the object cache not being build
correctly from the metadata.

Has anyone been able to correctly connect to a snowflake instance with
multiple databases/schemas displaying ok?
Happy to provide more info.

regards
Tom

[Squirrel-sql-users] Mariadb not handling 'create table' script correctly

[Roger H. <rh...@hi...>]

Hi.

Using Squirrel 4.2 (same issue with 4.1).

If I have a table in Mariadb that has a decimal column, say  
'dollarvalue decimal(15,2)', when I generate a 'create table' script, 
Squirrel is generating the column as 'dollarvalue decimal not null', i.e 
is dropping the (15,2).

Both DBeaver and DbVis generate the script correctly, and if i look at 
the 'Columns' tab in Squirrel when the table is highlighted in the 
Object list, it shows correctly.

So the detailed definition is being lost somewhere in the script 
generation, as far as I can see.

Or is it me, doing something stupid?

Cheers, thanks for a great tool.

Roger

Re: [Squirrel-sql-users] Query results seen as <Other>

[Fernando B. L. <fba...@so...>]

Thanks, that worked!


Best,

Fernando


El 13/5/21 a las 3:21, Gerd Wagner escribió:
>
>
> Am 11.05.21 um 19:04 schrieb Fernando Barreiro Lostres:
>> Hi all,
>>
>> When querying in Squirrel and retrieving fields with INET datatype,
>> results always return the value '<Other>' instead of the numeric IP.
>>
>> Why this behavior? Could I configure it to get the numeric IP?
>
> You may try the following: Go to menu File --> Global Preferences -->
> tab "Data Type Controls" and check the check boxes for types "SQL
> Other" and "Unknown Data Types".
>
>>
>>
>> Thanks in advance and for that great software!
>>
> Thank you.
>
> Gerd

Fernando Barreiro
Software developer
www.sonoc.io
This e-mail is for the exclusive use of its recipients and may contain business secrets or other confidential or privileged information. Any unauthorised use, copying, publication or distribution of this e-mail is strictly prohibited. If you are not the intended recipient, please inform us immediately by replying to this e-mail and delete it, including any attachments or copies on your system.
​
In accordance with the GDPR (EU) 2016/679 and the LOPDGDD 3/2018, we inform you that this e-mail address and/or any other personal data you have provided us with will be treated by SONOC with absolute confidentiality and with the only purpose of providing you with the requested services, due to your condition as a client, supplier or because you have requested information from us at any time. These data will only be kept for as long as required to comply with legal obligations. You can exercise your rights at any time by sending an e-mail to: dat...@so....

Re: [Squirrel-sql-users] Query results seen as <Other>

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

Am 11.05.21 um 19:04 schrieb Fernando Barreiro Lostres:
> Hi all,
> 
> When querying in Squirrel and retrieving fields with INET datatype, 
> results always return the value '<Other>' instead of the numeric IP.
> 
> Why this behavior? Could I configure it to get the numeric IP?

You may try the following: Go to menu File --> Global Preferences --> 
tab "Data Type Controls" and check the check boxes for types "SQL Other" 
and "Unknown Data Types".

> 
> 
> Thanks in advance and for that great software!
> 
Thank you.

Gerd

[Squirrel-sql-users] Query results seen as <Other>

[Fernando B. L. <fba...@so...>]

Hi all,

When querying in Squirrel and retrieving fields with INET datatype,
results always return the value '<Other>' instead of the numeric IP.

Why this behavior? Could I configure it to get the numeric IP?


Thanks in advance and for that great software!

Fernando


Fernando Barreiro
Software developer
www.sonoc.io
This e-mail is for the exclusive use of its recipients and may contain business secrets or other confidential or privileged information. Any unauthorised use, copying, publication or distribution of this e-mail is strictly prohibited. If you are not the intended recipient, please inform us immediately by replying to this e-mail and delete it, including any attachments or copies on your system.
​
In accordance with the GDPR (EU) 2016/679 and the LOPDGDD 3/2018, we inform you that this e-mail address and/or any other personal data you have provided us with will be treated by SONOC with absolute confidentiality and with the only purpose of providing you with the requested services, due to your condition as a client, supplier or because you have requested information from us at any time. These data will only be kept for as long as required to comply with legal obligations. You can exercise your rights at any time by sending an e-mail to: dat...@so....

Re: [Squirrel-sql-users] Sql2ins

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

Oh, sorry, I misunderstood you.

No, 4.2 does not contain the changes of snapshot-20210424_0200.

To give some details:
Version 4.2 was released on April the 5th of 2021.
snapshot-20210424_0200 was released on April the 24th of 2021.
As I do not merge changes back into existing releases the changes of the 
snapshot are not in version 4.2.

Gerd


2021-04-05

Am 29.04.21 um 20:25 schrieb Massimo Re:
> Gerd, i try to explain better my question ...
> 
> If i download the "official" 4.2 (last) version from
> 
> http://squirrel-sql.sourceforge.net/ <http://squirrel-sql.sourceforge.net/>
> 
> does it contain the new feature available in the snapshot you linked me 
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/ 
> <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/>  
>   or not ?
> 
> Thank a lot
> 
> Max
> 
> 
> Il giorno dom 25 apr 2021 alle ore 10:51 Gerd Wagner 
> <ger...@t-... <mailto:ger...@t-...>> ha scritto:
> 
> 
> 
>     Am 24.04.21 um 10:39 schrieb Massimo Re:
>      > Thanks Gerd !
>      >
>      > One more question ...
>      >
>      > The snapshot
>      >
>      >
>     https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
>     <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/>
> 
>      >
>     <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
>     <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/>>
>      >
>      > Is following the official version 4.2 correct ?
>     No it is not. I don't see this version anywhere, when I install the
>     snapshot.
>     Did you try to do a fresh install into an empty directory?
> 
>     Gerd
> 
> 
>      >
>      > Max
>      >
>      >
>      > Il giorno sab 24 apr 2021 alle ore 02:34 Gerd Wagner
>      > <ger...@t-... <mailto:ger...@t-...>
>     <mailto:ger...@t-... <mailto:ger...@t-...>>>
>     ha scritto:
>      >
>      >     Sorry, the snapshot link below was wrong. Here's the right one:
>      >
>     https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
>     <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/>
>      >   
>       <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/ <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/>>
>      >
>      >
>      >     Am 24.04.21 um 02:29 schrieb Gerd Wagner:
>      >      > Max,
>      >      >
>      >      > thank you for your kind words and for using SQuirreL.
>      >      >
>      >      > Your feature request is implemented in snapshot
>     20210424_0200, see
>      >      >
>      >
>     https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/
>     <https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/>
>      >   
>       <https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/ <https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/>>
>      >
>      >      >
>      >      >
>      >      > Excerpt from change log:
>      >      > SQL Scripts Plugin: Create Data (INSERT) file from SQL.
>      >      >   Creates INSERT statements of an SQL result in a file.
>      >      >   Available in SQL editor's right mouse menu and tools popup
>      >     (ctrl+T).
>      >      >
>      >      >
>      >      > Please be aware:
>      >      > The snapshot comes with a replacement of SQuirreL's former XML
>      >     library
>      >      > nanoxml. Almost all of SQuirreL's configuration files are
>      >     concerned by
>      >      > this. You should back up your SQuirreL user directory before
>      >     installing
>      >      > this snapshot. For more information see our change log
>      >      > and/or the Readme of the snapshot.
>      >      >
>      >      > Gerd
>      >      >
>      >      >
>      >      > Am 10.04.21 um 18:26 schrieb Massimo Re:
>      >      >> Hi guys !
>      >      >>
>      >      >> I'm using Squirrel from long time and I'm very happy to work
>      >     with it.
>      >      >>
>      >      >> So first of all, i want to congratulate with all teams
>     members,
>      >     it's
>      >      >> excellent and work fine.
>      >      >>
>      >      >> I want to ask to add a new little feature or improvement.
>      >      >>
>      >      >> With Alt+T, i often use Sql2ins to have a script with an
>     INSERT
>      >     INTO
>      >      >> statement for each record in the table.
>      >      >>
>      >      >> If the table contains a lot of records, i got the
>     error message
>      >     Java
>      >      >> heap space (query results is over the maximum memory
>     available.)
>      >      >>
>      >      >> Is possibile add a new option Sql2insfile that create a
>     new .sql
>      >     file
>      >      >> containing all INSERT INTO statements for every records
>     in the
>      >     table ?
>      >      >> This new option can resolve the problem above ...
>      >      >>
>      >      >> Is possibile to develop it ?
>      >      >>
>      >      >> Thank you
>      >      >>
>      >      >> Max
>      >      >>
>      >      >>
>      >      >>
>      >      >> _______________________________________________
>      >      >> Squirrel-sql-users mailing list
>      >      >> Squ...@li...
>     <mailto:Squ...@li...>
>      >     <mailto:Squ...@li...
>     <mailto:Squ...@li...>>
>      >      >>
>     https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>     <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users>
>      >   
>       <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>     <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users>>
>      >      >>
>      >
>      >
>      >
>      > --
>      > Massimo Re
> 
> 
> 
> -- 
> Massimo Re

Re: [Squirrel-sql-users] Sql2ins

[Massimo Re <max...@gm...>]

Gerd, i try to explain better my question ...

If i download the "official" 4.2 (last) version from

http://squirrel-sql.sourceforge.net/

does it contain the new feature available in the snapshot you linked me
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
 or not ?

Thank a lot

Max


Il giorno dom 25 apr 2021 alle ore 10:51 Gerd Wagner <
ger...@t-...> ha scritto:

>
>
> Am 24.04.21 um 10:39 schrieb Massimo Re:
> > Thanks Gerd !
> >
> > One more question ...
> >
> > The snapshot
> >
> >
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
> > <
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
> >
> >
> > Is following the official version 4.2 correct ?
> No it is not. I don't see this version anywhere, when I install the
> snapshot.
> Did you try to do a fresh install into an empty directory?
>
> Gerd
>
>
> >
> > Max
> >
> >
> > Il giorno sab 24 apr 2021 alle ore 02:34 Gerd Wagner
> > <ger...@t-... <mailto:ger...@t-...>> ha scritto:
> >
> >     Sorry, the snapshot link below was wrong. Here's the right one:
> >
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
> >     <
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
> >
> >
> >
> >     Am 24.04.21 um 02:29 schrieb Gerd Wagner:
> >      > Max,
> >      >
> >      > thank you for your kind words and for using SQuirreL.
> >      >
> >      > Your feature request is implemented in snapshot 20210424_0200, see
> >      >
> >
> https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/
> >     <
> https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/
> >
> >
> >      >
> >      >
> >      > Excerpt from change log:
> >      > SQL Scripts Plugin: Create Data (INSERT) file from SQL.
> >      >   Creates INSERT statements of an SQL result in a file.
> >      >   Available in SQL editor's right mouse menu and tools popup
> >     (ctrl+T).
> >      >
> >      >
> >      > Please be aware:
> >      > The snapshot comes with a replacement of SQuirreL's former XML
> >     library
> >      > nanoxml. Almost all of SQuirreL's configuration files are
> >     concerned by
> >      > this. You should back up your SQuirreL user directory before
> >     installing
> >      > this snapshot. For more information see our change log
> >      > and/or the Readme of the snapshot.
> >      >
> >      > Gerd
> >      >
> >      >
> >      > Am 10.04.21 um 18:26 schrieb Massimo Re:
> >      >> Hi guys !
> >      >>
> >      >> I'm using Squirrel from long time and I'm very happy to work
> >     with it.
> >      >>
> >      >> So first of all, i want to congratulate with all teams members,
> >     it's
> >      >> excellent and work fine.
> >      >>
> >      >> I want to ask to add a new little feature or improvement.
> >      >>
> >      >> With Alt+T, i often use Sql2ins to have a script with an INSERT
> >     INTO
> >      >> statement for each record in the table.
> >      >>
> >      >> If the table contains a lot of records, i got the error message
> >     Java
> >      >> heap space (query results is over the maximum memory available.)
> >      >>
> >      >> Is possibile add a new option Sql2insfile that create a new .sql
> >     file
> >      >> containing all INSERT INTO statements for every records in the
> >     table ?
> >      >> This new option can resolve the problem above ...
> >      >>
> >      >> Is possibile to develop it ?
> >      >>
> >      >> Thank you
> >      >>
> >      >> Max
> >      >>
> >      >>
> >      >>
> >      >> _______________________________________________
> >      >> Squirrel-sql-users mailing list
> >      >> Squ...@li...
> >     <mailto:Squ...@li...>
> >      >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >     <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users>
> >      >>
> >
> >
> >
> > --
> > Massimo Re
>


-- 
Massimo Re

Re: [Squirrel-sql-users] Sql2ins

[Massimo Re <max...@gm...>]

Thanks Gerd !

One more question ...

The snapshot

https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/

Is following the official version 4.2 correct ?

Max


Il giorno sab 24 apr 2021 alle ore 02:34 Gerd Wagner <
ger...@t-...> ha scritto:

> Sorry, the snapshot link below was wrong. Here's the right one:
>
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
>
>
> Am 24.04.21 um 02:29 schrieb Gerd Wagner:
> > Max,
> >
> > thank you for your kind words and for using SQuirreL.
> >
> > Your feature request is implemented in snapshot 20210424_0200, see
> >
> https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/
> >
> >
> > Excerpt from change log:
> > SQL Scripts Plugin: Create Data (INSERT) file from SQL.
> >   Creates INSERT statements of an SQL result in a file.
> >   Available in SQL editor's right mouse menu and tools popup (ctrl+T).
> >
> >
> > Please be aware:
> > The snapshot comes with a replacement of SQuirreL's former XML library
> > nanoxml. Almost all of SQuirreL's configuration files are concerned by
> > this. You should back up your SQuirreL user directory before installing
> > this snapshot. For more information see our change log
> > and/or the Readme of the snapshot.
> >
> > Gerd
> >
> >
> > Am 10.04.21 um 18:26 schrieb Massimo Re:
> >> Hi guys !
> >>
> >> I'm using Squirrel from long time and I'm very happy to work with it.
> >>
> >> So first of all, i want to congratulate with all teams members, it's
> >> excellent and work fine.
> >>
> >> I want to ask to add a new little feature or improvement.
> >>
> >> With Alt+T, i often use Sql2ins to have a script with an INSERT INTO
> >> statement for each record in the table.
> >>
> >> If the table contains a lot of records, i got the error message Java
> >> heap space (query results is over the maximum memory available.)
> >>
> >> Is possibile add a new option Sql2insfile that create a new .sql file
> >> containing all INSERT INTO statements for every records in the table ?
> >> This new option can resolve the problem above ...
> >>
> >> Is possibile to develop it ?
> >>
> >> Thank you
> >>
> >> Max
> >>
> >>
> >>
> >> _______________________________________________
> >> Squirrel-sql-users mailing list
> >> Squ...@li...
> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >>
>


-- 
Massimo Re

Re: [Squirrel-sql-users] Sql2ins

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

Max,

thank you for your kind words and for using SQuirreL.

Your feature request is implemented in snapshot 20210424_0200, see
https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/

Excerpt from change log:
SQL Scripts Plugin: Create Data (INSERT) file from SQL.
   Creates INSERT statements of an SQL result in a file.
   Available in SQL editor's right mouse menu and tools popup (ctrl+T).


Please be aware:
The snapshot comes with a replacement of SQuirreL's former XML library 
nanoxml. Almost all of SQuirreL's configuration files are concerned by 
this. You should back up your SQuirreL user directory before installing 
this snapshot. For more information see our change log
and/or the Readme of the snapshot.

Gerd


Am 10.04.21 um 18:26 schrieb Massimo Re:
> Hi guys !
> 
> I'm using Squirrel from long time and I'm very happy to work with it.
> 
> So first of all, i want to congratulate with all teams members, it's 
> excellent and work fine.
> 
> I want to ask to add a new little feature or improvement.
> 
> With Alt+T, i often use Sql2ins to have a script with an INSERT INTO 
> statement for each record in the table.
> 
> If the table contains a lot of records, i got the error message Java 
> heap space (query results is over the maximum memory available.)
> 
> Is possibile add a new option Sql2insfile that create a new .sql file 
> containing all INSERT INTO statements for every records in the table ?
> This new option can resolve the problem above ...
> 
> Is possibile to develop it ?
> 
> Thank you
> 
> Max
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] Sql2ins

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

Sorry, the snapshot link below was wrong. Here's the right one:
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/


Am 24.04.21 um 02:29 schrieb Gerd Wagner:
> Max,
> 
> thank you for your kind words and for using SQuirreL.
> 
> Your feature request is implemented in snapshot 20210424_0200, see
> https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/ 
> 
> 
> Excerpt from change log:
> SQL Scripts Plugin: Create Data (INSERT) file from SQL.
>   Creates INSERT statements of an SQL result in a file.
>   Available in SQL editor's right mouse menu and tools popup (ctrl+T).
> 
> 
> Please be aware:
> The snapshot comes with a replacement of SQuirreL's former XML library 
> nanoxml. Almost all of SQuirreL's configuration files are concerned by 
> this. You should back up your SQuirreL user directory before installing 
> this snapshot. For more information see our change log
> and/or the Readme of the snapshot.
> 
> Gerd
> 
> 
> Am 10.04.21 um 18:26 schrieb Massimo Re:
>> Hi guys !
>>
>> I'm using Squirrel from long time and I'm very happy to work with it.
>>
>> So first of all, i want to congratulate with all teams members, it's 
>> excellent and work fine.
>>
>> I want to ask to add a new little feature or improvement.
>>
>> With Alt+T, i often use Sql2ins to have a script with an INSERT INTO 
>> statement for each record in the table.
>>
>> If the table contains a lot of records, i got the error message Java 
>> heap space (query results is over the maximum memory available.)
>>
>> Is possibile add a new option Sql2insfile that create a new .sql file 
>> containing all INSERT INTO statements for every records in the table ?
>> This new option can resolve the problem above ...
>>
>> Is possibile to develop it ?
>>
>> Thank you
>>
>> Max
>>
>>
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>

Re: [Squirrel-sql-users] Sql2ins

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

Am 24.04.21 um 10:39 schrieb Massimo Re:
> Thanks Gerd !
> 
> One more question ...
> 
> The snapshot
> 
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/ 
> <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/>
> 
> Is following the official version 4.2 correct ?
No it is not. I don't see this version anywhere, when I install the 
snapshot.
Did you try to do a fresh install into an empty directory?

Gerd


> 
> Max
> 
> 
> Il giorno sab 24 apr 2021 alle ore 02:34 Gerd Wagner 
> <ger...@t-... <mailto:ger...@t-...>> ha scritto:
> 
>     Sorry, the snapshot link below was wrong. Here's the right one:
>     https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/
>     <https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210424_0200/>
> 
> 
>     Am 24.04.21 um 02:29 schrieb Gerd Wagner:
>      > Max,
>      >
>      > thank you for your kind words and for using SQuirreL.
>      >
>      > Your feature request is implemented in snapshot 20210424_0200, see
>      >
>     https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/
>     <https://sourceforge.net/projects/squirrel-sql/upload/3-snapshots/snapshot-20210424_0200/>
> 
>      >
>      >
>      > Excerpt from change log:
>      > SQL Scripts Plugin: Create Data (INSERT) file from SQL.
>      >   Creates INSERT statements of an SQL result in a file.
>      >   Available in SQL editor's right mouse menu and tools popup
>     (ctrl+T).
>      >
>      >
>      > Please be aware:
>      > The snapshot comes with a replacement of SQuirreL's former XML
>     library
>      > nanoxml. Almost all of SQuirreL's configuration files are
>     concerned by
>      > this. You should back up your SQuirreL user directory before
>     installing
>      > this snapshot. For more information see our change log
>      > and/or the Readme of the snapshot.
>      >
>      > Gerd
>      >
>      >
>      > Am 10.04.21 um 18:26 schrieb Massimo Re:
>      >> Hi guys !
>      >>
>      >> I'm using Squirrel from long time and I'm very happy to work
>     with it.
>      >>
>      >> So first of all, i want to congratulate with all teams members,
>     it's
>      >> excellent and work fine.
>      >>
>      >> I want to ask to add a new little feature or improvement.
>      >>
>      >> With Alt+T, i often use Sql2ins to have a script with an INSERT
>     INTO
>      >> statement for each record in the table.
>      >>
>      >> If the table contains a lot of records, i got the error message
>     Java
>      >> heap space (query results is over the maximum memory available.)
>      >>
>      >> Is possibile add a new option Sql2insfile that create a new .sql
>     file
>      >> containing all INSERT INTO statements for every records in the
>     table ?
>      >> This new option can resolve the problem above ...
>      >>
>      >> Is possibile to develop it ?
>      >>
>      >> Thank you
>      >>
>      >> Max
>      >>
>      >>
>      >>
>      >> _______________________________________________
>      >> Squirrel-sql-users mailing list
>      >> Squ...@li...
>     <mailto:Squ...@li...>
>      >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>     <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users>
>      >>
> 
> 
> 
> -- 
> Massimo Re

[Squirrel-sql-users] Sql2ins

[Massimo Re <max...@gm...>]

Hi guys !

I'm using Squirrel from long time and I'm very happy to work with it.

So first of all, i want to congratulate with all teams members, it's
excellent and work fine.

I want to ask to add a new little feature or improvement.

With Alt+T, i often use Sql2ins to have a script with an INSERT INTO
statement for each record in the table.

If the table contains a lot of records, i got the error message Java heap
space (query results is over the maximum memory available.)

Is possibile add a new option Sql2insfile that create a new .sql file
containing all INSERT INTO statements for every records in the table ?
This new option can resolve the problem above ...

Is possibile to develop it ?

Thank you

Max

Re: [Squirrel-sql-users] Column Size in Bits or Bytes?

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

Am 28.03.21 um 23:27 schrieb Benoit Xhenseval via Squirrel-sql-users:
> Hi
> 
> I love Squirel/J, thanks for the great tool.

thank you.

> 
> I was looking for a way to guess the table size and I found a screen 
> that shows the Column Size.
> 
> I thought I could just add each column size to have a good guess.
> 
> Some of my columns are BIGINT and the col size is 64 which implies it is 
> in Bits, as expected. But then I can see some varchar(80) and 20 and the 
> col Size is 80 and 20, implying in BYTES.
> 
> What is the unit on the Column Size?  It is the same for each data 
> type?  Or is it a small bug?

It's up to the JDBC driver to deliver the sizes. Below's a small Java 
program that shows how sizes are read. You may use it to reproduce your 
problem and possibly to consult your JDBC driver or database vendor.

Gerd


public class ResultSetTest
{
    public static void main(String[] args)
       throws ClassNotFoundException, SQLException
    {
       Class.forName("<YourJDBCDriverName>");

       Connection con = DriverManager.getConnection("<YourJDBCUrl>",
                        "User", "Password");

       ResultSet column =
          con.getMetaData().getColumns(null,
                                       "<YourSchemaOr_null>",
                                       "<YourTableName>",
                                       "<YourColumnName");

       column.next();

       int size = column.getInt("COLUMN_SIZE");

       System.out.println("Column size is: " + size);
    }
}

[Squirrel-sql-users] Column Size in Bits or Bytes?

[Benoit X. <be...@ya...>]

Hi
I love Squirel/J, thanks for the great tool.
I was looking for a way to guess the table size and I found a screen that shows the Column Size.
I thought I could just add each column size to have a good guess.
Some of my columns are BIGINT and the col size is 64 which implies it is in Bits, as expected. But then I can see some varchar(80) and 20 and the col Size is 80 and 20, implying in BYTES.
What is the unit on the Column Size?  It is the same for each data type?  Or is it a small bug?
See the snapshot attached.
Thanks for clarifying.
Benoit

Re: [Squirrel-sql-users] Squirrel - Can I use it in my company pc for free?

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

Am 11.03.21 um 15:14 schrieb Gonçalo Monteiro Duarte:
> Good morning,
> 
> I heard extremely good reviews for Squirrel.
> Congratulations for the product!
Thank you.

> 
> I would like to instal it on my company computer.
> Is it freeware? Would that use be legal?
SQuirreL is open source. So yes you can use it at work for free.
For further information and download see
http://www.squirrelsql.org/

Gerd

[Squirrel-sql-users] Squirrel - Can I use it in my company pc for free?

[Gonçalo M. D. <mon...@gm...>]

Good morning,

I heard extremely good reviews for Squirrel.
Congratulations for the product!

I would like to instal it on my company computer.
Is it freeware? Would that use be legal?

Thank you very much,

G

-- 
______________________
Gonçalo Monteiro Duarte