Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: local policy)
From: =?iso-8859-1?Q?Arnaud_Lema=EEtre?= <arnaud.lemaitre@free.fr>
To: <user-java@ibatis.apache.org>
Subject: Multi result sets support broken in ibatis-2.3.0.677
Date: Thu, 21 Jun 2007 12:35:48 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
thread-index: AceyU3+U8emE1KUrRDSP54tTtqJnEwBnAZXg
Message-Id: <20070621103536.593C01AB2BC@smtp1-g19.free.fr>

Hi,

Following my previous mail, i did jdbc quick and dirty equivalent to my
programm. (without changing my db configuration)

So Ibatis 2.3 seems to be broken regarding multi result sets support.
And apparently it=92s not only when resultclass is set to =AB int, int =
=BB since
I did some different tests returning POJOs etc.=20

If i can fix it myself  i'll submit a patch. Hope it=92s not tricky.

Regards,
Arnaud

Here is the test :

package com.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class test {

	public static void main( String[] args ) {
		new test( args );
	}

public void testJDBCConnection() throws Exception
	{
		Class.forName( "com.mysql.jdbc.Driver" );
	=09
		String url =3D
"jdbc:mysql://myHost:3306/myDatabase?autoReconnect=3Dtrue&allowMultiQueri=
es=3Dtr
ue&characterEncoding=3DUTF-8&characterSetResults=3DUTF-8";
	=09
		Connection conn =3D DriverManager.getConnection( url,
"myDatabase", "myPassword" );
		=09
		try
		{		=09
			String sqlString =3D "SELECT 1+1; SELECT 2+2; SELECT
3+3";
			System.out.println("Before executing");
		=09
		=09
			Statement stmt =3D conn.createStatement();
			stmt.execute( sqlString );
			for (;;) {
				int updateCount =3D stmt.getUpdateCount();
				if (updateCount >=3D 0) {
// report rows affected...
				}
				else {
					ResultSet rs =3D stmt.getResultSet();
					if (rs =3D=3D null)
					break;
					if ( rs.next() )
						System.out.println( "result
:" + rs.getInt(1) );
// process resultset ....
				}
				stmt.getMoreResults();
			}
								=09
			System.out.println("After executing");
		}
		catch (Exception e)
		{
			System.out.println("Exception: " + e);
		}
	=09
	}

public test( String[] args ) {=20
	try
	{		=09
	testJDBCConnection();=20
	}
	catch (Exception e)
	{
		System.out.println("Exception: " + e);
	}
}

}

And the output :

Before executing
result :2
result :4
result :6
After executing