[Eclipsesql-bugs] [ eclipsesql-Bugs-1878346 ] Long SQL script crashes Eclipse

[SourceForge.net <no...@so...>]

Bugs item #1878346, was opened at 2008-01-23 11:11
Message generated for change (Comment added) made by admorgan
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1878346&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: John Bollinger (jbollinger)
Assigned to: Nobody/Anonymous (nobody)
Summary: Long SQL script crashes Eclipse

Initial Comment:
Attempting to run a lengthy (~1200 statement) SQL script via the Eclipse plugin causes Eclipse to crash.

Initially, I see tabs starting to pop up in the "SQL Results" view (one per statement?), but in less than a minute Eclipse crashes.

Squirrel runs the same script successfully.


Additional information:

The crash occurred while running against an Oracle 10g (R2) database, using Oracle's JDBC driver for the target DB.

Statements being executed include roughly 280 CREATE TABLE statements, roughly 150 CREATE SEQUENCE statements, and many ALTER TABLE statments adding constraints.

Eclipse version 3.2.2
Plugin version 3.0.0.200609
Sun Java runtime 1.5.0_09
Windows XP SP2


----------------------------------------------------------------------

>Comment By: Austin Morgan (admorgan)
Date: 2008-11-07 15:20

Message:
I have created some very large scripts (less than 1200) and used it
successfully on oracle 10g(R2) databases using the 3.5 version of the
plugin and JDBC OCI connector.  If are interested please try the newest
version and let us know if it works.  If it does not please post a sample
script and I will find out why.

----------------------------------------------------------------------

Comment By: John Bollinger (jbollinger)
Date: 2008-01-23 11:17

Message:
Logged In: YES 
user_id=1989704
Originator: YES

Addendum: this problem makes the plugin largely useless to me.  I had
hoped to switch from Squirrel, but it doesn't look like that's going to
happen any time soon.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1878346&group_id=132863