All:
I am looking for any suggestions/help/advice/etc on my problem. The background is this, I have an application that uses 3 MDBs, 3 Entity Beans, is deployed on Weblogic7.0 (the latest), and needs to query an Oracle9i database.
I have set up my drivers and URL, they work fine under a normal
java class making a connection. They also return "success" when using dbping to
test the connection, so the set up is right.
When Weblogic starts, the connection pool is made, the DataSource is fine -- but when the
EJB is deployed it comes back with the SQLException "Access not allowed".
I've put the classes12.zip file at the beginning of the classpath, modified the setenv.cmd file so the PATH includes %ORACLE_HOME%\bin and %WL_HOME%\bin\oci920_8.
I've also put in the following in the weblogic-ejb-jar file:
<security-permission>
<description>Oracle</description>
<security-permission-spec>
grant {
permission java.lang.RuntimePermission "loadLibrary.ocijdbc9";
};
</security-permission-spec>
</security-permission>
I've even tried to do what the Security Manager portion of the Weblogic documentation says to do. It said to "activate the security manager" by putting the following line in the startWeblogic file:
-Djava.security.manager
None of these have worked -- I keep getting that error. Like I said previously I have tried the connections and they have worked through other methods.
I've tried everything, including using an XA driver -- to no avail.
Thanks!
--------------
The connection pool information follows (from the config.xml file):
<JDBCConnectionPool CapacityIncrement="1"
DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="1"
LoginDelaySeconds="1" MaxCapacity="36" Name="P3IConnectionPool"
Properties="user=EI_SERVICES;password=EI_SERVICES;dll=ocijdbc9;protocol=thin"
RefreshMinutes="0" Targets="beaserver"
TestConnectionsOnReserve="true" TestTableName="STATE_LKUP" URL="jdbc
racle:thin:@192.168.23.45:1521
RASUN"/>
