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

[Squirrel-sql-users] Display results version 3.71

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

Hi guys, is possible to avoid that numeric fields are shown with thousands
separators ?
For example :
My desidered result values after SELECT * FROM ............ is 123456 and
now i See 123.456.

I've tried to check in general preferences but nothing 😭😭😭

Thank  You for your support.

Max

[Squirrel-sql-users] Questions about Squirrel SQL Client, please help

[Taylor, K. X.-N. <Ker...@di...>]

I am totally new to using Squirrel Sql client. I am using SQuirreL SQL Client Version 3.7.1, attaching to Oracle DB.


1.    I can't seem to change the Limit Rows, no matter what I choose over 1000, it limits it to 1000.


[cid:image001.png@01D2D55C.8FE4A6C0]

[cid:image002.png@01D2D55C.8FE4A6C0]

I have also tried to change SQL results in New session properties

[cid:image006.png@01D2D55D.025119F0]


2.    I can't run parameters.


Entering: select :var from dual;

Error:
[cid:image003.png@01D2D55C.8FE4A6C0]

Sincerely,

Keri Taylor
Technical Analyst
Disney Parks & Resorts Digital
(818) 931-2447 | (407) 790-6473

"I can accept failure, but I can't accept not trying." - Michael Jordan

[cid:ima...@01...626E50]

Re: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

[Laffrey L. M. (FCA) <lyn...@fc...>]

I just did this today.  You just need to log in with your admin account  or run the command prompt with admin rights.  You will then be able to install Squirrel to “C:\Program Files (x86)\Squirrel” directory.  I successfully installed Squirrel and tested it in Windows 10.

Sincerely,
Lynne Marie Laffrey
Data Engineer
Business Analytics – ICT
FCA US LLC

From: Alexandre Peshansky [mailto:Ale...@ei...]
Sent: Tuesday, May 09, 2017 3:24 PM
To: Steve Carry <sc...@us...>
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

Just install SQuirreL into different directory.
Microsoft idea of security is to create extra hurdles for users; you can use a subdirectory of “C:\Program Files (x86)”, but it will require custom rights, and I’m not sure it is worth the effort.
--
Alexandre Peshansky, MS
Lead Bioinformatics Analyst, Research Informatics Core (RIC)
Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore
Albert Einstein College of Medicine
1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461
(718) 430-2440, (914) 457-6792 (office) (201) 970-3530 (cell) – NEW!!!
[cid:image002.jpg@01D2C8E2.DA24E1E0]

From: Steve Carry [mailto:sc...@us...]
Sent: Tuesday, May 09, 2017 2:39 PM
To: squ...@li...<mailto:squ...@li...>
Subject: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

I am trying to install the current version of SQuirreL on a Windows 10 machine.  I've downloaded the executable squirrel-sql-snapshot-20170430_2224-standard.jar file.  When I execute it, I was prompted to Select The Installation Path:.  The default value is C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224

When I try to accept this default by clicking the Next button, I get an error message that says, The directory cannot be written!  Please choose another directory!

There is a response on Squirrel-SQL-Users that says to create the C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224 directory manually in MS Explorer.  However, even after I did that, I get the same error message.

What do I need to do differently?

S Cary

Re: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

[Wesley N. <We...@Ke...>]

Hold shift and right-click on the installer file in explorer and select ‘Copy as path’

Click on Start Menu and type CMD, right click on ‘Command Prompt’ and select ‘Run as administrator’

Paste copied path to jar installer file at command prompt and click enter.

In my case it looks like this C:\WINDOWS\System32>"C:\Users\wesleyn.MWP\Downloads\squirrel-sql-snapshot-20170430_2224-standard.jar"

Best Regards,

Wesley S. Newswanger<http://w3w.cm/today.astounding.equals>    IT & Database Administrator

Keystone Collections™
Office:  866.881.6680    ext. 1028
Email:    we...@ke... <mailto:we...@ke...>

[cid:image001.gif@01D2C8E0.A23BC020]<http://www.keystonecollections.com/>
From: Steve Carry [mailto:sc...@us...]
Sent: Tuesday, May 09, 2017 2:39 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

I am trying to install the current version of SQuirreL on a Windows 10 machine.  I've downloaded the executable squirrel-sql-snapshot-20170430_2224-standard.jar file.  When I execute it, I was prompted to Select The Installation Path:.  The default value is C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224

When I try to accept this default by clicking the Next button, I get an error message that says, The directory cannot be written!  Please choose another directory!

There is a response on Squirrel-SQL-Users that says to create the C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224 directory manually in MS Explorer.  However, even after I did that, I get the same error message.

What do I need to do differently?

S Cary

Re: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

[Alexandre P. <Ale...@ei...>]

Just install SQuirreL into different directory.
Microsoft idea of security is to create extra hurdles for users; you can use a subdirectory of “C:\Program Files (x86)”, but it will require custom rights, and I’m not sure it is worth the effort.
--
Alexandre Peshansky, MS
Lead Bioinformatics Analyst, Research Informatics Core (RIC)
Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore
Albert Einstein College of Medicine
1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461
(718) 430-2440, (914) 457-6792 (office) (201) 970-3530 (cell) – NEW!!!
[cid:image001.png@01D2C8D8.41801590]

From: Steve Carry [mailto:sc...@us...]
Sent: Tuesday, May 09, 2017 2:39 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

I am trying to install the current version of SQuirreL on a Windows 10 machine.  I've downloaded the executable squirrel-sql-snapshot-20170430_2224-standard.jar file.  When I execute it, I was prompted to Select The Installation Path:.  The default value is C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224

When I try to accept this default by clicking the Next button, I get an error message that says, The directory cannot be written!  Please choose another directory!

There is a response on Squirrel-SQL-Users that says to create the C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224 directory manually in MS Explorer.  However, even after I did that, I get the same error message.

What do I need to do differently?

S Cary

Re: [Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

[Stefan G. <new...@sg...>]

Steve,

have you tried using right mouse button -> run as administrator?
Usually you are not permitted to write to "Program files (x86" as a
regular windows user.

Cheers

Stefan

Am Dienstag, den 09.05.2017, 18:39 +0000 schrieb Steve Carry:
> I am trying to install the current version of SQuirreL on a Windows
> 10 machine.  I've downloaded the executable squirrel-sql-snapshot-
> 20170430_2224-standard.jar file.  When I execute it, I was prompted
> to Select The Installation Path:.  The default value is C:\Program
> files (x86)\squirrel-sql-snapshot-20170430_2224
>  
> When I try to accept this default by clicking the Next button, I get
> an error message that says, The directory cannot be written!  Please
> choose another directory!
>  
> There is a response on Squirrel-SQL-Users that says to create
> the C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224
> directory manually in MS Explorer.  However, even after I did that, I
> get the same error message. 
>  
> What do I need to do differently?
>  
> S Cary
> 
> -------------------------------------------------------------------
> -----------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
-- 
Stefan Grewe

[Squirrel-sql-users] Choosing/creating an Installation Path for SQuirreL in Windows 10

[Steve C. <sc...@us...>]

<div class="socmaildefaultfont" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" dir="ltr" ><div dir="ltr" >I am trying to install the current version of SQuirreL on a Windows 10 machine.&nbsp; I've downloaded the executable&nbsp;<em>squirrel-sql-snapshot-20170430_2224-standard.jar </em>file.&nbsp; When I execute it, I&nbsp;was prompted to <em>Select The Installation Path:</em>.&nbsp; The default value is <u>C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224</u></div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >When I try to accept this default by clicking the Next button, I get an error message that says, <em>The directory&nbsp;cannot be written!&nbsp; Please choose another directory!</em></div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >There is a response on Squirrel-SQL-Users that says to create the&nbsp;<u>C:\Program files (x86)\squirrel-sql-snapshot-20170430_2224</u> directory manually in MS Explorer.&nbsp; <strong>However, even after I did that, I get the same error message.&nbsp; </strong></div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >What do I need to do differently?</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >S Cary</div></div><BR>

Re: [Squirrel-sql-users] MariaDB connections start failing after idle and won't reconnect

[KARR, D. <dk...@at...>]

> -----Original Message-----
> From: Gerd Wagner [mailto:ger...@t-...]
> Sent: Saturday, April 29, 2017 4:21 AM
> To: KARR, DAVID <dk...@at...>; squirrel-sql-
> us...@li...
> Subject: Re: [Squirrel-sql-users] MariaDB connections start failing
> after idle and won't reconnect
> 
> Here's another trial to answer a question you haven't already found out
> yourself.
> I was a bit busy lately and am going through several mails now. Sorry.

No problem.  Not a huge problem.

> Am 26.04.2017 um 21:48 schrieb KARR, DAVID:
> > I'm connecting to a MariaDB database.  The app running in Tomcat that
> > uses the database is now setting "testWhileIdle" and "testOnReturn"
> > to true, because the connections seem to time out after a while of
> > being idle.  Those appear to mitigate the problem in the app itself.
> >
> > In SQuirreL, if I leave a connection open for a while, I get similar
> > errors like: ---------- Error: (conn:121) Could not read packet:
> > unexpected end of stream, read 0 bytes from 4 ---------
> >
> > It's not clear to me how to configure the connection automatically to
> > mitigate these problems.
> >
> > What's even worse is that when I try to "Reconnect", it just fails
> > with "Error: (conn:121) Connection is close".  I actually have to
> > completely close the connection and reopen it, and then it works until
> > I go idle again.
> >
> > What can I do to mitigate these problems in SQuirreL?
> 
> Right click your Alias -> Alias properties -> Tab 'Connection'. The SQL
> entered there will be executed periodically with configurable repeat
> time.

Interesting.  That certainly works.

Any idea why MariaDB connections behave differently from Oracle connections?  Oracle connections do time out, but I just have to "Reconnect" to fix that.

If connections to particular databases don't "time out well", or have other specific behavior that have to be dealt with through alias properties, it seems like it would be useful for users to be able to set these properties in the Driver, essentially defining a properties template for aliases created for that driver.

Re: [Squirrel-sql-users] MariaDB connections start failing after idle and won't reconnect

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

Here's another trial to answer a question you haven't already found out 
yourself.
I was a bit busy lately and am going through several mails now. Sorry.

Am 26.04.2017 um 21:48 schrieb KARR, DAVID:
> I'm connecting to a MariaDB database.  The app running in Tomcat that
> uses the database is now setting "testWhileIdle" and "testOnReturn"
> to true, because the connections seem to time out after a while of
> being idle.  Those appear to mitigate the problem in the app itself.
>
> In SQuirreL, if I leave a connection open for a while, I get similar
> errors like: ---------- Error: (conn:121) Could not read packet:
> unexpected end of stream, read 0 bytes from 4 ---------
>
> It's not clear to me how to configure the connection automatically to
> mitigate these problems.
>
> What's even worse is that when I try to "Reconnect", it just fails
> with "Error: (conn:121) Connection is close".  I actually have to
> completely close the connection and reopen it, and then it works
> until I go idle again.
>
> What can I do to mitigate these problems in SQuirreL?

Right click your Alias -> Alias properties -> Tab 'Connection'. The SQL 
entered there will be executed periodically with configurable repeat time.

Re: [Squirrel-sql-users] SQuirreL somehow interpreting vertical bar in varchar value?

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

Sorry my last redundant answer that John had already given.


Am 25.04.2017 um 21:34 schrieb KARR, DAVID:
> Now that I've turned off variable interpolation in my big sql import
> script, when I run it, it gets an odd error on a particular insert
> line.  It looks somewhat like this (mostly elided, except for the
> start of the values list):
>
> insert into blah (colname1,colname2,colname3,...) values
> (371,null,'433449 | 274027 - ...
>
> In the error message, it says the syntax error is near "433449", and
> when it shows the entire query, the end of the line is the "9" at the
> end of that number.  It seems like that vertical bar character is
> doing something.
>
> I don't know whether this is a mysql/mariadb issue, or SQuirreL.
This should be due to our MYSQL Plugin (MariaDB is based on MYSQL). See 
menu File -> Global preferences -> Tab MySQL -> The procedure separator 
is by default set to '|'. Change it for example to ';' and the problem 
should be gone.

Re: [Squirrel-sql-users] How to execute SQL ignoring parameters

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

Am 25.04.2017 um 20:16 schrieb KARR, DAVID:
> Somewhat related to my just earlier question about exporting and
> importing a database, it appears that when I execute a SQL script,
> SQuirreL looks for strings like ":abc", which it recognizes as a
> parameter.  How can I execute the SQL script without processing
> parameters at all?

Got to menu Plugins -> Summary and uncheck the "SQL Parametrization" 
Plugin. Then restart SQuirreL.

Re: [Squirrel-sql-users] Export mariadb database for import to another instance?

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

Am 25.04.2017 um 20:03 schrieb KARR, DAVID:
> I'm working with an existing mariadb database, and I need to export
> the contents to a new instance.  I didn't notice any obvious export
> facilities in SQuirreL.  Is there an easy way to do this?  I noticed
> that the changelog for the unreleased version appeared to have some
> changes related to this.

The only feature that comes close to this is to select tables in the 
Object tree right click and choose "Copy table" then right click the 
same schema of your target database and choose "Paste".

Hope this helps.

>
>
>
> ------------------------------------------------------------------------------
>
>
Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
> _______________________________________________ Squirrel-sql-users
> mailing list Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] MariaDB connections start failing after idle and won't reconnect

[KARR, D. <dk...@at...>]

I'm connecting to a MariaDB database.  The app running in Tomcat that uses the database is now setting "testWhileIdle" and "testOnReturn" to true, because the connections seem to time out after a while of being idle.  Those appear to mitigate the problem in the app itself.

In SQuirreL, if I leave a connection open for a while, I get similar errors like:
----------
	Error: (conn:121) Could not read packet: unexpected end of stream, read 0 bytes from 4
---------

It's not clear to me how to configure the connection automatically to mitigate these problems.

What's even worse is that when I try to "Reconnect", it just fails with "Error: (conn:121) Connection is close".  I actually have to completely close the connection and reopen it, and then it works until I go idle again.

What can I do to mitigate these problems in SQuirreL?

Re: [Squirrel-sql-users] SQuirreL somehow interpreting vertical bar in varchar value?

[KARR, D. <dk...@at...>]

> -----Original Message-----
> From: John Hardin [mailto:jh...@im...]
> Sent: Tuesday, April 25, 2017 2:57 PM
> To: KARR, DAVID <dk...@at...>
> Cc: squ...@li...
> Subject: Re: [Squirrel-sql-users] SQuirreL somehow interpreting vertical
> bar in varchar value?
> 
> On Tue, 25 Apr 2017, KARR, DAVID wrote:
> 
> > Now that I've turned off variable interpolation in my big sql import
> script, when I run it, it gets an odd error on a particular insert line.
> It looks somewhat like this (mostly elided, except for the start of the
> values list):
> >
> >    insert into blah (colname1,colname2,colname3,...) values
> (371,null,'433449 | 274027 - ...
> >
> > In the error message, it says the syntax error is near "433449", and
> > when it shows the entire query, the end of the line is the "9" at the
> > end of that number.  It seems like that vertical bar character is
> > doing something.
> >
> > I don't know whether this is a mysql/mariadb issue, or SQuirreL.
> 
> Take a look at Session -> Session Properties -> SQL tab -> Statement
> Separator, is that perhaps set to vertical bar?
> 
> It doesn't make any sense for that to be the case, but that is one thing
> that can cause Squirrel to break the parsing of SQL midway through.

It turns out the problem was in the "MySQL Script Settings", in the "Procedure/Function Separator" field.  It was "|", and I changed it to "|||" to fix this problem.

Re: [Squirrel-sql-users] SQuirreL somehow interpreting vertical bar in varchar value?

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

On Tue, 25 Apr 2017, KARR, DAVID wrote:

> Now that I've turned off variable interpolation in my big sql import script, when I run it, it gets an odd error on a particular insert line.  It looks somewhat like this (mostly elided, except for the start of the values list):
>
>    insert into blah (colname1,colname2,colname3,...) values (371,null,'433449 | 274027 - ...
>
> In the error message, it says the syntax error is near "433449", and 
> when it shows the entire query, the end of the line is the "9" at the 
> end of that number.  It seems like that vertical bar character is doing 
> something.
>
> I don't know whether this is a mysql/mariadb issue, or SQuirreL.

Take a look at Session -> Session Properties -> SQL tab -> Statement 
Separator, is that perhaps set to vertical bar?

It doesn't make any sense for that to be the case, but that is one thing 
that can cause Squirrel to break the parsing of SQL midway through.


-- 
  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
-----------------------------------------------------------------------
   We should endeavour to teach our children to be gun-proof
   rather than trying to design our guns to be child-proof
-----------------------------------------------------------------------
  26 days since the first commercial re-flight of an orbital booster (SpaceX)

[Squirrel-sql-users] SQuirreL somehow interpreting vertical bar in varchar value?

[KARR, D. <dk...@at...>]

Now that I've turned off variable interpolation in my big sql import script, when I run it, it gets an odd error on a particular insert line.  It looks somewhat like this (mostly elided, except for the start of the values list):

    insert into blah (colname1,colname2,colname3,...) values (371,null,'433449 | 274027 - ...

In the error message, it says the syntax error is near "433449", and when it shows the entire query, the end of the line is the "9" at the end of that number.  It seems like that vertical bar character is doing something.

I don't know whether this is a mysql/mariadb issue, or SQuirreL.

Re: [Squirrel-sql-users] How to execute SQL ignoring parameters

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

On Tue, 25 Apr 2017, KARR, DAVID wrote:

> Somewhat related to my just earlier question about exporting and 
> importing a database, it appears that when I execute a SQL script, 
> SQuirreL looks for strings like ":abc", which it recognizes as a 
> parameter.  How can I execute the SQL script without processing 
> parameters at all?

Temporarily disable the parameters plugin?

I don't think there's a way to suppress that on a per-query basis.


-- 
  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
-----------------------------------------------------------------------
   It is not the business of government to make men virtuous
   or religious, or to preserve the fool from the consequences
   of his own folly.                                   -- Henry George
-----------------------------------------------------------------------
  26 days since the first commercial re-flight of an orbital booster (SpaceX)

[Squirrel-sql-users] How to execute SQL ignoring parameters

[KARR, D. <dk...@at...>]

Somewhat related to my just earlier question about exporting and importing a database, it appears that when I execute a SQL script, SQuirreL looks for strings like ":abc", which it recognizes as a parameter.  How can I execute the SQL script without processing parameters at all?

[Squirrel-sql-users] Export mariadb database for import to another instance?

[KARR, D. <dk...@at...>]

I'm working with an existing mariadb database, and I need to export the contents to a new instance.  I didn't notice any obvious export facilities in SQuirreL.  Is there an easy way to do this?  I noticed that the changelog for the unreleased version appeared to have some changes related to this.

Re: [Squirrel-sql-users] Squirrel - Importing

[Michael C. <mjc...@ao...>]

On Sun, 19 Mar 2017 19:03:05 -0400
"Brooks Jealous" <dbj...@gm...> wrote:

> Hi
> 
>  
> 
> First time Squirrel user and I’m having a bit of trouble with the
> import function.
> 
>  
> 
> 1.       I get a pop-up verification that all records in the target
> table will be deleted when I import. Seems a bit odd. Is there any
> flag / parameter that enables non-delete imports?
> 
>  
> 
> 2.       Even though I don’t get an error, records are not
> successfully imported. The records are valid CSV and/or XLS files
> that have been previously tested with other SQL clients, so I’m
> confident that there are no formatting issues. Any thoughts /
> comments on the stability of the import function, or notes on common
> errors?
> 
>  
> 
> Many thanks in advance! 
> 
>  
> 
> Brooks 
> 
> 金布鲁克斯
> 
>  
> 
> +1 415.870.0962
> 
>  <mailto:dbj...@gm...> dbj...@gm...
> 
>  <http://www.linkedin.com/in/dbjdigitalconsultant>
> www.linkedin.com/in/dbjdigitalconsultant
> 
>  
> 
> 滴水穿石
> 
>  
> 

Hi Brooks, I use the import plug-in regularly and it seems to work
well, but it was difficult to get it to work the first time.  For the
suggest to work, I need to use ignore case.  When the import doesn't
work I get an error.  I have not seen it appear to work without actually
doing the import.  I use a temporary table to get the import and then
use an insert to move data from the temporary table into the working
table.  I am not aware of an option where you can import directly
without deleting the existing data in the table.  I have used
squirrel-sql for a few years but am not an expert by any means.
Perhaps others can offer other insights.  Mike

[Squirrel-sql-users] Squirrel - Object Maintenance

[Brooks J. <dbj...@gm...>]

Hi

 

Maybe I didn’t install Squirrel correctly, but I can’t find any function to add, drop or modify a view. Surely this function exists in Squirrel – could anyone point me to it?

 

Thanks!

 

Brooks

金布鲁克斯

 

+1 415.870.0962

 <mailto:dbj...@gm...> dbj...@gm...

 <http://www.linkedin.com/in/dbjdigitalconsultant> www.linkedin.com/in/dbjdigitalconsultant

 

滴水穿石

 

[Squirrel-sql-users] FW: Squirrel - Importing - Part 02

[Brooks J. <dbj...@gm...>]

Pls disregard this last question. 

 

From: Brooks Jealous [mailto:dbj...@gm...] 
Sent: Sunday, March 19, 2017 7:07 PM
To: 'squ...@li...' <squ...@li...>
Subject: Squirrel - Importing - Part 02

 

Sorry – forgot one other obvious question. The mapping process can be tedious for tables with numerous columns – even with Suggest Columns checked, Squirrel does not populate the mapping list. 

 

1.       Is there a fix for the mapping issue above?

 

2.       Is there a template function, so that I can create standard templates for recurring imports…?

 

Thanks again,

 

Brooks

金布鲁克斯

 

+1 415.870.0962

 <mailto:dbj...@gm...> dbj...@gm...

 <http://www.linkedin.com/in/dbjdigitalconsultant> www.linkedin.com/in/dbjdigitalconsultant

 

滴水穿石

 

[Squirrel-sql-users] Squirrel - Importing - Part 02

[Brooks J. <dbj...@gm...>]

Sorry – forgot one other obvious question. The mapping process can be tedious for tables with numerous columns – even with Suggest Columns checked, Squirrel does not populate the mapping list. 

 

1.       Is there a fix for the mapping issue above?

 

2.       Is there a template function, so that I can create standard templates for recurring imports…?

 

Thanks again,

 

Brooks

金布鲁克斯

 

+1 415.870.0962

 <mailto:dbj...@gm...> dbj...@gm...

 <http://www.linkedin.com/in/dbjdigitalconsultant> www.linkedin.com/in/dbjdigitalconsultant

 

滴水穿石

 

[Squirrel-sql-users] Squirrel - Importing

[Brooks J. <dbj...@gm...>]

Hi

 

First time Squirrel user and I’m having a bit of trouble with the import function.

 

1.       I get a pop-up verification that all records in the target table will be deleted when I import. Seems a bit odd. Is there any flag / parameter that enables non-delete imports?

 

2.       Even though I don’t get an error, records are not successfully imported. The records are valid CSV and/or XLS files that have been previously tested with other SQL clients, so I’m confident that there are no formatting issues. Any thoughts / comments on the stability of the import function, or notes on common errors?

 

Many thanks in advance! 

 

Brooks 

金布鲁克斯

 

+1 415.870.0962

 <mailto:dbj...@gm...> dbj...@gm...

 <http://www.linkedin.com/in/dbjdigitalconsultant> www.linkedin.com/in/dbjdigitalconsultant

 

滴水穿石

 

[Squirrel-sql-users] Running out of memory when genreating SQL Server table data creation script in v.3.6

[Alex M. <ale...@bl...>]

So far I increased the memory size on the start command in the bat file to 1024m but java does not allocate anywhere near that - I get the error message

The query results have exceeded the maximum amount of memory allocated to this application.
All result tabs have been closed to allow you to save your work and restart the application.

when the process memory size is around 719m in the task manager. Also, I am not able to allow Squirrel use more than approximately 1240m of memory, it simply crashes on startup when I specify 1260, 1400 etc. Is there any workaround?  Does the data script generator really need to keep all data in memory? I am thinking that if there was an option to output the generated script straight to disk, there would be no need for this much memory.

Thank you!
Alex