RAR5074 exception against Oracle8.1.7 and Sun App Server PE 8.2
Folks,
I have seen some posts floating around re: this problem but haven't been able to get specifics regarding this problem. would greatly appreciate if someone is able to give me a hand with this issue.
Background:
I have an app running inside the Sun Java App Server PE8.2, talking to an oracle8.1.7 backend via the container pool, using Oraclejdbc14.jar
This is how I have set up my pool:
=====================================================
Datasource Classname: oracle.jdbc.pool.OracleDataSource
Resource Type:javax.sql.ConnectionPoolDataSource
Pool Settings:
Initial and Minimum Pool Size: 2
Maximum Pool Size:10
Pool Resize Quantity:2
Idle Timeout:300
Max Wait Time: 60000
Connection Validation
Connection Validation: Required
Validation Method:table
Table Name:DUAL
On Any Failure: Close All Connections
And here is my Code to retrieve the Connection
Context context =new InitialContext();
m_Logger.debug("Connecting to JNDI: " + jndi);
dataSource = (DataSource)context.lookup(jndi);
sqlConnection = dataSource.getConnection();
m_OracleConnection = (OracleConnection) dataSource.getConnection(sqlConnection);
if (m_OracleConnection ==null)
{
thrownew CoreDBConnectionException("Connection retrieved is null");
}
Now the application works just fine, I have no issues reading or writign data to the database, however if i look at the server log there are numerous exceptions as below
[#|2006-05-24T14:42:05.328+0800|SEVERE|sun-appserver-pe8.2|javax.enterprise.resource.resourceadapter|_ThreadID=14;|RAR5074 : Exceptionwhile executing prepared statement|#]
If i use a plain java.sql.DataSource everything is fine i.e. i don;t get the exceptions anymore but i am forced to use the sun datasource because i am using Clobs in my app and in order to create Temporary Clob, it needs an implicit OracleConnection.
has anyone come across this issue before, if yes have you been able to resolve this? Also does anyone have any other options of wrting Clobs to databse without actually creating a temporary clob?
Any help is much appreciated
Thanks in Advance,
Dushy
