netbeans-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greenberg, Gary" <>
Subject RE: Executing SQL file in NB
Date Tue, 16 Oct 2018 23:35:09 GMT
I have resolved the issue.
Something happened with the running NB and connection selector at the top of SQL window was
grayed out and stuck with Derby.
After I restarted NB it allows me select connection to MySQL.

From: Greenberg, Gary <>
Sent: Tuesday, October 16, 2018 1:40 PM
To: Don <>; NetBeans Mailing List <>
Subject: RE: Executing SQL file in NB

I could do what you said from the beginning.
That is not what I asked about.
I do have a SQL script file opened in NB.
I have established connection to MySQL.
I want to execute this file without copying its contents to the Execute Command window.
For that purpose, SQL files has set of buttons on the top:
Run SQL, Run Selection, etc.
Those buttons do not work properly. They throw me out to Derby connection, which is not active.

From: Don <<>>
Sent: Tuesday, October 16, 2018 12:16 PM
To: Greenberg, Gary <<>>
Subject: Re: Executing SQL file in NB

Right-click the connection.

Select Connect

Right-click again

Select Execute Command

On 10/16/2018 02:42 PM, Greenberg, Gary wrote:
I have created database connection  to MySQL in NB 8.2 (I can't upgrade to newer version without
installer due to the company security constraints).
It is working and I can execute some commands.
However, I do have a SQL script in the file which I want to execute.
I do have connection selected in 'Services' tab, but when I click on the button 'Run SQL',
NB always trying to establish connection with default Derby and certainly failing.
Whatever I tried to do to make it use proper connection, nothing works.
Is it a bug or there is a "secret souse" that I haven't apply?

Gary Greenberg
Staff Software Engineer
Data Product Development<>
Mobile: (650)269-7902


View raw message