headers
Richard L. Zijdeman | 1 Mar 2011 10:57
Picon

drivers not loading (mac os x)

Dear all,

I am new to SQuirrelSQL and seem to have a problem loading the drivers. In the lists of drivers none of the
drivers are loading. As the manual hints this may be due to the fact that the files necessary to load the
driver are in a different path than expected by SQuirrel. However, I installed everything according to
the 'default' settings. Also, all the paths and files mentioned in the change-driver-window just below
"Java Class Path" are on my computer and in the right place. I tried removing and re-installing SQuirrel,
but that gave me the same results. I would be particularly interested in the mysql driver. I am using
SQuirrelSQL 3.2.1 on a macbook pro, mac os x 10.6.6.

Thank you for your suggestions.

Richard

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev
Permalink | Reply | 3 comments |
headers
Thomas, Jojo John | 1 Mar 2011 13:54

Squirrel with Netezza

Hi,
 
Need help with configuring Squirrel with Netezza.
Have installed Netezza plugin, but Netezza does not appear under drivers.
 
Cheers,
Working from UK/London/CGC1
W. +44 20 7986 7347 M. +44 79 0381 5270
 
 
 
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 5 comments |
headers
Robert Manning | 1 Mar 2011 13:55
Picon
Gravatar

Re: drivers not loading (mac os x)

Hello,
 
The SQuirreL installer doesn't ship JDBC drivers.  You should download the mysql connector jdbc driver and copy it into the SQUIRREL_INSTALL_DIR/lib folder, then restart SQuirreL.
 
In case your wondering about the optional mysql plugin, it extends SQuirreL to enhance it's capabilities when working with a mysql database.
 
Rob

On Tue, Mar 1, 2011 at 4:57 AM, Richard L. Zijdeman <r.l.zijdeman <at> uu.nl> wrote:
Dear all,

I am new to SQuirrelSQL and seem to have a problem loading the drivers. In the lists of drivers none of the drivers are loading. As the manual hints this may be due to the fact that the files necessary to load the driver are in a different path than expected by SQuirrel. However, I installed everything according to the 'default' settings. Also, all the paths and files mentioned in the change-driver-window just below "Java Class Path" are on my computer and in the right place. I tried removing and re-installing SQuirrel, but that gave me the same results. I would be particularly interested in the mysql driver. I am using SQuirrelSQL 3.2.1 on a macbook pro, mac os x 10.6.6.

Thank you for your suggestions.

Richard









------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
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
Lennon , Sam | 1 Mar 2011 18:27

Re: iSeries data and CCSID

This may not answer your question, but it may help with background. And I have not done a lot with it.

 

The table you are reading is tagged with a CCSID (37, for example, is USA English.)  However, there is also 65535, which is hex and is not translated.  (Strictly speaking, individual columns can also be tagged with a CCSID on more recent OS versions.)

 

There is also a CCSID associated with the servicing job on the iSeries.

 

Some systems have a default of 65535 for both files and jobs.

 

The “DB2 for i SQL Reference” http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/index.jsp?topic=/rzahg/icmain.htm has lots more info on CCSIDs.  It can be pretty convoluted.

 

Sam

 

From: Robert Rogerson [mailto:rogersonra <at> gmail.com]
Sent: Monday, February 28, 2011 4:21 PM
To: squirrel-sql-users <at> lists.sourceforge.net
Subject: [Squirrel-sql-users] iSeries data and CCSID

 

 HI all,

How do I change the CCSID for data returned from an SQL statement where the db is on an iSeries.

Thanks,

Rob

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-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
Robert Manning | 1 Mar 2011 22:57
Picon
Gravatar

Re: Squirrel with Netezza

Get the JDBC driver through your IBM / Netezza support channel.  The plugin extends SQuirreL but is not a JDBC driver.
 
Rob

On Tue, Mar 1, 2011 at 7:54 AM, Thomas, Jojo John <jojo.john.thomas <at> citi.com> wrote:
Hi,
 
Need help with configuring Squirrel with Netezza.
Have installed Netezza plugin, but Netezza does not appear under drivers.
 
Cheers,
Working from UK/London/CGC1
W. +44 20 7986 7347 M. +44 79 0381 5270
 
 
 

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-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
Robert Manning | 2 Mar 2011 01:59
Picon
Gravatar

Re: drivers not loading (mac os x)

Richard,

I've always used the mysql connector and haven't had many problems with it.  Do select the MySQL optional plugin (which is not a driver) when installing SQuirreL for a better object browsing and script execution experience.

Rob

On Tue, Mar 1, 2011 at 7:37 PM, Richard L. Zijdeman <r.l.zijdeman <at> uu.nl> wrote:
Dear Robert,

thank you for your helpful suggestion. I am indeed now able to access my database through SQuirreL. Would you in general recommend the optional mysql driver or even the MMMySQL driver?

Best wishes,

Richard

On 01 Mar 2011, at 13:55, Robert Manning wrote:

Hello,
 
The SQuirreL installer doesn't ship JDBC drivers.  You should download the mysql connector jdbc driver and copy it into the SQUIRREL_INSTALL_DIR/lib folder, then restart SQuirreL.
 
In case your wondering about the optional mysql plugin, it extends SQuirreL to enhance it's capabilities when working with a mysql database.
 
Rob

On Tue, Mar 1, 2011 at 4:57 AM, Richard L. Zijdeman <r.l.zijdeman <at> uu.nl> wrote:
Dear all,

I am new to SQuirrelSQL and seem to have a problem loading the drivers. In the lists of drivers none of the drivers are loading. As the manual hints this may be due to the fact that the files necessary to load the driver are in a different path than expected by SQuirrel. However, I installed everything according to the 'default' settings. Also, all the paths and files mentioned in the change-driver-window just below "Java Class Path" are on my computer and in the right place. I tried removing and re-installing SQuirrel, but that gave me the same results. I would be particularly interested in the mysql driver. I am using SQuirrelSQL 3.2.1 on a macbook pro, mac os x 10.6.6.

Thank you for your suggestions.

Richard









------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-- 
Richard L. Zijdeman
Assistant Professor | ICS / Dept. of Sociology | Utrecht University
Honorary Research Fellow | Dept. of Applied Social Science | Stirling University


 







------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-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
Richard L. Zijdeman | 2 Mar 2011 01:37
Picon

Re: drivers not loading (mac os x)

Dear Robert,

thank you for your helpful suggestion. I am indeed now able to access my database through SQuirreL. Would you in general recommend the optional mysql driver or even the MMMySQL driver?

Best wishes,

Richard

On 01 Mar 2011, at 13:55, Robert Manning wrote:

Hello,
 
The SQuirreL installer doesn't ship JDBC drivers.  You should download the mysql connector jdbc driver and copy it into the SQUIRREL_INSTALL_DIR/lib folder, then restart SQuirreL.
 
In case your wondering about the optional mysql plugin, it extends SQuirreL to enhance it's capabilities when working with a mysql database.
 
Rob

On Tue, Mar 1, 2011 at 4:57 AM, Richard L. Zijdeman <r.l.zijdeman <at> uu.nl> wrote:
Dear all,

I am new to SQuirrelSQL and seem to have a problem loading the drivers. In the lists of drivers none of the drivers are loading. As the manual hints this may be due to the fact that the files necessary to load the driver are in a different path than expected by SQuirrel. However, I installed everything according to the 'default' settings. Also, all the paths and files mentioned in the change-driver-window just below "Java Class Path" are on my computer and in the right place. I tried removing and re-installing SQuirrel, but that gave me the same results. I would be particularly interested in the mysql driver. I am using SQuirrelSQL 3.2.1 on a macbook pro, mac os x 10.6.6.

Thank you for your suggestions.

Richard









------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-- 
Richard L. Zijdeman
Assistant Professor | ICS / Dept. of Sociology | Utrecht University
Honorary Research Fellow | Dept. of Applied Social Science | Stirling University








------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 1 comment |
headers
Thomas, Jojo John | 2 Mar 2011 13:33

Re: Squirrel with Netezza

Hi Matt,

Thank you very much. Was able to get working with Netezza – using Extra Class Path TAB (now changed as per your suggestion).

Does the SQuirrel SQL client also allow editing of procedures, or just view – (that is what the plug-in documentation suggests)

 

Also, would you, or anybody else on the forum be able to advice if <<Aginity - Netezza Workbench>> is better when working with Netezza.

Cheers, Jojo

+44 79 0381 5270

 

From: Matt Dahlman [mailto:mdahlman <at> jaspersoft.com]
Sent: 01 March 2011 23:49
To: Thomas, Jojo John [CCC-OT_IT]
Cc: 'squirrel-sql-users <at> lists.sourceforge.net'
Subject: Re: [Squirrel-sql-users] Squirrel with Netezza

 

Hello,
 
The SQuirreL installer doesn't ship JDBC drivers.  You should download the Netezza jdbc driver and copy it into the SQUIRREL_INSTALL_DIR/lib folder, then restart SQuirreL.
 
In case you're wondering about the optional Netezza plugin, it extends SQuirreL to enhance it's capabilities when working with a Netezza database.

Matt

(With apologies to Rob, since I just did s/MySQL/Netezza/ on his last email!)

 

On 1 Mar 2011, at 4:54, Thomas, Jojo John wrote:



Hi,

 

Need help with configuring Squirrel with Netezza.

Have installed Netezza plugin, but Netezza does not appear under drivers.

 

Cheers,

Jojo (jt22629 - jojo.john.thomas <at> citi.com)

Working from UK/London/CGC1

W. +44 20 7986 7347 M. +44 79 0381 5270

 

 

 

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

 

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
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
Robert Rogerson | 2 Mar 2011 17:09
Picon
Subject: Searching archives...

Searching archives...

Hi all,

I went to

SourceForge.net > Projects > SQuirreL SQL Client > Mail > Archive

to check the archives if my question had been answered before. 

Forgive me but I could not find a way to search the archives.  I can see past posts but I'm trying to avoid having to scan each page.  Am I missing something or is this feature not available.

Thanks,

Robert Rogerson
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-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 Dahlman | 2 Mar 2011 00:49
Favicon
Gravatar

Re: Squirrel with Netezza

Hello,
 
The SQuirreL installer doesn't ship JDBC drivers.  You should download the Netezza jdbc driver and copy it into the SQUIRREL_INSTALL_DIR/lib folder, then restart SQuirreL.
 
In case you're wondering about the optional Netezza plugin, it extends SQuirreL to enhance it's capabilities when working with a Netezza database.

Matt
(With apologies to Rob, since I just did s/MySQL/Netezza/ on his last email!)

On 1 Mar 2011, at 4:54, Thomas, Jojo John wrote:

Hi,
 
Need help with configuring Squirrel with Netezza.
Have installed Netezza plugin, but Netezza does not appear under drivers.
 
Cheers,
Working from UK/London/CGC1
W. +44 20 7986 7347 M. +44 79 0381 5270
 
 
 
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Permalink | Reply | 3 comments |

Gmane