Thread: Postgresql and Creator2 commitChanges()
Hi. Sun Java Studio Creator 2 and PostgreSQL 8.1 database using 8.1-405 jdbc3. Connectin,fetching,... works. But "someDataProvider.commitChanges()" works only first time. Then the only message i get after "someDataProvider.commitChanges()" is "can't change isolation level in the middle of transaction". I must use stored procedures for update and insert records. It works fine. When i change the data provider to MySQL all works fine (i mean "someDataProvider.commitChanges()"). Can anybody comment ?. Thanks.
On Tue, 18 Apr 2006, lash wrote: > Sun Java Studio Creator 2 and PostgreSQL 8.1 database > using 8.1-405 jdbc3. > > But "someDataProvider.commitChanges()" works only first time. > Then the only message i get after "someDataProvider.commitChanges()" is > "can't change isolation level in the middle of transaction". If you are going to post to multiple lists, please cross-post instead of sending two separate messages. This is a JDBC question, so I'll follow up there. Kris Jurka