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

[Squirrel-sql-users] Question on ERROR

[Savoy, M. <Mel...@te...>]

I just installed the latest updates to my SQuirreL installation via the UPDATE function.

I got the following error after I restarted SQuirreL:

Error occured in IPlugin.sessionCreated() for SQL Validator plugin

Stack Trace:

java.lang.NoClassDefFoundError: org/apache/axis/encoding/DeserializerFactory
        at net.sourceforge.squirrel_sql.plugins.sqlval.WebServiceSessionProperties.<init>(WebServiceSessionProperties.java:52)
        at net.sourceforge.squirrel_sql.plugins.sqlval.SQLValidatorPlugin.sessionCreated(SQLValidatorPlugin.java:228)
        at net.sourceforge.squirrel_sql.client.plugin.PluginManager.sessionCreated(PluginManager.java:157)
        at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:372)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:93)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.ClassNotFoundException: org.apache.axis.encoding.DeserializerFactory
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
        ... 13 more
After I click the CLOSE button on the dialog box that shows the error I can get to the normal SQuirreL screen and run my queries but I just encounter the error above when starting the program.  Any suggestions on how to fix would be appreciated.

Regards.



Melinda Savoy
Sr. Programmer Analyst, ERP Systems
Innovative Technology Solutions
Texas Health Resources
600 E. Lamar Blvd, Ste 301, Arlington TX  76011
Mel...@te...<mailto:Mel...@te...>

Texas Health Resources: Arlington Memorial,
Harris Methodist and Presbyterian Hospitals
A shared mission and now a shared name.





The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from disclosure under applicable law.  If you are not the intended recipient, you are prohibited from copying, distributing, or using the information.  Please contact the sender immediately by return e-mail and delete the original message from your system.

[Squirrel-sql-users] sql result table is not readable and problem with update statement for DB2 database

[arihan <ari...@gm...>]

Hi All,

FOR DB2 database
=============
When I am executing the sql command as SELECT * FROM STM.LOAN where ID =
72000695; and try to edit the sql results table it doesnot allow me. 

I've sql results as editable table in new session properties -> Genral .
Also even if you don't make it editable then you can right click on the
column and it would give me the option to make editable. I tried both and it
doesn't work

Could you please let me know if I am facing this problem. 
When I click the objects -> table name > content tab and try to edit it then
it works fine. It gives me "make editable" option by right click on the
column.

Actually I am trying to use the update statement by taking different
combinations

UPDATE STM.LOAN SET ADDRESS = 'XYZ' WHERE ID = 72000695;
UPDATE "STM"."LOAN" SET ADDRESS = 'XYZ' WHERE ID = 72000695;
UPDATE STM.LOAN A SET A.ADDRESS = 'XYZ' WHERE A.ID = 72000695;

it gives the error as 
Error: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501,
SQLERRMC=APPTEST;UPDATE;STM.LOAN, DRIVER=3.50.152
SQLState:  42501
ErrorCode: -551

Is anything wrong in the syntax of update statement. Any quick help would be
highly appreciable.

Cheers
Arihan

-- 
View this message in context: http://old.nabble.com/sql-result-table-is-not-readable-and-problem-with-update-statement-for-DB2-database-tp32097939p32097939.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Unable to see stored procedure

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

Read access is required to the following system views in order for this
additional functionality to work correctly:

   - informix.sysfragments
   - informix.sysindices
   - sysmaster:informix.sysptnhdr
   - informix.sysprocbody
   - informix.sysprocedures
   - informix.systables
   - informix.systriggers
   - informix.systrigbody
   - informix.sysviews

In particular, for stored procedures, the following query is run:

SELECT T1.procid, T2.data, T2.seqno
FROM informix.sysprocedures AS T1, informix.sysprocbody AS T2
WHERE procname = ?
AND T2.procid = T1.procid
AND datakey = 'T'
ORDER BY T1.procid, T2.seqno

My guess is you don't have access to informix.sysprocedures or
informix.sysprocbody.

Rob

On Tue, Jul 5, 2011 at 6:58 PM, Chris Yeo (cyeo) <cy...@ci...> wrote:

>  Hi,****
>
> ** **
>
> I’ve installed Squirrel SQL Client 3.2.1 with Informix plugin. When I
> connect to the Informix DB,  I can see the tables but I can’t see the stored
> procedures. Appreciate any suggestion.****
>
> ** **
>
> Thx.****
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

[Squirrel-sql-users] Unable to see stored procedure

[Chris Y. (cyeo) <cy...@ci...>]

Hi,

 

I've installed Squirrel SQL Client 3.2.1 with Informix plugin. When I
connect to the Informix DB,  I can see the tables but I can't see the
stored procedures. Appreciate any suggestion.

 

Thx.

[Squirrel-sql-users] Saving Object tree filters

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

How do I save the object tree filters? I've set them up and clicked File>Save preferences but they aren't saved. 
I now have Win7. In WinXP they were saved. I am running Squirrel as administrator.
 

Ellary Kahan
True Value Company 
Information Services
773-695-6045
ell...@tr...

[Squirrel-sql-users] Saving Object tree filters

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

How do I save the object tree filters? I've set them up and clicked File>Save preferences but they aren't saved. 
I now have Win7. In WinXP they were saved. I am running Squirrel as administrator.
 

Ellary Kahan
True Value Company 
Information Services
773-695-6045
ell...@tr...

[Squirrel-sql-users] Is there a high-res logo for SQuirrel SQL?

[Toby M. <tob...@gm...>]

Hello,

The resolution for the SQuirrelSQL icon (the one that turns up when you
alt-tab through applications, also the same as the icon itself) is in a
grainy, low resolution. At least, this is the case for v3.2.1 for Mac. Is
there a higher resolution acorn logo available?  :)

-Toby

[Squirrel-sql-users] Problem with CREATE TABLE auto-generated script in Sybase

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

Hi,
I noticed that auto-generated "CREATE TABLE" script uses only "NOT NULL" column attributes, so all the columns in the resulted table are "NOT NULL".
ASE documentation states: "If you do not specify null or not null, Adaptive Server uses not null by default."  There is a way to change ASE default, but it requires role_sa role, which I don't have.
Is there a setting somewhere that can change the (SQL default) behavior of SQuirreL SQL to ASE-specific behavior?
-- 
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534
Bronx, NY 10461
(718) 430-2440 (Mo, We, Fr)  (718) 920-4885 (Tu & Th)

Re: [Squirrel-sql-users] export large results sets

[Brandon B. <bor...@gm...>]

Ah, that's great.  I'll wait until 3.3.0, then, whenever it's released.

On Wed, Jun 22, 2011 at 13:13, Robert Manning <rob...@gm...>wrote:

>
> This capability is being worked on currently and will likely be in the
> 3.3.0 release.  That said, we don't yet have a solid schedule for the 3.3.0
> release.
>
> Rob
>
> On Wed, Jun 22, 2011 at 2:39 PM, Brandon Borkholder <bor...@gm...>wrote:
>
>> If I have query that results in a huge number of rows, can I export it to
>> csv without actually loading the results into SQuirrel?  If this
>> functionality doesn't exist, should it be a plugin?
>>
>> Thanks,
>> Brandon
>>
>>
>> ------------------------------------------------------------------------------
>> Simplify data backup and recovery for your virtual environment with
>> vRanger.
>> Installation's a snap, and flexible recovery options mean your data is
>> safe,
>> secure and there when you need it. Data protection magic?
>> Nope - It's vRanger. Get your free trial download today.
>> http://p.sf.net/sfu/quest-sfdev2dev
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>>
>

Re: [Squirrel-sql-users] export large results sets

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

This capability is being worked on currently and will likely be in the 3.3.0
release.  That said, we don't yet have a solid schedule for the 3.3.0
release.

Rob

On Wed, Jun 22, 2011 at 2:39 PM, Brandon Borkholder <bor...@gm...>wrote:

> If I have query that results in a huge number of rows, can I export it to
> csv without actually loading the results into SQuirrel?  If this
> functionality doesn't exist, should it be a plugin?
>
> Thanks,
> Brandon
>
>
> ------------------------------------------------------------------------------
> Simplify data backup and recovery for your virtual environment with
> vRanger.
> Installation's a snap, and flexible recovery options mean your data is
> safe,
> secure and there when you need it. Data protection magic?
> Nope - It's vRanger. Get your free trial download today.
> http://p.sf.net/sfu/quest-sfdev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

[Squirrel-sql-users] export large results sets

[Brandon B. <bor...@gm...>]

If I have query that results in a huge number of rows, can I export it to
csv without actually loading the results into SQuirrel?  If this
functionality doesn't exist, should it be a plugin?

Thanks,
Brandon

Re: [Squirrel-sql-users] Missing feature

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

On Wed, 8 Jun 2011, Bhushan Chinchalkar wrote:

> I was user of aqua data studio and now user of squirrel for last 2 years.
> One feature I miss from ADS is ability to export query results into file
> directly. Many times I am not interested in seeing the result in the output
> window. I just want to export it to a csv file and then take it from there.
> Especially very large resultset having millions of rows. I think it would be
> effective also if we could start dumping resultset to file instead of
> outputing it to window and then export.

Please file this as a feature request at Sourceforge so the developers 
have a way to be aware of it and track it.

Thanks!

-- 
  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
-----------------------------------------------------------------------
   If you ask amateurs to act as front-line security personnel,
   you shouldn't be surprised when you get amateur security.
                                                     -- Bruce Schneier
-----------------------------------------------------------------------
  181 days since the first successful private orbital launch (SpaceX)

[Squirrel-sql-users] Missing feature

[Bhushan C. <bhu...@gm...>]

Hello,

I was user of aqua data studio and now user of squirrel for last 2 years.
One feature I miss from ADS is ability to export query results into file
directly. Many times I am not interested in seeing the result in the output
window. I just want to export it to a csv file and then take it from there.
Especially very large resultset having millions of rows. I think it would be
effective also if we could start dumping resultset to file instead of
outputing it to window and then export.

Thanks
Bhushan

[Squirrel-sql-users] Direct export to file

[Tilmann B. <til...@ka...>]

Hello,

we often use squirrel to export the result of a query to Excel or CSV. But 
in order to export the results, we first need to display them.
With large datasets this can lead to memory problems (insufficient java 
heap space). 

As far as I know I cannot write a query and then pipe the query results 
directly into a file.
But I think this would be a very useful option and could possibly prevent 
these memory problems.

P.S. I know I can configure squirrel to use more heap space, but this is 
not always sufficient.

Tilmann Brenk


Kaimer GmbH & Co. Holding KG
Kommanditgesellschaft mit Sitz in Essen · Amtsgericht Essen · HRA 6843

Kaimer GmbH · Geschäftsführer: Bernd Kaimer, Frank Schrick
Amtsgericht Essen · HRB 13343

Re: [Squirrel-sql-users] Apache Derby Network Server running SSL

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

Oh, and you also need a special JDBC url of one of the following forms:

jdbc:derby://myhost:1527/db;ssl=basic

or

jdbc:derby://myhost:1527/db;ssl=peerAuthentication


I found this information here:
http://db.apache.org/derby/docs/dev/adminguide/cadminsslclient.html


Rob



On Sat, Jun 4, 2011 at 11:39 AM, Robert Manning
<rob...@gm...>wrote:

> Thomas,
>
> SQuirreL doesn't currently provide direct support for specifying things
> like keystore, keystore password, truststore and truststore password
> (probably a feature request away). However, the JVM allows you to specify
> these as system properties using command line arguments.  For example:
>
> java -Djavax.net.ssl.keyStore=/home/username/identity.jks
> -Djavax.net.ssl.keyStorePassword=mypassword
> -Djavax.net.ssl.trustStore=/home/username/trustore.jks
> javax.net.ssl.trustStorePassword=mytrustpassowrd ...
>
> These would need to be added to the line that runs the Java command in
> squirrel-sql.sh or squirrel-sql.bat.
>
> Is the derby server configured to do basic or peer authentication ? If its
> basic, then you only need the truststore which contains the server's cert
> (or ideally, the CA cert that signed the server's cert). However, if the
> server is configured for peer authentication, then you will need client
> certificates that are signed by a CA whose certificate is configured to be
> trusted on the server. Basic is relatively easy, peer authentication (or
> client authentication) can be a real PITA.
>
> Rob
>
>
>
> On Sat, Jun 4, 2011 at 8:02 AM, Thomas Hill <Tho...@t-...>wrote:
>
>> Hi,
>>
>> I would like to use squirril (current version on Windows) to connect to
>> an Apache Derby Network Server. Challenge is: the Apache Derby Server is
>> running SSL and therefore only accepts SSL connections. Is it possible
>> to use squirril in such a scenario? If so, where would I need to
>> specific the keystore files to be used for connecting?
>>
>> Thanks
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Simplify data backup and recovery for your virtual environment with
>> vRanger.
>> Installation's a snap, and flexible recovery options mean your data is
>> safe,
>> secure and there when you need it. Discover what all the cheering's about.
>> Get your free trial download today.
>> http://p.sf.net/sfu/quest-dev2dev2
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
>

Re: [Squirrel-sql-users] Apache Derby Network Server running SSL

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

Thomas,

SQuirreL doesn't currently provide direct support for specifying things like
keystore, keystore password, truststore and truststore password (probably a
feature request away). However, the JVM allows you to specify these as
system properties using command line arguments.  For example:

java -Djavax.net.ssl.keyStore=/home/username/identity.jks
-Djavax.net.ssl.keyStorePassword=mypassword
-Djavax.net.ssl.trustStore=/home/username/trustore.jks
javax.net.ssl.trustStorePassword=mytrustpassowrd ...

These would need to be added to the line that runs the Java command in
squirrel-sql.sh or squirrel-sql.bat.

Is the derby server configured to do basic or peer authentication ? If its
basic, then you only need the truststore which contains the server's cert
(or ideally, the CA cert that signed the server's cert). However, if the
server is configured for peer authentication, then you will need client
certificates that are signed by a CA whose certificate is configured to be
trusted on the server. Basic is relatively easy, peer authentication (or
client authentication) can be a real PITA.

Rob



On Sat, Jun 4, 2011 at 8:02 AM, Thomas Hill <Tho...@t-...>wrote:

> Hi,
>
> I would like to use squirril (current version on Windows) to connect to
> an Apache Derby Network Server. Challenge is: the Apache Derby Server is
> running SSL and therefore only accepts SSL connections. Is it possible
> to use squirril in such a scenario? If so, where would I need to
> specific the keystore files to be used for connecting?
>
> Thanks
>
>
>
> ------------------------------------------------------------------------------
> Simplify data backup and recovery for your virtual environment with
> vRanger.
> Installation's a snap, and flexible recovery options mean your data is
> safe,
> secure and there when you need it. Discover what all the cheering's about.
> Get your free trial download today.
> http://p.sf.net/sfu/quest-dev2dev2
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] Apache Derby Network Server running SSL

[Thomas H. <Tho...@t-...>]

Hi,

I would like to use squirril (current version on Windows) to connect to 
an Apache Derby Network Server. Challenge is: the Apache Derby Server is 
running SSL and therefore only accepts SSL connections. Is it possible 
to use squirril in such a scenario? If so, where would I need to 
specific the keystore files to be used for connecting?

Thanks

[Squirrel-sql-users] Ostermiller and Netbeans editors will be removed

[Gerd W. <ger...@t-...>]

Hi all,

in the next release the Ostermiller and Netbeans editors will be 
removed. The versions that SQuirreL uses of these editors are very very 
old and not supported anymore in any way.

Any user that still uses one of these two editors will automatically 
switched to the new RSyntax editor. The RSyntax editor is SQuirreL's 
most stable and feature rich editor since version 3.1.

The plain text editor will still be available in future versions.


FYI:
To choose and configure SQuirreL's editor use menu File --> New Session 
Properties --> Tab Syntax.



Gerd

[Squirrel-sql-users] SQuirrel SQL Client Version 3.2.0 and unicode compatible

[Suat S. <ss...@he...>]

Dear all,

I have a question about SQuirrel SQL Client Version 3.2.0 and unicode ability. We use in our 
sybase15 the UTF-8 character set  and the german letters are in our tables.

If I edit a german letter with SQuirrel, I cannot find the set with a select query and the 
changed text is not saved in UTF8.

Has someone any idea how I can solve my unicode problem in SQuirrel?

Regards,
Suat
-- 
Dr. Suat Suna
Universität Frankfurt am Main, HeBIS-Informationstechnologie
Senckenberganlage 31-33           60054 Frankfurt am Main
Tel.: +49(0)69 798 25174            Fax: +49(0)69 798 28817

[Squirrel-sql-users] Windows 64-bit support

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

Hello,

I wanted to take this opportunity to mention a need that the SQuirreL
development team has - specifically for SQuirreL users on the Windows 64-bit
platform.  On this project, as developers we strive to do continuous testing
of the SQuirreL application to provide a high degree of quality for our
users (and ourselves).  However, our testing doesn't currently include *any*
Windows 64-bit platform, because we lack the funds to acquire a license for
that version of the Windows operating system.   If anyone who uses *any*
64-bit version of Windows would care to donate a license/funds to this
project, we would happily setup a 64-bit Windows VM to test the installation
and execution of SQuirreL to verify our support for this platform.

Alternatively, if you use SQuirreL and your platform is *any* Windows
64-bit, we would appreciate it if you could verify that certain snapshot
builds work correctly on your 64-bit install of Windows.

Please e-mail me directly if you would like to help us out (
rob...@gm...)

Rob

Re: [Squirrel-sql-users] update and plugins folder in my home folder

[Gabriele B. <br...@ed...>]

Perfect, it worked!!

Thanks a lot

On 18/05/2011 14:05, Robert Manning wrote:
> In this case, I would recommend that you download the 3.2.1 install jar
> and install into /usr/local/squirrel-sql-3.2.1.  Then run
> squirrel-sql.sh from that directory.  Once you are able to connect to
> your database using that new install of SQuirreL, then you can remove
> the plugins/updates folder from your home directory, as well as the
> /usr/local/squirrel-sql-3.1.2 directory and its contents.
> Rob
>
> On Wed, May 18, 2011 at 3:52 AM, Gabriele Brosulo <br...@ed...
> <mailto:br...@ed...>> wrote:
>
>     Hi Robert,
>     On my linuxbox (Debian Sid) Squirrel-sql is installed in
>     /usr/local/squirrel-sql-3.1.2, and the files you listed below are in
>     that directory.
>
>     The problem is that I have also plugins and update directory also in
>     my home directory.
>
>     Permissions into the install directory are the followings:
>
>     ################################################################
>     ################################################################
>     g4b0@gabodeb:/usr/local/squirrel-sql-3.1.2$ ls -l
>     totale 3976
>     -rw-r--r--  1 root staff      23 16 giu  2010 addpath.bat
>     drwxr-sr-x  4 root staff    4096  5 lug  2010 doc
>     drwxr-sr-x  2 root staff    4096  5 lug  2010 icons
>     -rwxr-xr-x  1 root staff   15213  5 lug  2010
>     IzPackLocaleEnabledXdgDesktopIconScript.sh
>     drwxr-sr-x  2 root staff    4096  5 lug  2010 lib
>     -rw-r--r--  1 root staff     308 16 giu  2010 log4j.properties
>     drwxr-sr-x 21 root staff    4096  6 lug  2010 plugins
>     -rw-r--r--  1 root staff    3223  9 lug  2010 squirrel-sql.bat
>     -rw-r--r--  1 root staff     590  5 lug  2010
>     SQuirreL-SQL-Client-1278336331009.desktop
>     -rw-r--r--  1 root staff 3994110 16 giu  2010 squirrel-sql.jar
>     -rwxr-xr-x  1 root staff    4469  9 lug  2010 squirrel-sql.sh
>     drwxr-sr-x  2 root staff    4096  5 lug  2010 Uninstaller
>     drwxr-sr-x  2 root staff    4096  5 lug  2010 update
>     -rw-r--r--  1 root staff     400 16 giu  2010 update-log4j.properties
>     ################################################################
>     ################################################################
>
>     My user is part of the staff group:
>
>     ################################################################
>     ################################################################
>     g4b0@gabodeb:/usr/local/squirrel-sql-3.1.2$ groups g4b0
>     g4b0 : g4b0 dialout cdrom floppy audio video plugdev staff scanner
>     netdev bluetooth fuse powerdev
>     ################################################################
>     ################################################################
>
>     How can I solve this?
>
>     I think that this problem is also related to another: if I enable
>     the syntax plugin I can't connect to any remote server, following
>     the stack trace:
>
>     ################################################################
>     ################################################################
>     java.lang.NoClassDefFoundError: org/fife/ui/rtextarea/RTextArea
>             at
>     net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxSQLEntryAreaFactory.createSQLEntryPanel(RSyntaxSQLEntryAreaFactory.java:37)
>             at
>     net.sourceforge.squirrel_sql.plugins.syntax.SQLEntryPanelFactoryProxy.createSQLEntryPanel(SQLEntryPanelFactoryProxy.java:64)
>             at
>     net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.createGUI(SQLPanel.java:844)
>             at
>     net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init>(SQLPanel.java:182)
>             at
>     net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getComponent(SQLTab.java:72)
>             at
>     net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getSQLPanel(SQLTab.java:123)
>             at
>     net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.setSession(SQLTab.java:83)
>             at
>     net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.<init>(SQLTab.java:42)
>             at
>     net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init>(MainPanel.java:112)
>             at
>     net.sourceforge.squirrel_sql.client.gui.session.MainPanelFactory.createMainPanel(MainPanelFactory.java:27)
>             at
>     net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI(SessionPanel.java:478)
>             at
>     net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.initialize(SessionPanel.java:134)
>             at
>     net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI(SessionInternalFrame.java:123)
>             at
>     net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init>(SessionInternalFrame.java:53)
>             at
>     net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame(WindowManager.java:360)
>             at
>     net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:372)
>             at
>     java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>             at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:642)
>             at java.awt.EventQueue.access$000(EventQueue.java:85)
>             at java.awt.EventQueue$1.run(EventQueue.java:603)
>             at java.awt.EventQueue$1.run(EventQueue.java:601)
>             at java.security.AccessController.doPrivileged(Native Method)
>             at
>     java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
>             at java.awt.EventQueue.dispatchEvent(EventQueue.java:612)
>             at
>     net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:194)
>             at
>     java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
>             at
>     java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
>             at
>     java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
>             at
>     java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
>             at
>     java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
>             at
>     java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
>     Caused by: java.lang.ClassNotFoundException:
>     org.fife.ui.rtextarea.RTextArea
>             at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>             at java.security.AccessController.doPrivileged(Native Method)
>             at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>             at
>     net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
>             at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
>             at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
>             ... 31 more
>     ################################################################
>     ################################################################
>
>     Thanks a lot
>
>
>     On 14/05/2011 16:54, Robert Manning wrote:
>
>         Gabriele,
>
>         The best thing to do in this case would be to re-install
>         SQuirreL in a
>         different folder and remove the SQuirreL-related files
>         (log4j.properties, squirrel-sql.sh, squirrel-sql.bat, lib/, update/,
>         plugins/, etc. ) from your home directory.  Do not remove the
>         .squirrel-sql folder from your home directory as doing this
>         would wipe
>         out your aliases, drivers and preferences.
>
>         Rob
>
>         On Fri, May 13, 2011 at 10:36 AM, Gabriele Brosulo
>         <br...@ed... <mailto:br...@ed...>
>         <mailto:br...@ed... <mailto:br...@ed...>>> wrote:
>
>             Hi all,
>             How can I move update and plugins folder from my home folder
>         to another
>             location?
>
>             Thanks a lot
>             --
>             Gabriele Dr. Brosulo
>               Responsabile Web
>               EdiSoft Srl
>               Sede Legale: Corso Piemonte, 13
>               Sede Operativa: Via Bodoni, 23/25
>               12037 SALUZZO (CN)
>               Tel. + 39 0175 43443 <tel:%2B%2039%200175%2043443>
>         <tel:%2B%2039%200175%2043443>
>               Fax. + 39 0175 475196 <tel:%2B%2039%200175%20475196>
>         <tel:%2B%2039%200175%20475196>
>               E-mail: br...@ed... <mailto:br...@ed...>
>         <mailto:br...@ed... <mailto:br...@ed...>>
>               Web Principale: www.edisoft.net <http://www.edisoft.net/>
>         <http://www.edisoft.net <http://www.edisoft.net/>>
>               Divisione Internet: internet.edisoft.net
>         <http://internet.edisoft.net/> <http://internet.edisoft.net
>         <http://internet.edisoft.net/>>
>
>               Divisione Verticali: verticali.edisoft.net
>         <http://verticali.edisoft.net/>
>         <http://verticali.edisoft.net <http://verticali.edisoft.net/>>
>               Divisione Servizi: servizi.edisoft.net
>         <http://servizi.edisoft.net/> <http://servizi.edisoft.net
>         <http://servizi.edisoft.net/>>
>
>               -----------------------------------------
>               Informativa sulla privacy reperibile presso:
>         http://www.edisoft.net/privacy/informativa.pdf
>
>
>           ------------------------------------------------------------------------------
>             Achieve unprecedented app performance and reliability
>             What every C/C++ and Fortran developer should know.
>             Learn how Intel has extended the reach of its
>         next-generation tools
>             to help boost performance applications - inlcuding clusters.
>         http://p.sf.net/sfu/intel-dev2devmay
>             _______________________________________________
>             Squirrel-sql-users mailing list
>         Squ...@li...
>         <mailto:Squ...@li...>
>         <mailto:Squ...@li...
>         <mailto:Squ...@li...>>
>
>         https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
>
>


-- 
Gabriele Dr. Brosulo
  Responsabile Web
  EdiSoft Srl
  Sede Legale: Corso Piemonte, 13
  Sede Operativa: Via Bodoni, 23/25
  12037 SALUZZO (CN)
  Tel. + 39 0175 43443
  Fax. + 39 0175 475196
  E-mail: br...@ed...
  Web Principale: www.edisoft.net
  Divisione Internet: internet.edisoft.net
  Divisione Verticali: verticali.edisoft.net
  Divisione Servizi: servizi.edisoft.net
  -----------------------------------------
  Informativa sulla privacy reperibile presso:
  http://www.edisoft.net/privacy/informativa.pdf

Re: [Squirrel-sql-users] DBCopy problem

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

It could be the driver.  See this support link for differences between the
trial and licensed version:

http://www.hxtt.com/access/introduction.html

Though I don't normally recommend the JDBC-ODBC bridge, to get your data out
you could probably use it.  SQuirreL uses far too many JDBC APIs that ODBC
lacks to make it useful generally.

Rob
<http://www.hxtt.com/access/introduction.html>

On Mon, May 16, 2011 at 12:30 PM, Vincent M. Visconti <
VVi...@so...> wrote:

> Hi Rob,
>
>
>
> Thanks for the reply. I tried your suggestion, I changed the fetch size to
> 2,000 and it still cut off at 1,000 records. Do you think it could be the
> driver that I am using? Currently I am using an evaluation version of the
> HXTT Access v5.0 driver (Access JDBC 4.0 Package). Is there another driver
> you would recommend using for Access 2007?
>
>
>
>
>
> If you have any questions, please contact me.
>
> Thank you,
>
> Vincent Visconti
> Database Analyst/Programmer
> Sound Recording Special Payments Fund
> 570 Lexington Avenue, 21st Floor
> New York, NY 10022-6837
> Phone: 212-310-9429
> e-mail: vvi...@so...
>
>
>
> *From:* Robert Manning [mailto:rob...@gm...]
> *Sent:* Friday, May 13, 2011 8:31 PM
> *To:* Vincent M. Visconti
> *Cc:* squ...@li...
> *Subject:* Re: [Squirrel-sql-users] DBCopy problem
>
>
>
>
>
> Hmmm, it seems a bit too coincidental that the default select batch size
> for the DBCopy plugin is 1000, and that is also the maximum number of
> records retrieved by the HXTT driver to be copied.  How about if you try
> this:  Open File -> Global Preferences -> DBCopy - and change "ResultSet
> fetch size" to say 2000 and try the copy operation again (first, remove the
> records from the destination database table).   If that manages to somehow
> copy 2000 records this time, then I would say that the driver is limiting
> the total number of records in the result set based on the fetch size.  In
> which case, you could then try increasing that setting to a number above the
> total number of records to be copied.
>
>
>
> Rob
>
> On Fri, May 13, 2011 at 11:30 AM, Vincent M. Visconti <
> VVi...@so...> wrote:
>
> Hi, I’m trying to copy tables from Access 2007 into DB2 for i5/OS. I’m
> connecting to the Access DB via HXTT Access Client driver and the i5 via the
> JTOpen(AS/400) driver. The problem is when I copy a table from Access to i5,
> it only copies 1,000 records. I get a message that the copy was successful,
> but it only copies the 1st 1,000 records. I tried changing around some
> settings, but nothing seems to help. Any suggestions? Thank you!
>
>
>
>
>
> If you have any questions, please contact me.
>
>
>
> Thank you,
>
> Vincent Visconti
> Database Analyst/Programmer
> Sound Recording Special Payments Fund
> 570 Lexington Avenue, 21st Floor
> New York, NY 10022-6837
> Phone: 212-310-9429
> e-mail: vvi...@so...
>
>
>
>
>
> ------------------------------------------------------------------------------
> Achieve unprecedented app performance and reliability
> What every C/C++ and Fortran developer should know.
> Learn how Intel has extended the reach of its next-generation tools
> to help boost performance applications - inlcuding clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>

Re: [Squirrel-sql-users] DBCopy problem

[Vincent M. V. <VVi...@so...>]

Hi Rob,

Thanks for the reply. I tried your suggestion, I changed the fetch size to 2,000 and it still cut off at 1,000 records. Do you think it could be the driver that I am using? Currently I am using an evaluation version of the HXTT Access v5.0 driver (Access JDBC 4.0 Package). Is there another driver you would recommend using for Access 2007?


If you have any questions, please contact me.

Thank you,

Vincent Visconti
Database Analyst/Programmer
Sound Recording Special Payments Fund
570 Lexington Avenue, 21st Floor
New York, NY 10022-6837
Phone: 212-310-9429
e-mail: vvi...@so...<mailto:vvi...@so...>

From: Robert Manning [mailto:rob...@gm...]
Sent: Friday, May 13, 2011 8:31 PM
To: Vincent M. Visconti
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] DBCopy problem


Hmmm, it seems a bit too coincidental that the default select batch size for the DBCopy plugin is 1000, and that is also the maximum number of records retrieved by the HXTT driver to be copied.  How about if you try this:  Open File -> Global Preferences -> DBCopy - and change "ResultSet fetch size" to say 2000 and try the copy operation again (first, remove the records from the destination database table).   If that manages to somehow copy 2000 records this time, then I would say that the driver is limiting the total number of records in the result set based on the fetch size.  In which case, you could then try increasing that setting to a number above the total number of records to be copied.

Rob
On Fri, May 13, 2011 at 11:30 AM, Vincent M. Visconti <VVi...@so...<mailto:VVi...@so...>> wrote:
Hi, I'm trying to copy tables from Access 2007 into DB2 for i5/OS. I'm connecting to the Access DB via HXTT Access Client driver and the i5 via the JTOpen(AS/400) driver. The problem is when I copy a table from Access to i5, it only copies 1,000 records. I get a message that the copy was successful, but it only copies the 1st 1,000 records. I tried changing around some settings, but nothing seems to help. Any suggestions? Thank you!


If you have any questions, please contact me.

Thank you,

Vincent Visconti
Database Analyst/Programmer
Sound Recording Special Payments Fund
570 Lexington Avenue, 21st Floor
New York, NY 10022-6837
Phone: 212-310-9429<tel:212-310-9429>
e-mail: vvi...@so...<mailto:vvi...@so...>


------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

[Squirrel-sql-users] delete a SQL statement from my SQL history

[Thorsten B. <tho...@go...>]

Hi everybody,

I would like to delete a SQL statement from my SQL history (100).
I used SQuirreL to change my password (sp_password 'old', 'new')
and now can everybody see my new password in the SQL history.


Bye the way: why is it not possible to search in the help menu?

best regards

[Squirrel-sql-users] how to generate SQLAliases.xml with program

[Sebastien R. <seb...@ya...>]

Hi everybody,

I would like to made a program to automatically generate SQLAliases.xml files.
It works fine but I have an issue with the <identifier> tag.
Do you know if there is a way to generate the <string> value for this tag ? It seems to be generated by Squirrel when adding a new alias but how can I run a tier program to generate this value ?

regards