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.

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.

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.

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']

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")

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).

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

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