You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Kreutzer, T. <Ted...@mt...> - 2012-03-21 19:26:12
|
Currently, I am using Squirrel SQL with a Vertica DB cluster. When I run queries that involve a return of timestamp values with a timezone, instead of the UTC value stored on the server, Squirrel SQL converts the timestamp value to the timezone of my client (Pacific). Is there are setting, configuration, or workaround so that I can get the UTC timezone instead of the client timezone. -- Ted Kreutzer | Database Architect | Nickelodeon | Social Games |
|
From: Stan D. <sdr...@rn...> - 2012-03-09 13:47:47
|
Hi Andreas, That's what I thought I was trying, but I gave it another go today and had no problems querying. Other than the autocomplete not finding the names for tables and fields, everything went fine. Clearly it was user error! Thanks everyone for trying to help. Stan On 12-03-08 08:23 PM, Andreas Oswald wrote: Hi Stan, if the databases are part of the same database servers you can use qualified table names. The example below should explain how to use qualified table names --Create two new test databases create database db1; create database db2; --Create tables in both databases use db1; create table master ( id int, info varchar(255) ); use db2; create table detail values ( id int, masterid int, info varchar(255) ); --create sample data use db1; insert into master values(1, 'master values A'); insert into master values(2, 'master values B'); insert into master values(3, 'master values C'); use db2; insert into detail values(1,1, 'detail values A'); insert into detail values(2,1, 'detail values B'); insert into detail values(3,1, 'detail values C'); insert into detail values(4,2, 'detail values D'); insert into detail values(5,2, 'detail values E'); insert into detail values(6,2, 'detail values F'); insert into detail values(7,3, 'detail values G'); insert into detail values(8,3, 'detail values H'); insert into detail values(9,3, 'detail values I'); --query the sample data select m.id MasterId, d.id DetailId, m.info, d.info from db1.Master m join db2.Detail d on d.masterid=m.id; Hope that helps. Take care Andreas Am 09.03.2012 00:06, schrieb Stan Dragnev: Sorry for not specifying! It's MySQL databases. Stan On 12-03-08 04:38 PM, CptBlaubaer wrote: Hi Stan, what kind of databases do you use? With Oracle you could use database links, from SQuirreL's point of view you would then query one database. I don't know about another alternative for your ideas. Perhaps you can provide some more information? Take care Andreas Am 08.03.2012 18:24 schrieb "Stan Dragnev" <sdr...@rn...>: Hi, Is it possible to run a query that joins tables across multiple databases in Squirrel SQL? E.g.: select * from db1.table1 inner join db2.table2... I created a user with permissions for both and connected to the host but when trying to query I was getting a no default database selected error. Maybe I'm missing something obvious! Thanks. Stan ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Andreas O. <cpt...@gm...> - 2012-03-09 01:23:40
|
Hi Stan, if the databases are part of the same database servers you can use qualified table names. The example below should explain how to use qualified table names --Create two new test databases create database db1; create database db2; --Create tables in both databases use db1; create table master ( id int, info varchar(255) ); use db2; create table detail values ( id int, masterid int, info varchar(255) ); --create sample data use db1; insert into master values(1, 'master values A'); insert into master values(2, 'master values B'); insert into master values(3, 'master values C'); use db2; insert into detail values(1,1, 'detail values A'); insert into detail values(2,1, 'detail values B'); insert into detail values(3,1, 'detail values C'); insert into detail values(4,2, 'detail values D'); insert into detail values(5,2, 'detail values E'); insert into detail values(6,2, 'detail values F'); insert into detail values(7,3, 'detail values G'); insert into detail values(8,3, 'detail values H'); insert into detail values(9,3, 'detail values I'); --query the sample data select m.id MasterId, d.id DetailId, m.info, d.info from db1.Master m join db2.Detail d on d.masterid=m.id; Hope that helps. Take care Andreas Am 09.03.2012 00:06, schrieb Stan Dragnev: > Sorry for not specifying! It's MySQL databases. > > Stan > > On 12-03-08 04:38 PM, CptBlaubaer wrote: >> >> Hi Stan, >> >> what kind of databases do you use? With Oracle you could use database >> links, from SQuirreL's point of view you would then query one >> database. I don't know about another alternative for your ideas. >> >> Perhaps you can provide some more information? >> >> Take care >> >> Andreas >> >> Am 08.03.2012 18:24 schrieb "Stan Dragnev" <sdr...@rn... >> <mailto:sdr...@rn...>>: >> >> Hi, >> >> Is it possible to run a query that joins tables across multiple >> databases in Squirrel SQL? >> E.g.: >> select * from db1.table1 inner join db2.table2... >> >> I created a user with permissions for both and connected to the >> host but >> when trying to query I was getting a no default database selected >> error. >> Maybe I'm missing something obvious! >> >> Thanks. >> >> Stan >> >> ------------------------------------------------------------------------------ >> Virtualization & Cloud Management Using Capacity Planning >> Cloud computing makes use of virtualization - but cloud computing >> also focuses on allowing computing to be delivered as a service. >> http://www.accelacomm.com/jaw/sfnl/114/51521223/ >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> <mailto:Squ...@li...> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> |
|
From: Jim It <ji...@ho...> - 2012-03-09 01:21:44
|
Matt, What driver are you using? You should be using either the jt400.jar included with IBM Client Access install or from the jt400.jar from JTOpen. http://jt400.sourceforge.net/ Jim Date: Thu, 8 Mar 2012 16:44:24 -0500 From: rob...@gm... To: dic...@uk... CC: squ...@li... Subject: Re: [Squirrel-sql-users] Code page problem with SQL Squirrel ? Any app that tries to use that DB2 driver to inspect the procedures in your database is going to run into that issue. It's not just SQuirreL, judging by the stack trace. You should see if there is a fixpack that has an update for your driver, or file a support request with IBM. Rob On Wed, Mar 7, 2012 at 9:44 AM, Dickinson, Matthew <dic...@uk...> wrote: Hi Hopefully someone can help me. I have been using SQL squirrel to access a DB2 database on a AS400. I have been successfully accessing my database until recently when I have started getting the following error 2012-03-07 13:07:03,216 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures com.ibm.db2.jcc.am.SqlDataException: [jcc][t4][10275][10041][3.61.65] Unsupported ccsid, encoding, or locale: "Cp858". ERRORCODE=-4220, SQLSTATE=22021 at com.ibm.db2.jcc.am.ed.a(ed.java:668) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:85) at com.ibm.db2.jcc.am.o.a(o.java:432) at com.ibm.db2.jcc.t4.cc.a(cc.java:2349) at com.ibm.db2.jcc.t4.cb.a(cb.java:3407) at com.ibm.db2.jcc.t4.cb.a(cb.java:1982) at com.ibm.db2.jcc.t4.cb.b(cb.java:1919) at com.ibm.db2.jcc.t4.cb.a(cb.java:1887) at com.ibm.db2.jcc.t4.cb.l(cb.java:574) at com.ibm.db2.jcc.t4.cb.k(cb.java:348) at com.ibm.db2.jcc.t4.cb.e(cb.java:97) at com.ibm.db2.jcc.t4.q.e(q.java:81) at com.ibm.db2.jcc.t4.rb.k(rb.java:160) at com.ibm.db2.jcc.am.gn.jb(gn.java:2188) at com.ibm.db2.jcc.am.hn.b(hn.java:3917) at com.ibm.db2.jcc.am.in.dc(in.java:144) at com.ibm.db2.jcc.am.jc.a(jc.java:7799) at com.ibm.db2.jcc.am.jc.a(jc.java:6091) at com.ibm.db2.jcc.am.jc.a(jc.java:6018) at com.ibm.db2.jcc.am.jc.getProcedures(jc.java:6008) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:755) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:597) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:412) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:351) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187) at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:241) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Unknown Source) Caused by: java.io.UnsupportedEncodingException: Cp858 at sun.io.Converters.getConverterClass(Unknown Source) at sun.io.Converters.newConverter(Unknown Source) at sun.io.ByteToCharConverter.getConverter(Unknown Source) at com.ibm.db2.jcc.am.u.<init>(u.java:10) at com.ibm.db2.jcc.am.s.a(s.java:10) at com.ibm.db2.jcc.am.o.a(o.java:428) ... 25 more Any tips/ suggestions ? Matt This message was created by: MATT DICKINSON – Senior Consultant - UK Technology Centre Innovation Group Tel: +44 (0) 1489 898370 I Fax: +44 (0) 1489 579181 I Mob: +44 (0) 7818 032113 I E-mail: dic...@uk... I Web: www.uk.innovation-group.com ________________________________________________________________________ Any opinions expressed in this email are those of the individual and not necessarily the company. The contents of this email and any attachments are confidential to The Innovation Group PLC and are solely for use by the intended recipient at the email address to which it has been addressed. This email and any attachments may not be disclosed to or used by anyone other than the intended recipient, nor may it be copied in any way. If you have received this email in error, please forward a copy of this email to its...@uk... and then delete it from your system. The Innovation Group PLC: Registered in England 3256771 Registered Office: Yarmouth House 1300 Parkway Solent Business Park Whiteley Hampshire PO15 7AE UK http://www.innovation-group.com This email and any attachments has been swept for computer viruses. Neither The Innovation Group PLC nor the sender accept any responsibility for computer viruses once this email has been transmitted. ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Stan D. <sdr...@rn...> - 2012-03-08 23:06:12
|
Sorry for not specifying! It's MySQL databases. Stan On 12-03-08 04:38 PM, CptBlaubaer wrote: Hi Stan, what kind of databases do you use? With Oracle you could use database links, from SQuirreL's point of view you would then query one database. I don't know about another alternative for your ideas. Perhaps you can provide some more information? Take care Andreas Am 08.03.2012 18:24 schrieb "Stan Dragnev" <sdr...@rn...>: Hi, Is it possible to run a query that joins tables across multiple databases in Squirrel SQL? E.g.: select * from db1.table1 inner join db2.table2... I created a user with permissions for both and connected to the host but when trying to query I was getting a no default database selected error. Maybe I'm missing something obvious! Thanks. Stan ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Robert M. <rob...@gm...> - 2012-03-08 21:44:33
|
Any app that tries to use that DB2 driver to inspect the procedures in your database is going to run into that issue. It's not just SQuirreL, judging by the stack trace. You should see if there is a fixpack that has an update for your driver, or file a support request with IBM. Rob On Wed, Mar 7, 2012 at 9:44 AM, Dickinson, Matthew < dic...@uk...> wrote: > Hi**** > > ** ** > > Hopefully someone can help me. I have been using SQL squirrel to access a > DB2 database on a AS400.**** > > ** ** > > I have been successfully accessing my database until recently when I have > started getting the following error**** > > ** ** > > 2012-03-07 13:07:03,216 [Thread-3] ERROR > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed > to load stored procedures**** > > com.ibm.db2.jcc.am.SqlDataException: [jcc][t4][10275][10041][3.61.65] > Unsupported ccsid, encoding, or locale: "Cp858". ERRORCODE=-4220, > SQLSTATE=22021**** > > at com.ibm.db2.jcc.am.ed.a(ed.java:668)**** > > at com.ibm.db2.jcc.am.ed.a(ed.java:60)**** > > at com.ibm.db2.jcc.am.ed.a(ed.java:85)**** > > at com.ibm.db2.jcc.am.o.a(o.java:432)**** > > at com.ibm.db2.jcc.t4.cc.a(cc.java:2349)**** > > at com.ibm.db2.jcc.t4.cb.a(cb.java:3407)**** > > at com.ibm.db2.jcc.t4.cb.a(cb.java:1982)**** > > at com.ibm.db2.jcc.t4.cb.b(cb.java:1919)**** > > at com.ibm.db2.jcc.t4.cb.a(cb.java:1887)**** > > at com.ibm.db2.jcc.t4.cb.l(cb.java:574)**** > > at com.ibm.db2.jcc.t4.cb.k(cb.java:348)**** > > at com.ibm.db2.jcc.t4.cb.e(cb.java:97)**** > > at com.ibm.db2.jcc.t4.q.e(q.java:81)**** > > at com.ibm.db2.jcc.t4.rb.k(rb.java:160)**** > > at com.ibm.db2.jcc.am.gn.jb(gn.java:2188)**** > > at com.ibm.db2.jcc.am.hn.b(hn.java:3917)**** > > at com.ibm.db2.jcc.am.in.dc(in.java:144)**** > > at com.ibm.db2.jcc.am.jc.a(jc.java:7799)**** > > at com.ibm.db2.jcc.am.jc.a(jc.java:6091)**** > > at com.ibm.db2.jcc.am.jc.a(jc.java:6018)**** > > at com.ibm.db2.jcc.am.jc.getProcedures(jc.java:6008)**** > > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:755) > **** > > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:597) > **** > > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:412) > **** > > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:351) > **** > > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187) > **** > > at > net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:241) > **** > > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) > **** > > at java.lang.Thread.run(Unknown Source)**** > > Caused by: java.io.UnsupportedEncodingException: Cp858**** > > at sun.io.Converters.getConverterClass(Unknown Source)**** > > at sun.io.Converters.newConverter(Unknown Source)**** > > at sun.io.ByteToCharConverter.getConverter(Unknown Source) > **** > > at com.ibm.db2.jcc.am.u.<init>(u.java:10)**** > > at com.ibm.db2.jcc.am.s.a(s.java:10)**** > > at com.ibm.db2.jcc.am.o.a(o.java:428)**** > > ... 25 more**** > > ** ** > > Any tips/ suggestions ?**** > > ** ** > > Matt **** > > This message was created by: > *MATT DICKINSON* –* Senior Consultant - UK Technology Centre* > > Innovation Group > *Tel:** **+44 (0) 1489 898370 I* * **Fax:** **+44 (0) 1489 579181 I* * **Mob: > **+44 (0) 7818 032113 I* * **E-mail:** ** > dic...@uk... I* * **Web:** ** > www.uk.innovation-group.com***** > > ** ** > > ________________________________________________________________________ > Any opinions expressed in this email are those of the individual and not > necessarily the company. The contents of this email and any attachments are > confidential to The Innovation Group PLC and are solely for use by the > intended recipient at the email address to which it has been addressed. > > This email and any attachments may not be disclosed to or used by anyone > other than the intended recipient, nor may it be copied in any way. If you > have received this email in error, please forward a copy of this email to > its...@uk... and then delete it from your system. > > The Innovation Group PLC: Registered in England 3256771 > Registered Office: Yarmouth House 1300 Parkway Solent Business Park > Whiteley Hampshire PO15 7AE UK > http://www.innovation-group.com > > This email and any attachments has been swept for computer viruses. > Neither The Innovation Group PLC nor the sender accept any responsibility > for computer viruses once this email has been transmitted. > > > ------------------------------------------------------------------------------ > Virtualization & Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a service. > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
|
From: CptBlaubaer <cpt...@gm...> - 2012-03-08 21:38:31
|
Hi Stan, what kind of databases do you use? With Oracle you could use database links, from SQuirreL's point of view you would then query one database. I don't know about another alternative for your ideas. Perhaps you can provide some more information? Take care Andreas Am 08.03.2012 18:24 schrieb "Stan Dragnev" <sdr...@rn...>: > Hi, > > Is it possible to run a query that joins tables across multiple > databases in Squirrel SQL? > E.g.: > select * from db1.table1 inner join db2.table2... > > I created a user with permissions for both and connected to the host but > when trying to query I was getting a no default database selected error. > Maybe I'm missing something obvious! > > Thanks. > > Stan > > > ------------------------------------------------------------------------------ > Virtualization & Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a service. > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Stan D. <sdr...@rn...> - 2012-03-08 17:23:42
|
Hi, Is it possible to run a query that joins tables across multiple databases in Squirrel SQL? E.g.: select * from db1.table1 inner join db2.table2... I created a user with permissions for both and connected to the host but when trying to query I was getting a no default database selected error. Maybe I'm missing something obvious! Thanks. Stan |
|
From: Stefan W. <ste...@ao...> - 2012-03-08 14:10:59
|
Hi, by default, SQuirreL SQL will remember only the last 100 entries of the SQL History. You can configure this by "New Session Properties ==> SQL ==> SQL History". SQuirreL save the history in a file called "sql_history.xml". (See your home directory. There should be a folder called ".squirrel-sql"). So older entries are no more avaiable. I think, you can only recover the history, if you have a periodically backup of this file/folder. Stefan Am 2012-03-07 23:25, schrieb Furze: > Hi > > Long story but I need to recover my scripts - I see many but not all in > sql_history.xml Does this file automatically delete older entries. If so, can > they be recovered ? > > Regards > > > > ------------------------------------------------------------------------------ > Virtualization& Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a service. > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Furze <jfk...@ei...> - 2012-03-07 22:35:11
|
Hi Long story but I need to recover my scripts - I see many but not all in sql_history.xml Does this file automatically delete older entries. If so, can they be recovered ? Regards |
|
From: Dickinson, M. <dic...@uk...> - 2012-03-07 15:05:51
|
Hi
Hopefully someone can help me. I have been using SQL squirrel to access
a DB2 database on a AS400.
I have been successfully accessing my database until recently when I
have started getting the following error
2012-03-07 13:07:03,216 [Thread-3] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo -
Failed to load stored procedures
com.ibm.db2.jcc.am.SqlDataException: [jcc][t4][10275][10041][3.61.65]
Unsupported ccsid, encoding, or locale: "Cp858". ERRORCODE=-4220,
SQLSTATE=22021
at com.ibm.db2.jcc.am.ed.a(ed.java:668)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:85)
at com.ibm.db2.jcc.am.o.a(o.java:432)
at com.ibm.db2.jcc.t4.cc.a(cc.java:2349)
at com.ibm.db2.jcc.t4.cb.a(cb.java:3407)
at com.ibm.db2.jcc.t4.cb.a(cb.java:1982)
at com.ibm.db2.jcc.t4.cb.b(cb.java:1919)
at com.ibm.db2.jcc.t4.cb.a(cb.java:1887)
at com.ibm.db2.jcc.t4.cb.l(cb.java:574)
at com.ibm.db2.jcc.t4.cb.k(cb.java:348)
at com.ibm.db2.jcc.t4.cb.e(cb.java:97)
at com.ibm.db2.jcc.t4.q.e(q.java:81)
at com.ibm.db2.jcc.t4.rb.k(rb.java:160)
at com.ibm.db2.jcc.am.gn.jb(gn.java:2188)
at com.ibm.db2.jcc.am.hn.b(hn.java:3917)
at com.ibm.db2.jcc.am.in.dc(in.java:144)
at com.ibm.db2.jcc.am.jc.a(jc.java:7799)
at com.ibm.db2.jcc.am.jc.a(jc.java:6091)
at com.ibm.db2.jcc.am.jc.a(jc.java:6018)
at com.ibm.db2.jcc.am.jc.getProcedures(jc.java:6008)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQ
LDatabaseMetaData.java:755)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privat
eLoadStoredProcedures(SchemaInfo.java:597)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadSt
oredProcedures(SchemaInfo.java:412)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privat
eLoadAll(SchemaInfo.java:351)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initia
lLoad(SchemaInfo.java:187)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:2
41)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:
82)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.UnsupportedEncodingException: Cp858
at sun.io.Converters.getConverterClass(Unknown Source)
at sun.io.Converters.newConverter(Unknown Source)
at sun.io.ByteToCharConverter.getConverter(Unknown
Source)
at com.ibm.db2.jcc.am.u.<init>(u.java:10)
at com.ibm.db2.jcc.am.s.a(s.java:10)
at com.ibm.db2.jcc.am.o.a(o.java:428)
... 25 more
Any tips/ suggestions ?
Matt
This message was created by:
MATT DICKINSON - Senior Consultant - UK Technology Centre
Innovation Group
Tel: +44 (0) 1489 898370 I Fax: +44 (0) 1489 579181 I Mob: +44 (0)
7818 032113 I E-mail: dic...@uk... I Web:
www.uk.innovation-group.com
________________________________________________________________________
Any opinions expressed in this email are those of the individual and not necessarily the company. The contents of this email and any attachments are confidential to The Innovation Group PLC and are solely for use by the intended recipient at the email address to which it has been addressed.
This email and any attachments may not be disclosed to or used by anyone other than the intended recipient, nor may it be copied in any way. If you have received this email in error, please forward a copy of this email to its...@uk... and then delete it from your system.
The Innovation Group PLC: Registered in England 3256771
Registered Office: Yarmouth House 1300 Parkway Solent Business Park Whiteley Hampshire PO15 7AE UK
http://www.innovation-group.com
This email and any attachments has been swept for computer viruses. Neither The Innovation Group PLC nor the sender accept any responsibility for computer viruses once this email has been transmitted. |
|
From: Alexandre P. <Ale...@ei...> - 2012-03-06 19:11:58
|
If you specify the last column as LD_TS TIMESTAMP NOT NULL WITH DEFAULT DB2 should populate it with the timestamp at the time of load. -- 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) > -----Original Message----- > From: tells1977 [mailto:ct...@gm...] > Sent: Monday, March 05, 2012 5:49 PM > To: squ...@li... > Subject: [Squirrel-sql-users] Import File Plugin with Timestamp field > > > I am attempting to import a CSV file into a database that has a TIMESTAMP > column. > > Create table DB2.TEST_Table ( > FIELD1 CHAR(18), > FIELD2 CHAR(2), > FIELD3 CHAR(5), > FIELD4 CHAR(2), > FIELD5 CHAR(1), > FIELD6 CHAR(1), > LD_TS TIMESTAMP NOT NULL ) > > My input file would contain FIELDS1 - FIELDS6. LD_TS is the load > timestamp. > I tried using fix format in the import function but I am unable to find a > value that will work correctly. Is there any way to use the import > function and also populate the timestamp field? > -- > View this message in context: http://old.nabble.com/Import-File-Plugin- > with-Timestamp-field-tp33447560p33447560.html > Sent from the squirrel-sql-users mailing list archive at Nabble.com. > > > -------------------------------------------------------------------------- > ---- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Robert M. <rob...@gm...> - 2012-03-06 13:08:55
|
To echo Stefan's comments, the SID is usually 8 characters or less. A service name is typically specified in tnsnames.ora and allows Oracle apps (such as SQL*Plus) to connect to a remote database. If you use SQL*Plus to login to the database as the sys user (or any privileged user 'as sysdba') and execute the following command: show parameter DB_NAME; You should get the correct value to use for the SID. Rob On Mon, Mar 5, 2012 at 1:36 PM, Stefan Willinger <ste...@ao...> wrote: > ** > Hi, > > The IOException indicates, that you can't reach the DB-Host. > > Try one of the following on a command line: > * ping hostname > * telnet hostname portNumber > > The telnet must be successfully. > > But please, check if you have the right host and SID > > *PFNGFD01.ukroi.tesco.org* looks a little bit strange for a SID. Looks > more like a DB-Hostname as a SID. > > Stefan > > > > Am 2012-03-05 15:55, schrieb hechesspee: > > Hi, > I'm using Squirrel 3.3.0 and Oracle 9i client. > I configured the Oracle Thin driver by using the ojdbc14.jar in the Extra > Class Path > > Then I configured the alias as below (apart from login details) > > jdbc:oracle:thin:UKIRP251:1521:PFNGFD01.ukroi.tesco.org > > where HOST = UKIRP251 and SERVICE_NAME = PFNGFD01.ukroi.tesco.org > > However I'm unable to connect and I'm getting the error as - > > IO exception. The network adapter could not establish the connection. > > Can anyone help me resolve this? > > Regards > Harsha > > > > ------------------------------------------------------------------------------ > Try before you buy = See our experts in action! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-dev2 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
|
From: tells1977 <ct...@gm...> - 2012-03-05 22:49:22
|
I am attempting to import a CSV file into a database that has a TIMESTAMP column. Create table DB2.TEST_Table ( FIELD1 CHAR(18), FIELD2 CHAR(2), FIELD3 CHAR(5), FIELD4 CHAR(2), FIELD5 CHAR(1), FIELD6 CHAR(1), LD_TS TIMESTAMP NOT NULL ) My input file would contain FIELDS1 - FIELDS6. LD_TS is the load timestamp. I tried using fix format in the import function but I am unable to find a value that will work correctly. Is there any way to use the import function and also populate the timestamp field? -- View this message in context: http://old.nabble.com/Import-File-Plugin-with-Timestamp-field-tp33447560p33447560.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: Stefan W. <ste...@ao...> - 2012-03-05 18:36:56
|
Hi, The IOException indicates, that you can't reach the DB-Host. Try one of the following on a command line: * ping hostname * telnet hostname portNumber The telnet must be successfully. But please, check if you have the right host and SID /PFNGFD01.ukroi.tesco.org/ looks a little bit strange for a SID. Looks more like a DB-Hostname as a SID. Stefan Am 2012-03-05 15:55, schrieb hechesspee: > Hi, > I'm using Squirrel 3.3.0 and Oracle 9i client. > I configured the Oracle Thin driver by using the ojdbc14.jar in the Extra > Class Path > > Then I configured the alias as below (apart from login details) > > jdbc:oracle:thin:UKIRP251:1521:PFNGFD01.ukroi.tesco.org > > where HOST = UKIRP251 and SERVICE_NAME = PFNGFD01.ukroi.tesco.org > > However I'm unable to connect and I'm getting the error as - > > IO exception. The network adapter could not establish the connection. > > Can anyone help me resolve this? > > Regards > Harsha |
|
From: Drav S. <ho...@re...> - 2012-03-05 17:42:43
|
hechesspee wrote: > Hi, > I'm using Squirrel 3.3.0 and Oracle 9i client. > I configured the Oracle Thin driver by using the ojdbc14.jar in the Extra > Class Path > > Then I configured the alias as below (apart from login details) > > jdbc:oracle:thin:UKIRP251:1521:PFNGFD01.ukroi.tesco.org > > where HOST = UKIRP251 and SERVICE_NAME = PFNGFD01.ukroi.tesco.org > > However I'm unable to connect and I'm getting the error as - > > IO exception. The network adapter could not establish the connection. > > Can anyone help me resolve this? A thin client does not use the TNS name lookup. The schema for thin clients is: jdbc:oracle:thin:@<server>[:<1521>]:<database_name> <server> would be PFNGFD01.ukroi.tesco.org I assume? It has to be resolvable by DNS. <1521> is the port it connects on and <database_name> is the schema you need to access. Regards D. |
|
From: Drav S. <hol...@re...> - 2012-03-05 17:42:31
|
hechesspee wrote: > I want to connect to Oracle DB using Squirrel. I'm using oracle 9i as the > client. > Can someone guide me or send me a link to any post where it is explained? Download the JDBC client (if you haven't already got it installed), I use ojdbc6.jar personally (connects to 10g and 11g just fine). And install it. http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html Click on drivers, scroll down and double click Oracle Thin Driver. Click Extra Class Path, and click Add. Navigate to the ojdbc file you just installed. oracle.jdbc.OracleDriver should appear in the class name. Click Ok. The log window should say: Driver class oracle.jdbc.OracleDriver successfully registered for driver definition: Oracle Thin Driver Add a new Alias, Set the Driver to the Oracle Thin driver and fill in the details. Regards D. |
|
From: hechesspee <har...@gm...> - 2012-03-05 14:55:54
|
Hi, I'm using Squirrel 3.3.0 and Oracle 9i client. I configured the Oracle Thin driver by using the ojdbc14.jar in the Extra Class Path Then I configured the alias as below (apart from login details) jdbc:oracle:thin:UKIRP251:1521:PFNGFD01.ukroi.tesco.org where HOST = UKIRP251 and SERVICE_NAME = PFNGFD01.ukroi.tesco.org However I'm unable to connect and I'm getting the error as - IO exception. The network adapter could not establish the connection. Can anyone help me resolve this? Regards Harsha -- View this message in context: http://old.nabble.com/Unable-to-connect-to-Oracle-DB-using-Squirrel-tp33443998p33443998.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: hechesspee <har...@gm...> - 2012-03-02 12:24:34
|
Hi, I want to connect to Oracle DB using Squirrel. I'm using oracle 9i as the client. Can someone guide me or send me a link to any post where it is explained? Thanks in advance! Harsha -- View this message in context: http://old.nabble.com/Connecting-to-oracle-DB-using-Squirrel-3.3.0-tp33428009p33428009.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: hechesspee <har...@gm...> - 2012-03-02 12:22:36
|
Hi, This has been answered by Robert Manning. I'm putting the reply from him for others. What I would do in this case is edit squirrel-sql.bat and put something like this at the top just after "@echo off": set JAVA_HOME=<path to java> <path to java> should be an absolute path to the folder containing "bin", "lib", "jre" and such. If <path to java> for you is a path that contains spaces, you may need to adjust quotes in the rest of the script. If <path to java> does not contain spaces, then all the better. regards Harsha hechesspee wrote: > > Hi, > I installed Squirrel 3.3.0 to connect to vertica DB and it was fine. > Later I installed Oracle 9i(9.2.0.1.0) client which installed JVM > C:\Program Files\Oracle\jre\1.3.1 > > Now my squirrel is not working. When I open it, it says - Java Virtual > Machine must be atleast 1.6 where as JVM is 1.3.1 > > I tried installing the latest version of JVM. But even after the > installation, i got the same message. > > Is there any way that I can use squirrel 3.3.0 with oracle 9i being > installed? > > Thanks in advance! > Harsha > -- View this message in context: http://old.nabble.com/Squirrel-3.3.0-not-running-after-oracle-9i-installation-tp33367115p33427995.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: Robert M. <rob...@gm...> - 2012-02-22 03:21:28
|
Ahh yes, the good ol' days of 9i on windows. It's nice how it decides which version of Java you want to use when it puts it's own version in *front* of everything else in your %PATH%. What I would do in this case is edit squirrel-sql.bat and put something like this at the top just after "@echo off": set JAVA_HOME=<path to java> <path to java> should be an absolute path to the folder containing "bin", "lib", "jre" and such. If <path to java> for you is a path that contains spaces, you may need to adjust quotes in the rest of the script. If <path to java> does not contain spaces, then all the better. Rob On Tue, Feb 21, 2012 at 4:37 PM, hechesspee <har...@gm...>wrote: > > Hi, > I installed Squirrel 3.3.0 to connect to vertica DB and it was fine. > Later I installed Oracle 9i(9.2.0.1.0) client which installed JVM > C:\Program > Files\Oracle\jre\1.3.1 > > Now my squirrel is not working. When I open it, it says - Java Virtual > Machine must be atleast 1.6 where as JVM is 1.3.1 > > I tried installing the latest version of JVM. But even after the > installation, i got the same message. > > Is there any way that I can use squirrel 3.3.0 with oracle 9i being > installed? > > Thanks in advance! > Harsha > -- > View this message in context: > http://old.nabble.com/Squirrel-3.3.0-not-running-after-oracle-9i-installation-tp33367115p33367115.html > Sent from the squirrel-sql-users mailing list archive at Nabble.com. > > > > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: hechesspee <har...@gm...> - 2012-02-21 21:36:23
|
Hi, I installed Squirrel 3.3.0 to connect to vertica DB and it was fine. Later I installed Oracle 9i(9.2.0.1.0) client which installed Now my squirrel is not working. When I open it, it says - Java Virtual Machine must be atleast 1.6 where as JVM is C:\Program Files\Oracle\jre\1.3.1 I tried installing the latest version of JVM. But even after the installation, i got the same message. Is there any way that I can use squirrel 3.3.0 with oracle 9i being installed? Thanks in advance! Harsha -- View this message in context: http://old.nabble.com/Squirrel-3.3.0-not-running-after-oracle-9i-installation-tp33367115p33367115.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: Robert M. <rob...@gm...> - 2012-02-17 22:40:47
|
Hi Perry, When you say "stored scripts", what exactly are you referring to? Can you give me an example? Rob On Thu, Feb 16, 2012 at 8:40 PM, Perry Bullied <per...@gm...>wrote: > First visit to site, I was unaware of a User's Group. > > > The only difficulty I have run into so far; can your stored scripts be > exported? > > > ------------------------------------------------------------------------------ > Virtualization & Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a service. > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
|
From: Perry B. <per...@gm...> - 2012-02-17 01:40:28
|
First visit to site, I was unaware of a User's Group. The only difficulty I have run into so far; can your stored scripts be exported? |
|
From: KARR, D. <dk...@at...> - 2012-02-10 15:01:20
|
> -----Original Message----- > From: Alexandre Peshansky [mailto:Ale...@ei...] > Sent: Friday, February 10, 2012 6:51 AM > To: squ...@li... > Subject: Re: [Squirrel-sql-users] Can't see table schema through > SYNONYM, but SQL Developer can see it in "Other Users" > > On Thu, Feb 09, 2012 at 2:34 PM, "KARR, DAVID" <dk...@at...> wrote: > > > > I have read-only credentials for an Oracle database. We have to > access > > many of the tables through a synonym. I can query them, but I can't > see > > the column definitions. I can do completion on the column names in > the > > SQL buffer, but I'd still like to be able to see the column > definitions. > > > > Someone else here uses SQL Developer to access the same database, > using > > the same credentials, and if they go to the "Other Users" section, > they're > > able to see the column definitions. > > > > Is there an analog of this in SQuirreL, or is it not possible to do > this > > at this time? > > David, > Did you select "Allow all Schemas" under "Oracle" tab in alias > properties? I just set that, and renewed my connection and refreshed my schema and redisplayed the "Columns" tab of a synonym, and it's still empty. > > -----Original Message----- > > From: KARR, DAVID [mailto:dk...@at...] > > Sent: Thursday, February 09, 2012 2:34 PM > > To: squ...@li... > > Subject: [Squirrel-sql-users] Can't see table schema through SYNONYM, > but > > SQL Developer can see it in "Other Users" > > --------------------------------------------------------------------- > ----- > > ---- > > Virtualization & Cloud Management Using Capacity Planning Cloud > computing > > makes use of virtualization - but cloud computing also focuses on > allowing > > computing to be delivered as a service. > > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > ----------------------------------------------------------------------- > ------- > Virtualization & Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a service. > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
