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.
Implement a solution that allows a user to easily install the Sakila sample database. The challenge is the SQL file is so large (2 MB) that it can't be loaded by our SQL Editor to be run like our other samples. It also needs to be tweaked with 'delimiter' blocks so that the stored procedures and triggers it creates can be correctly loaded. The size is of some concern, as it impacts download size for NetBeans. One possible solution is to build this as a plugin that users can download, but which is not part of the standard install.
Need to fix it so Sakila script executes successfully as part of this feature.
*** Issue 129828 has been marked as a duplicate of this issue. ***
With this changeset, the foundational support in db.mysql module is there, and now we can build the Sakila NBM for the update center after I return from vacation (post feature freeze). http://hg.netbeans.org/main?cmd=changeset;node=a45560212d61
*** Issue 136541 has been marked as a duplicate of this issue. ***
I am hitting the same issue as 136541. It turns out that the issue is a single line in the data script, and it's an insert into the 'staff' table where an actual *picture* binary is being inserted. So somehow the mysql command-line tool is able to handle a binary stream like this -- perhaps it detects that the column is binary and parses it correctly. But our poor parser is completely at a loss, and even if we got it right, I suspect passing in a binary as a String to JDBC would fail. So my workaround is I will take the binary data that's jammed into the sakila data script, store it in a separate file, and load it manually. Sheesh!
I think there is another problem, but not related to sakila. The sakila script I downloaded has some statements that end with 2 semicolons. Execution fails at those lines with 2 semicolons. I'll file a separate issue For example: -- Fails: DELIMITER;; -- Succeeds: DELIMITER;
actually it's not the 2 semicolons, it's a command that follows a comment Passes: -- hello Passes: DELIMITER;; Fails: -- hello DELIMITER;
I know about the delimiter problem and have already fixed it.
Committed changes - this works when I test it through "Run Project." Next will work on building and testing NBM and getting onto the dev UC for testing.
Integrated into 'main-golden', available in build *200808141419* on http://bits.netbeans.org/dev/nightly/ Changeset: http://hg.netbeans.org/main/rev/d84405be8559 User: David Van Couvering <davidvc@netbeans.org> Log: #134307 - Sakila sample database plugin Ready for the dev UC
This is done, with my getting it ready for the Stable UC
Verified.