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 <ggreenbe@visa.com>
Sent: Tuesday, October 16, 2018 1:40 PM
To: Don <don.albertson@gmail.com>; NetBeans Mailing List <users@netbeans.apache.org>
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 <don.albertson@gmail.com<mailto:don.albertson@gmail.com>>
Sent: Tuesday, October 16, 2018 12:16 PM
To: Greenberg, Gary <ggreenbe@visa.com<mailto:ggreenbe@visa.com>>
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
ggreenbe@visa.com<mailto:ggreenbe@visa.com>
Mobile: (650)269-7902
[/Users/nkavumpu/Library/Containers/com.microsoft.Outlook/Data/Library/Caches/Signatures/signature_749324139]
|
| Mime |
- Unnamed multipart/related (inline, None, 0 bytes)
- Unnamed multipart/alternative (inline, None, 0 bytes)
|