Oracle Error 17090
general structure of JDBC error messages, then lists general JDBC error messages and TTC error messages that the Oracle JDBC drivers can return. The appendix is organized as follows: General Structure of JDBC Error Messages General JDBC Messages HeteroRM XA Messages TTC Messages Each of the message lists is first sorted by ORA number, and then alphabetically. For general information about processing JDBC exceptions, see "Processing SQL Exceptions". General Structure of JDBC Error Messages The general JDBC error message structure allows runtime information to be appended to the end of a message, following a colon, as follows:
Speaker BureauLog inRegisterSearchSearchCancelError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Java Database Connectivity (JDBC) All PlacesJavaDatabase ConnectivityJava Database Connectivity (JDBC) This discussion is archived 0 Replies Latest reply on Jul 24, 2002 11:41 AM by 260017 Transaction Locking Problem in JDBC with ResultSet : ORA-17090. 260017 Jul 24, 2002 11:41 https://docs.oracle.com/cd/B12037_01/java.101/b10979/ermesap.htm AM I have a locking concern using JDBC. I select a set of records to determine if they need to to be updated by a set of generated results (from else where in the program). If the results are not in this cursored set of records selected they are to be INSERTED else they (if they are in the https://community.oracle.com/thread/36252 select set) they are to be UPDATED. I set up a ResultSet using concurrancy parameters so that I can scroll through them for each of the program results to check. If I set up the ResultSet with TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE, I get a possible race condition if I am accessing teh same records through some other program such as toad. As such the first record is not checked (if my cursor in toad is on this first record) and as such is duplicated. If I set up the ResultSet with TYPE_SCROLL_SENSITIVE, CONCUR_READ_ONLY. This fixes this concurrancy problem but occassionally I get the following error which is Oracle based and not documented: java.sql.SQLException: operation not allowed: Unsupported syntax for refreshRow() at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:251) at oracle.jdbc.driver.SensitiveScrollableResultSet.refreshRow(SensitiveScrollableResultSet.java:171) at oracle.jdbc.driver.SensitiveScrollableResultSet.handle_refetch(SensitiveScrollableResultSet.java:239) at oracle.jdbc.driver.SensitiveScrollableResultSet.next(SensitiveScrollableResultSet.java:83) at sfwmd.hisa.oneflow.TimeSeries.load(TimeSeries.java:2502) at sfwmd.hisa.oneflow.OneParameter.main(OneParameter.java:808) which translates to an ORA-17090 (operation not allowed) {NOTE: I do NOT call ResultSet.refreshRow() anywhere in my program} I do not see any methods in ResultSet for record locking, outside of the mentioned parameters in the constructor. The database (updates and inserts) changes
here for a quick overview of the site Help http://stackoverflow.com/questions/28245950/spring-jdbctemplate-insert-throws-uncategorized-sqlexception Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask oracle error Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Spring JdbcTemplate Insert throws uncategorized SQLException up vote 1 down vote favorite 1 I am inserting oracle error 17090 a new row into a table with Spring JDBCTemplate. The jdbcTemplate.update() throws the following exception: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17090]; operation not allowed But the row is inserted into the db anyway. Here's the code: final StringBuilder widgetInsert = new StringBuilder(); widgetInsert.append("INSERT INTO WIDGET (ID, KEY, DEPT_NUM, TYPE, CREATED_BY_ID, CREATED_DATE) "); widgetInsert.append("VALUES (WIDGET_SEQ.NEXTVAL, ?, ?, ?, ?, ?) "); Long widgetId; try { KeyHolder kh = new GeneratedKeyHolder(); jdbcTemplate.update( new PreparedStatementCreator() { @Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement(widgetInsert.toString()); ps.setLong(1, key); ps.setLong(2, deptNumber); ps.setString(3, widgetType); ps.setLong(4, creatorId); ps.setLong(5, System.currentTimeMillis()); return ps; } }, kh); widgetId = kh.getKey().longValue(); } catch (Exception e) { // THIS EXCEPTION IS THROWN throw new WidgetException("Problem inserting widget for key=" + key, e); } EDIT: Running Spring JDBC 3.2.4.RELEASE Full exception: [21] 15/02/02 15:04:59.537