nice to contact every one,This is my first time to mail in english,please forgive me. #1.It seems that when procedure in a class was loaded, drop and reloaded, the changes of JAR file havn't take effected! eg script: drop PROCEDURE test; call sqlj.remove_jar('admin.creaateClient', 0); call sqlj.install_jar('export\testproc.jar','admin.creaateClient', 0); CREATE PROCEDURE test( IN orgID INTEGER, IN groupID INTEGER, IN name varchar(60), IN faceFileID bigint, IN recStatus smallint, IN creator bigint ) PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME 'com.bana.commonServer.procedure.Client_info.creaateClient'; call test(1,2,'name',4,5,6); -- code ended when I change and re-complie the JAR ( a little changes of logic,nothing of the other changeed), I repeat the script but the logic is the old one...囧 #2 sql = "SELECT groupSize,seq from SEQ where seqType =101 and orgID =? and groupID =? "; pSeq= connection.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE); pSeq.setInt(1, orgID); pSeq.setInt(2, groupID); System.out.println(" exe SQL:"+sql); rs = pSeq.executeQuery(); if(rs.next()){ groupSize =rs.getInt(1); seq = rs.getInt(2); System.out.println("seq:"+seq); if(seq>=groupSize){ //returnCode[0] =4002; return; } System.out.println("groupSize:"+groupSize); rs.updateInt("seq", seq+1); /////////////not executed rs.updateRow();//////////////////not executed System.out.println("update:"+seq+1);//////////////////not executed
the return message is: The exception 'java.sql.SQLException:........ ' was thrown while evaluating an expression. I try the same code in independent java source and execute passed.I feel confused ,It my first time to try derby.... I look forward to your reply.thank you for you intention.