I am wondering in a three tier architecture with Weblogic as Application Server and connecting to Oracle 8.1.6 through JDBC, if let's say there are 10 connections in the database which are active querying the database what happens if application server crashes? Will all the connection be terminated or simply once a sesion connects to database it forgets about the connection between Weblogic & Oracle therefore no matter what happens to Application Server the session would stayed connected until the query finishes?

I think all connections would be terminated, correct or I am wrong?