-
1. Re: JBoss 2.4.5 - Cannot access DB
akerr May 13, 2002 3:48 PM (in response to fbiaggi)I tried porting to 2.4.5 today with the same results. It looks like the at least the first database access succeeds, but once the exceptions start, I can't access the database anymore.
My MySQL setup works perfectly in 2.4.4.
One other strange thing... I keep seeing multiple "Creating XA Pool" messages in the log. Shouldn't I only see this once per pool? Perhaps this is related? -
2. Re: JBoss 2.4.5 - Cannot access DB
jgremmen May 14, 2002 2:53 AM (in response to fbiaggi)Same problem here. My application runs on JBoss 2.4.4 but on 2.4.5 I get (among others) the following database exception:
[INFO,XAPoolDataSource] Creating XA Pool
[ERROR,es_framework] com.xyz.es.applications.ir.server.EmployeeBean: Unable to load employee bean EmployeePK[dvID=14]
java.sql.SQLException: Closed Statement
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4768)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:349)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
at org.jboss.pool.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:71)
My datasource definition in jboss.jcml:
/es/jdbc/Default_DS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:thin:@hello.mydomain.de:1521:XYZ
&user&
&pass&
true
2
5
true
1500
Can someone help me (us) out?
Regards,
Jeroen -
3. Re: JBoss 2.4.5 - Cannot access DB
erok May 15, 2002 9:23 AM (in response to fbiaggi)Same trouble here. Changed from 2.4.5 RC2+MySQL (I think) to 2.4.5Final+MySQL (MM JDBC driver 2.0.13) and couldn't access the DB.
I actually tried to run 2.4.5 final, with the much older MM JDBC driver 2.0.4, and it started WORKING!!!
I don't know why though... -
4. Re: JBoss 2.4.5 - Cannot access DB
jgremmen May 16, 2002 5:22 AM (in response to fbiaggi)@erok
In other threads the same problem is discussed for Oracle drivers. As each submitter states that all worked fine in JBoss 2.4.4 (or even 2.4.5RC3) I'm not convinced that moving back to a flintstones-version of the mysql driver is a real solution. The release notes of 2.4.5 describe changes that have been made in the PreparedStatement code and that's where the exceptions are thrown.
I'd love to submit this (apparantly) JBoss bug but JBoss version 2.4.5 is not yet in the bug-product-list. I'm wondering if this version is considered stable by the JBoss people...
Regards,
Jeroen -
5. Re: JBoss 2.4.5 - Cannot access DB
jgremmen May 16, 2002 5:25 AM (in response to fbiaggi)It seems there's a solution:
http://main.jboss.org/forums/thread.jsp?forum=46&thread=15432 -
6. Re: JBoss 2.4.5 - Cannot access DB
fbiaggi May 16, 2002 7:12 AM (in response to fbiaggi)Yes,
JBoss 2.4.6 solves the problem.