GMX | 27 Jan 12:34 2015
Picon
Picon

Graph: relations of the foreign key of the tables

Hi,
I have installed Squirrel SQl Client 3.6 on Windows 8.1.
I am connecting to a Embedded Derby Database. All is ok.
I can also show the tables in the Graph.
But I can not see the "relations of the foreign key of the tables" in 
the Graph.

Please can you help me that i can see this relations in the Graph.

--

-- 
Mit freundlichen Grüßen
Hans-Georg Glöckler

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Chuck Brooks | 23 Jan 20:24 2015
Picon

explain plan


I do not see the explain plan option next to the results tab in the sql window. I am running 3.6 of Squirrel SQL and  would like to get a db2 explain plan. I have all the plug ins installed?

I would appreciate some help

Thanks
--
Dr. Chuck Brooks,  DM/IST
(586) 524-9180
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Stephen Cprek | 23 Jan 18:16 2015
Picon

Connecting to Gerrit H2 database

Hi,


I am trying to do the difficult task of migrating a H2 database to mariaDB for easier replication/master-slave config etc. After lots of researching I decided to give squirrel sql a try.

I was able to connect to my mariaDB.
I have an embedded H2 database running in a gerrit instance.
I got the jdbc driver working for H2 and can create an alias that successfully connects, but it seems like it's not actually connecting.

For testing purposes I copied my h2 db file into a local dir (say gerrit.h2.db)
I create an alias with H2 embedded and
URL: jdbc:h2:<fullpath>/gerrit.h2.db
un/pw can be blank or sa and no pw and it still connects?

When I actually look at it it's has the name, INFORMATION AND PUBLIC SCHEMA. However the PUBLIC schmea is completely empty and that's where the data is if I was to use gsql on the gerrit server.

If I look in my local dir I see a new file was created appending .mv.db???
gerrit.h2.db.mv.db

I don't know what to try next?

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
John Hardin | 23 Jan 17:28 2015

Squirrel vs. JVM 1.8.0_31

Folks:

Just auto-upgraded to Java 1.8.0_31, and now Squirrel is refusing to 
start, displaying a message that it requires at least 1.6. It worked fine 
yesterday before the upgrade.

Any workaround?

--

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jhardin <at> impsec.org    FALaholic #11174     pgpk -a jhardin <at> impsec.org
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
  Today: John Moses Browning's 160th Birthday

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Dariusz Chmaj | 13 Jan 15:03 2015
Picon

statementExecuting: and statementExecuted: in log window

Hi All,

 Is it possible to turn off information about statement execution in bottom log window? I need only information if query was executed and how many rows were updated. Additional informations make this information hard to find.

Thanks in advance,

Kind regards,
Dariusz
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
sandro | 30 Dec 21:45 2014
Picon

error message with squirrel version 3.5 and 3.6

I've installed squirrel 3.6 from sourceforge.net and it's gone all rigth.

When i start squirrel log shows the error:

 

2014-12-30 21:11:12,684 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################

2014-12-30 21:11:12,690 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - # Starting SQuirreL SQL Client Version 3.6 at 30/12/14 21.11

2014-12-30 21:11:12,690 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################

2014-12-30 21:11:12,694 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - SQuirreL SQL Client Version 3.6 started: Tue Dec 30 21:11:12 CET 2014

 

...............

 

2014-12-30 21:11:13,706 [AWT-EventQueue-1] WARN net.sourceforge.squirrel_sql.plugins.laf.LAFPlugin - Failed to create empty required user files

2014-12-30 21:11:13,900 [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:372)

at java.net.URLClassLoader$1.run(URLClassLoader.java:361)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:360)

at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)

 

....................................

 

In fact the correct class name is com.jtattoo.plaf.aluminium.AluminiumLookAndFeel

and not com.jtattoo.plaf.aluminum.AluminiumLookAndFeel)

This error is also in the 3.5.0 release.

Sandro Penzo

------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
BESANÇON Ludovic | 19 Dec 15:29 2014
Picon

Silent installation

Hi,

I use the script generate at the end of the GUI installation to install silently Squirrel.
But ...
The icons in the start menu are always in the current user and not for all users.
I try to change in the xml the "option" CreateForAll from false to true.
But it seems that this option is not read.

Thank you for your help.

Ludovic Besançon
Ludovic.Besancon <at> Besse.fr<mailto:Ludovic.Besancon <at> Besse.fr>
www.besse.fr<http://www.besse.fr/>

*  02 40 41 49 00

**************************************************************************************************************************************************
Pour des raisons de sécurité, il est prudent de considérer qu'une demande de garantie d'assurance, de
prise d'effet de garantie, ou de déclaration de sinistre, n'aura été prise en compte qu'à partir du
moment où elle aura donné lieu à une réponse personnalisée du destinataire (à l'exclusion donc de
tout procédé automatique d'accusé de réception ou de lecture).
For security reasons, it is wise to consider that a request for insurance coverage, inception or claims
notification, will be considered as agreed only upon receipt of a  personalised reply from the addressee
(your contact) and not an automatic reply acknowledging receipt or that the document has been read. 
**************************************************************************************************************************************************


------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Gisella Saavedra | 4 Dec 18:51 2014
Picon

mac version change font of sql result data


I have a Mac version, I do not see whether the L&F plugin is doing something.
I do not see it listed either.
How can I change the font of the result set?


From my Android phone.
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
P Shah | 23 Nov 23:25 2014
Picon

Problem installing SQuirreLSQL app on Mac Osx.....

I am trying to install the latest version (3.6) 

java -jar squirrel-sql-3.6-MACOSX-install.jar

java -version
java version "1.8.0_25"
Java(TM) SE Runtime Environment (build 1.8.0_25-b17)
Java HotSpot(TM) 64-Bit Server VM (build 25.25-b02, mixed mode)

The app installs but when i launch it - it seems to be stuck trying to download something (progress bar at the bottom keeps resetting).
 
I see this in the log

2014-11-23 17:15:05,601 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.gui.SquirrelSplashScreen  - No SplashScreen availabe
java.lang.NullPointerException: No SplashScreen availabe. Please check VM parameter -splash:
at net.sourceforge.squirrel_sql.client.gui.SquirrelSplashScreen.<init>(SquirrelSplashScreen.java:41)
at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:215)
at net.sourceforge.squirrel_sql.client.Main$2.run(Main.java:118)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:744)
at java.awt.EventQueue.access$400(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:697)
at java.awt.EventQueue$3.run(EventQueue.java:691)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:714)
at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

I did not select any drivers or plugins. 

Please let me know if this can be solved.....

Thanks, Purvi.
pps2010 <at> yahoo.com


------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
hany bardissi | 21 Nov 06:02 2014
Picon

Re: 11/21/2014 5:02:37 PM y

http://duygudogan.com/hslor/izafdqdamseravmqtgul.oaukjudwcljwavioqvdbmltuq






















hany bardissi
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Jason Delli Santi | 14 Nov 16:43 2014

Updated SQuirreL SQL version 3.6 snapshot 20141108_2236 + Java 1.8 JDBC/ODBC bridge no longer exists or working

I updated my java version (windows 7 32 bit) to 1.8 and updated Squirrel to 3.6 snapshot 20141108_2236. The JDBC/ODBC bridge is not working and it looks like it is no longer there (or Squirrel cannot find it).  Any ideas on how to fix? I do utilize DB-specific drivers for most connections but still use the JDBC/ODBC bridge for alot.

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Gmane