1 2 Previous Next 23 Replies Latest reply on Sep 21, 2004 6:38 AM by Michael Arndt

    nukes 1.1RC2 available

    jae Master

      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.

        • 1. Re: nukes 1.1RC2 available
          jae Master

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

          • 2. Re: nukes 1.1RC2 available
            Paul Dlug Newbie

            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.

            • 3. Re: nukes 1.1RC2 available
              jae Master

              what do you mean the datasource isn't populated?

              • 4. Re: nukes 1.1RC2 available
                Paul Dlug Newbie

                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.

                • 5. Re: nukes 1.1RC2 available
                  jae Master

                  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.

                  • 6. Re: nukes 1.1RC2 available
                    Paul Dlug Newbie

                    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.

                    • 7. Re: nukes 1.1RC2 available
                      Paul Dlug Newbie

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

                      • 8. Re: nukes 1.1RC2 available
                        jae Master

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

                        • 9. Re: nukes 1.1RC2 available
                          Patrick McDaniel Newbie

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

                          • 10. Re: nukes 1.1RC2 available
                            jae Master

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

                            • 11. Re: nukes 1.1RC2 available
                              Patrick McDaniel Newbie

                              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?

                              • 12. Re: nukes 1.1RC2 available
                                Viet Master

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

                                • 13. Re: nukes 1.1RC2 available
                                  jae Master

                                  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
                                  



                                  • 14. Re: nukes 1.1RC2 available
                                    Patrick McDaniel Newbie

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

                                    1 2 Previous Next