nukes 1.1RC2 available

[jae77]

nukes 1.1RC2 is now available, so get it while it's hot. :)

cvs tag: Nukes_1_1_0_RC2
mysql precompiled zip: http://www.jboss.org/nukes-1.1/nukes-1.1.0-mysql-RC2.zip

the original RC1 announcement can be found here: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=50357

* items still outstanding (to my knowlege)

- update the "default" index page, this will be done as soon as i can get the binary data string out of hsqldb (everyone else is easy b/c they take in a string).

* known issues

- the "view" option on the "manage html" page does not render the character sets properly. (this is annoying, but can be worked around by just openning the link in a different window).

please let me know if you encounter any issues, especially surrounding table creation and adding the unique constraints.

the core tables still need to be created by hand, but everything else is deploy and go.

[jae77]

Used the nukes-1.1.0-mysql-rc2.zip to install. Most of the setup went fine. Per your request for info, I had one unique statement fail on startup. See below:


2004-06-30 17:04:14,784 INFO [org.jboss.nukes.addons.modules.news.NewsModule] Started
2004-06-30 17:04:14,784 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:jndiName=nukes/news/PropertyDefaultValue,plugin=pool,service=EJB
2004-06-30 17:04:14,784 INFO [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=nukes/news/PropertyDefaultValue,service=EJB
2004-06-30 17:04:14,844 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Created table 'nuke_news_topics' successfully.
2004-06-30 17:04:14,894 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Created index 'nuke_news_topics_idx13' on 'nuke_news_topics' successfully.
2004-06-30 17:04:14,894 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] issuePostCreateSQL::sql: [ALTER TABLE nuke_news_topics ADD UNIQUE (name).] on table nuke_news_topics
2004-06-30 17:04:14,894 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Executing SQL: ALTER TABLE nuke_news_topics ADD UNIQUE (name).
2004-06-30 17:04:14,894 WARN [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Issuing sql ALTER TABLE nuke_news_topics ADD UNIQUE (name). failed: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1"
2004-06-30 17:04:14,894 ERROR [org.jboss.ejb.EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while issuing sql in post-table-create; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1")

[pdlug]

Please excuse this newbie question. I successfully built 1.1RC2, I edited the local.properties to build for hsqldb instead of mysql, it deploys the datasource and the packages correctly with the 'deploy-all' target. However this datasource isn't populated. I previously used the main CVS branch with the installer to initialize the datasource. How do I do this with the RC?

Thanks.

[jae77]

what do you mean the datasource isn't populated?

[pdlug]

The first time I ran "deploy-all" the build failed with the error that $JBOSS_HOME/server/default/nukes didn't exist so I created it by hand and re-ran the deploy-all. This time it puts all the files in $JBOSS_HOME/server/default/nukes and puts nukes.ear and nukes-ds.xml into place. Running JBOSS at this point causes tons of "TABLE not found" errors when it starts nukes.

Also the nukes-ds.xml contains this line:
<connection-url>jdbc:hsqldb:${jboss.server.data.dir}/hypersonic/nukes</connection-url>

This didn't get substituted as part of the build process. I edited the datasource to give it the correct path but the tables aren't there, it's just the stock nukes.script file from the hsqldb initialization of the database.

[jae77]

ok - i'll have to update the "deploy-all" target to create the missing directory.

the ${jboss.server.data.dir} variable is automatically subsituted by jboss, so that does not need to occur through the build process (and should not be changed).

in terms of the missing tables, you have create those either via the ddl in the "output/hsqldb" directory, or use the bean shell script (it ends in bsh) - if you drop tthat directly into the deploy dir, it will create the tables for you automatically.

while there have been tremendous gains on moving to a pure cmp implementation for the modules, there are still some issues to work out that prevent the core from being pure cmp as well.

[pdlug]

Great, that did it. I had to copy the nukes-ds.xml in first, then copy the .bsh in, then run deploy-all. It's running now.

Now all I need is some documentation on creating a theme and creating a real site with this :-)

Thanks.

[pdlug]

I am getting this exception in the logs:

javax.ejb.CreateException: Error checking if entity exists:java.sql.SQLException: Table not found: NUKE_FILESTAT in statement [SELECT COUNT(*) FROM NUKE_FILESTAT WHERE pn_from=1088617191129 AND pn_id=1 AND pn_vmid='951C02B90095DC3E']

[jae77]

grr - guess that beanshell script hasn't been updated to include those tables. i'll make sure that gets taken care of as well.

do you have access to a client that can connect to hsqldb? if yes, you can just cut and paste the table definitions in the ddl file (output/hsqldb).

[5holeem]

Used the nukes-1.1.0-mysql-rc2.zip to install. Most of the setup went fine. Per your request for info, I had one unique statement fail on startup. See below:


2004-06-30 17:04:14,784 INFO [org.jboss.nukes.addons.modules.news.NewsModule] Started
2004-06-30 17:04:14,784 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:jndiName=nukes/news/PropertyDefaultValue,plugin=pool,service=EJB
2004-06-30 17:04:14,784 INFO [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=nukes/news/PropertyDefaultValue,service=EJB
2004-06-30 17:04:14,844 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Created table 'nuke_news_topics' successfully.
2004-06-30 17:04:14,894 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Created index 'nuke_news_topics_idx13' on 'nuke_news_topics' successfully.
2004-06-30 17:04:14,894 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] issuePostCreateSQL::sql: [ALTER TABLE nuke_news_topics ADD UNIQUE (name).] on table nuke_news_topics
2004-06-30 17:04:14,894 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Executing SQL: ALTER TABLE nuke_news_topics ADD UNIQUE (name).
2004-06-30 17:04:14,894 WARN [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.TopicEJB] Issuing sql ALTER TABLE nuke_news_topics ADD UNIQUE (name). failed: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1"
2004-06-30 17:04:14,894 ERROR [org.jboss.ejb.EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while issuing sql in post-table-create; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1")

[jae77]

damn it - i thought that was resolved. i've got to install mysql somewhere.

if you know the correct syntax for the alter table command, you can just edit the "mysql.properties" file in the "build/etc" directory and then re-run the build and deployment.

or if the table was actually created, you could just alter the table by hand.

now to go d/l a copy of mysql...

[5holeem]

Table was created, so it was easy to add the unique field. I think i found the problem. you have a period at the end of the sql staement. I think you just need to remove it from you mysql.properties files and you should be all set.

ALTER TABLE nuke_news_topics ADD UNIQUE (name).

I'm having one other problem. When I go to add an image file in the HTML module I get an out of memory exception. I saw another post like this in the forum, but with no answer. When I look in the server log it indicates that the nukeservlet is throwing the exception. Any ideas?

[julien1]

increase the VM heap, by default it's 64mb.

[jae77]

ahh - ok. i guess i "fat-fingered" the peropd key instead of the semi-colon. :)

to answer your other question, edit the startup script for jboss (either run.bat or run.sh) and add the following to the JAVA_OPTS var.

-Xms128M -Xmx256M

[5holeem]

thanks. that did it. I guess in the other post the person had resolved their own problem. my bad.