8 Replies Latest reply on Jun 8, 2004 10:48 AM by jae

    Help on install

    Daniele Newbie

      Hi, I'm a newby and I've never installed Nukes before...
      Following the wiki I've dowloaded the last CVS snapshot...
      I've edited the local.properties to use hypersonic sql (no more than this), built the distro and buit the installer and deploy-installer.
      Then on the installer page I've chosen the proposed DefaultDS as datasource (which is the default from JBoss, so the default distro for hsqldb).
      All things seemed going well and finally I obtaind the "congratulation" message.
      However the deploy of nukes.ear failed.
      The error is related with a ClassNotFound:
      No ClassLoaders found for: com.mysql.jdbc.PreparedStatement
      I'm a newbye but the com.mysql seems the package for MySQL DB ... but I've compiled with the hsqldb database target...
      Using SQuirreL I can see that all tables and indexes and data have been created... however the EAR think to connect to a MySQL server...
      Can someone tell me why the install process failed (and why "contratulations" if the sistem is down?)
      An why all this stuff is needed if Nukes currently uses Datasource?
      Why, finally, Nukes doesn't simply use CMP 2.0 to create all needed table?
      Sorry for my many questions and if you found them stupid, it's the first time for me...
      Thaks!

        • 1. Re: Help on install
          jae Master

          1) you need to have the mysql jar in the "lib" directory of your jboss install. the code will function correctly and use hsql, but you need to have the mysql jar on the classpath (this should be fixed at some point).

          nukes uses straight jdbc to persist it's configuration settings (security, etc) to the database.

          2) the modules being released for nukes 1.1 will support having their tables created via cmp. only the "core" tables won't be supported by cmp for this release (this is b/c there is no way to create a unique constraint via cmp table creation, so we need to figure something else out to deal w/ this).

          • 2. Re: Help on install
            Viet Master

            we are moving to cmp, thing is that some thing cannot be done with the automatic table creation like putting a unique constraint on a column.

            • 3. Re: Help on install
              Daniele Newbie

              Thank you so much...
              I can't figure out why you need that jar, however...
              I've tried the "full-shipped" version (JBoss323+Nukes) and it started... but I can't see even there the mysql jar...
              However I'll try seraching the Iternet for that jar (or can you tell me where to directly download it? thanks again!).

              • 4. Re: Help on install
                jae Master

                this is the entry page, you can pick your own mirror location from here:

                http://dev.mysql.com/downloads/connector/j/3.0.html

                • 5. Re: Help on install
                  Daniele Newbie

                  Uhm.... Still having problems...
                  Has someone really tested it with HsqlBD?
                  The error now is:

                  2004-06-08 09:36:24,644 ERROR [org.jboss.nukes.component.Component.quotes] Cannot retrieve quotes
                  javax.ejb.FinderException: Find failed: java.sql.SQLException: Column not found: PN_ID in statement [SELECT t0_s.pn_id, t0_s.pn_author, t0_s.pn_quote FROM NUKE_QUOTES t0_s ORDER BY t0_s.pn_author ASC, t0_s.pn_quote ASC]
                  ...

                  I think this kind of error shoud never happen since it seems that the DB structure doesn't reflect what the software is expecting... a column is missing PN_ID ... so, perhaps, HsqlDB install scripts are not up-to-date with latest software upgrade... but even EJB classes seems not to be preflectly up-to-date with the invoker since, trying to use the "quotes" section an error occurs:

                  2004-06-08 10:13:59,580 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.jboss.nukes.addons.modules.quotes.ejb.QuotesEJBLocal org.jboss.nukes.addons.modules.quotes.ejb.QuotesEJBLocalHome.create(java.lang.String,java.lang.String) throws javax.ejb.CreateException, causedBy:
                  java.lang.IllegalArgumentException: object is not an instance of declaring class

                  And, but I can only imagine, this error is not related with HsqlDB so even using MySQL I should get it... even using the "FAQ" module:

                  2004-06-08 10:17:08,526 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.jboss.nukes.addons.modules.faq.ejb.FaqCategoryEJBLocal org.jboss.nukes.addons.modules.faq.ejb.FaqCategoryEJBLocalHome.create(org.jboss.nukes.addons.modules.faq.ejb.FaqCategoryEJBLocal,java.lang.String,java.lang.String) throws javax.ejb.CreateException, causedBy:
                  java.lang.IllegalArgumentException: object is not an instance of declaring class

                  Then same kind of error...
                  But the only thing I've done was compiling from the latest cvs snap-shot and following all web-installer instructions...

                  Is there somebody using Nukes successfully with HsqlDB? and if so could he/she zip it's result and post it somewhere :-) ... this would really save time to many of us...
                  I know there's the JBoss+Nukes+HsqlDB package in "downloads" but it is not shipped with many of the modules (quote, faq etc...) that I really need!
                  ... and perhaps it is so bercause they are experimental and doesn't work properly? it's not a critic, I'm only asking since I can't figure out why... perhaps it' only the latest CVS commit that had some problems?
                  If you can tell me something that can be usefull, you're welcome!!!
                  Thanks again and sorry if you think my post silly...
                  (and, sure, sorry for my english too)


                  • 6. Re: Help on install
                    jae Master

                    there is no guarentee that the faq and quotes modules work right now. they aren't scheduled for the 1.1 release, so no real attention is being given to them.

                    howard (hxp) was working on them, but he's traveling on business right now. hopefully when he gets back he can get them finished off and they can be released as part of a 1.2 release.

                    • 7. Re: Help on install
                      Daniele Newbie

                       

                      "jae77" wrote:
                      there is no guarentee that the faq and quotes modules work right now. they aren't scheduled for the 1.1 release, so no real attention is being given to them.

                      howard (hxp) was working on them, but he's traveling on business right now. hopefully when he gets back he can get them finished off and they can be released as part of a 1.2 release.


                      I didn't know this... is there a list of supported only modules?
                      I'm asking this since even "sections" doesn't work and seem to have the same problem:

                      2004-06-08 15:58:24,009 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.jboss.nukes.addons.modules.sections.ejb.SectionEJBLocal org.jboss.nukes.addons.modules.sections.ejb.SectionEJBLocalHome.create(java.lang.String,java.lang.String) throws javax.ejb.CreateException, causedBy:
                      java.lang.IllegalArgumentException: object is not an instance of declaring class
                      


                      So even "sections" is scheduled in another release? ... perhaps my feelings were correct: the jboss+nukes+hsqldb zip package, available for download, ships only supported modules?
                      well... it's a pitty since "sections" is really usefull to give news to users...
                      Is there someone that successfully installed those features? perhaps from an early snapshot? is there any reference to obtain an older working snap-shot?
                      Thanks again...

                      • 8. Re: Help on install
                        jae Master

                        i'm not really sure what the sections module does. if you are looking for a way to provide news to users, use the news module.

                        as stated in previous posts, the modules slated for 1.1 are:

                        - core
                        - bb (forums)
                        - news
                        - downloads

                        if you're interested in getting the sections module working, then refactor the code yourself and contribute it back. the module needs to be converted to "pure" cmp, have the html extracted into templates, etc.

                        and yes, the complete "packages" that you refer to only ship w/ the modules that are officially released.