Set default DELIMITER for database connection

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Set default DELIMITER for database connection

Xenos
Hi,

I use some SQL files in Netbeans that define PROCEDURE. So, I've set up a database connection to my MySQL, and I use it to execute the SQL files. But in this SQL file, the delimiter "$$" is used instead of the default ";"

So, how can I tell the Database connection (JDBC) that it must use the delimiter $$?

I've tried
jdbc:mysql://localhost:3306/variispace_beta?zeroDateTimeBehavior=convertToNull&ConnSettings=DELIMITER%20%24%24

And I've also tried setting the property "ConnSettings" to "DELIMITER $$" in the "Connection properties" part of the Services/Databases/Mydatabase properties

But none of this work: the DELIMITER seems to be ";" when I execute a SQL file on that connection (a "SELECT 1$$" yelds "You have an error... near $$")

This is related to the NB autocompletion bug ( https://netbeans.org/bugzilla/show_bug.cgi?id=270545 ): I loose the autocompletion if I set the "DELIMITER $$" inside the SQL file, so I would like to set it outside. Any clue how?