squirrel-sql-users Mailing List for SQuirreL SQL Client (Page 129)
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
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
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Eric T. <eto...@de...> - 2006-03-12 06:57:15
|
Just noticed a typo in what I sent. I said "classpath" but meant "system path" :) Regards, Eric Eric Townson wrote: > Are you using the Sun JRE? You can test what JRE is being picked up on > the classpath by typing java -version at a command prompt > (Start/Run/cmd <enter>). If so, I would go to the Control Panel and > open the Java control center and make sure the Sun Java is the default > JRE. If that doesn't work then I would try uninstalling and > reinstalling it. That should set things right again. I'd also go with > the latest 5.0 version. > > Another option would be to run the batch file that SQuirreL uses to > launch from the command prompt. It will be best to first CD to the > SQuirreL folder. This might allow you to see some more error messages. > Finally, you could make a copy of this batch file and modify it. > > Regards, > Eric > > Steve Dunn wrote: >> I've just installed Squirrel and can't seem to get it to run. When I >> double-click the desktop icon I get a windows error box. At first it >> couldn't find 'javaw', so I copied it into Squirrel's folder. Now it >> says it can't find the JRE. My classpath is set so it should find it. >> Can anyone provide any assistance . . . your help would be greatly >> appreciated. >> >> Thanks, >> >> *Steve* >> > ------------------------------------------------------- This SF.Net > email is sponsored by xPML, a groundbreaking scripting language that > extends applications into web and mobile media. Attend the live > webcast and join the prime developer group breaking into this new > coding territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ Squirrel-sql-users > mailing list Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Matthew D. <mda...@su...> - 2006-03-12 05:21:16
|
The first step you should try is to run squirrel-sql.bat from the command line as the previous email suggests. This is generally the easiest way to find out what's wrong. In your case it sounds like SQuirreL isn't finding java. Your technique of solving it was "move Java to SQuirrel". I think you'll find it's better to try the technique of "point SQuirreL to Java". To do this you could modify environment variables so that JAVA_HOME is well defined. But I find it easier to directly modify squirrel-sql.bat so I know exactly what's going on. Try this idea to get a squirrel-sql.bat file that looks like this: @echo off IF "%JAVA_HOME%"=="" SET LOCAL_JAVA=java IF NOT "%JAVA_HOME%"=="" SET LOCAL_JAVA=%JAVA_HOME%\bin\java rem Note to myself: the following line was added by me (31 Jan 2006) SET LOCAL_JAVA=C:\j2sdk1.4.2_04\bin\java set SQUIRREL_SQL_HOME=C:\Program Files\SQuirreL SQL Client [standard squirrel-sql.bat continues...] You probably have a JRE rather than a JDK (or SDK or whatever it's called). So your path to it will be something like this: C:\Program Files\Java\jdk1.5.0_06\bin\java Regards, Matt _____ From: squ...@li... [mailto:squ...@li...] On Behalf Of Eric Townson Sent: Sunday, March 12, 2006 6:47 AM To: squ...@li... Subject: Re: [Squirrel-sql-users] Trouble Running Squirrel Are you using the Sun JRE? You can test what JRE is being picked up on the classpath by typing java -version at a command prompt (Start/Run/cmd <enter>). If so, I would go to the Control Panel and open the Java control center and make sure the Sun Java is the default JRE. If that doesn't work then I would try uninstalling and reinstalling it. That should set things right again. I'd also go with the latest 5.0 version. Another option would be to run the batch file that SQuirreL uses to launch from the command prompt. It will be best to first CD to the SQuirreL folder. This might allow you to see some more error messages. Finally, you could make a copy of this batch file and modify it. Regards, Eric Steve Dunn wrote: I've just installed Squirrel and can't seem to get it to run. When I double-click the desktop icon I get a windows error box. At first it couldn't find 'javaw', so I copied it into Squirrel's folder. Now it says it can't find the JRE. My classpath is set so it should find it. Can anyone provide any assistance . . . your help would be greatly appreciated. Thanks, Steve ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Eric T. <eto...@de...> - 2006-03-11 22:48:24
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> <font face="Microsoft Sans Serif">Are you using the Sun JRE? </font><font face="Microsoft Sans Serif">You can test what JRE is being picked up on the classpath by typing java -version at a command prompt (Start/Run/cmd <enter>). </font><font face="Microsoft Sans Serif">If so, I would go to the Control Panel and open the Java control center and make sure the Sun Java is the default JRE. If that doesn't work then I would try uninstalling and reinstalling it. That should set things right again. I'd also go with the latest </font><font face="Microsoft Sans Serif">5.0 </font><font face="Microsoft Sans Serif">version.<br> <br> Another option would be to run the batch file that SQuirreL uses to launch from the command prompt. It will be best to first CD to the SQuirreL folder. This might allow you to see some more error messages. Finally, you could make a copy of this batch file and modify it.<br> <br> Regards,<br> Eric</font><br> <br> Steve Dunn wrote: <blockquote cite="mid...@ma..." type="cite"> <meta http-equiv="Content-Type" content="text/html; "> <meta content="MSHTML 6.00.2800.1528" name="GENERATOR"> <div><font face="Comic Sans MS" size="2"><span class="577592403-10032006">I've just installed Squirrel and can't seem to get it to run. When I double-click the desktop icon I get a windows error box. At first it couldn't find 'javaw', so I copied it into Squirrel's folder. Now it says it can't find the JRE. My classpath is set so it should find it. Can anyone provide any assistance . . . your help would be greatly appreciated.</span></font></div> <div><font face="Comic Sans MS" size="2"><span class="577592403-10032006"></span></font> </div> <div><font face="Comic Sans MS" size="2"><span class="577592403-10032006">Thanks,</span></font></div> <div> </div> <div align="left"><strong><font color="#000080" face="Comic Sans MS" size="2">Steve</font></strong></div> <div align="left"> </div> <div> </div> </blockquote> </body> </html> |
From: Steve D. <sd...@in...> - 2006-03-10 03:29:49
|
I've just installed Squirrel and can't seem to get it to run. When I double-click the desktop icon I get a windows error box. At first it couldn't find 'javaw', so I copied it into Squirrel's folder. Now it says it can't find the JRE. My classpath is set so it should find it. Can anyone provide any assistance . . . your help would be greatly appreciated. =20 Thanks, =20 Steve <mailto:sd...@in...>=20 =20 |
From: Tom J W. Jr <twi...@cs...> - 2006-03-09 16:02:39
|
DQoNCg0KDQpJIHdhbnRlZCB0byBsZXQgZXZlcnlvbmUga25vdyB0aGF0IHdlIGdvdCBhY2Nlc3Mg dG8gdGhlIFNZU0FETSBzY2hlbWENCm9iamVjdHMgZm9yIG90aGVyIGFjY291bnRzIHdpdGhvdXQg bW9kaWZ5aW5nIHRoZSBleGlzdGluZyBPcmFjbGUgc2VjdXJpdHkuDQoNCkFsbCB3ZSBkaWQgd2Fz IGdvIGludG8gdGhlIFNRdWlycmVMIFNRTCBzZXNzaW9uIHByb3BlcnRpZXMgYW5kIG1vZGlmeSB0 aGUNCk9iamVjdCBUcmVlIEZpbHRlciB0byBpbmNsdWRlIFNZU0FETSBhbmQgU1lTLiAgV2UgdGhl biBwZXJmb3JtZWQgYSByZWZyZXNoDQpvZiB0aGUgU1F1aXJyZUwgY2xpZW50IG9iamVjdCB0cmVl IGFuZCB3ZSBzdWRkZW5seSBzYXcgYWxsIFRhYmxlcywgVmlld3MsDQpldGMuDQoNClJlZ2FyZHMs DQpUb20gV2lsbGlhbXMgSnIuICAg4oC5DQpQZW9wbGVTb2Z0IFN1cHBvcnQNCg0KDQoNCg0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0NCg0KVGhpcyBpcyBhIFBSSVZBVEUgbWVzc2FnZS4gSWYgeW91IGFyZSBub3QgdGhlIGludGVu ZGVkIHJlY2lwaWVudCwgcGxlYXNlDQpkZWxldGUgd2l0aG91dCBjb3B5aW5nIGFuZCBraW5kbHkg YWR2aXNlIHVzIGJ5IGUtbWFpbCBvZiB0aGUgbWlzdGFrZSBpbg0KZGVsaXZlcnkuIE5PVEU6IFJl Z2FyZGxlc3Mgb2YgY29udGVudCwgdGhpcyBlLW1haWwgc2hhbGwgbm90IG9wZXJhdGUgdG8NCmJp bmQgQ1NDIHRvIGFueSBvcmRlciBvciBvdGhlciBjb250cmFjdCB1bmxlc3MgcHVyc3VhbnQgdG8g ZXhwbGljaXQgd3JpdHRlbg0KYWdyZWVtZW50IG9yIGdvdmVybm1lbnQgaW5pdGlhdGl2ZSBleHBy ZXNzbHkgcGVybWl0dGluZyB0aGUgdXNlIG9mIGUtbWFpbA0KZm9yIHN1Y2ggcHVycG9zZS4NCi0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQoNCg0KDQoNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgIHNxdWlycmVsLXNx bC11c2VyICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAg ICAgICAgICAgcy1yZXF1ZXN0QGxpc3RzLnMgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICANCiAgICAgICAgICAgICBvdXJjZWZvcmdlLm5ldCAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFRvIA0KICAgICAgICAgICAgIFNlbnQgYnk6 ICAgICAgICAgICAgICAgICAgc3F1aXJyZWwtc3FsLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmcgDQog ICAgICAgICAgICAgc3F1aXJyZWwtc3FsLXVzZXIgICAgICAgICBlLm5ldCAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICBzLWFkbWluQGxpc3RzLnNvdSAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNjIA0KICAgICAgICAgICAgIHJjZWZv cmdlLm5ldCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgU3ViamVjdCANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIFNxdWlycmVsLXNxbC11c2VycyBkaWdlc3QsIFZvbCAxICAgIA0KICAgICAgICAgICAgIDAz LzA4LzIwMDYgMDg6MTEgICAgICAgICAgIzMwMSAtIDMgbXNncyAgICAgICAgICAgICAgICAgICAg ICAgDQogICAgICAgICAgICAgUE0gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgDQogICAgICAgICAgICAgUGxlYXNlIHJlc3BvbmQgdG8gICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICBzcXVpcnJlbC1zcWwtdXNl ciAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAg ICAgIHNAbGlzdHMuc291cmNlZm9yICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgDQogICAgICAgICAgICAgICAgICBnZS5uZXQgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgDQoNCg0KDQoNClNlbmQgU3F1aXJyZWwtc3FsLXVzZXJzIG1haWxpbmcgbGlz dCBzdWJtaXNzaW9ucyB0bw0KICAgICAgICAgICAgIHNxdWlycmVsLXNxbC11c2Vyc0BsaXN0cy5z b3VyY2Vmb3JnZS5uZXQNCg0KVG8gc3Vic2NyaWJlIG9yIHVuc3Vic2NyaWJlIHZpYSB0aGUgV29y bGQgV2lkZSBXZWIsIHZpc2l0DQoNCmh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3Rz L2xpc3RpbmZvL3NxdWlycmVsLXNxbC11c2Vycw0Kb3IsIHZpYSBlbWFpbCwgc2VuZCBhIG1lc3Nh Z2Ugd2l0aCBzdWJqZWN0IG9yIGJvZHkgJ2hlbHAnIHRvDQogICAgICAgICAgICAgc3F1aXJyZWwt c3FsLXVzZXJzLXJlcXVlc3RAbGlzdHMuc291cmNlZm9yZ2UubmV0DQoNCllvdSBjYW4gcmVhY2gg dGhlIHBlcnNvbiBtYW5hZ2luZyB0aGUgbGlzdCBhdA0KICAgICAgICAgICAgIHNxdWlycmVsLXNx bC11c2Vycy1hZG1pbkBsaXN0cy5zb3VyY2Vmb3JnZS5uZXQNCg0KV2hlbiByZXBseWluZywgcGxl YXNlIGVkaXQgeW91ciBTdWJqZWN0IGxpbmUgc28gaXQgaXMgbW9yZSBzcGVjaWZpYw0KdGhhbiAi UmU6IENvbnRlbnRzIG9mIFNxdWlycmVsLXNxbC11c2VycyBkaWdlc3QuLi4iDQoNCg0KVG9kYXkn cyBUb3BpY3M6DQoNCiAgIDEuIERpZmZlcmVuY2UgYmV0d2VlbiBPcmFjbGUgT0NJIENsaWVudCBh bmQgT3JhY2xlIFRoaW4gQ2xpZW50IGRyaXZlcnMNCihUb20gSiBXaWxsaWFtcyBKcikNCiAgIDIu IE9yYWNsZSBTY2hlbWEgUXVlc3Rpb24gKFRvbSBKIFdpbGxpYW1zIEpyKQ0KICAgMy4gUmU6IE9y YWNsZSBTY2hlbWEgUXVlc3Rpb24gKE1hdXJ5IEhhbW1lbCkNCg0KLS1fXy0tX18tLQ0KDQpNZXNz YWdlOiAxDQpUbzogc3F1aXJyZWwtc3FsLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldA0KRnJv bTogVG9tIEogV2lsbGlhbXMgSnIgPHR3aWxsaTU4QGNzYy5jb20+DQpEYXRlOiBXZWQsIDggTWFy IDIwMDYgMTI6MjY6NTcgLTA4MDANClN1YmplY3Q6IFtTcXVpcnJlbC1zcWwtdXNlcnNdIERpZmZl cmVuY2UgYmV0d2VlbiBPcmFjbGUgT0NJIENsaWVudCBhbmQNCk9yYWNsZSBUaGluIENsaWVudCBk cml2ZXJzDQoNCg0KDQoNCg0KRG9lcyBhbnlvbmUga25vdyB3aGF0IHRoZSBtYWluIGRpZmZlcmVu Y2VzIGJldHdlZW4gdGhlc2UgYXJlPyAgSXMgb25lDQpmYXN0ZXIgdGhhbiB0aGUgb3RoZXI/DQpX aGVuIEkgY29uZmlndXJlZCB0aGVtLCBJIHBvaW50ZWQgdGhlbSB0byB0aGUgc2FtZSBPcmFjbGUg SkRCQyBqYXIgZmlsZSBhbmQNCnRoZXkgc2VlbSB0byB3b3JrIHRoZSBzYW1lLg0KDQpSZWdhcmRz LA0KVG9tIFdpbGxpYW1zIEpyLg0KDQoNCg0KLS1fXy0tX18tLQ0KDQpNZXNzYWdlOiAyDQpUbzog c3F1aXJyZWwtc3FsLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldA0KRnJvbTogVG9tIEogV2ls bGlhbXMgSnIgPHR3aWxsaTU4QGNzYy5jb20+DQpEYXRlOiBXZWQsIDggTWFyIDIwMDYgMTM6MDY6 NDggLTA4MDANClN1YmplY3Q6IFtTcXVpcnJlbC1zcWwtdXNlcnNdIE9yYWNsZSBTY2hlbWEgUXVl c3Rpb24NCg0KRFFvTkNnMEtEUXBJWld4c2J5d05DZzBLUkc5bGN5Qmhibmx2Ym1VZ2EyNXZkeUJv YjNjZ2RHOGdiV0ZyWlNCMGFHVWdVMWxUUVVSTg0KDQpJRzl5SUdocFoyaGxjaUJzWlhabGJDQnpZ MmhsYldFZ1lYWmhhV3hoWW14bElIUnZEUXBoSUhWelpYSWdabTl5SUZacFpYY2dhVzRnDQoNCmRH aGxJRTlpYW1WamRDQkNjbTkzYzJWeUlIUm9ZWFFnYUdGMlpTQmhJR3h2ZDJWeUlHeGxkbVZzSUc5 bUlFOXlZV05zWlEwS1lXTmoNCg0KWlhOeklHbHVJRk5SZFdseWNtVk1MZzBLRFFwU1pXZGhjbVJ6 TEEwS1ZHOXRJRmRwYkd4cFlXMXpJRXB5TGlBZ0lPS0F1UTBLVUdWdg0KDQpjR3hsVTI5bWRDQlRk WEJ3YjNKMERRcFRSRVJESUZCb2IyNWxJRG9nS0RnMU9Da2dOVGN6TGpNek16RU5Da05sYkd3Z1VH aHZibVVnDQoNCk9pQW9OakU1S1NBek5ERXVNalkxTWcwS1ZHVjRkQ0JOWlhOellXZGxJRFl4T1RN ME1USTJOVEpBZEdWc1pXWnNhWEF1WTI5dERRb04NCg0KQ2cwS0RRb3RMUzB0TFMwdExTMHRMUzB0 TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdA0KDQpM UzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExT MHRMUzB0TFMwdExTMHRMUzB0DQoNCkxTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMw dExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHQNCg0KTFMwdExTMHRMUzB0 TFEwS0RRcFVhR2x6SUdseklHRWdVRkpKVmtGVVJTQnRaWE56WVdkbExpQkpaaUI1YjNVZ1lYSmxJ RzV2ZENCMA0KDQphR1VnYVc1MFpXNWtaV1FnY21WamFYQnBaVzUwTENCd2JHVmhjMlVOQ21SbGJH VjBaU0IzYVhSb2IzVjBJR052Y0hscGJtY2dZVzVrDQoNCklHdHBibVJzZVNCaFpIWnBjMlVnZFhN Z1lua2daUzF0WVdsc0lHOW1JSFJvWlNCdGFYTjBZV3RsSUdsdURRcGtaV3hwZG1WeWVTNGcNCg0K VGs5VVJUb2dVbVZuWVhKa2JHVnpjeUJ2WmlCamIyNTBaVzUwTENCMGFHbHpJR1V0YldGcGJDQnph R0ZzYkNCdWIzUWdiM0JsY21GMA0KDQpaU0IwYncwS1ltbHVaQ0JEVTBNZ2RHOGdZVzU1SUc5eVpH VnlJRzl5SUc5MGFHVnlJR052Ym5SeVlXTjBJSFZ1YkdWemN5QndkWEp6DQoNCmRXRnVkQ0IwYnlC bGVIQnNhV05wZENCM2NtbDBkR1Z1RFFwaFozSmxaVzFsYm5RZ2IzSWdaMjkyWlhKdWJXVnVkQ0Jw Ym1sMGFXRjANCg0KYVhabElHVjRjSEpsYzNOc2VTQndaWEp0YVhSMGFXNW5JSFJvWlNCMWMyVWdi MllnWlMxdFlXbHNEUXBtYjNJZ2MzVmphQ0J3ZFhKdw0KDQpiM05sTGcwS0xTMHRMUzB0TFMwdExT MHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0DQoN CkxTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0 TFMwdExTMHRMUzB0TFMwdExTMHQNCg0KTFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRM UzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdExTMHRMUzB0TFMwdA0KDQpMUzB0TFMwdExT MHRMUzBOQ2c9PQ0KDQoNCg0KDQotLV9fLS1fXy0tDQoNCk1lc3NhZ2U6IDMNCkRhdGU6IFdlZCwg MDggTWFyIDIwMDYgMTU6MjM6MjYgLTA2MDANCkZyb206IE1hdXJ5IEhhbW1lbCA8bWwxLmhhbW1l bEBzaGF3LmNhPg0KVG86IHNxdWlycmVsLXNxbC11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQN ClN1YmplY3Q6IFJlOiBbU3F1aXJyZWwtc3FsLXVzZXJzXSBPcmFjbGUgU2NoZW1hIFF1ZXN0aW9u DQoNCg0KVG9tIEogV2lsbGlhbXMgSnIgd3JvdGU6DQoNCj4gRG9lcyBhbnlvbmUga25vdyBob3cg dG8gbWFrZSB0aGUgU1lTQURNIG9yIGhpZ2hlciBsZXZlbCBzY2hlbWEgYXZhaWxhYmxlDQp0bw0K PiBhIHVzZXIgZm9yIFZpZXcgaW4gdGhlIE9iamVjdCBCcm93c2VyIHRoYXQgaGF2ZSBhIGxvd2Vy IGxldmVsIG9mIE9yYWNsZQ0KPiBhY2Nlc3MgaW4gU1F1aXJyZUwuDQoNCkkgaGF2ZW4ndCBsb29r ZWQgYXQgdGhhdCBwYXJ0IG9mIHRoZSBjb2RlLCBidXQgSSB3b3VsZCBndWVzcyB0aGF0IHRoZQ0K T3JhY2xlIHVzZXIgeW91IGFyZSBsb2dnaW5nIGluIGFzIGhhcyB0byBoYXZlIGFjY2VzcyAoaS5l LiBHUkFOVCBTRUxFQ1QsDQouLi4pIHRvIHRoZSB0aGUgdGFibGVzIGluIHRoZSBzY2hlbWEgKFNZ U0FETSkgeW91IHdhbnQgdG8gYmUgYWJsZSB0byBzZWUuDQoNCg0KTWF1cnkNCg0KDQoNCg0KLS1f Xy0tX18tLQ0KDQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f Xw0KU3F1aXJyZWwtc3FsLXVzZXJzIG1haWxpbmcgbGlzdA0KU3F1aXJyZWwtc3FsLXVzZXJzQGxp c3RzLnNvdXJjZWZvcmdlLm5ldA0KaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMv bGlzdGluZm8vc3F1aXJyZWwtc3FsLXVzZXJzDQoNCg0KRW5kIG9mIFNxdWlycmVsLXNxbC11c2Vy cyBEaWdlc3QNCg== |
From: Thomas S. <th...@em...> - 2006-03-09 11:07:42
|
Sorry for this newbee questions: At Sourceforge I found a couple of diffenrent downloads and I am confused w= hich one is the most suitable for me: 1.) Under "v2.1 stable" I found: 2.1final plain zip=20 and 2.1final Windows/Linux/Others=20 Hmm, whats the difference ? By the way: Why is v2.1 placed BELOW v2.1.rC2 (on the top)? 2.) Under "2.1final plain zip " I found: squirrel-sql-2.1final-base.zip=20 and squirrel-sql-2.1final-standard.zip=20 What is the difference? 3.) Is there a version where all Database Plugins (MySQL, MSSL) are already= included or do I need in any case to download them separately ? Thx --=20 ___________________________________________________ Play 100s of games for FREE! http://games.mail.com/ |
From: Maury H. <ml1...@sh...> - 2006-03-08 21:23:44
|
Tom J Williams Jr wrote: > Does anyone know how to make the SYSADM or higher level schema available to > a user for View in the Object Browser that have a lower level of Oracle > access in SQuirreL. I haven't looked at that part of the code, but I would guess that the Oracle user you are logging in as has to have access (i.e. GRANT SELECT, ...) to the the tables in the schema (SYSADM) you want to be able to see. Maury |
From: Tom J W. Jr <twi...@cs...> - 2006-03-08 21:07:04
|
DQoNCg0KDQpIZWxsbywNCg0KRG9lcyBhbnlvbmUga25vdyBob3cgdG8gbWFrZSB0aGUgU1lTQURN IG9yIGhpZ2hlciBsZXZlbCBzY2hlbWEgYXZhaWxhYmxlIHRvDQphIHVzZXIgZm9yIFZpZXcgaW4g dGhlIE9iamVjdCBCcm93c2VyIHRoYXQgaGF2ZSBhIGxvd2VyIGxldmVsIG9mIE9yYWNsZQ0KYWNj ZXNzIGluIFNRdWlycmVMLg0KDQpSZWdhcmRzLA0KVG9tIFdpbGxpYW1zIEpyLiAgIOKAuQ0KUGVv cGxlU29mdCBTdXBwb3J0DQpTRERDIFBob25lIDogKDg1OCkgNTczLjMzMzENCkNlbGwgUGhvbmUg OiAoNjE5KSAzNDEuMjY1Mg0KVGV4dCBNZXNzYWdlIDYxOTM0MTI2NTJAdGVsZWZsaXAuY29tDQoN Cg0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLQ0KDQpUaGlzIGlzIGEgUFJJVkFURSBtZXNzYWdlLiBJZiB5b3UgYXJlIG5vdCB0 aGUgaW50ZW5kZWQgcmVjaXBpZW50LCBwbGVhc2UNCmRlbGV0ZSB3aXRob3V0IGNvcHlpbmcgYW5k IGtpbmRseSBhZHZpc2UgdXMgYnkgZS1tYWlsIG9mIHRoZSBtaXN0YWtlIGluDQpkZWxpdmVyeS4g Tk9URTogUmVnYXJkbGVzcyBvZiBjb250ZW50LCB0aGlzIGUtbWFpbCBzaGFsbCBub3Qgb3BlcmF0 ZSB0bw0KYmluZCBDU0MgdG8gYW55IG9yZGVyIG9yIG90aGVyIGNvbnRyYWN0IHVubGVzcyBwdXJz dWFudCB0byBleHBsaWNpdCB3cml0dGVuDQphZ3JlZW1lbnQgb3IgZ292ZXJubWVudCBpbml0aWF0 aXZlIGV4cHJlc3NseSBwZXJtaXR0aW5nIHRoZSB1c2Ugb2YgZS1tYWlsDQpmb3Igc3VjaCBwdXJw b3NlLg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0NCg== |
From: Tom J W. Jr <twi...@cs...> - 2006-03-08 20:27:25
|
Does anyone know what the main differences between these are? Is one faster than the other? When I configured them, I pointed them to the same Oracle JDBC jar file and they seem to work the same. Regards, Tom Williams Jr. |
From: Gerd W. <bir...@t-...> - 2006-03-08 01:10:09
|
Matthew Dahlman wrote: > Hi all, > > I'm hoping someone can help me figure out the reason for the following > behavior (and then how I can get around it). > > Until recently I was using SQuirreL 1.1. It worked well with a connection to > Teradata (v2r5) with, for example, a simple query like this: > select * from "DEMO_TRG"."TRG_CITY" > > Now I've switched to SQuirreL 2.1. It's better in almost all respects! But > now when I connect to the same Teradata database using the same JDBC driver, > I get the following error message: > java.sql.SQLException: [NCR][Teradata JDBC Driver]:TeraResultSetMetaData: > function not supported in this version Could you please send more of the stacktrace. I need to see which function was called and where. Thanks Gerd |
From: Matthew D. <mda...@su...> - 2006-03-08 01:02:21
|
Hi all, I'm hoping someone can help me figure out the reason for the following behavior (and then how I can get around it). Until recently I was using SQuirreL 1.1. It worked well with a connection to Teradata (v2r5) with, for example, a simple query like this: select * from "DEMO_TRG"."TRG_CITY" Now I've switched to SQuirreL 2.1. It's better in almost all respects! But now when I connect to the same Teradata database using the same JDBC driver, I get the following error message: java.sql.SQLException: [NCR][Teradata JDBC Driver]:TeraResultSetMetaData: function not supported in this version I have not been able to find a way to get around this. It seems like I must be missing something obvious--like there's a checkbox somewhere to tell SQuirreL to just display the results of the query and not to get the result set metadata. But I can't figure out how to do it. Anyone have any suggestions? Regards, Matt |
From: <jos...@ya...> - 2006-03-07 17:48:26
|
Tom, I've used it without problems. Just click on the Explain Plan Tab, when you're at the SQL Entry Area and Run your SQL. If you havent got a PLAN_TABLE created, SQuirreL will ask permission to create one. The meaning of the output is Oracle specific, so you must on the online Oracle docs for further information. []s Francis Tom J Williams Jr <twi...@cs...> escreveu: Hello, I am new to SQuirreL and slowly growing more accustom to it as I have grown up on Quest's Toad application. Having said that, you are likely to get many questions from me regarding Squirrel in the next few months as I learn the do's and don'ts of Squirrel. Has anyone out there used the Oracle Explain option in Squirrel? I am very curious to see how it functions within Squirrel and would appreciate any information regarding the use of Explain in Squirrel. Off topic question... Where is the best place to download plugins for Squirrel and Oracle? Regards, Tom Williams Jr. â¹N¬HS^µéX¬²'²Þu¼±<ÂÚº.Öëy©" ®*mx%jx.j «^ÆקvÆ©¦Xjبȧ¶m©Ýâév&¶×§vØ^+ÞÁæÜjËZØè{azâç^½éh¥êனn·)à{h¶¬ì¡Ø§×«®+h¯(m¶ÿ±éZ²ëjYwþÇ¥rgy$õ×Oxá¸n5ïmjõÛ^¸Ù*®ºÞÊ¥ºÇ«²f¢)à+-J«¢®·¥²©n±êì+-²Ê.Ç¢¸ëa¶Úlÿùb²Û,¢êÜyú+éÞ·ùb²Û?+-wèþÊ®ºÞÊ¥ºÇ« --------------------------------- Yahoo! Acesso Grátis Internet rápida e grátis. Instale o discador agora! |
From: Robert M. <rob...@gm...> - 2006-03-07 10:38:46
|
On 3/6/06, Tom J Williams Jr <twi...@cs...> wrote: > > > Off topic question... > > Where is the best place to download plugins for Squirrel and Oracle? Tom, The installer that we make available for snapshots and releases now has the Oracle plugin bundled with it (among other optional plugins). I can't speak to your question about explain plan capability as I haven't used it from squirrel. Rob |
From: Eric T. <eto...@de...> - 2006-03-07 00:49:54
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> <font face="Microsoft Sans Serif">Mu company uses SQuirreL with Derby a lot without issue. What version of Derby are you using?<br> <br> Regards,<br> Eric<br> </font><br> ysoonleo wrote: <blockquote cite="mid...@we..." type="cite">I have a session window connected to a derby database but it is not possible to open the session properties dialog. I am using 2.1 final jar file. I have tried with jdk 1.4.0, 1.4.2_10 and 1.5.0.<br> <br> I can dump the session properties to a text file and there is no error in the log file.<br> <br> I noticed that there are two active windows under the Windows menu.<br> 1 - derbydb as user1<br> 1 - derbydb as user1 - Session Properties (2)<br> <br> What could be the problem?<br> <p> </p> <hr size="1">Do you Yahoo!?<br> <a href="http://sg.rd.yahoo.com/mail/sg/footer/def/*http://sg.movies.yahoo.com">Yahoo! Movies</a><img moz-do-not-send="true" src="http://sg.yimg.com/i/sg/widgets/new.gif" align="abstop" height="11" hspace="4" width="28"> - Search movie info and celeb profiles and photos. </blockquote> </body> </html> |
From: Tom J W. Jr <twi...@cs...> - 2006-03-07 00:29:20
|
DQoNCg0KDQpIZWxsbywNCg0KSSBhbSBuZXcgdG8gU1F1aXJyZUwgYW5kIHNsb3dseSBncm93aW5n IG1vcmUgYWNjdXN0b20gdG8gaXQgYXMgSSBoYXZlIGdyb3duDQp1cCBvbiBRdWVzdCdzIFRvYWQg YXBwbGljYXRpb24uICBIYXZpbmcgc2FpZCB0aGF0LCB5b3UgYXJlIGxpa2VseSB0byBnZXQNCm1h bnkgcXVlc3Rpb25zIGZyb20gbWUgcmVnYXJkaW5nIFNxdWlycmVsIGluIHRoZSBuZXh0IGZldyBt b250aHMgYXMgSSBsZWFybg0KdGhlIGRvJ3MgYW5kIGRvbid0cyBvZiBTcXVpcnJlbC4NCg0KSGFz IGFueW9uZSBvdXQgdGhlcmUgdXNlZCB0aGUgT3JhY2xlIEV4cGxhaW4gb3B0aW9uIGluIFNxdWly cmVsPyAgSSBhbSB2ZXJ5DQpjdXJpb3VzIHRvIHNlZSBob3cgaXQgZnVuY3Rpb25zIHdpdGhpbiBT cXVpcnJlbCBhbmQgd291bGQgYXBwcmVjaWF0ZSBhbnkNCmluZm9ybWF0aW9uIHJlZ2FyZGluZyB0 aGUgdXNlIG9mIEV4cGxhaW4gaW4gU3F1aXJyZWwuDQoNCk9mZiB0b3BpYyBxdWVzdGlvbi4uLg0K DQpXaGVyZSBpcyB0aGUgYmVzdCBwbGFjZSB0byBkb3dubG9hZCBwbHVnaW5zIGZvciBTcXVpcnJl bCBhbmQgT3JhY2xlPw0KDQpSZWdhcmRzLA0KVG9tIFdpbGxpYW1zIEpyLiAgIOKAuQ== |
From: ysoonleo <yso...@ya...> - 2006-03-01 03:41:34
|
I have a session window connected to a derby database but it is not possible to open the session properties dialog. I am using 2.1 final jar file. I have tried with jdk 1.4.0, 1.4.2_10 and 1.5.0. I can dump the session properties to a text file and there is no error in the log file. I noticed that there are two active windows under the Windows menu. 1 - derbydb as user1 1 - derbydb as user1 - Session Properties (2) What could be the problem? --------------------------------- Do you Yahoo!? Yahoo! Movies - Search movie info and celeb profiles and photos. |
From: Gerd W. <bir...@t-...> - 2006-02-26 22:01:14
|
Hi all, I just detected a bug in Microsofts MSSQL 2005 driver. It raises an error like "CREATE/ALTER PROCEDURE' must be the first statement in a query batch" when one tries to create a procedure or a view with SQuirreL. A workaround is to switch off the row limit when executing view or stored procedure DDLs. Gerd |
From: Stephen C. <st...@co...> - 2006-02-26 18:10:51
|
All, I have downloaded Squirrel onto a Mac OS X machine, running Java 1.5. Squirrel seems to open correctly, but none of the menus work. Clicking on them highlights the name, i.e., File, but they do not drop down. Moving drivers to the Alias window does not work either. Is there a configuration file or some other setting that needs to be done? Also, I want to connect to a Derby (Cloudscape) database. Exactly how is this accomplished? Thank you in advance. Stephen Caine CommonGround Softworks, Inc. |
From: gwg <gw...@co...> - 2006-02-24 21:07:07
|
Hi Mark, The WHERE clause is constructed in a class named ContentsTab (I think) somewhere under the app code. For each column in the table, that class calls the appropriate class in the fw/dataviewer/cellcomponent (I think) directory, which decides how that column is to be handled. For columns that cannot be used in a WHERE clause (eg: BLOB), it does not include it. If a column type is not known to SQuirreL (eg: an Oracle-specific column that does not correspond to a standard SQL data type) the column is not included. Thus, if you are using a lot of Oracle-specific data types, you might see a lot of variation in which columns are in the WHERE clause. (By the way, the same approach is used for extracting data from the columns and for updating them.) I am not familiar with the SDO GEOMETRY data type, so I am guessing that it is Oracle-specific. If so, that might explain some of your problems. At one point we were thinking about including the necessary hooks for DB-specific plugins to be able to include DB-specific data types. I'm not absolutely certain, but I'm pretty sure that we did do that. If so, then the problem could be fixed by updating the Oracle-specific plugin to tell SQuirreL how to handle the SDO GEOMETRY data type. Glenn Mark Neher wrote: > Hi All, > > I've been looking at the Oracle edit issues that various people have > been helping out with. The common thread among rows that I can't update > at this point is a non-null SDO_GEOMETRY field (we use Oracle Spatial > heavily.) I've found that for rows that I can't edit, I can make them > work by > a) removing the geometry column > b) setting the geometry column to null or > c) removing the geometry from the where clause using the Squirrel GUI, > as someone suggested trying earlier while we were still puzzling out the > date issues. > Obviously, only option c) is realistic in a real world scenario, but I'm > just exploring. > > I had originally suspected the geometry fields as a possible issue, as > someone earlier in this thread had mentioned CLOBs and BLOBs as > potential problem areas for updating. I had been able to successfully > update rows with non-null geometries, however. Today, I have been able > to verify that the current snapshot fixes the date issue, but now trips > on (only some) rows containing non-null geometries. > > I turned log4j up to debug, which dumps the sql being used to perform > the updates to the log. Looking at these queries, there seems to be a > wide variation in the number of fields used in the where clause of these > updates, and the success of the updates has to do with (and likely did > even before the date fix) whether the geometry field is included. Note > that I am not specifically excluding any fields from the where clause > with the GUI at this point. > > As a couple of examples, I update a row of table AAA in my own schema. > It updates successfully, even with a non-null geometry, because the > where clause only contains one of the 24 fields. When I update a row in > another copy of the schema, it also succeeds; this time, however, the > where clause contains 23 of the 24 fields, neatly excluding the geometry > field that would have caused trouble. Again, I am excluding no fields > through the GUI. > > Table BBB: I update in my own schema and succeed. There are three > geometries, two of them non-null, and the where clause contains only > three of 40+ fields. When I try to update the same table in another > schema, it fails. Most, but not all, of the fields are included in the > where clause in this case; one of the geometries is included, and trips > me up. If I exclude that field through the GUI, I can update successfully. > > At this point, editing works great for me. The date fix was the big > stumbling block; I can get around the current issue by excluding the > problem fields in the GUI. I am curious, though, as to how the where > clause is constructed; it was mentioned in this thread that all of the > columns in the table are used to form a huge where clause, and looking > at the debug output there seems to be quite a bit of variation in the > fields selected instead of all columns all the time. > > I don't imagine that Oracle Spatial support is a high priority at this > point; if anybody is working on it and wants some help with testing, you > can drop me an email. > > Regards, > > Mark > > > |
From: Mark N. <mar...@ho...> - 2006-02-22 20:54:07
|
Hi All, I've been looking at the Oracle edit issues that various people have been helping out with. The common thread among rows that I can't update at this point is a non-null SDO_GEOMETRY field (we use Oracle Spatial heavily.) I've found that for rows that I can't edit, I can make them work by a) removing the geometry column b) setting the geometry column to null or c) removing the geometry from the where clause using the Squirrel GUI, as someone suggested trying earlier while we were still puzzling out the date issues. Obviously, only option c) is realistic in a real world scenario, but I'm just exploring. I had originally suspected the geometry fields as a possible issue, as someone earlier in this thread had mentioned CLOBs and BLOBs as potential problem areas for updating. I had been able to successfully update rows with non-null geometries, however. Today, I have been able to verify that the current snapshot fixes the date issue, but now trips on (only some) rows containing non-null geometries. I turned log4j up to debug, which dumps the sql being used to perform the updates to the log. Looking at these queries, there seems to be a wide variation in the number of fields used in the where clause of these updates, and the success of the updates has to do with (and likely did even before the date fix) whether the geometry field is included. Note that I am not specifically excluding any fields from the where clause with the GUI at this point. As a couple of examples, I update a row of table AAA in my own schema. It updates successfully, even with a non-null geometry, because the where clause only contains one of the 24 fields. When I update a row in another copy of the schema, it also succeeds; this time, however, the where clause contains 23 of the 24 fields, neatly excluding the geometry field that would have caused trouble. Again, I am excluding no fields through the GUI. Table BBB: I update in my own schema and succeed. There are three geometries, two of them non-null, and the where clause contains only three of 40+ fields. When I try to update the same table in another schema, it fails. Most, but not all, of the fields are included in the where clause in this case; one of the geometries is included, and trips me up. If I exclude that field through the GUI, I can update successfully. At this point, editing works great for me. The date fix was the big stumbling block; I can get around the current issue by excluding the problem fields in the GUI. I am curious, though, as to how the where clause is constructed; it was mentioned in this thread that all of the columns in the table are used to form a huge where clause, and looking at the debug output there seems to be quite a bit of variation in the fields selected instead of all columns all the time. I don't imagine that Oracle Spatial support is a high priority at this point; if anybody is working on it and wants some help with testing, you can drop me an email. Regards, Mark |
From: Robert M. <rob...@gm...> - 2006-02-22 10:52:31
|
On 2/21/06, Gerd Wagner <bir...@t-...> wrote: > > Robert Manning wrote: > > Glenn, Gerd: > > > > Just a thought: > > > > The standard and optional plugins are all available in the installer > now. > > However, we don't currently have any inter-dependencies between > > plugins. If we introduce one, we'll probably want to update the > installer > > to not allow the user to install one plugin without the plugin that it > > depends on. > There already is a dependence between the Graph and the Script Plugin. > It works like this: If you use the Graph Plugin without the SQL-Script > Plugin and if you try to script a table from within a Graph the Plugin > tells you that it needs the SQL-Script Plugin to perform this task. Gerd, Thanks for correcting me on this. I like that behavior. Now that there is the "super" / unified installer - that contains the plugins - versioning isn't as much of an issue as it could be. Even so, I'll take a look and see what can be done with the installer when I have a chance. Rob |
From: Gerd W. <bir...@t-...> - 2006-02-21 20:18:55
|
Robert Manning wrote: > Glenn, Gerd: > > Just a thought: > > The standard and optional plugins are all available in the installer now. > However, we don't currently have any inter-dependencies between > plugins. If we introduce one, we'll probably want to update the installer > to not allow the user to install one plugin without the plugin that it > depends on. There already is a dependence between the Graph and the Script Plugin. It works like this: If you use the Graph Plugin without the SQL-Script Plugin and if you try to script a table from within a Graph the Plugin tells you that it needs the SQL-Script Plugin to perform this task. Though this is the user list a little hint to the sources: See PluginManager.bindExternalPluginService(). I see the problem you are talking about. But I think it's not black and white. There are several ways to deal with the problem. The ones I see right now are: - Introduce inter-dependencies within the installer as you suggested - Move things to core as you suggested - Tell the user when a Plugin is missing to preform a task. - Declare Plugins as standard There may even be more. I'm not yet sure which one or which combination is best. At the moment I tend to just see how things are going to evolve. Perhaps the users will tell us, perhaps we are going to find out when we go on building SQuirreL's core and SQuirreL Plugins. > > In a related topic, functionality that is common to multiple plugins might > best be moved to core, no? So, if scripting support is required by > multiple > plugins, would it make sense to work out a generic API and relocate it to > FW? See above. > > Rob > > On 2/21/06, *Glenn Griffin* < gw...@co... > <mailto:gw...@co...>> wrote: > > Hi Gerd, > I would suggest that the Designer function not be included in the SQL > Script plugin. My reasoning is that the Designer could become a major > functionality on its own, and putting it in the Script plugin would > have > two negative effects. One is that people who want the Scripts plugin > may not want the Designer and all of its complexity, and the other is > that the potentially huge amount of Designer code could make it > difficult to maintain the Scripts plugin. Glenn, I see your point. The designer dialog I described could be a Plugin of its own. But I still think it would be good if it worked only on one table at a time and if you could invoke it from the Object Tree. Nonetheless, the one who's going to write it will do most of the deciding. Gerd |
From: Gerd W. <bir...@t-...> - 2006-02-21 19:46:00
|
Mark Neher wrote: > > > In a (probably) unrelated note, when I run the new snapshot, there seems > to be some automatic formatting of numeric data. Number fields are now > formatted with commas (an ID field like 15000 now displays as 15,000) > and float fields don't display numbers after the decimal point. I don't > remember reading anything about this, and don't see anything in the help > screens about it. It's in our change log. Goto http://cvs.sourceforge.net/viewcvs.py/squirrel-sql/sql12/doc/changes.txt?view=markup and look for the Fixed bugs #1043604 and #1043599: ... entry. > Is there a way to turn this off ?? I cut and paste > frequently and plain old numbers work better for that. See Rob's mail. > > Thanks, > > Mark |
From: Robert M. <rob...@gm...> - 2006-02-21 18:33:54
|
Glenn, Gerd: Just a thought: The standard and optional plugins are all available in the installer now. However, we don't currently have any inter-dependencies between plugins. If we introduce one, we'll probably want to update the installer to not allow the user to install one plugin without the plugin that it depends on. In a related topic, functionality that is common to multiple plugins might best be moved to core, no? So, if scripting support is required by multipl= e plugins, would it make sense to work out a generic API and relocate it to FW? Rob On 2/21/06, Glenn Griffin < gw...@co...> wrote: > > Hi Gerd, > I would suggest that the Designer function not be included in the SQL > Script plugin. My reasoning is that the Designer could become a major > functionality on its own, and putting it in the Script plugin would have > two negative effects. One is that people who want the Scripts plugin > may not want the Designer and all of its complexity, and the other is > that the potentially huge amount of Designer code could make it > difficult to maintain the Scripts plugin. > > |
From: Robert M. <rob...@gm...> - 2006-02-21 18:24:48
|
Mark, As far as the number formatting, try this: General Preferences -> Data Type Controls In the section called FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL choose "use default format (3.14159)" Rob On 2/21/06, Maury Hammel <ml1...@sh...> wrote: > > Mark Neher wrote: > > > I downloaded and installed the snapshot referenced. I have partial goo= d > > news -- some of the tables which I was unable to edit before work now > > (including the minimal sample that I submitted last week), but I am > > still unable to save an update to the rest. As I get a chance, I will > > try to determine what data conditions might cause these differences. > > If I understand the fix that Gerd implemented, then the tables where the > update doesn't work are probably tables where you have multiple rows > where date values that are on the same day (e.g. 2 Feb 2006 12:00:01 and > 2 Feb 2006 11:48:33, etc.). > > The fix truncates the date when doing the comparison. In such cases, > the code is going to find (what it thinks are) duplicate rows, so it > will not do the update. > > > Maury > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat= =3D121642 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |