WLS 7.0 JDBC connection problem.

[Deyan D. Bektchiev]

Hi when trying to run an application that is running fine on 6.0 and 6.1
I ran in the exception below.
The DB is Oracle 8.1.6 and I'm using the thin driver with a TXDataSource.
The strange thing is that the exception happens momentarily and not
after 300 seconds as the exception says.

Does anyone have an idea what is going on?

java.sql.SQLException: Cannot obtain connection after 300 seconds. ,
Exception = Access not allowed
at
weblogic.jdbc.jts.Connection.wrapAndThrowSQLException(Connection.java:701)
at
weblogic.jdbc.jts.Connection.getOrCreateConnection(Connection.java:623)
at
weblogic.jdbc.jts.Connection.prepareStatement(Connection.java:133)
at
weblogic.jdbc.rmi.internal.ConnectionImpl.prepareStatement(ConnectionImpl.java:139)
at
weblogic.jdbc.rmi.SerialConnection.prepareStatement(SerialConnection.java:81)

Thanks,
Dejan

[Mike]

I'm getting something similar

weblogic.common.ResourceException: Access not allowed
at weblogic.jdbc.common.internal.ResourceAllocator.checkAdminPermissions
(ResourceAllocator.java:230)

[Deyan D. Bektchiev]

I was actually able to fix my problem by defining an ACL that allows
anyone to reserve a connection from the JDBC connection pool and now it
works fine but it took me some time to figure that out as sometimes it
was giving me connections and sometimes not.
I wish the reporting was a little better.

--dejan

[Mike]

Yes, someone here fixed it by updating the FileRealm.properites to include

acl.reset.weblogic.jdbc.connectionPool.<domain>=everyone
acl.reserve.weblogic.jdbc.connectionPool.<domain>=everyone

where domain is your domain

"Deyan D. Bektchiev" <dejan_b...@appl.net> wrote in message
news:3CD6D33...@appl.net...