RE: [JBoss-user] ear jndi different databases.

I used to have the same problem, one app instance is accessing the datasource of another app2 instance. I resolved the problem by adding a jboss-app.xml with a unique loader repository name for every new app instance. Regards, Rene -Original Message- From: Stefan Groschupf

[JBoss-user] Element type auto-increment must be declared.

Hi, I'm using jboss-3.2.0RC2 and I want to auto-increment my PK in MySql. I followed the format in jbosscmp-jdbc.xml: cmp-field field-namejsCode/field-name column-nameJS_CODE/column-name jdbc-typeINTEGER/jdbc-type sql-typeINTEGER(11)/sql-type auto-increment/ /cmp-field

[JBoss-user] mysql auto-increment

Hi, I'm following the recent discussion about PK generation in 3.2 specifically mysql auto-increment and presently I'm getting: javax.ejb.EJBException: Unexpected Error java.lang.NoSuchMethodError: com.mysql.jdbc.PreparedStatement.getGeneratedKeys()Ljava/sql/ResultSet; The detailed log error

[JBoss-user] ear-based scoping or multiple jboss instance

I have an application that I want to deploy multiple times to be consumed by different customers. What is the best practice, one ear file per application or one jboss instance per application. I tend to use the former approach because it feel that this is more manageable, but I'm concerned with

[JBoss-user] Question on how to deploy multiple ear file of the same application

Hi, I have an application implementing servlet-SLSB-EB that runs well on jboss3.0.4. My problem is how to duplicate this same application several times that will run on the same machine/jboss/web/database server instance (to be consumed by different customers much like an App Service Provider

[JBoss-user] Throughput testing

Hi, I'm doing a throughput testing with a Stateless SB method (w/ CMP 2.0 EB) querying a simple 25 rows resultset. Using JUnitPerf, I set the number of concurrent users to 20 and JBoss errors out between the 15-20th concurrent access. I'm wondering about where the possible bottlenecks are so I

[JBoss-user] entityHome.create() returning null EJBObject

Hi, I get a NULL EJBObject with the below expression. I'm using java.lang.Integer as my primary key and MySQL auto-increment feature for my primary key generator. Based on the SQL log file, the data was inserted in the DB, but I get a NULL reference. Please advice what's wrong with my

Re: [JBoss-user] entityHome.create() returning null EJBObject

Thanks Alex, I think this is what I'm missing. :) Regards, Rene Hello Rene, if you want auto-increment support, you need JBoss-3.2 at a minimum. Then in jbosscmp-jdbc.xml for the autoincremented field: cmp-field field-nameid/field-name

[JBoss-user] character literal comparison in JBoss-QL

I've been doing a: * @jboss:query signature=Collection findFundStatusReservedByJbCode(java.lang.Integer JB_CODE) * query=SELECT OBJECT(jr) FROM GlJournalBatch jb, IN(jb.glJournals) jr WHERE jb.jbCode=?1 AND jr.jrFundStatus='R' and keep getting a: org.jboss.deployment.DeploymentException:

Re: [JBoss-user] character literal comparison in JBoss-QL

passed the 'char' in the finder parameter instead of hard-coding it in the EJB-QL and it worked fine. Rene The jr.jrFundStatus field is obviously a number and therefore cannot be compared to a string literal. Either change the field to a String or change the query. -dain Rene Palad wrote