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

[Squirrel-sql-users] SF feature request (Top N bugs/requests)

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

Hello,

I've submitted a "feature request" to SourceForge.net to allow users
of SF projects to cast votes in favor of bugs (or feature requests)
that they are particularly affected by.  This might help you tip the
balance in favor of a problem that you and others have that developers
might not see or believe to be very widespread.  You can read what
I've said here:

http://sourceforge.net/tracker/index.php?func=detail&aid=1698358&group_id=1&atid=350001

Obviously, there is no way for you to vote on this feature request (to
allow you to vote on bugs/requests). However, one way you could voice
support for my proposal, would be to click on the link above and
simply add a comment to it expressing your support.  I don't know if
that will cause them to give this request a higher priority, but it
might help to improve it's visibility.  Thanks for your time.

Rob

Re: [Squirrel-sql-users] Export Oracle table to Flat file

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

On 4/8/07, Matthew Dahlman <mda...@ja...> wrote:
> CB,
>
> I think this is a case where SQuirreL won't be the right tool for the job.
>
I believe Matt is correct in this regard.  The current CSV/Excel
export (which is fairly new and very handy) is tied to the having the
data come from the UI.  It will take a bit of work to remove that
dependency, but it's very possible.  I would imagine you would select
a statement, and right-click to access the Export CVS/Excel menu like
you  can today with either the object tree or the SQL results panel.
For now, I would probably just use SQL-Plus, turn on spooling (spool
<filename>) and issue your query.  You may find that turning off
feedback, termout and others gets you just the data.  You may need to
deal with column formats but it's probably still faster.

Rob

Re: [Squirrel-sql-users] Export Oracle table to Flat file

[Matthew D. <mda...@ja...>]

CB,

I think this is a case where SQuirreL won't be the right tool for the job.

I suspect you'll either need a hand-coding solution or a different tool.
Hand-coding could be as simple as using SQL*Plus, turning spooling on, and
running select * from your table. Of course you'll need to tweak
SQL*Plus's params a bit... but that's the basic idea. It's too bad that
Oracle doesn't offer tools like Sybase's bcp or Teradata's FastExport to
do what you want.

A different tool like Oracle Data Integrator (ODI) might be better. It has
built-in tools like OdiSqlUnload designed to unload data from a table to a
file. It may be using a canon to swat a fly--there may be more setup and
config time needed than your relatively modest requirement merits. But
it's an option (it's free to download from oracle.com).

Then again, maybe one of the SQuirreL gurus will know of a clever way to
easily redirect the output of a query to a flat file without requiring the
whole dataset to be held in memory. It doesn't seem like it ought to be
too difficult to achieve. Good luck.

-Matt


-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Carolina Barcenas
Sent: Sunday, 08 April, 2007 6:03
To: squ...@li...
Subject: [Squirrel-sql-users] Export Oracle table to Flat file

I am new Squirrel User.  How can I export an Oracle table (1 Million
records) to a flat file?  I am having problems with the size limit. When I
try to bring up all the table it can't handle. I could always break the
table in pieces but I am wondering if there is an easier way.  I
appreciate any suggestions.
CB

_________________________________________________________________
Cant afford to quit your job?  Earn your AS, BS, or MS degree online in
1 year.
http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.c
lassesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplov
r%3D866143

[Squirrel-sql-users] Export Oracle table to Flat file

[Carolina B. <car...@ho...>]

I am new Squirrel User.  How can I export an Oracle table (1 Million 
records) to a flat file?  I am having problems with the size limit. When I 
try to bring up all the table it can't handle. I could always break the 
table in pieces but I am wondering if there is an easier way.  I appreciate 
any suggestions.
CB

_________________________________________________________________
Can’t afford to quit your job? – Earn your AS, BS, or MS degree online in 1 
year. 
http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866143

Re: [Squirrel-sql-users] How can i get all the features of squirrel

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

On 4/3/07, rohitkhariwal <roh...@ya...> wrote:
>
> Hello All,
>
> I am developing an eclipse plugin something like SQL Explorer. I am planning
> to use squirrel for this purpose.
>
> I have tried on google but could not fiund any tutorials or javadocs of
> squirrel.
> Could anybody help me out.

You are correct, this info could be made a little more easy to find :)

Try these links (3 separate documents)

SQuirreL Programming Guide
http://www.squirrelsql.org/paper/SQuirreL_us.pdf

Plugin Programming Guide
http://squirrel-sql.cvs.sourceforge.net/*checkout*/squirrel-sql/sql12/doc/plugins.html?revision=HEAD

Overview of functionality:
http://squirrel-sql.cvs.sourceforge.net/*checkout*/squirrel-sql/sql12/doc/quick_start.html?revision=HEAD

The documents are currently being revised, so any input you have would
be welcome.

Rob

[Squirrel-sql-users] How can i get all the features of squirrel

[rohitkhariwal <roh...@ya...>]

Hello All,

I am developing an eclipse plugin something like SQL Explorer. I am planning
to use squirrel for this purpose.

I have tried on google but could not fiund any tutorials or javadocs of
squirrel.
Could anybody help me out.

Thanks in advance
Rohit
-- 
View this message in context: http://www.nabble.com/How-can-i-get-all-the-features-of-squirrel-tf3518812.html#a9819780
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

[Squirrel-sql-users] DBASE 101

[Tyrone B. <tyr...@ho...>]

I thought I was good at databases but I need a crash course on databases.  
And on how to query databases.  I'm a hands-on type of person so if it has a 
sample database and way for me to use Squirrel or MS Access, that would be 
great.

Is there another website or websites to try to learn databases from basics 
to advance?

Possible book?

Here is one:

http://www.geekgirls.com/databases_from_scratch_3.htm

_________________________________________________________________
Watch free concerts with Pink, Rod Stewart, Oasis and more. Visit MSN 
Presents today. 
http://music.msn.com/presents?icid=ncmsnpresentstagline&ocid=T002MSN03A07001

Re: [Squirrel-sql-users] Installation of ORACLE driver (and plugin)

[S. S. <s.s...@gm...>]

I have exactly the same problem, since there are no drivers being
listed (I'm trying to usse the MySQL plugin by the way). I even tried
installing squirrelsql to a directory without spaces, in the hope that
that could be the solution (no such luck). So I'll post some outtakes
of my squirrel log here. I'm running Ubuntu Edgy (6.10) and using
"/usr/lib/jvm/java-1.5.0-sun/jre/bin/java"

20296 [AWT-EventQueue-1] DEBUG
net.sourceforge.squirrel_sql.fw.util.Resources  - No resource found
for action.net.sourceforge.squirrel_sql.client.mainframe.action.ViewDriversAction
: image
20798 [main] DEBUG net.sourceforge.squirrel_sql.fw.util.Resources  -
No resource found for
action.net.sourceforge.squirrel_sql.plugins.mysql.action.AnalyzeTableAction
: image

21405 [main] DEBUG
net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager
 - GUI work done in wrong thread
java.lang.Exception: GUI work done in wrong thread
        at net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager.checkThread(ThreadCheckingRepaintManager.java:48)

22992 [Thread-3] DEBUG
net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager
 - GUI work done in wrong thread
java.lang.Exception: GUI work done in wrong thread
        at net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager.checkThread(ThreadCheckingRepaintManager.java:48)
        at net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager.addDirtyRegion(ThreadCheckingRepaintManager.java:59)
        at javax.swing.JComponent.repaint(JComponent.java:4518)
        at java.awt.Component.repaint(Component.java:2731)
        at javax.swing.text.View.updateLayout(View.java:1247)
        at javax.swing.text.View.changedUpdate(View.java:799)
        at javax.swing.text.html.BlockView.changedUpdate(BlockView.java:325)
        at javax.swing.plaf.basic.BasicTextUI$RootView.changedUpdate(BasicTextUI.java:1534)
        at javax.swing.plaf.basic.BasicTextUI$UpdateHandler.changedUpdate(BasicTextUI.java:1779)
        at javax.swing.text.AbstractDocument.fireChangedUpdate(AbstractDocument.java:213)
        at javax.swing.text.html.HTMLDocument.fireChangedUpdate(HTMLDocument.java:1321)
        at javax.swing.text.html.HTMLDocument$HTMLReader.adjustEndElement(HTMLDocument.java:2045)
        at javax.swing.text.html.HTMLDocument$HTMLReader.flush(HTMLDocument.java:2100)
        at javax.swing.text.html.HTMLEditorKit.read(HTMLEditorKit.java:231)
        at javax.swing.JEditorPane.read(JEditorPane.java:519)
        at javax.swing.JEditorPane.read(JEditorPane.java:537)
        at javax.swing.JEditorPane$PageLoader.run(JEditorPane.java:566)
62857 [AWT-EventQueue-1] ERROR
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager  - Unable to find
Driver Class com.mysql.jdbc.Driver for JDCB driver MySQL Driver

[Squirrel-sql-users] 2.5 release (soon)

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

Everyone,

Originally I had planned to release 2.5 by the end of March.  However,
I believe we have a few more translation updates as a result of some
bug fixes I introduced tonight (Translators: in the plugins for Oracle
and Sybase, they now have the custom tokenizer preference strings just
like in MS-SQL plugin).  I'm going to prepare a snapshot that I hope
will be the last prior to 2.5.  I'd like to get feedback on the
snapshot since there are quite a few fresh bug-fixes (from this week)
rather than push it out as 2.5.  This way, if there is anything really
critical, we can get it addressed for the 2.5 release, and anything
minor will go into 2.5.1 which will go out in early May.  I know that
most folks stay away from the snapshots as they are "experimental",
but this next snapshot will be pretty close to what goes out as the
2.5 release.  The only changes I'll make from here out are
documentation and critical problems.  Thanks to everyone that has
helped make this release possible and happy bug-hunting!

Rob

Re: [Squirrel-sql-users] GUI launches a window (on Linux) but nothing appears in client-area

[David C. <dav...@ve...>]

Rob -

Just FYI:
Ok, I did upgrade to Java 6, but that alone does NOT fix this
'java-swing-application' issue!

Here's another link that seems to confirm that the problem continues in
java-6:
  http://wiki.beryl-project.org/wiki/Java
and their solution/patch is more long-winded for java-6 than it is for
java-5

I tried the java-5 'workaround' (the 'export' thing, but it did NOT work
for me).

So, my (simple) solution is just a couple of clicks away...i.e. just
switch off 'Beryl' window-manager
anytime I want to run my 'SQuirreL' or my 'NetBeans IDE', and then
re-enable Beryl again after
I'm done with the java-app.

Thanks again for the great SQuirreL product and the quick response for
identifying the culprit (Beryl)!

Cheers and regards...

Dave


On Tue, 2007-03-27 at 06:06 -0400, Robert Manning wrote:

> On 3/27/07, David Cook <dav...@ve...> wrote:
> >
> >  Great, that's it.  As soon as I switch away from Beryl window-manager and
> >  onto KWin (KDE) window manager, SQuirreL works just fine.
> >  [I'll upgrade my Java run-time soon, and re-test.]
> >
> >  Many thanks, and regards...
> >
> 
> Glad to hear it.  Sounds like Sun went 2 for 2 this time - scoring
> both Gnome and KDE :)  At least there is a work-around and the problem
> is big enough to merit a quick response.
> 
> Rob

Re: [Squirrel-sql-users] GUI launches a window (on Linux) but nothing appears in client-area

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

On 3/27/07, David Cook <dav...@ve...> wrote:
>
>  Great, that's it.  As soon as I switch away from Beryl window-manager and
>  onto KWin (KDE) window manager, SQuirreL works just fine.
>  [I'll upgrade my Java run-time soon, and re-test.]
>
>  Many thanks, and regards...
>

Glad to hear it.  Sounds like Sun went 2 for 2 this time - scoring
both Gnome and KDE :)  At least there is a work-around and the problem
is big enough to merit a quick response.

Rob

Re: [Squirrel-sql-users] GUI launches a window (on Linux) but nothing appears in client-area

[David C. <dav...@ve...>]

Great, that's it.  As soon as I switch away from Beryl window-manager
and
onto KWin (KDE) window manager, SQuirreL works just fine.
[I'll upgrade my Java run-time soon, and re-test.]

Many thanks, and regards...

Dave


On Mon, 2007-03-26 at 21:51 -0400, Robert Manning wrote:

> It sounds very similar to an issue which we saw with the JDK where
> users who ran any java applications would see what you've described.
> The particular troublesome combination was Linux with Sun 1.5/1.6 and
> the use of the desktop effects (Compiz).  Others saw this problem when
> desktop effects were used in conjunction with nvidia cards and the
> nvidia display driver, again on Linux.  I remember hearing that Sun
> put out an update to the JDK (a new 1.6 release I believe) that was
> supposed to address the issue but that some nvidia users were still
> seeing issues.  The problem had to do with how the AWT Frame handled
> events with it's native peer on this platform.  You may want to try
> disabling desktop effects if they are turned on.  At least one user
> reported that as a work-around.
> 
> Rob
> 
> On 3/26/07, David Cook <dav...@ve...> wrote:
> >
> >  Hi -
> >
> >  I had SQuirreL v2.2 installed on my Linux box, but when I launched it
> > (under KDE),
> >  it draws the window w/ title-bar, but nothing ever shows up in the
> > client-area
> >  of the window (i.e. it remains white).
> >
> >  Since it was a bit out-of-date, I grabbed your new v2.4.1 install-jar, and
> > installed that.
> >  (I do just the single-user install, which puts it into my /home/<user>
> > sub-tree.)
> >
> >  I'm still seeing the exact same symptom (i.e. nothing shows up in window
> > client-area).
> >
> >  I checked the obvious:
> >
> >  java -version
> >  java version "1.5.0_08"
> >  Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_08-b03)
> >  Java HotSpot(TM) Client VM (build 1.5.0_08-b03, mixed mode, sharing)
> >  root@2[SQuirreL SQL Client]#
> >
> >  and another unrelated -jar file executes just fine.
> >
> >  [The original v2.2 worked a month or so ago...since then, I've
> >  upgrade the Linux system (leaving my '/home' partition intact).
> >  That usually works...SQuirreL typically runs just fine once I install
> >  a newer Linux distro and JRE, etc.]
> >
> >  Any ideas on what to look at?  [I'm sure its gonna be something simple
> >  that I'm overlooking.
> >
> >  TIA...
> >
> >  Dave
> > -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share your
> > opinions on IT & business topics through brief surveys-and earn cash
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
> >
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] GUI launches a window (on Linux) but nothing appears in client-area

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

It sounds very similar to an issue which we saw with the JDK where
users who ran any java applications would see what you've described.
The particular troublesome combination was Linux with Sun 1.5/1.6 and
the use of the desktop effects (Compiz).  Others saw this problem when
desktop effects were used in conjunction with nvidia cards and the
nvidia display driver, again on Linux.  I remember hearing that Sun
put out an update to the JDK (a new 1.6 release I believe) that was
supposed to address the issue but that some nvidia users were still
seeing issues.  The problem had to do with how the AWT Frame handled
events with it's native peer on this platform.  You may want to try
disabling desktop effects if they are turned on.  At least one user
reported that as a work-around.

Rob

On 3/26/07, David Cook <dav...@ve...> wrote:
>
>  Hi -
>
>  I had SQuirreL v2.2 installed on my Linux box, but when I launched it
> (under KDE),
>  it draws the window w/ title-bar, but nothing ever shows up in the
> client-area
>  of the window (i.e. it remains white).
>
>  Since it was a bit out-of-date, I grabbed your new v2.4.1 install-jar, and
> installed that.
>  (I do just the single-user install, which puts it into my /home/<user>
> sub-tree.)
>
>  I'm still seeing the exact same symptom (i.e. nothing shows up in window
> client-area).
>
>  I checked the obvious:
>
>  java -version
>  java version "1.5.0_08"
>  Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_08-b03)
>  Java HotSpot(TM) Client VM (build 1.5.0_08-b03, mixed mode, sharing)
>  root@2[SQuirreL SQL Client]#
>
>  and another unrelated -jar file executes just fine.
>
>  [The original v2.2 worked a month or so ago...since then, I've
>  upgrade the Linux system (leaving my '/home' partition intact).
>  That usually works...SQuirreL typically runs just fine once I install
>  a newer Linux distro and JRE, etc.]
>
>  Any ideas on what to look at?  [I'm sure its gonna be something simple
>  that I'm overlooking.
>
>  TIA...
>
>  Dave
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

Re: [Squirrel-sql-users] Installation of ORACLE driver (and plugin)

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

On 3/26/07, Frank Reifenstahl <f.r...@se...> wrote:
> >> Hi,
> >>
> >> it seems SquirrelSQL is my long time longed for DB tool...
> >>
> >> Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
> >> to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
> >> Class Path". But pressing the button doesn't display any drivers. Any
> >> idea?
> >
> > You mean pressing the "List Drivers" button doesn't display any
> > drivers in the Class Name drop-down?
>
> That's what I mean...
>
> > If so, instead of placing it in
> > the lib directory, you link directly to it using the
> > "Add" button on the "Extra Class Path" tab.
>
> I have tried this twice, at first with the JAR located in
> /usr/local/bin/SquirrelSQL/lib and then putting it into my home dir, two
> misses... :/
>

Ok, then could you check your squirrel-sql.log file for errors?  What
this condition seems to indicate is that the ojdbc14.jar file doesn't
contain any classes that implement the java.sql.Driver interface.  If
there are exceptions during the search for Driver implementations you
should get an INFO message in the log stating such.

Rob

[Squirrel-sql-users] GUI launches a window (on Linux) but nothing appears in client-area

[David C. <dav...@ve...>]

Hi -

I had SQuirreL v2.2 installed on my Linux box, but when I launched it
(under KDE),
it draws the window w/ title-bar, but nothing ever shows up in the
client-area
of the window (i.e. it remains white).

Since it was a bit out-of-date, I grabbed your new v2.4.1 install-jar,
and installed that.
(I do just the single-user install, which puts it into my /home/<user>
sub-tree.)

I'm still seeing the exact same symptom (i.e. nothing shows up in window
client-area).

I checked the obvious:

java -version
java version "1.5.0_08"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_08-b03)
Java HotSpot(TM) Client VM (build 1.5.0_08-b03, mixed mode, sharing)
root@2[SQuirreL SQL Client]# 

and another unrelated -jar file executes just fine.

[The original v2.2 worked a month or so ago...since then, I've
upgrade the Linux system (leaving my '/home' partition intact).
That usually works...SQuirreL typically runs just fine once I install
a newer Linux distro and JRE, etc.]

Any ideas on what to look at?  [I'm sure its gonna be something simple
that I'm overlooking.

TIA...

Dave

Re: [Squirrel-sql-users] Installation of ORACLE driver (and plugin)

[Frank R. <f.r...@se...>]

>> Hi,
>>
>> it seems SquirrelSQL is my long time longed for DB tool...
>>
>> Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
>> to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
>> Class Path". But pressing the button doesn't display any drivers. Any
>> idea?
> 
> You mean pressing the "List Drivers" button doesn't display any
> drivers in the Class Name drop-down?  

That's what I mean...

> If so, instead of placing it in
> the lib directory, you link directly to it using the
> "Add" button on the "Extra Class Path" tab.

I have tried this twice, at first with the JAR located in
/usr/local/bin/SquirrelSQL/lib and then putting it into my home dir, two
misses... :/

Regards
Frank

Re: [Squirrel-sql-users] Installation of ORACLE driver (and plugin)

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

On 3/23/07, Frank Reifenstahl <f.r...@se...> wrote:
> Hi,
>
> it seems SquirrelSQL is my long time longed for DB tool...
>
> Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
> to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
> Class Path". But pressing the button doesn't display any drivers. Any idea?

You mean pressing the "List Drivers" button doesn't display any
drivers in the Class Name drop-down?  If so, instead of placing it in
the lib directory, you link directly to it using the
"Add" button on the "Extra Class Path" tab.

>
> Second issue: trying to download the ORACLE plugin. The link in "See our
> download section  for details" misses the "www" prefix. Getting there
> and reading "See the plugins page for instructions on installing
> plugins" I click plugins. After that I am back where I started.
> Scrolling down to "Beta Plugins" and clicking "Oracle" I am lead upwards
> to section "Installation" to restart the game... ;) oooomph - Well then,
> how to get the ORACLE plugin?

The Oracle plugin comes with the installer now.  That documentation
needs to be re-written.

Rob

Re: [Squirrel-sql-users] SQuirreL SQL serialized Java objects viewer/editor

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

On 3/23/07, David Druker <dr...@ie...> <dr...@ie...> wrote:
> Hi all,
>
> I use an 3rd-party application that saves data to RDBMS tables as serialized Java objects. The data
> type in the database is BLOB. The feature I would like in SQuirreL-SQL would be to double-click on
> the BLOB data while viewing in the Content tab and have it open as the deserialized Java object. In
> most cases, these objects have reasonable toString() methods and would be viewable.
>
> I am possibly interested in writing a plugin to perform this, but want to make sure the
> functionality does not now exist in SQuirreL-SQL or a plugin.

This feature is not implemented to my knowledge.

Rob

[Squirrel-sql-users] SQuirreL SQL serialized Java objects viewer/editor

[David D. <dr...@ie...>]

Hi all,

I use an 3rd-party application that saves data to RDBMS tables as serialized Java objects. The data 
type in the database is BLOB. The feature I would like in SQuirreL-SQL would be to double-click on 
the BLOB data while viewing in the Content tab and have it open as the deserialized Java object. In 
most cases, these objects have reasonable toString() methods and would be viewable.

I am possibly interested in writing a plugin to perform this, but want to make sure the 
functionality does not now exist in SQuirreL-SQL or a plugin.

Thanks,

David Druker
dr...@ie...

[Squirrel-sql-users] Installation of ORACLE driver (and plugin)

[Frank R. <f.r...@se...>]

Hi,

it seems SquirrelSQL is my long time longed for DB tool...

Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
Class Path". But pressing the button doesn't display any drivers. Any idea?

Second issue: trying to download the ORACLE plugin. The link in "See our
download section  for details" misses the "www" prefix. Getting there
and reading "See the plugins page for instructions on installing
plugins" I click plugins. After that I am back where I started.
Scrolling down to "Beta Plugins" and clicking "Oracle" I am lead upwards
to section "Installation" to restart the game... ;) oooomph - Well then,
how to get the ORACLE plugin?

Regards
Frank

Re: [Squirrel-sql-users] Invalid SQL is executed

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

On 3/22/07, Mark Noten <mar...@se...> wrote:
> Hi Robert,
>
> Thanks for your reply. The queries that were executed are:
>
> update vessel_declarations set changed=0, response_status='ACC',
> child_change=0, transmission_status='TRD' where id=4274;
> update containers set changed=0, response_status='ACC' where
> cuscar_id=4274;
> update cni set changed=0, response_status='ACC' where cuscar_id=4274;
> update gid set changed=0, link_change=0, response_status='ACC' where
> cni_id in (select cni_id from cni where cuscar_id=4274);
>
> I selected them all together and hit the Run SQL button. The auto commit
> option was on.
>
> I ran the below query that is used for the "in (...)" where clause of
> the last update query.
>
> select cni_id from cni where cuscar_id=4274
>
> As expected it gives the error:
>
> Error: java.sql.SQLException: ORA-00904: "CNI_ID": invalid identifier
> , SQL State: 42000, Error Code: 904
>
> So why did the last update query, update 89,867 rows? Can it be an issue
> with the OCI driver of Oracle?

That's definitely a head-scratcher.  I don't ever use the OCI drivers.
 You may want to try the thin driver and see if you get the same
behavior (maybe not on your production server this time - or at least
in a different schema ;-)

Rob

Re: [Squirrel-sql-users] object list and schema filtering

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

On 3/21/07, eric millham <emi...@gm...> wrote:
> > I don't think I quite understand what you mean.  If you have a list of
> > tables (that doesn't change) then create an alias and configure only
> > those schemas to be loaded.  The list of included schemas is all that
> > matters and is all that will be loaded - regardless of other schemas
> > that are created and dropped.  Your problem seems to be a perfect fit
> > for the use of Alias properties.  I must be missing something.
> >
> > Rob
>
>

<snip>

> Does your comment that the
> "list of tables that does not change" mean that if a new table is added to
> an included schema that it will not show up? Hope not.

Sorry, I meant schemas.  If you configure alias properties to load
tables for specific schemas, only these will be loaded into the object
tree when you connect.  If you then go back into alias properties and
hit the "connect database to refresh Schema table ", the new schema(s)
will appear in the list as "don't load".  You can then add the objects
from those new schemas as well as any others to be loaded if that is
your desire.

Rob

Re: [Squirrel-sql-users] Invalid SQL is executed

[Mark N. <mar...@se...>]

Hi Robert,

Thanks for your reply. The queries that were executed are:

update vessel_declarations set changed=3D0, response_status=3D'ACC',
child_change=3D0, transmission_status=3D'TRD' where id=3D4274;
update containers set changed=3D0, response_status=3D'ACC' where
cuscar_id=3D4274;
update cni set changed=3D0, response_status=3D'ACC' where =
cuscar_id=3D4274;
update gid set changed=3D0, link_change=3D0, response_status=3D'ACC' =
where
cni_id in (select cni_id from cni where cuscar_id=3D4274);

I selected them all together and hit the Run SQL button. The auto commit
option was on.

I ran the below query that is used for the "in (...)" where clause of
the last update query.

select cni_id from cni where cuscar_id=3D4274

As expected it gives the error:

Error: java.sql.SQLException: ORA-00904: "CNI_ID": invalid identifier
, SQL State: 42000, Error Code: 904

So why did the last update query, update 89,867 rows? Can it be an issue
with the OCI driver of Oracle?

Kind regards,

Mark

-----Original Message-----
From: Robert Manning [mailto:rob...@gm...]=20
Sent: woensdag 21 maart 2007 22:53
To: Mark Noten
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Invalid SQL is executed

On 3/21/07, Mark Noten <mar...@se...> wrote:
> Hi all,
>
> When executing the below invalid SQL statement, all the 89,867 records
in the database were updated in stead of just a couple rows.
>
> update gid set changed=3D0, link_change=3D0, response_status=3D'ACC' =
where
cni_id in (select cni_id from cni where cuscar_id=3D4274);
>
> 89,867 Row(s) Updated
> Query 4 of 4 elapsed time (seconds) - Total: 1,675.695, SQL query:
1,675.695, Building output: 0
>
> The cni_id column does not exist in the cni table. In stead of raising
an exception, the invalid SQL update statement was executed without the
where condition. Needless to say that updating 89,867 records with
production data did not receive a warm welcome. ;-)
>
> Can anyone explain me why this invalid query is executed in stead or
raising an error? I'm using Squirrel SQL Client Version 2.3 final with a
Oracle OCI Driver and oracle.jadbc.driver.OracleDriver from the
ojdbc14.jar.
>

I don't know of any issues in 2.3 that would produce this problem.
What do you get when you just execute:

select cni_id from cni where cuscar_id=3D4274;

Did you only highlight "update gid set changed=3D0, link_change=3D0,
response_status=3D'ACC' " when you ran the query?  Or, could it be that
there were two end-of-lines between the first part and the where
clause, like:

update gid set changed=3D0, link_change=3D0, response_status=3D'ACC'

where cni_id in (select cni_id from cni where cuscar_id=3D4274);

If so and you had the cursor on just the the top line, I can see how
that would happen.  The query tokenizer interprets "\n\n" as a
statement separator in addition to ";".

Rob

Re: [Squirrel-sql-users] object list and schema filtering

[eric m. <emi...@gm...>]

On 3/21/07, Robert Manning <rob...@gm...> wrote:
>
> On 3/21/07, eric millham <emi...@gm...> wrote:
> > Hi, I see the alias properties function to copy down all the schema's
> and
> > then refine which schema's I want tables loaded for. This is nice. But,
> I
> > have a little twist on that, I need to create a static list of schema's
> to
> > load tables for and have as a default to not load tables for other
> schema's.
> > This is because we have literally hundreds of transitory schema's that
> show
> > up with random names and then disappear. Squirrel takes forever to start
> up
> > on this database. I do need the metadata for the static schema's and
> tables
> > though. Ideas?
>
> I don't think I quite understand what you mean.  If you have a list of
> tables (that doesn't change) then create an alias and configure only
> those schemas to be loaded.  The list of included schemas is all that
> matters and is all that will be loaded - regardless of other schemas
> that are created and dropped.  Your problem seems to be a perfect fit
> for the use of Alias properties.  I must be missing something.
>
> Rob



Hi Rob, I did not understand the function then. It appeared to me that this
was a way to exclude specific schema's.  But, I didn't get that a new
schema, not in the schema select list, would, by default, not be included. I
suppose that since there was also a way to specifically include schema's
that should have been my clue that only the included schema's would be
loaded from then on. Anyway, good news, thanks. Does your comment that the
"list of tables that does not change" mean that if a new table is added to
an included schema that it will not show up? Hope not.

Re: [Squirrel-sql-users] object list and schema filtering

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

On 3/21/07, eric millham <emi...@gm...> wrote:
> Hi, I see the alias properties function to copy down all the schema's and
> then refine which schema's I want tables loaded for. This is nice. But, I
> have a little twist on that, I need to create a static list of schema's to
> load tables for and have as a default to not load tables for other schema's.
> This is because we have literally hundreds of transitory schema's that show
> up with random names and then disappear. Squirrel takes forever to start up
> on this database. I do need the metadata for the static schema's and tables
> though. Ideas?

I don't think I quite understand what you mean.  If you have a list of
tables (that doesn't change) then create an alias and configure only
those schemas to be loaded.  The list of included schemas is all that
matters and is all that will be loaded - regardless of other schemas
that are created and dropped.  Your problem seems to be a perfect fit
for the use of Alias properties.  I must be missing something.

Rob