i have an easerver 6.3 development edition,
the datasource on the easerver is ojdbc14.jar oracle driver, it is
defined ok i can ping it,
i have the simplest powerbuilder 11.5 component that uses a
connection(transaction object) by cachename
i can call the connection and i can execute a select statement, and i
can verify that it uses the connection from the pool
the problem is that i'm calling the component from java jsp web page
this is the code:
#################################
String vrati;
javax.naming.Context ctx = new javax.naming.InitialContext();
// look up the home interface
//i have it defined in the web.xml
Object obj = ctx.lookup("java:comp/env/ejb/treca");
// Convert the object to a home interface
n_treca_kompHome trecahome = (n_treca_kompHome)
javax.rmi.PortableRemoteObject.narrow(obj,n_treca_kompHome.class);
n_treca_komp treca = trecahome.create();
//executing the method
vrati = treca.vrati();
treca.remove();
treca = null;
trecahome = null;
return vrati;
###############################
the power builder component does just
connect
select count(*) into :str from somwhere;
disconnect;
so now to my problem,
this is the thing
when i execute the jsp web page that calls the above mentioned java
code it executes ok
it returns the result and everything is ok, but it doesnt realese all
the memory,
so after a 2000-3000 calls to the page it breaks, the easerver i mean
i have noticed that if execute the above java code and try to shut
down the easerver it says::
####################
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x2b382028, pid=7832,
tid=7668
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b04 mixed mode)
# Problematic frame:
# C [pbjvm115.dll+0x2028]
#
# An error report file with more information is saved as
hs_err_pid7832.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
######################################
but if i comment out the part that uses the database everything is ok
it exits fine,
so i figured out that it has to be about using the connection
but i haven't been able to figure it out,
so if any one has seen this problem and knows how to do this the right
way PLEASE HELP,
i have tried everything, by everything i mean moving the connect; &
disconnect;
statements from activate, deactivate, constructor,destructor, to
method but i dont know
nothing seem to be helping me, if i call connect in my component i
get the error
and it is a big problem