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: domain of steven.ebersole@gmail.com
 designates 209.85.214.180 as permitted sender)
Sender: Steve Ebersole <steven.ebersole@gmail.com>
Message-ID: <51F9A579.5060204@hibernate.org>
Date: Wed, 31 Jul 2013 19:02:01 -0500
From: Steve Ebersole <steve@hibernate.org>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130623 Thunderbird/17.0.7
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Java stored procedure performing insert/update/delete
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I am trying to work out how to define a Java stored procedure using 
Derby that performs a insert/update/delete and results in the proper 
"update count" on the JDBC client.  But I have so far been unsuccessful.

Here is what I have...

First, through JDBC I execute:

create procedure deleteAllUsers()
language java
external name 'TheClass.deleteAllUsers'
parameter style java

TheClass.deleteAllUsers looks like:

public static void deleteAllUsers() {
     Connection conn = DriverManager.getConnection( 
"jdbc:default:connection" );
     PreparedStatement ps = conn.prepareStatement( "delete from t_user" );
     int count = ps.executeUpdate();
     System.out.println( "Count : " + count );
     ps.close();
     conn.close();
}

And on the JDBC client side:

Connection conn = ...;
CallableStatement stmnt = conn.prepareCall( "{call deleteAllUsers()}" );
// yes I know this could be stmnt.executeUpdate()...
stmnt.execute();
int count = stmnt.getUpdateCount();


So the deleteAllUsers() prints the correct count.  But on the client, I 
always get zero (and not -1).

Obviously I am doing something wrong.  Any pointers?

Thanks,
Steve