headers
Roman Denisov | 11 Jun 2013 23:00
Picon

New line character setting in sql editor

Hello!

Please advise, does squirrel sql editor has new line character setting? (for example, choose line ending between CR, CRLF, LF characters)?

Problem is that following script gives different results on different platforms (Linux, Windows), because different EOL characters are used:

-- (mssql 2008)
DECLARE <at> new_line nvarchar(2) = '
'

SELECT 'Current EOL character is: '+CASE <at> new_line WHEN CHAR(10) THEN 'LF' WHEN CHAR(13) THEN 'CR' WHEN CHAR(10)+CHAR(13) THEN 'CRLF' ELSE 'OTHER' END

Is there any way to configure EOL character to be used in script editor?

Thank you!

Roman



-- Роман 
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 0 comments |
headers
Matt F | 10 Jun 2013 14:36
Picon
Favicon

Slowness in 3.5?

Running 3.5 on Java 7 U 21 and I can't help but notice it seems slower than 3.4...While the timer function is nice, it looks like for the first 3-4 seconds it's not actually running the query. An extreme example is a query I run daily over a tbale to give me entries from the last 24 hours. Yesterday that query ran on 3.4 in about 15-20 seconds and returned 9 hits. Today, it took 199 seconds on 3.5.0 (the timer didn't even start for a good 20-30 seconds) and only returned one hit. The amount of hits were both expected

In an unrelated question (and I can open a separate thread on this if needed) is how to persist session properties, specially the 'load columns in background' setting


Thanks for all your help

Matt

 
==============================================
Matt Ferreira
defjab <at> yahoo.com

------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 0 comments |
headers
Slavomir Kocka | 3 Jun 2013 13:54
Picon

MacOS X upgrade error

Hi,

After automated upgrade from 3.4 to 3.5 I found out, that squirrel no longer starts... Icon just shows up,
and then dissapears...
So I executed Squirrel from commnad line, and found this:

Exception in thread "main" java.lang.NoClassDefFoundError: net/sourceforge/squirrel_sql/fw/util/log/ILoggerFactory
	at java.lang.Class.getDeclaredMethods0(Native Method)
	at java.lang.Class.privateGetDeclaredMethods(Class.java:2451)
	at java.lang.Class.getMethod0(Class.java:2694)
	at java.lang.Class.getMethod(Class.java:1622)
	at sun.launcher.LauncherHelper.getMainMethod(LauncherHelper.java:494)
	at sun.launcher.LauncherHelper.checkAndLoadMain(LauncherHelper.java:486)
Caused by: java.lang.ClassNotFoundException: net.sourceforge.squirrel_sql.fw.util.log.ILoggerFactory
	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 java.lang.ClassLoader.loadClass(ClassLoader.java:423)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
	... 6 more

Any idea, how to get tool working again?

Thanks.

Slavomir Kocka
------------------------------------------------------------------------------
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 <2% overhead.
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap2
Permalink | Reply | 2 comments |
headers
Ben Stover | 29 May 2013 05:54
Picon
Favicon

Re: How to visually (!) load and save BLOB content into/from columns?

Hmm, thank you for the suggestion but there is no description of inserting external images through Popup window.

At least on web page:
http://tienbas.free.fr/Logitek/squirrel-sql-2.6.3-standard/SQuirreL%20SQL%20Client/doc/quick_start.html#UsingPopup

The popup window shows an "Export" but NO expected "Import" button.
Any other way (e.g. by cut and paste through clipboard or by drag&drop) does not work.

So any other suggestion?


--Original Message Text---
From: Robert Manning
Date: Thu, 9 May 2013 07:50:31 -0400

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 <bxstover <at> yahoo.co.uk> 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
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users








------------------------------------------------------------------------------
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 <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 <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 0 comments |
headers
Wolfgang Kluge | 26 May 2013 15:26

Firebird Connection String

Good evening.

I will be grateful if sombody could tell me what is wrong with the 
following connection string:

jdbc:firebirdsql:localhost:3050:c:\fbdata\frontdesk.fdb

Firebird 1.5.6  on Win XP SP3

I found may contradicting versions but could not get any one to work.

Thanks in advance.

Wolfgang Kluge

------------------------------------------------------------------------------
Try New Relic Now & 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, & 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
Permalink | Reply | 2 comments |
headers
urbanmojo | 25 May 2013 11:32
Picon

Oracle Disconnect

I'm working with Squirrel 3.4.0 connecting to Oracle over a shaky VPN
connection using the Oracle Thin JDBC driver.

I've noticed that even if Squirrel is sitting idle for some time and, during
that time, I lose connection to the database and then come back and try to
run a query that it doesn't run and I get something like a "closed
connection error". (even though I currently do have connectivity when
attempting to run it). 

The only way I see is to close my query window and reconnect to the alias. 

Question 1:
1. Is this an issue with Squirrel, the driver, or Oracle?
2. Any way around this?

Thanks!

--
View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Oracle-Disconnect-tp3169.html
Sent from the Users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Try New Relic Now & 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, & 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
Permalink | Reply | 2 comments |
headers
Ellary Kahan | 23 May 2013 21:29

DB2 App Driver Error

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 <at> truevalue.com 
------------------------------------------------------------------------------
Try New Relic Now & 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, & 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 <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 0 comments |
headers
Ben Stover | 23 May 2013 08:51
Picon
Favicon

Let Squirrel auto-remember current SQL commands and column widths at exit?

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 New Relic Now & 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, & 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
Permalink | Reply | 2 comments |
headers
Ben Stover | 17 May 2013 09:40
Picon
Favicon

Auto-closing session at exit without prompt? Auto-connecting for Alias

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
Permalink | Reply | 2 comments |
headers
Peter Dow | 14 May 2013 21:20
Favicon

Unable to connect to IBM DB2 for LUW v10.1 using JDBC driver 3.65.77

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:<dbname>
    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 open an SQL connection."

and clicking on the Stack Trace button, I see:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Unable to create connection. Check your URL.
    at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
    at java.util.concurrent.FutureTask.get(Unknown Source)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.sql.SQLException: Unable to create connection. Check your URL.
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
    ... 6 more
Caused by: java.sql.SQLException: Unable to create connection. Check your URL.
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:136)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
    ... 8 more

I am able to start an IBM DB2 command line processor window and connect to MIRdb using the same userid and password.

Am I missing something obvious?

Peter Dow, IT Specialist
Montessori In Redlands
909 793-9050 

------------------------------------------------------------------------------
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
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 2 comments |
headers
Colin Graham | 14 May 2013 16:39
Picon
Favicon

Objects list Sequence is Case Sensitive

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 <at> Enterprise.plc.uk

Web           | www.Enterprise.plc.uk

 

Enterprise

Lancaster House, Centurion Way, Leyland, Lancashire, PR26 6TX

Enterprise: Maintaining the Infrastructure of the UK

 



*******************************************************************************

Please consider the environment before printing this e-mail.

This email is confidential and is intended solely for the use of the individual to whom it is addressed.
Any views or opinions expressed are solely those of the author and do not necessarily represent those
of Enterprise. If you are not the intended recipient of this email, please inform the sender immediately
and delete this email from your system. If that is the case, you must not use, copy or disclose any part
of this email for any purpose.

Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this e-mail,

the company cannot accept responsibility for any loss or damage arising from the use of this e-mail or its contents.

As internet connections are capable of data corruption no responsibility is accepted for changes made to this

message after it was sent.

For this reason it may be inappropriate to rely upon the contents without obtaining written confirmation.

Enterprise PLC, registered in England at Lancaster House, Centurion Way, Leyland, Preston, Lancashire, PR26 6TX.

Registered No 6134591.  

********************************************************************************

------------------------------------------------------------------------------
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
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 0 comments |

Gmane