help!! problem with postgresql and java studio creator
[252 byte] By [001cesara] at [2007-11-26 12:40:32] 
sorry my english helpme!!i am trying to insert a registry in a table in postgresql throght JAVA STUDIO CREATOR and i got the next errorCannot change transaction isolation level in the middle of a transactionhelpme thanks you
# 1
Cesar,
Check out these from http://forum.java.sun.com/thread.jspa?forumID=881&threadID=5101711
Looked around in JSC, and found the following properties to set, which solved my problem:
1. Node Resources (under Servers): set transaction-isolation-level to read-committed, connection-validation-method to auto-commit
2. SessionBean RowSets: set transactionIsolation to TRANSACTION_READ_COMMITTED
Actually connection validation and isolation level are related. See my theory here:
http://forum.sun.com/jive/thread.jspa?threadID=62629&start=25&tstart=0
Regards,
-Brad Mayer
utsukushiia at 2007-7-7 16:12:13 >
Development Tools New Topic
- Page navigation made easy
- problem inserting timestamp field in mysql db using dataprovider
- java.sql.SQLException: Internal Error in RowSetReader: no connection or com
- help problem with postgresql and SUN STUDIO CREATOR
- please helpme "Cannot change transaction isolation level in the middle of "
- Query regarding Treen node and its Content
- JMS
- Exception Details: java.lang.IllegalArgumentException: EMPID
Development Tools Hot Topic
- Need help linking (Sun Workshop 6 CC)
- source line mapping in .s
- Help !!Can't compile C++ in netbeans
- Sun Java Studio Creator or Visual Web Pack?
- Show dialog box on the web page
- button text does not change
- JSE 8 very slow after 3 alt-tab's on XP SP2
- How to update my DB Table data from my JSP page (please help me out)
Development Tools
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding