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.