This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 192965 - [70cat] Statement execution doesn't run when the connection is not established
Summary: [70cat] Statement execution doesn't run when the connection is not established
Status: RESOLVED DUPLICATE of bug 194766
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 7.0
Hardware: PC Linux
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-07 12:20 UTC by Michel Graciano
Modified: 2011-02-04 13:03 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michel Graciano 2010-12-07 12:20:11 UTC 
[ BUILD # : 495eaf3904dc ]
[ JDK VERSION : 1.6.20 ]

It is probably a recent regression, but now when I run a statement before
establish the connection the statement is not executed. For 6.9 if you do this
the connection is performed before to run the statement and password is asked
if necessary.
Comment 1 Jiri Rechtacek 2011-01-04 12:00:14 UTC 
Tested on a build:
  Product Version         = NetBeans IDE Dev (Build 201101040001) (#15af2035d5d0)
  Operating System        = Linux version 2.6.35-24-generic running on amd64
  Java; VM; Vendor        = 1.6.0_23; Java HotSpot(TM) 64-Bit Server VM 19.0-b09; Sun Microsystems Inc.
  Runtime                 = Java(TM) SE Runtime Environment 1.6.0_23-b05
it seems working for me.
Test case A:
1) Restart IDE with some SQL script (more SQL statements) opened in editor
2) Invoke 'Run SQL Statement' from popup menu
=> a popup warning appears with message "No database connection selected. Need to select one from..."
3) Once I select some, it asks for password then opens the connection and display a result.
Test case B:
1) Write SQL script
2) Disconnect a connection
3) Run SQL Statement =>
prompt for password then open DB connection again, displays data.
If I'm wrong, please describe your steps in detail. Thanks
Comment 2 Michel Graciano 2011-01-10 12:17:35 UTC 
Sorry for the delay, I am back from vacation just today.
I have tested it again and I forgot to mention that I use Oracle database. For Java DB it really works. Thanks a lot.
Comment 3 Jiri Rechtacek 2011-02-04 13:03:24 UTC 

*** This bug has been marked as a duplicate of bug 194766 ***