Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    2

    Unanswered: JDBC driver problem - Informix XPS

    I am facing a problem with using Informix JDBC driver 2.2. Database is Informix XPS 8.32.FC1.

    I get the following error when I try to close a connection:

    "Error Closing Connection. Must terminate transaction before closing database."

    I am not starting a transaction. All I am doing is a SELECT. Why am I getting this error ?

    Any help will be really appreciated. This is driving me crazy.

    Thanks
    Ghanshyam

  2. #2
    Join Date
    Mar 2002
    Posts
    112

    re

    I don't know about use JDBC connect Informix , in SQL statement that you send it to run use "begin work" ...<YOUR SQL> "commit work" ,I don't know that it's the solution but it's identify that begin transaction and end transaction

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Are you closing your resultset and statements ? Are you setting autocommit ? Have you reviewed the release notes ?

    If possible, please post your code.

  4. #4
    Join Date
    May 2002
    Posts
    2
    Here is what I am doing:

    Connection conn = ds.getConnection();
    conn.setAutoCommit(true); // default is true so not really needed
    String sql = "select * from emp";
    Statement stmt = conn.createStatement(sql);
    ResultSet rs = stmt.executeQuery();
    // process ResultSet code here
    conn.close() // this is where I get the error

    Thanks
    Ghanshyam

Posting Permissions

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