Results 1 to 2 of 2

Thread: pdo error

  1. #1
    Join Date
    Jan 2005
    Posts
    362

    Unanswered: pdo error

    I use php with h2 database at resin server that support php.
    I have a paging page that has a list af articles and I use a connection pooling for the database.
    The page seems to display ok at IE but at the log of resin the error "the object is already closed at org.h2.jdbc.jdbcStatement.CheckClosed.java:812 etc." is displayed.
    Maybe the driver try to release this Statement object's database and JDBC resources and find that some object is already close.
    As I understant this error is here for a pdo prepared statement.
    My code that I see the error is like this
    Code:
    $query="select count(*) as a from c where b=?";
    $res=$dbh->prepare($query);
    $res->execute(array(1));
    Is something wrong with this?
    Dimis
    Last edited by dimis2500; 11-10-07 at 11:08.

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    I'm confused, are you using Java or PHP, as the error (org.h2.jdbc.jdbcStatement.CheckClosed.java:812) indicates you're using Java somewhere.
    Also, what database system are you using? I'm not aware of a database called "h2".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •