Issues
Hello,
As part of my final training period in ESIAL (French engineering school) I am currently building a client/server application based on the JBoss framework. It is definitely a great piece of software: congratulations for your work !
I have been using JBoss 3 (alpha, beta, beta2) for 7 months now, mainly because I needed the CMP 2 features.
And I would like to report some "strange behavior".
I am running Win2k Pro SP2, I have downloaded the latest release (cvs this morning) and compiled it using JDK 1.4. I start the server with a JAVA_OPTS set to "-Dpolicy.expandProperties=false". At the moment, our application can use Hypersonic or IBM DB2 dbms, depending on the datasource which is set and the appropriate jbosscmp-jdbc.xml file (this is set at install).
Here is a list of issues:
1) the EJB-Verifier is reporting warnings when deploying beans:
2002-04-10 09:48:34,415 INFO [org.jboss.ejb.EJBDeployer]
Bean : TSomething
Section: 10.8.1
Warning: The primkey-field must be one of the CMP fields of the entity bean.
But the ejb-jar.xml is ok: it was generated automatically, and it contains the primkey-field.
<display-name>TSomething</display-name>
<ejb-name>TSomething</ejb-name>
(...)
<cmp-field>
<field-name>Identifier_Something</field-name>
</cmp-field>
(...)
<prim-key-class>java.lang.Integer</prim-key-class>
<primkey-field>Identifier_Something</primkey-field>
(...)
Is there something wrong here ? I have checked the syntax, the case, the orders of declaration but nothing worked (and the DTD is ok). Of course, this is only a warning, but it may be related to other issues.
2) The file connector\src\etc\example-config\hsqldb-service.xml contains several times "LocalTxCM,name=MySqlDS"
(instead of name=HsqlDS I guess). But this is not very important.
3) I created a db2-service.xml based on what I found in example-config (and from previous working configurations), and configured the auth.conf file. Our application works fine when using Hypersonic. But when using DB2, it does not behave as it should. For instance, if I use a findAllInstances on some particular beans, it works, but JBoss hangs when accessing others. The log grows exponentially, with entries such as:
2002-04-10 09:51:44,669 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.TSomething] Executing SQL: SELECT IDENTIFER_SOMETHING (...) FROM ttt.T_SOMETHING WHERE (IDENTIFER_SOMETHING =?) OR (IDENTIFER_SOMETHING=?) OR (IDENTIFER_SOMETHING=?) OR (...) and so on.
It seems to be related to the new jca file, but I do no know if I am missing something here. It works with Hypersonic, and it worked with previous releases of JBoss.
Any ideas ?
Thanks.
PS: I am sorry, I tried to attach both db2-service.xml and hsql-service.xml files, but it will not work, the web server is not responding.