I'm using a local server (websphere 5.0 Test Enviroment) with a DB2 datasource (DB2 JDBC Provider). Sometimes it works really well but 3 out of 5 times, it doesn't. I don't get errors in my log, all seams well but it is not. I get unpredictable query results, like ongoing loops (rs.next() gives me the same record, on and on), date-fields gives empty strings, other fields gives me strange characters and things like that. When I restart the server (sometimes more than 1 time), all is well again.
Does anyone have the same experience and know what the problem could be?