I am writing some stored procedure for Derby. And I am confused about the transaction settings for a Derby stored procedure using a nested connection.
Actually I am trying to modify the transaction isolation level to something like Serializable or Read Committed, and also change the auto commit to be false so that I can manually control the rollback or commit in the stored procedure. What I am doing is just something like:
connection = DriverManager.getConnection("jdbc:default:connection");
PreparedStatement insertToIndexPerson = connection
.prepareStatement("INSERT INTO index_time_person (index_time, person_email) VALUES (?, ?)");
I found both the autocommit mode and isolation level can be modified successfully.
But when I read Derby guide documents (derbydev.pdf "Programming database-side JDBC procedures), I found these items which is obvious forbids what I was doing: