Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <20100104002738.bzjyn3yjwg4o8sc8@www.staffmail.ed.ac.uk>
Date: Mon, 04 Jan 2010 00:27:38 +0000
From: Trevor Carpenter <trevor.carpenter@ed.ac.uk>
To: "derby-user@db.apache.org" <derby-user@db.apache.org>
Subject: problem with select statement?
MIME-Version: 1.0
Content-Type: text/plain;
	charset=ISO-8859-1;
	DelSp="Yes";
	format="flowed"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi

when trying to call the next method on a result set generated by a =20
select statement I get the exception:
java.sql.SQLException: ResultSet not open.  Verify that autocommit is OFF.
         at =20
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown =20
Source)
         at =20
org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
         at org.apache.derby.client.am.ResultSet.next(Unknown Source)
         at jpegrobot.Main.main(Main.java:44)
Caused by: org.apache.derby.client.am.SqlException: ResultSet not =20
open.  Verify that autocommit is OFF.
         at =20
org.apache.derby.client.am.ResultSet.checkForClosedResultSet(Unknown =20
Source)
         at org.apache.derby.client.am.ResultSet.nextX(Unknown Source)
         ... 2 more

Here is the relevant portion of my code:
package jpegrobot;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Time;

/**
  *
  * @author tcarpent
  */
public class Main {

     /**
      * @param args the command line arguments
      */
     public static void main(String[] args) {
         //
// connect to database
         try {       Connection localConnection =3D null;
                     Statement localStatement;
             try{
                     Class.forName("org.apache.derby.jdbc.ClientDriver");
                     localConnection =3D =20
DriverManager.getConnection("jdbc:derby://localhost:1527/C:/database/mydatab=
ase", "*", =20
"*");
                     System.out.println("Data connection obtained");
                 } catch (Exception e) {
                     System.err.println("I cannot connect to the database");
                     System.err.println("Exception: "+e.getMessage());
                     System.exit(1);
                 }
             String SQLString =3D"SELECT * FROM WORKFLOW";
             localStatement =3D localConnection.createStatement();
             ResultSet resultSet =3D localStatement.executeQuery(SQLString);
             while (resultSet.next()) {
<-- exception at call to next()

My platform is:
------------------ Java Information ------------------
Java Version:    1.6.0_17
Java Vendor:     Sun Microsystems Inc.
Java home:       C:\Program Files\Java\jre6
Java classpath:  C:\Program =20
Files\Sun\JavaDB\bin\../lib/derby.jar;C:\Program =20
Files\Sun\JavaDB\bin\../lib/derbynet.jar;C:\Program Files\Sun\J
avaDB\bin\../lib/derbyclient.jar;C:\Program =20
Files\Sun\JavaDB\bin\../lib/derbytools.jar
OS name:         Windows XP
OS architecture: x86
OS version:      5.1
Java user name:  tcarpent
Java user home:  C:\Documents and Settings\tcarpent
Java user dir:   C:\Program Files\Sun\JavaDB\bin
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[C:\Program Files\Sun\JavaDB\lib\derby.jar] 10.4.2.1 - (706043)
[C:\Program Files\Sun\JavaDB\lib\derbytools.jar] 10.4.2.1 - (706043)
[C:\Program Files\Sun\JavaDB\lib\derbynet.jar] 10.4.2.1 - (706043)
[C:\Program Files\Sun\JavaDB\lib\derbyclient.jar] 10.4.2.1 - (706043)
------------------------------------------------------

is the result set closed after committing the select statment (why)? I =20
have tried specifying cursor hold etc?

Thanks

Trevor

--=20
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.