Sun App Server configurations
I have done something wrong, but I don't know what.
Few days ago my app read 1000 records from database in 0,5 s ,now it takes 120s .I have reinstalled server, and probably have not configured it properly, particularly the JDBC connection.
Can anybody give me some links with step-by-step configuring database connection on Sun App Server. I use NetBeans, I suppose it also do some server configuration automatically, but I am not sure.
perhaps this is cause of Isolation Level set to Read-commited when before it was set to read-uncommited , but now if I set it to read-uncommited in connection pool properties I have exception:
Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: The transaction isolation could not be set: "acceptable are" READ_COMMITTED and SERIALIZABLEError Code: 0
Now I am in situation when in Admin Console I try to ping my connection pool with Read-Uncomminted exception is raised and in console there is a message:
ErrorAn error has occurred.
Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: The transaction isolation could not be set: "acceptable are only"READ_COMMITTED and SERIALIZABLE
Why I can't set that isolation level ?
