http://permalink.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://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2546 <pre> Add a feature request for the ability to enter a filename as part of a connection alias, with Squirrel autoloading that file when the connection is opened and saved when the connection is closed. There is autosize, which is nice until you deal with a varchar(2000) column... is that close enough? </pre> John Hardin 2013-05-23T19:30:40 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2545 <pre>When trying to set up the extra class path for the DB2 App Drover I get this error: Error registering driver: IBM DB2 App Driver. Error: java.lang.UnsatisfiedLinkError: Native Library C:\Program Files\IBM\SQLLIB\BIN\db2jdbc.dll already loaded in another classloader SQLState: null ErrorCode: 0 What does this mean? Thanks. Ellary Kahan True Value Company Information Services 773-695-6045 ellary.kahan&lt; at &gt;truevalue.com ------------------------------------------------------------------------------ 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_may_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users&lt; at &gt;lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-us</pre> Ellary Kahan 2013-05-23T19:29:05 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2544 <pre> Ben, SQuirreL saves all queries/SQL commands in the History as they are executed. Don't blame the screwdriver that it is a bad hammer! So how should SQuirreL know what columns settings to use? By SQL? You are, supposedly, data analyst; can you imagine a data structure that can be used for that? I routinely use SQL commands that run into several pages of the text - how unwieldy are you willing to make the settings to satisfy your wish? And what if you changed something in the command, e.g., added or changed WHERE clause or ORDER BY clause? Do you expect SQuirreL to analyze your SQL commands to distinguish between this changes and changes in the structure of the result? Be careful what you wish for - you may end up with Microsoft Windows ;-) </pre> Alexandre Peshansky 2013-05-23T14:58:24 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2543 <pre>1.) Assume I established a connection to a MySQL database and entered some (a lot) of SQL commands in the SQL editor pane/tab. Now I close the session resp. exit whole Squirrel. After a later restart all the previously entered SQL commands in the SQL pane/tab are vanished. Is there a way to tell SQuirrel to remember all current SQL commands and automatically re-show them in the SQL editor pane/tab just as if I would never had exit Squirrel? No, I don't want to save them explicitely/manually. The save should take place automatically! 2.) Similarly I adjusted the column widths in the "Result" tab of a previously executed SQL command. After a close session resp exit and restart all the columns widths are initially much too wide. All my customized column widths are forgotten. Can I somehow tell Squirrel to automatically rememeber the column widths and re-adjust the columns in each result tab accordingly? Thank you Ben ------------------------------------------------------------------------------ Try</pre> Ben Stover 2013-05-23T06:51:10 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2542 <pre> That would be platform-dependent. Check your DBMS SQL syntax documentation. Generally speaking, no, it's not likely. The easier it is to automate destroying things, the easier it is to accidentally destroy things you don't want destroyed. Again, platform-dependent. However, Squirrel does provide metadata (schema) information on one of the tabs. Look there. I don't know if that includes FKs, I'm not in a position to check at the moment. </pre> John Hardin 2013-05-22T14:31:55 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2541 <pre>Ok, thank you. Regarding the DROP TABLE command one more question: Is there an advanced DROP command which allow me to enforce a drop a table WITH all depending objects? Or is this not possible because I always have to specify this already at creation time e.g. with a CREATE TABLE .... ON CASCADING DELETE; option? How do I find out which objects (INDEXES...) depend from a TABLE? Ben --Original Message Text--- From: Cristiano Guadagnino Date: Tue, 14 May 2013 09:30:31 +0200 Hi Ben! The problem in your DDL script is the name of the index. This is your script: CREATE UNIQUE INDEX PRIMARY ON tbl_test2(id) This means you want to create an index named "PRIMARY" on the table tbl_test2. But an index named "PRIMARY" already exists on the table tbl_test. Tipically the name of indexes must be unique at the database level, so you have to change the name of the new index. Regarding your DROP instruction, the problem is that you have referential integrity constraints on that table. The table is a par</pre> Ben Stover 2013-05-22T07:56:36 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2540 <pre>Ben, It is possible to disable the confirmation dialog. File menu &gt; Global Preferences &gt; General tab &gt; General panel on right side &gt; Confirm Session Close This is where I find the option in v.3.2.1. ------------------------------------------------------------------------------ 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> Jacob L. Galley 2013-05-17T21:47:48 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2539 <pre>I am not sure that disabling a confirmation dialog is such a good idea - I don't know about you, but I did click on the wrong "close" icon occasionally. As for automatically connecting to the alias, just check the box "Auto logon" on the "Modify Alias" page. </pre> Alexandre Peshansky 2013-05-17T14:05:23 http://permalink.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://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2537 <pre>Thanks Marcin. I wasn't sure what the difference between the App and Net drivers was. I tried the Net driver again, with the Extra Classpath you specified, and I got closer. Now it's failing because of a user/pswd problem: java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][2013][11249][4.15.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000 I tried using db2admin, both with the password I changed it to have in Active Directory and the default of db2admin; I also tried the Administrator userid/pswd. I realize this is not strictly a Squirrel SQL Client issue, but I'm new to both it and DB2 for LUW. I'm more used to DB2 for i. On 5/15/2013 5:59 AM, Marcin Krol wrote: ------------------------------------------------------------------------------ AlienVault Unified Security Management (USM) platform delivers complete security visibility with the</pre> Peter Dow 2013-05-16T20:45:29 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2536 <pre>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello Peter, I'm not sure that app driver even works well enough or it is updated. Around here (big blue) everybody I know is using net driver. IBM DB2 Net Driver example url: jdbc:db2://&lt;server&gt;:&lt;6789&gt;/&lt;db-name&gt; website: http://www-306.ibm.com/software/data/db2 extra classpath contains: db2jcc4.jar, db2jcc_license_cu.jar class name: com.ibm.db2.jcc.DB2Driver Above settings have worked for me for every 10.1 instance I worked with. Regards, Marcin Krol Peter Dow wrote: -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJRk4aVAAoJEFMgHzhQQ7hO3BIH/A+clPY4cSwNpFC6tI6mHvIY UnvAA1/AeCGfuNNdFyXWdWwaYx/1htz4jtu5EoSox7g3sT3p1g/uQu8sc/QVIrZo Dj5kU9LlfSNxOoeuOG8agk3CX1DDIBKW1m7y9eVsVq/bPvA7TefDWi2JwZsFkgOJ zBRVbRvgrpWUTKL/YZxIvBHFQFAsAGSUY2bhh0UE4X0vMC7AgWBKrpxP8/GAoPnT +SiPrmAs32PyVv3mfI82/1z7q8lK0IgqM9NBaAhITHwXTuX/UlSUDuNA+wYMIC7C wP3Bj2IFIwS42g45SGIQTINj7Lk080W5RMaOZHn</pre> Marcin Krol 2013-05-15T12:59:01 http://permalink.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://permalink.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://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2533 <pre>Hi Ben! The problem in your DDL script is the name of the index. This is your script: CREATE UNIQUE INDEX PRIMARY ON tbl_test2(id) This means you want to create an index named "PRIMARY" on the table tbl_test2. But an index named "PRIMARY" already exists on the table tbl_test. Tipically the name of indexes must be unique at the database level, so you have to change the name of the new index. Regarding your DROP instruction, the problem is that you have referential integrity constraints on that table. The table is a parent in the constraint, so you cannot drop it. You should learn a bit on referential integrity to understand what's going on. Basically, you have a link between one of more child table and a parent table, so that some of the data in the child tables depend on the data present in the parent table. When you create those links, you can specify to the DBMS what it should do when someone tries to invalidate the link (e.g. by deleting one row in the parent table). You have various possible actions;</pre> Cristiano Guadagnino 2013-05-14T07:30:31 http://permalink.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://permalink.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://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2530 <pre> 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 b</pre> John Hardin 2013-05-13T14:44:12 http://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2529 <pre>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. </pre> Alexandre Peshansky 2013-05-13T14:02:10 http://permalink.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://permalink.gmane.org/gmane.comp.db.squirrel-sql.users/2527 <pre>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 : ------------------------------------------------------------------------------ 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> Erwan Duroselle 2013-05-12T15:57:04 http://permalink.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 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.squirrel-sql.users