Thanks for reading this.
I've got a problem when using jboss to deploy a BMP and my database is mysql.
The problem is I've got the connection successfully, but when
I execute a query why it report an error:the table is not found.
pstmt = conn.prepareStatement( "select sum(balance) as total from test.account" );
I'm sure this table is in the database.I'm puzzled.
First the default pool size is 20 concurrent connections.
Also, upgrade to a more recent version of jboss. There were many bugs
in that pooling implementation. In fact it has been "rewritten" twice since 3.0.2
Regards,
Adrian