Home » Developer & Programmer » JDeveloper, Java & XML » Java Stored Procedure only work in First Connection.
Java Stored Procedure only work in First Connection. [message #92800] Fri, 28 January 2005 07:11 Go to next message
Michael Yeung
Messages: 1
Registered: January 2005
Junior Member
I am using Oracle 10g standard edition on Fedora Core 2.

Java Stored Procedures and DBMS_JAVA work perfectly on the first connection after startup. But other connection afterware it will cause an ORA-07445 and disconnect.

My database is running under dedicated Server Mode.
Detail log as below :
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [[joe_well_known_internal()+39]] [[SIGSEGV]] [[Address not mapped to object]] [[0x13F7D5C]] [[]] [[]]
Current SQL statement for this session:
Create Java Source Named "Host" using BFILE( myDir, 'Host.java' )

I have try share server mode, Java Stored Procedures and DBMS_JAVA only work for first few SQL statements.
It seems only the first share server can work.

Pls Help.
Re: Java Stored Procedure only work in First Connection. [message #120440 is a reply to message #92800] Thu, 19 May 2005 14:55 Go to previous message
gpaton
Messages: 1
Registered: May 2005
Junior Member
I am experiencing the same problem, however only in certain situations. I depends on my set up. When I run weblogic 8.1 with an Oracle9i database, my java stored proceedure only works the first time. The second time I try to trigger it, my call times out. However if I'm running an Orion app server against an Oracle 9i database, I don't experience this problem.

I think it may be a Weblogic configuration issue.

Have you by any chance resolved this problem?
Previous Topic: Breaking connection to server while executing SQL query
Next Topic: Creating object to a data binded class which is inside another jar
Goto Forum:
  


Current Time: Fri Nov 22 09:49:18 CST 2024