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.
Summary: | Provide support for Sakila sample database | ||
---|---|---|---|
Product: | db | Reporter: | David Vancouvering <davidvc> |
Component: | Code | Assignee: | David Vancouvering <davidvc> |
Status: | VERIFIED FIXED | ||
Severity: | blocker | CC: | pjiricka |
Priority: | P3 | Keywords: | PLAN |
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
URL: | http://wiki.netbeans.org/SakilaSupportUISpec | ||
Issue Type: | ENHANCEMENT | Exception Reporter: | |
Bug Depends on: | 136541, 138768, 143250, 143505 | ||
Bug Blocks: |
Description
David Vancouvering
2008-05-01 01:20:56 UTC
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. |