i am using Weblogic 6.1. I have setup a connection pool to my Oracle 9i database.But everytime my Ejb's try to access the database nothing happens(connection hangs) and after some time i get the TransactionRolledBackException.
Strange thing is if i point my connection pool to my other Oracle 8 server, everything works perfectly. I am using the Oracle thin JDBC driver, does it have anything to do with that ?
I dont think there is a problem with my 9i installation because that works perfectly if i change my EJB's so as to connect to the database without any Connection pool.
Any faced this problem before ?
Any suggestions would be much appreciated as right now i am all at sea
. If nothing comes up i will have to uninstall Oracle 9i and start all over again, but that is a option i do not want to take 'coz i am pretty sure that there is nothing wrong with the way Oracle is installed.