Java Stored Procedure only work in First Connection. [message #92800] |
Fri, 28 January 2005 07:11 |
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 |
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?
|
|
|