View RSS Feed


Java Database Connectivity (JDBC) examples. SQL with Java.

  1. PreparedStatements and J2EE servers

    by , 04-27-2012 at 08:09 PM
    Things can get more complicated when we use a J2EE server. Normally, a prepared statement is associated with a single database connection. When the connection is closed, the preparedstatement is discarded. Normally, a fat client application would get a database connection and then hold it for its lifetime. It would also create all prepared statements eagerly or lazily. Eagerly means that they are all created at once when the application starts. Lazily means that they are created as they are used. ...