1) Hi, i'm trying to track down what causes the errors:

GDS Exception. Error reading data from the connection.
local transaction active: can't begin another

You cannot getAutomcommit on an unassociated closed connection

These errors do not happens all the times, usually they happen when i
run a long heavy duty test during the night. They could happen after
some hours or, like last night, after 30 minutes i've gone home.

I'm using the 1.0RC4 driver with Firebird 1.02, windows xp pro.

Java code:
String query = "SELECT * FROM \"proc_getRes\"(" + param + ")";
try {
PreparedStatement ps = dbconn.getConn().prepareCall(query);
ResultSet rs = ps.executeQuery();
if(rs.next()) {
//get data from rs
} else {
//no data
}
rs.close();
ps.close();
} catch (SQLException ex) {
System.err.println(query);
throw ex;
}


"proc_getRes" it's a singleton stored procedure.
dbconn it's a simple wrapper around a Connection. Connection is obtained
from a pool created as stated in the FAQ. Connection is taken from the
pool performing an open and then released after doing the job.
Pool is configured to create and mantain a fixed (10) number of
connections. During the test i was having about 50 threads using the
pool... uhm... is the pool synchronized?


SQL:

begin
SELECT LR_RES, LR_DATARES, LR_ORARES FROM "LogRes"
WHERE LR_IDCLIENT = :"idclient" AND LR_PROGCLIENT = :"progclient" AND
LR_DATARES is not null
INTO :"res", :"data", :"ora";
suspend;
end



2) Now i'm trying to do some tests: i've restarted my java application
and i've restarted Firebird. My java application starts but it's now
locked and saying:

log4j:ERROR No appenders could be found for category
(org.firebirdsql.jca.IdleRemover).
log4j:ERROR Please initialize the log4j system properly.

... uh, hey, after about 1 minute staying idle the application started.

what this means?


thanks.
ciao
--
Seti@Home Java Applets
http://maruko.cjb.net/