BB forum checked in

[julien1]

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

[joanrey]

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

[julien1]

did you install the mysql driver ?

julien

[joanrey]

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

[raja05]

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

[julien1]

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