5 Replies Latest reply on Oct 30, 2003 9:13 AM by Viet

    BB forum checked in

    Viet Master

      I have commited the code for the bb forums.

      It is still not finished but at least it is usable and the sources were goof enough to be checked in.

      It builds with the latest JBoss 3.2.2 but one should use a Branch_3_2 of jboss because there is a bug is 3.2.2 in the CMP engine which does not execute properly the ORDER BY clause in JBossQL. On the main page forums are not well sorted.

      In addition nukes user have now an additional property and therefore the user table must be updated (pn_last_visit). There is an alter table statement in nukes/nukes/mysql/setup.ddl to modify the table.

      What must be done next :

      1/finish security implementation
      2/update lucene 1.2 to 1.3RC2
      3/test
      4/debug
      5/test
      6/debug

      julien

        • 1. Re: BB forum checked in
          Joan Rey Noval Newbie

          Hi Julien,

          We've tried to install BB module from cvs. Unfortunately we encountered errors:

          2003-10-29 11:59:01,858 INFO [org.jboss.nukes.addons.modules.bb.BBModule] Creating
          2003-10-29 11:59:01,858 INFO [org.jboss.nukes.addons.modules.bb.BBModule] Created
          2003-10-29 11:59:01,874 INFO [org.jboss.nukes.addons.modules.bb.MailModule] Starting
          2003-10-29 11:59:01,967 INFO [org.jboss.nukes.addons.modules.bb.MailModule] Started
          2003-10-29 11:59:02,311 ERROR [org.jboss.ejb.EntityContainer] Starting failed
          org.jboss.deployment.DeploymentException: Could not load class:
          at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityCommandMetaData.(JDBCEntityCommandMetaData.java:61)
          at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:782)
          at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:361)

          ------------------------------------

          MBeans waiting for other MBeans:
          [ObjectName: nukes.modules:name=bb
          state: CREATED
          I Depend On: nukes.modules:name=core
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Category
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Forum
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Group
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Option
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Poll
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Post
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Topic
          jboss.j2ee:service=EJB,jndiName=nukes/bb/User
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Utils
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Vote
          jboss.j2ee:service=EJB,jndiName=nukes/bb/Watch

          Depends On Me: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Watch
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Post
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Poll
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Forum
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Group
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Topic
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Option
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Category
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/Vote
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: , ObjectName: jboss.j2ee:service=EJB,jndiName=nukes/bb/User
          state: FAILED
          I Depend On:
          Depends On Me: nukes.modules:name=bb
          org.jboss.deployment.DeploymentException: Could not load class: ]
          2003-10-29 11:59:17,295 INFO [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
          2003-10-29 11:59:17,374 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/jboss-3.2.2/server/default/conf/jboss-service.xml
          2003-10-29 11:59:17,389 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.2 (build: CVSTag=JBoss_3_2_2 date=200310182216)] Started in 53s:734ms


          Could you help us regarding this error?

          How can we get the Branch_3_2 of jboss?

          Regards,
          Joan

          • 2. Re: BB forum checked in
            Viet Master

            did you install the mysql driver ?

            julien

            • 3. Re: BB forum checked in
              Joan Rey Noval Newbie

              Yep. We installed the driver for mysql, unfortunately we forgot to replace the local.properties file for mysql. :(

              Here's what we did to make Nukes - MySQL with BB work. (We're running WinXP for development)

              1. Download latest copy of Nukes from CVS, download BB module from CVS.
              2. Download/Install JBoss 3.2.x (Branch_3_2) from this link.
              http://www.jboss.org/index.html?module=html&op=userdisplay&id=developers/sourcecode
              Download/Install mysql
              Download mysql jdbc driver
              3. Replace %NUKES%\build\etc\local.properties-example with local.properties-mysql ( make a backup copy if you want hsql :) )
              4. run build on %NUKES%\build
              5. create 'nukes' folder on %JBOSS_HOME%\server\default
              6. copy %NUKES%\nukes\src\resources\mysql\nukes-ds.xml to %JBOSS_HOME%\server\default\deploy
              7. copy mysql-connector-java-3.0.9-stable-bin.jar to %JBOSS_HOME%\server\default\deploy

              we modified %NUKES%\nukes\src\resources\mysql\prepare.ddl and did the ff changes:

              instead of

              GRANT
              Select,
              Insert,
              Update,
              Delete,
              Create,
              Drop,
              Reload,
              File,
              References,
              Index,
              Alter
              ON nukes.* TO nukes@'localhost' WITH GRANT OPTION;

              =============================================

              separate this to:

              GRANT
              Select,
              Insert,
              Update,
              Delete,
              Create,
              Drop,
              Index,
              Alter
              ON nukes.* TO nukes@'localhost' WITH GRANT OPTION;

              GRANT
              Reload,
              File,
              References,
              ON *.* TO nukes@'localhost' WITH GRANT OPTION;


              we modified %NUKES%\nukes\src\resources\mysql\setup.ddl and did the ff changes:

              on table `nuke_users` we replaced UNIQUE INDEX (`pn_name`) to UNIQUE INDEX (`pn_uname`)

              *****To Julien***
              Is this the right thing to do?? the hsql version doesn't have an index,
              if we don't do this, we will encounter "Duplicate entry '' for key 2" errors every time we register a new user for Nukes.

              8. use *replace favorite sql client here* and connect to MySQL db:

              a. execute %NUKES%\nukes\src\resources\mysql\setup.ddl
              b. execute %NUKES%\bb\src\resources\mysql\prepare.ddl
              c. execute %NUKES%\bb\src\resources\mysql\setup.ddl

              9. run build deploy on %NUKES%\nukes
              10. run build deploy on %NUKES%\bb
              11. run build deploy on the other modules. (don't forget to execute the respective setup.ddl for these modules)


              Whew! :)

              I hope I didn't miss something important.

              Great work guys! We'll test the BB module and send feedback.

              Joan Rey Noval
              Questnova Systems Corporation

              • 4. Re: BB forum checked in
                Raja Master

                Joan,
                Did you have to install other modules to make bb work? Can i just have a nukes and bb setup? im facing the exact issue that u posted earlier(Classnotfound). I could not find a manifest entry that points to my bb-lib.jar from the ejb jar file. CAn you post the manifest for ur bb-ejb-jar.jar?

                Thanks
                Raj

                • 5. Re: BB forum checked in
                  Viet Master

                  the cvs is up-to-date but not yet the dayly-archive. this piss me off :-)

                  okay, so to make the transformation :

                  here is nukes-bb-ejb-jar.mf :

                  Manifest-Version: 1.0
                  Created-By: @java.vm.version@ (@java.vm.vendor@)
                  Specification-Title: @specification.title@
                  Specification-Version: @specification.version@
                  Specification-Vendor: @specification.vendor@
                  Implementation-Title: @implementation.title@
                  Implementation-URL: @implementation.url@
                  Implementation-Version: @implementation.version@
                  Implementation-Vendor: @implementation.vendor@
                  Implementation-Vendor-Id: @implementation.vendor.id@
                  Class-Path: ./nukes-bb-lib.jar

                  then you have to remove from application.xml :


                  nukes-bb-lib.jar