> Marcio Suda wrote: > > > > > I�ve experienced some database problems. I�m using a > > JBOSS server(java > > server) connecting to a SAP DB database, and now after some > > time using the > > server, the database simply don�t connect any more. I�ve > > tried using SQL > > Studio and using a JDBC driver, but the database doesn�t > > connect, it simply > > locks and don�t respond, I can�t connect anymore. I don�t > > know exactly which > > operation, sql instruction caused this. Which reasons can cause this > > database lock?. (Note the jboss server use row locking > > feature, but the > > problem persist when the db is restarted).
Did you close the Statement/PreparedStatement or ResultSet or Connection ? It would be better if you close each of them in every sql executed. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
