爪哇咖啡屋 : [轉貼]ORACLE JDBC 的 getGeneratedKeys

String sql = "INSERT INTO FOO (NAME) VALUES ('BAR')";
Statement stmt = connection.createStatement();
stmt.executeUpdate(sql, Statement.RETURN_GENERATED_KEYS);
ResultSet rs = stmt.getGeneratedKeys();
oracle.sql.ROWID rid = (oracle.sql.ROWID) rs.getObject(1); //getLong and getInt fail
// The following fail
// long l = rid.longValue();
// int i = rid.intValue();
String s = rid.stringValue(); // s equals "AAAXcTAAEAAADXYAAB"

String sql = "INSERT INTO ORDERS (ORDER_ID, CUSTOMER_ID) VALUES (ORDER_ID_SEQ.NEXTVAL, ?)";
String generatedColumns[] = {"ORDER_ID"};
PreparedStatement pstmt = conn.prepareStatement(sql, generatedColumns);
pstmt.setLong(1, customerId);
pstmt.executeUpdate();
ResultSet rs = pstmt.getGeneratedKeys();
rs.next();
// The generated order id
long orderId = rs.getLong(1);

int a[]={1};

PreparedStatement pstmt = conn.prepareStatement(sql, a);

......

			boolean ready2Commit = true;

			int rimtid[]={1};

			try {
				ebsConnection = sqlTalk.getConnectionFromPool();
				//Prepared Statement Transaction with commit/rollback pattern
				ebsConnection.setAutoCommit(false);

				updateMCount = sqlPreparedStamtementM.executeUpdate();

				if( updateMCount > 0 ) {
					ResultSet rsM = sqlPreparedStamtementM.getGeneratedKeys();
					rsM.next();
					long orderMId = rsM.getLong(1);

				if( ready2Commit ) {
					//20190726，Prepared Statement Transaction with commit/rollback pattern
					ebsConnection.commit();
				}

pstmt = conn.prepareStatement(query, Statement.RETURN_GENERATED_KEYS); 

com.microsoft.sqlserver.jdbc.SQLServerException
The statement must be executed before any results can be obtained.