SQuirreL SQL Client

Hey Howard,
In newer versions (2.6.7) you can export a SELECT result into CSV / MS Excel
format by simply right clicking the results and choosing the option.

Otherwise you can export a whole table as INSERT statements by simply
selecting a table from the Objects tree, right click and then Scripts >
Create data script. That will generate the INSERT statements in the SQL
editor window - keep in mind that if the table is large you need to increase
the Maximum Heap Size (-Xmx).

HTH,
Dan

2008/10/1 Howard J. Herman <howard@...>

>  Is it possible to export using a script or at least using SQL in
> Squirrel?
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Squirrel-SQL-announce mailing list
> Squirrel-SQL-announce@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-announce
>
>

I've had no problems allocating 256 MB for SQuirreL, so the problem is
likely just getting precisely the correct syntax in your startup command.
My squirrel-sql.bat file uses this line:
start "SQuirreL SQL Client" /B "%LOCAL_JAVA%w" -Xmx256m -cp %TMP_CP%
net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%
 
If your main goal is to dump the contents of a table into a file then
SQuirreL may not be the simplest solution. Its need to load the data into
memory first will be an issue. I would expect that using the database's
standard command line tools would more easily let you run a simple query
and redirect the result to a file.
 
You didn't specify a database technology, but it would be similar with any
database. For example with MySQL you could run a command like this:
mysql -u myuser -pmypassword -D foodmart < myquery.sql > result.txt
 
Regards,
Matt Dahlman
Jaspersoft

  _____  

From: Howard J. Herman [mailto:howard@...] 
Sent: Wednesday, 01 October, 2008 11:07
To: squirrel-sql-announce@...
Subject: [Squirrel-SQL-announce] heap space



In Squirrel SQL 2.5 I have been unable to allocate more than 64 MB for
heap space.  I have a table that is over 100,000 records and this is
creating a problem for opening/viewing/exporting.  What is the syntax for
opening
Squirrel SQL to grant this amount of memory?  I have tried variants of the
-Xmx parameter but without success and also changing preferences for
viewing different amounts of records but this has eventually caused an
error when reaching the heap limit.

Hey Howard,
Have you tried adding the -Xmx parameter to the squirrel-sql.bat /
squirre-sql.sh ?
I'm using version 2.6.7 and by default it uses now 256 MB for heap, e.g.

@rem Run with no command window. This may not work with older versions of
Windows. Use the command above then.
start "SQuirreL SQL Client" /B "%LOCAL_JAVA%w" -Xmx256m -cp %TMP_CP%
net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%

HTH,
Dan

2008/10/1 Howard J. Herman <howard@...>

>  In Squirrel SQL 2.5 I have been unable to allocate more than 64 MB for
> heap space.  I have a table that is over 100,000 records and this is
> creating a problem for opening/viewing/exporting.  What is the syntax for
> opening
> Squirrel SQL to grant this amount of memory?  I have tried variants of the
> -Xmx parameter but without success and also changing preferences for viewing
> different amounts of records but this has eventually caused an error when
> reaching the heap limit.
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Squirrel-SQL-announce mailing list
> Squirrel-SQL-announce@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-announce
>
>