Internal error: unknown or unrealized access type: 9
We are starting the tomcat server with connection pooling and recently we get this error randomly. This happens when we run random processing on a stored procedure in a batch. I tried to do some research on the problem myself which leads to the source of this Java class where I assume the error is being dumped from: http://ora-jdbc-source.googlecode.com/svn/trunk/OracleJDBC/src/oracle/jdbc /driver/T2CCallableStatement.java
My question is, what is access type 9? It is not defined in the class of the class I provided, but whoever wrote this class should have had a list of accessories and their corresponding numbers, which I would like to see from if possible, but could not find.
I also found other access type numbers in the error logs, for example: 6 is also shown.
Update: I found a page detailing the datatypes and their code values, but datatypes 6 and 9 don't seem to exist, making this error even weirder: https://docs.oracle.com/cd/E11882_01 /appdev.112/e10646/oci03typ.htm#LNOCI030
source to share
It seems this issue is caused by Java when there are concurrency issues in the code. We ran into the issue above when our program started a thread pool and a programmer mistakenly using the same connection on each thread, only for SELECT statements would be ok (and according to the Java Connection class, this should be technically good) ... I think this just goes to show that the Java Jar for Oracle DB is not thread safe.
source to share
I faced the same problem, but the type was 6. The problem was caused by not closing (by calling .close ()) prepared statements and result sets containing the query results. The New Prepared Statement and Result Set wizard is not enough, you should always close them. Lesson learned.
source to share