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

[Squirrel-sql-users] Bad Creating SQL Script from existing table; DROP TABLE error

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

I connected successfully to an MySQL database then opened the OBJECTS tree, right clicked on a certain existing table and 
selected

Scripts->Create Table Script

As result the following DDL code is generated in SQL editor:

> CREATE TABLE tbl_test 
> (
>   id bigint PRIMARY KEY NOT NULL,
>  TOP_CHANGED_AT timestamp,
>   TOP_CHANGED_BY varchar(255),
>   TOP_CREATED_AT timestamp,
>   TOP_CREATED_BY varchar(255),
>   TOP_FINAL_TIMEOUT int 
> )
> ;
> CREATE UNIQUE INDEX PRIMARY ON tbl_test(id)
> ;


Now I simply change the table name and append a "2", then I let the script run:

>CREATE TABLE tbl_test2
> (
> id bigint PRIMARY KEY NOT NULL,
>   TOP_CHANGED_AT timestamp,
>   TOP_CHANGED_BY varchar(255),
>   TOP_CREATED_AT timestamp,
>   TOP_CREATED_BY varchar(255),
>   TOP_FINAL_TIMEOUT int
> )
> ;
>CREATE UNIQUE INDEX PRIMARY ON tbl_test2(id)
> ;

Much to my surprise I got errors:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right 
syntax to use near 
'PRIMARY ON tbl_test2(id)' at line 1
SQLState:  42000
ErrorCode: 1064
Error occured in:
CREATE UNIQUE INDEX PRIMARY ON tbl_test2(id)

So Squirrels seems NOT to produce valid DDL CREATE TABLE scripts from existing tables..

Whats wrong?

Furthermore if I try to execute a simple

DROP TABLE tbl_test;

I got the following error:

Error: Cannot delete or update a parent row: a foreign key constraint fails
SQLState:  23000
ErrorCode: 1217

Why is it impossible to drop the existing table (including index)?

I am using MySQL 64bit MySQL v5.6.10

Ben

[Squirrel-sql-users] Getting ClassNotFoundException concerning L&F

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

I was looking in the log to diagnose a SQL error I was getting, and I noticed this:
------------------
2013-05-13 07:59:35,747 [AWT-EventQueue-1] WARN  net.sourceforge.squirrel_sql.plugins.laf.LAFPlugin  - Failed to create empty required user files
2013-05-13 07:59:39,751 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData  - Unable to load LAF class (com.jtattoo.plaf.aluminum.AluminiumLookAndFeel):com.jtattoo.plaf.aluminum.AluminiumLookAndFeel
java.lang.ClassNotFoundException: com.jtattoo.plaf.aluminum.AluminiumLookAndFeel
	at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:266)
	at net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.putClass(JTattooLafData.java:82)
------------------

I'm not aware of any particular symptoms this is causing.

Re: [Squirrel-sql-users] Running (not all or all or partially) SQL/DDL statements in SQL editor

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

On Mon, 13 May 2013, Ben Stover wrote:

> Assume I have various SQL statements entered in the SQL editor pane.
>
> They are all delimited by a blank line.
>
> When I put now the cursor onto lets say the 3rd SQL statement (out of 5) 
> and press the "run" icon in the toolbar then all SQL statements from 
> cursor position downwards are executed.
>
> How can I let Squirrel only execute ONLY the SQL statement under the 
> current cursor position (until the next blank line) and stop then?

That is how it behaves for me with all the database platforms I use it 
with. A blank line is a delimiter, and it only executes one block of SQL 
as delimited by blank lines.

This can be annoying when you load an SQL script from a file and forget 
this limitation, or if you accidentally hit RETURN once too often in the 
middle of a query... :)

Be *VERY CAREFUL* of accidentally inserting a blank line before the WHERE 
clause of an UPDATE or DELETE query... :(

Squirrel will execute the code preceding the cursor if it's on a blank 
line after text (e.g. so you can type a query, hit [ENTER] reflexively, 
then hit [CTRL]-[ENTER] and it will still execute the query you just 
typed), but if your cursor is on a single blank line between queries, I'm 
not sure what happens - I usually separate queries by two or more blank 
lines to make selecting them a little easier.

I've *never* seen it execute from the cursor to the end of the file 
regardless of blank lines like you describe.

I don't know why it wouldn't be behaving this way for you. What database 
platform is this? Are all your options at the defaults? I suppose it's 
possible one of the SQL parsing options (query delimiter, perhaps?) got 
changed from the default and that's causing this behavior.

> How can I let Squirrel execute ALL SQL statements on pane regardless of 
> the current curosr position?

[CTRL]-A to select all, then execute.  [CTRL]-A, [CTRL]-[RETURN]

What is selected (highlighted) is what will be executed regardless of 
where the cursor is.

-- 
  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
-----------------------------------------------------------------------
   Drugs will always be around. Politicians are therefore making an
   active decision to distribute them through violent gangs. --Twitter
-----------------------------------------------------------------------
  347 days since the first successful private support mission to ISS (SpaceX)

Re: [Squirrel-sql-users] Running (not all or all or partially) SQL/DDL statements in SQL editor

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

Strange - when I do this, only the statement where the cursor is is executing (but I end all my statements with semicolon as well).
When I do not use blank line to separate statements, all are executed.
-- 
Alexandre Peshansky, MS
Senior 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, Bronx, NY 10461
(718) 430-2440 (Mo, Tu, Th, Fr)  (718) 920-4885 (We)


-----Original Message-----
From: Ben Stover [mailto:bxs...@ya...] 
Sent: Monday, May 13, 2013 12:44 AM
To: Squirrel SQL Users
Subject: [Squirrel-sql-users] Running (not all or all or partially) SQL/DDL statements in SQL editor

Assume I have various SQL statements entered in the SQL editor pane.

They are all delimited by a blank line.

When I put now the cursor onto lets say the 3rd SQL statement (out of 5) and press the "run" icon in the toolbar then all SQL statements from cursor position downwards are executed.

How can I let Squirrel only execute ONLY the SQL statement under the current cursor position (until the next blank line) and stop then?

How can I let Squirrel execute ALL SQL statements on pane regardless of the current curosr position?

Ben






------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. 
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Running (not all or all or partially) SQL/DDL statements in SQL editor

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

Assume I have various SQL statements entered in the SQL editor pane.

They are all delimited by a blank line.

When I put now the cursor onto lets say the 3rd SQL statement (out of 5) and press the "run" icon in the toolbar
then all SQL statements from cursor position downwards are executed.

How can I let Squirrel only execute ONLY the SQL statement under the current cursor position (until the next blank line) and stop 
then?

How can I let Squirrel execute ALL SQL statements on pane regardless of the current curosr position?

Ben

Re: [Squirrel-sql-users] Change font for SQL scripts?

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

Change it menu File/New sessionproperties/SQL tab.
An then start a new session

Erwan

Le 12/05/2013 11:35, Ben Stover a écrit :
> Is it possible to change the font (size, bold, fontfamily) for the SQL scripts?
>
> If yes: how exactly does it work? I foudn no global preference for that.
>
> Ben
>
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Change font for SQL scripts?

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

Is it possible to change the font (size, bold, fontfamily) for the SQL scripts?

If yes: how exactly does it work? I foudn no global preference for that.

Ben

Re: [Squirrel-sql-users] Getting driver for MySQL? 32bit Squirrel vs 64bit MySQL?

[Dennis B. <Den...@gm...>]

Hello Ben,

you can download the MySQL JDBC driver from 
<http://dev.mysql.com/downloads/connector/j/>. It does not matter if you 
run Squirrel with a 32 bit JVM and your MySQL server runs with 64 bit.


Cheers,
Dennis Benzinger

Am 12.05.2013 09:17, schrieb Ben Stover:
> I have to setup Squirrel (again) to access a 64bit MySQL database.
>
> After start of Squirrel I have to setup at first the MySQL driver.
> So clicked "Drivers" section and double-clicked on "MySQL Driver".
> A popup appears prompting me for the MySQL driver *.jar
> Where is the apropriate MySQL driver?
>
> Is it supplied with Squirrel (where exactly)?
> Is it supplied with MySQL (where exactly)?
> Or do I have to download it separately?
>
> Further question:
>
> Assume I use 32bit Squirrel and want to access a 64bit MySQL stand-alone server.
>
> Does this matter when selecting a MySQL driver?
>
> Thank you
> Ben
>
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] Getting driver for MySQL? 32bit Squirrel vs 64bit MySQL?

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

I have to setup Squirrel (again) to access a 64bit MySQL database.

After start of Squirrel I have to setup at first the MySQL driver.
So clicked "Drivers" section and double-clicked on "MySQL Driver".
A popup appears prompting me for the MySQL driver *.jar
Where is the apropriate MySQL driver?

Is it supplied with Squirrel (where exactly)?
Is it supplied with MySQL (where exactly)?
Or do I have to download it separately?

Further question:

Assume I use 32bit Squirrel and want to access a 64bit MySQL stand-alone server.

Does this matter when selecting a MySQL driver?

Thank you
Ben

Re: [Squirrel-sql-users] How to visually (!) load and save BLOB content into/from columns?

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

See the help in the section "Using the Popup Window" under "The Contents
tab and editing data"

Rob


On Tue, May 7, 2013 at 4:14 AM, Ben Stover <bxs...@ya...> wrote:

> I am searching for a way to visually (!) load and save BLOB content
> into/from columns.
>
> Visually means NOT programmatically through e.g. Java but with a GUI based
> tool like Squirrel.
>
> I expected e.g. a right-click context menu "load" for a certain BLOB
> column row which let me import a
> *.jpg image file directly from hard disc directory.
>
> I tried to find a solution with Toad for MySQL but was not successful.
> Unfortuantely there seems no such way in Toad for MySQL.
>
> What about Squirrel? Is this somehow possible?
>
> Thank you
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] How to visually (!) load and save BLOB content into/from columns?

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

I am searching for a way to visually (!) load and save BLOB content into/from columns.

Visually means NOT programmatically through e.g. Java but with a GUI based tool like Squirrel.

I expected e.g. a right-click context menu "load" for a certain BLOB column row which let me import a
*.jpg image file directly from hard disc directory. 

I tried to find a solution with Toad for MySQL but was not successful. 
Unfortuantely there seems no such way in Toad for MySQL. 

What about Squirrel? Is this somehow possible?

Thank you 

[Squirrel-sql-users] displaying columns of array type?

[James T. <jt...@sa...>]

Hello,
Does SQuirrel support the display of array type column values? For 
example, a schema like this:

CREATE TABLE sal_emp (
     name    text,
     pay_by_quarter    integer ARRAY[4],
     schedule              text ARRAY
);

How would the pay_by_quarter column values be displayed?

Regards,

James

Re: [Squirrel-sql-users] Renewed Password

[Ellary K. <Ell...@tr...>]

Change the password in the Alias you use to connect to the DB server.

 

Ellary Kahan
True Value Company 
Information Services
773-695-6045
ell...@tr...>>> Jeff Robinson <jro...@bl...>
5/2/2013 1:16 PM >>>

Hi,
I’m using SQuirreL 3.4.0 to access MS SQL Server 2005 using Windows
authentication.  When I first connected SQuirreL, it remembered the
password I used and nicely supplied it for me each time I connected. 
Now my password has changed, however SQuirreL still only remembers the
original.  Each time I have to overtype the old password.
 
Having it remember is a nice feature.  Is there somewhere that I can
change the password so that SQuirreL now recognizes the new one?
 
Thanks,
Jeff

Re: [Squirrel-sql-users] Renewed Password

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

It is stored in SQLAliases23.xml under .squirrel_sql directory in your personal data (Users\{your_name} on Windows 7 or "Documents and settings\{yourname}" on Windows XP).

-- 
Alexandre Peshansky, MS
Senior 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, Bronx, NY 10461
(718) 430-2440 (Mo, Tu, Th, Fr)  (718) 920-4885 (We)


From: Jeff Robinson [mailto:jro...@bl...] 
Sent: Thursday, May 02, 2013 2:16 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Renewed Password

Hi,
I'm using SQuirreL 3.4.0 to access MS SQL Server 2005 using Windows authentication.  When I first connected SQuirreL, it remembered the password I used and nicely supplied it for me each time I connected.  Now my password has changed, however SQuirreL still only remembers the original.  Each time I have to overtype the old password.

Having it remember is a nice feature.  Is there somewhere that I can change the password so that SQuirreL now recognizes the new one?

Thanks,
Jeff

[Squirrel-sql-users] Renewed Password

[Jeff R. <jro...@bl...>]

Hi,
I'm using SQuirreL 3.4.0 to access MS SQL Server 2005 using Windows authentication.  When I first connected SQuirreL, it remembered the password I used and nicely supplied it for me each time I connected.  Now my password has changed, however SQuirreL still only remembers the original.  Each time I have to overtype the old password.

Having it remember is a nice feature.  Is there somewhere that I can change the password so that SQuirreL now recognizes the new one?

Thanks,
Jeff

[Squirrel-sql-users] Load Oracle OCI Driver

[Dave M. <dmo...@gm...>]

Hello team,

I'm trying to enable Squirrel to load the Oracle OCI driver, I see it in the
drivers list with a red X next to it. I have downloaded the Oracle client
and have agreed to all its terms. Help?

Thank you

 

David Moore

Marketing & Product Development

Mobile: 717-715-5310

 

Re: [Squirrel-sql-users] "Connect timed out" error from mult drivers

[Justin T. <JU...@lo...>]

"Did your new PC come with any preinstalled security software? Third party firewall blocking outbound ports?"


Both machines are running our Trend Micro corporate anti-virus and Windows Firewall.  AFAIK, there are no other security programs running.  I discovered that my IBM Eclipse-based IDE has a SQL client, and I'm able to connect to DB2 thru it using the IBM JDBC driver.

[Squirrel-sql-users] "Connect timed out" error from mult drivers

[Justin T. <JU...@lo...>]

I installed SQuirreL SQL Client Version 3.4.0 on a new Win7 PC late last week.  I set up MS's SQL Server driver and IBM's JTOpen DB2 driver.  I am getting a "Connect timed out" error trying to connect to any DB.  I've tried two different Windows servers (SQL Server 2005 & 2008) and an IBM Power7.

I ran SQuirreL 3.2.1 on my WinXp machine and it worked fine.

Can anyone offer any suggestions?

[Squirrel-sql-users] sql editor blinks

[Daniel T. <dan...@is...>]

Hello,
I have started to use SquirrelSQL for a PostGresSQL database and looks very
nice! However I have a major problem and I did not find an answer on the
web.

The SQL editor blinks a lot each time I add a new line or I select the SQL
text.
With one line of SQL is not a big deal, but if I have 20 lines of SQL it
takes 5 seconds to refresh the text box!

My specs:
Java
java version "1.6.0_43"
Java(TM) SE Runtime Environment (build 1.6.0_43-b01-447-11M4203)
Java HotSpot(TM) 64-Bit Server

SquirrelLSQL Version 3.4.0

I have a mac 64bit retina display.

Do you have any clue what the problem could be?
Thanks in advance,
Daniel

-- 
Daniel Teixeira
Email: dan...@is...

Re: [Squirrel-sql-users] Does Squirrel communicate in clear text?

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

To further John's excellent explanation, I believe I have seen Oracle
documentation for "ssl-ifying" connections using PKI materials.  This is
likely accomplished using JDBC driver properties, which SQuirreL allows you
to set on each Alias (Right-click on alias, choose "Alias Properties" then
"Driver Properties" tab).  You should consult the vendor documentation from
whomever distributes your JDBC driver.

Rob


On Fri, Apr 19, 2013 at 8:56 PM, John Hardin <jh...@im...> wrote:

> On Wed, 17 Apr 2013, Gonyer, Lisa wrote:
>
> > I have been a fan of SQuirreL for almost 8 years.  However, in the
> > process of upgrading my laptop, I was informed by our IT team that they
> > can no longer install SQuirreL because they were informed it
> > communicates in clear text.  Can someone please direct me to
> > documentation (and where within) it states that communications is
> > encrypted or otherwise secure OR communication is in clear text?  I
> > would like to debunk the clear text argument so I can continue to use
> > this client.
>
> That depends almost entirely on the JDBC drivers that it uses to
> communicate with the database server.
>
> Which database server platform are you talking to? Check the vendor's page
> and see what they have to say (if anything) about encryption of network
> traffic in their JDBC client.
>
> If they say communication is in cleartext, there's nothing Squirrel can do
> about it, but then *any* Java database app talking to that database would
> have the same problem.
>
> If they say communication is encrypted, then it's encrypted.
>
> If they say encryption is optional and the client may choose to disable
> it, and encryption is controlled via the JDBC connect string, then it's
> under your control - use the right connect string! That's not specific to
> Squirrel.
>
> If they say encryption is optional and the client may choose to disable
> it, and it's controlled by standard JDBC API options (assuming there are
> such), then I'd expect to see an option somewhere in the Squirrel UI to
> enable or disable encryption. Is there an option like that? I haven't
> looked... This is the only case in which what Squirrel does, matters.
>
>
> That said, most insecure network protocols can be made secure using a
> package called stunnel, but that's a network-geekish solution that
> (ideally) requires access to install stunnel on the database server, and
> your IT team may balk at that solution. :)
>
> --
>   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
> -----------------------------------------------------------------------
>    Our government should bear in mind the fact that the American
>    Revolution was touched off by the then-current government
>    attempting to confiscate firearms from the people.
> -----------------------------------------------------------------------
>   Today: the 238th anniversary of The Shot Heard 'Round The World
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] MySQL result data cached?

[OpenDog <ope...@gm...>]

Hi fellow Squirrels!

Can somebody tell me why the result data from a MySQL server seems to be cached?
The table data is changed via another JDBC app. I keep seeing the same query results 
until I hit the commit button in SquirrelSQL. Then it changes. 

The MySQL command line utility shows the changes immediately. 

This isn't happening with other DBs like MSSQL. 

What settings I'm missing?

Thank you,
Dog

--
OpenDog
mo...@op...

Re: [Squirrel-sql-users] Does Squirrel communicate in clear text?

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

On Wed, 17 Apr 2013, Gonyer, Lisa wrote:

> I have been a fan of SQuirreL for almost 8 years.  However, in the 
> process of upgrading my laptop, I was informed by our IT team that they 
> can no longer install SQuirreL because they were informed it 
> communicates in clear text.  Can someone please direct me to 
> documentation (and where within) it states that communications is 
> encrypted or otherwise secure OR communication is in clear text?  I 
> would like to debunk the clear text argument so I can continue to use 
> this client.

That depends almost entirely on the JDBC drivers that it uses to 
communicate with the database server.

Which database server platform are you talking to? Check the vendor's page 
and see what they have to say (if anything) about encryption of network 
traffic in their JDBC client.

If they say communication is in cleartext, there's nothing Squirrel can do 
about it, but then *any* Java database app talking to that database would 
have the same problem.

If they say communication is encrypted, then it's encrypted.

If they say encryption is optional and the client may choose to disable 
it, and encryption is controlled via the JDBC connect string, then it's 
under your control - use the right connect string! That's not specific to 
Squirrel.

If they say encryption is optional and the client may choose to disable 
it, and it's controlled by standard JDBC API options (assuming there are 
such), then I'd expect to see an option somewhere in the Squirrel UI to 
enable or disable encryption. Is there an option like that? I haven't 
looked... This is the only case in which what Squirrel does, matters.


That said, most insecure network protocols can be made secure using a 
package called stunnel, but that's a network-geekish solution that 
(ideally) requires access to install stunnel on the database server, and 
your IT team may balk at that solution. :)

-- 
  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
-----------------------------------------------------------------------
   Our government should bear in mind the fact that the American
   Revolution was touched off by the then-current government
   attempting to confiscate firearms from the people.
-----------------------------------------------------------------------
  Today: the 238th anniversary of The Shot Heard 'Round The World

[Squirrel-sql-users] Does Squirrel communicate in clear text?

[Gonyer, L. <lg...@ep...>]

Hello,

I have been a fan of SQuirreL for almost 8 years.  However, in the process of upgrading my laptop, I was informed by our IT team that they can no longer install SQuirreL because they were informed it communicates in clear text.  Can someone please direct me to documentation (and where within) it states that communications is encrypted or otherwise secure OR communication is in clear text?  I would like to debunk the clear text argument so I can continue to use this client.

Thanks!


________________________________
This e-mail and files transmitted with it are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you are not one of the named recipient(s) or otherwise have reason to believe that you received this message in error, please immediately notify sender by e-mail, and destroy the original message. Thank You.

Re: [Squirrel-sql-users] Mac Icon

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

Ahhh, yes, the updater for Mac (and PC) may have this problem.  Perhaps you
could file a bug report and include the version details for old/new
squirrel and the Mac.  Thanks for running this to ground!

Rob


On Mon, Apr 8, 2013 at 5:07 PM, Matthew Dahlman <mda...@ja...>wrote:

> Er... I replied promptly. But GMail config settings gave me problems.
> Resending.
>
> Q: Does "INSTALL_PATH/Content/
> Resources/acorn.icns"?
> A: Yes.
>
> Q: "CFBundleIconFile" well-defined?
> A: Yes.
>
> But... that was exactly the clue I needed. There is something wrong with
> acorn.icns. I could tell right away that I could not preview the icns file
> in Finder. Normally this should be possible.
>
> I downloaded it directly from the git repo:
>
> http://sourceforge.net/p/squirrel-sql/git/ci/aa1b53077535b6e2fc640a02481ec8b1d1dd1491/tree/sql12/installer/squirrelsql-macosx-installer/src/main/resources/acorn.icns
>
> Then I replaced the old icon with the new one. You can see the extreme file
> size difference. Things immediately started working correctly. Hmm...
> hi-res acorn goodness.
>
> It seems that I had installed from an
> old squirrel-sql-3.2.0-MacOSX-install.jar that I had handy. Then I
> upgraded
> in place. So... I think we can safely assume it was an old problem. Nothing
> to worry about.
>
> I guess you could add a conceivable enhancement request to include the
> icons in the bits that get upgraded. But I doubt that makes it into the top
> 100 things you might add next.
>
> FYI, here's the good vs bad files:
> ls -l /Applications/SQuirreLSQL_3.2.app/Contents/Resources/
> total 960
> drwxr-xr-x  10 mdahlman  staff     340 Mar 26 20:21 Java
> -rw-r--r--@  1 mdahlman  staff  385339 Mar 27 22:10 acorn.icns
> -rw-r--r--   1 mdahlman  staff  100175 Nov 21  2010
> acorn_original(bad).icns
>
> Thanks a lot,
> Matt
>
>
> On Tue, Mar 26, 2013 at 8:20 AM, Robert Manning <
> rob...@gm...> wrote:
>
>> Matt,
>>
>> From the command-line, does this file exist ?
>>
>> INSTALL_PATH/Content/Resources/acorn.icns
>>
>> And in INSTALL_PATH/Contents/Info.plist, is "acorn.icns" listed as the
>> value for : "CFBundleIconFile" ?
>>
>> If the answer is yes to both of those questions, my guess is that maybe
>> Apple made a backward-incompatible change to the Info.plist file format.  I
>> don't have 10.7, so I can't verify that is the case.  Maybe looking through
>> their dev documentation for Info.plist would yield an answer.
>>
>> Rob
>>
>> On Tue, Mar 26, 2013 at 6:16 AM, Matthew Dahlman <mda...@ja...
>> > wrote:
>>
>>> I just installed SQuirreL SQL on a clean Mac (OS X 10.7 (Lion)). I don't
>>> get an icon like I used to have. I just have a default application icon.
>>> Bummer.
>>>
>>> Is this somehow user error? Are other folks experiencing the same thing?
>>> I see that this happened and got fixed a couple of years ago. Regression?
>>>
>>> Does anyone know how to manually add an icon? (I suppose I could
>>> probably google that up myself... but I don't know where to grab the
>>> SQuirreL SQL icon to get started.) Thanks for any tips.
>>>
>>> -Matt
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Own the Future-Intel&reg; Level Up Game Demo Contest 2013
>>> Rise to greatness in Intel's independent game demo contest.
>>> Compete for recognition, cash, and the chance to get your game
>>> on Steam. $5K grand prize plus 10 genre and skill prizes.
>>> Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
>>> _______________________________________________
>>> Squirrel-sql-users mailing list
>>> Squ...@li...
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>>
>>>
>>
>
>
> --
> Winner, InfoWorld Technology of the Year. See Why > <http://bit.ly/Xo6erX>
>

Re: [Squirrel-sql-users] Mac Icon

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

Er... I replied promptly. But GMail config settings gave me problems.
Resending.

Q: Does "INSTALL_PATH/Content/
Resources/acorn.icns"?
A: Yes.

Q: "CFBundleIconFile" well-defined?
A: Yes.

But... that was exactly the clue I needed. There is something wrong with
acorn.icns. I could tell right away that I could not preview the icns file
in Finder. Normally this should be possible.

I downloaded it directly from the git repo:
http://sourceforge.net/p/squirrel-sql/git/ci/aa1b53077535b6e2fc640a02481ec8b1d1dd1491/tree/sql12/installer/squirrelsql-macosx-installer/src/main/resources/acorn.icns

Then I replaced the old icon with the new one. You can see the extreme file
size difference. Things immediately started working correctly. Hmm...
hi-res acorn goodness.

It seems that I had installed from an
old squirrel-sql-3.2.0-MacOSX-install.jar that I had handy. Then I upgraded
in place. So... I think we can safely assume it was an old problem. Nothing
to worry about.

I guess you could add a conceivable enhancement request to include the
icons in the bits that get upgraded. But I doubt that makes it into the top
100 things you might add next.

FYI, here's the good vs bad files:
ls -l /Applications/SQuirreLSQL_3.2.app/Contents/Resources/
total 960
drwxr-xr-x  10 mdahlman  staff     340 Mar 26 20:21 Java
-rw-r--r--@  1 mdahlman  staff  385339 Mar 27 22:10 acorn.icns
-rw-r--r--   1 mdahlman  staff  100175 Nov 21  2010 acorn_original(bad).icns

Thanks a lot,
Matt


On Tue, Mar 26, 2013 at 8:20 AM, Robert Manning
<rob...@gm...>wrote:

> Matt,
>
> From the command-line, does this file exist ?
>
> INSTALL_PATH/Content/Resources/acorn.icns
>
> And in INSTALL_PATH/Contents/Info.plist, is "acorn.icns" listed as the
> value for : "CFBundleIconFile" ?
>
> If the answer is yes to both of those questions, my guess is that maybe
> Apple made a backward-incompatible change to the Info.plist file format.  I
> don't have 10.7, so I can't verify that is the case.  Maybe looking through
> their dev documentation for Info.plist would yield an answer.
>
> Rob
>
> On Tue, Mar 26, 2013 at 6:16 AM, Matthew Dahlman <mda...@ja...>wrote:
>
>> I just installed SQuirreL SQL on a clean Mac (OS X 10.7 (Lion)). I don't
>> get an icon like I used to have. I just have a default application icon.
>> Bummer.
>>
>> Is this somehow user error? Are other folks experiencing the same thing?
>> I see that this happened and got fixed a couple of years ago. Regression?
>>
>> Does anyone know how to manually add an icon? (I suppose I could probably
>> google that up myself... but I don't know where to grab the SQuirreL SQL
>> icon to get started.) Thanks for any tips.
>>
>> -Matt
>>
>>
>> ------------------------------------------------------------------------------
>> Own the Future-Intel&reg; Level Up Game Demo Contest 2013
>> Rise to greatness in Intel's independent game demo contest.
>> Compete for recognition, cash, and the chance to get your game
>> on Steam. $5K grand prize plus 10 genre and skill prizes.
>> Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>>
>


-- 
Winner, InfoWorld Technology of the Year. See Why > <http://bit.ly/Xo6erX>