http://blog.gmane.org/gmane.comp.db.squirrel-sql.users hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2538 <pre>Assume I have a running (MySQL) database session Now I click File-Exit (or the "close" button in window). I am prompted then "Are you sure you want to close the session ..... YES NO" How can disable the prompt and let Squirrel automatically close possibly open sessions sessions? This prompt appears as well if I do not exit but just close the session. The prompt should be disabled here as well. Simlarly when I double-click on an Alias the connect shout take place AUTOMATICALLY. Currently I have to manually to click on the "Connect" button. Ben ------------------------------------------------------------------------------ AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d </pre> Ben Stover 2013-05-17T07:40:45 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2535 <pre>I've created an IBM DB2 database named MIRdb, and then tried to connect to it using the Squirrel SQL Client version 3.4.0. The driver is: Name: IBM DB2 App Driver Example URL: jdbc:db2:&lt;dbname&gt; Class Name: COM.ibm.db2.jdbc.app.DB2Driver Extra Class Path: C:\Program Files\IBM\SQLLIB\java\db2java.zip C:\Program Files\IBM\SQLLIB\java\db2jcc.jar C:\Program Files\IBM\SQLLIB\java\db2jcc4.jar C:\Program Files\IBM\SQLLIB\java\sqlj.zip C:\Program Files\IBM\SQLLIB\java\sqlj4.zip C:\Program Files\IBM\SQLLIB\BIN (my understanding is that I only need the db2java.zip, but I included the rest when it didn't work) The alias is: Name: MIRdb Driver: IBM DB2 App Driver (which as a check mark indicating it was loaded) URL: jdbc:db2:MIRdb User name: db2admin Password: When I try to connect to the alias, I enter the password, click the Connect button and get an Error window stating: "Unexpected Error occurred attempting to o</pre> Peter Dow 2013-05-14T19:20:58 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2534 <pre>Hello All, I've been using Squirrel SQL for about 9 months now to access Sybase databases and I'm generally very happy with it, but one aspect that would really improve things for me is the display sequence of tables in the Object tab. At our installation all of our databases are configured as case insensitive but the Squirrel SQL seems to adhere strictly to case sensitive, thus giving me two completely separate lists to work with - e.g. tables with the names of Order and order_items are not adjacent to each other in the list. Is it possible to make the table lists case insensitive? I've asked this before and not had a reply - can I assume from that that this is not possible? Regards Colin Graham Colin Graham | Group IT | BI Developer Telephone | +44 (0)1772 819718 Internal | x22718 Email | Colin.Graham&lt; at &gt;Enterprise.plc.uk Web | www.Enterprise.plc.uk Enterprise Lancaster House, Centurion Way, Leyland, Lancashire, PR26 6TX Enterprise: Maintaining the Infrastructure of the UK </pre> Colin Graham 2013-05-14T14:39:56 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2532 <pre>I connected successfully to an MySQL database then opened the OBJECTS tree, right clicked on a certain existing table and selected Scripts-&gt;Create Table Script As result the following DDL code is generated in SQL editor: Now I simply change the table name and append a "2", then I let the script run: 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 </pre> Ben Stover 2013-05-14T06:00:51 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2531 <pre>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) </pre> KARR, DAVID 2013-05-13T15:11:22 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2528 <pre>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 </pre> Ben Stover 2013-05-13T04:43:38 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2526 <pre>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 </pre> Ben Stover 2013-05-12T09:35:46 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2524 <pre>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 </pre> Ben Stover 2013-05-12T07:17:15 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2522 <pre>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 </pre> Ben Stover 2013-05-07T08:14:19 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2521 <pre>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 ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite It's a free troubleshooting tool designed for production Get down to code-level detail for bottlenecks, with &lt;2% overhead. Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap2 </pre> James Taylor 2013-05-03T23:39:53 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2518 <pre>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 ------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with &lt;2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/l</pre> Jeff Robinson 2013-05-02T18:16:13 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2516 <pre>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 &amp; Product Development Mobile: 717-715-5310 ------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with &lt;2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users </pre> Dave Moore 2013-05-01T20:51:18 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2514 <pre>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 &amp; 2008) and an IBM Power7. I ran SQuirreL 3.2.1 on my WinXp machine and it worked fine. Can anyone offer any suggestions? ------------------------------------------------------------------------------ Try New Relic Now &amp; We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, &amp; servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users </pre> Justin Taylor 2013-04-29T18:14:07 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2513 <pre>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 </pre> Daniel Teixeira 2013-04-29T09:33:06 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2511 <pre>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 mojo&lt; at &gt;opendog.org ------------------------------------------------------------------------------ Try New Relic Now &amp; We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, &amp; servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/lists/list</pre> OpenDog 2013-04-23T22:33:25 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2509 <pre>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 t</pre> Gonyer, Lisa 2013-04-17T21:23:27 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2503 <pre> hi there, i use squirrel sql client v3.4.0. When i query one of my tables, i see some cells are shown in different color. I do not understand why those cells are shown in different color. It happens only that column and not on any other columns. This column has multi-line texts. Is this reason why squirrel shows those cells in a different color? thanks, red hunt ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users </pre> harish gokul 2013-04-04T18:59:52 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2498 <pre>Hi,  I just installed the Squirrel 3.4.0 on my 64-bit Windows 7 machine, but I have trouble connecting to the Microsoft Access database on my local drive. Anyone can help with this? Thank you very much.  SW------------------------------------------------------------------------------ Own the Future-Intel&amp;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 Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users </pre> Wang Xueyan 2013-03-26T19:55:24 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2496 <pre>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&amp;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 Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sour</pre> Matthew Dahlman 2013-03-26T10:16:54 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2495 <pre>Hi, I installed the squirrel 3.4.0 on my Windows 7 64 bit machine, but I don't know how to connect it to the MS Access 2013 database on a shared drive. I couldn't find any instruction to set it up, anyone can share the experience? Thank you very much. ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users </pre> River Front 2013-03-22T16:34:57 http://comments.gmane.org/gmane.comp.db.squirrel-sql.users/2494 <pre>List, This is a follow-up email to my post from yesterday where I was having difficulty using the KEYTOOL command to import some certificates. I was able to skirt that problem by creating a new keystore for my certificates instead of importing them to an existing keystore. I am trying to get the JDBC connection to the IBM System I to use SSL. The next step is to add "secure=true;" to the connection string but there also must be a way to instruct SQuirreL to use my keystore and where it can be found. Can someone point me in the right direction? Will I need to make this change to the squirrel-sql.bat file or are there additional changes needed to the connection string? Thanks in advance! Michael Rosinger Manager of Application Development Computer Credit Inc | 336.761.1524 www.ccicollections.com&lt;http://www.ccicollections.com/&gt; | www.md-collect.com&lt;http://www.md-collect.com/&gt; ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your w</pre> Michael Rosinger 2013-03-22T11:09:30 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.squirrel-sql.users