SQLException « Operation « Java Database Q&A

1. SQLException in JDBC    stackoverflow.com

I am getting a SQLException when I try to run the query in Informix DB using JDBC. The query is huge in size:

select * table_name where tableid in (....)

2. Getting java.sql.SQLException: Invalid column index while inserting into table    stackoverflow.com

I have been working with a snippet of code where 'java.sql.SQLException: Invalid column index' is being thrown at runtime. I have worked several times in past with this exception and every time ...

3. How to get exact sql query that contains exception in batch processing    stackoverflow.com

I want to execute the following: (a transfer to PRESENTATION DB of a row from a fetched row of PROCESSING DB)

    PreparedStatement stmt;
    Statement st;
 ...

4. SQLException encountered while executing the query - however, at random situations    coderanch.com

5. Getting SQLException while executing merge query.    coderanch.com

6. java.sql.SQLException: ORA-01400: cannot insert NULL into ("SYSTEM"."DESCRIPTION"."TYPE")    coderanch.com

insert into DESCRIPTION (TYPE,DESCRIPTION,IS_HTML,EVENT_ID) values('','','',41) java.sql.SQLException: ORA-01400: cannot insert NULL into ("SYSTEM"."DESCRIPTION"."TYPE") at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125) at com.event.struts.InsertDetails.doPost(InsertDetails.java:78) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source and i ...

7. SQLException - Operation must use updateable query    dbforums.com

Hi all, I keep getting the exception below when I try to execute an update to a table using JDBC-ODBC. I have tried using "Statement.executeUpdate" but keep getting the same exception. --> java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. at sun.jdbc.odbc.JdbcOdbc.createSqlException(JdbcOdbc .java:6026) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :6183) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java :2489) at sun.jdbc.odbc.JdbcOdbcStatement.execute (JdbcOdbcStatement.java:329) at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate (JdbcOdbcStatement.java:279) ------------------------------------------------------------------------- Has anybody ...

8. java.sql.SQLException: ORA-01401: inserted value too large for column    forums.oracle.com

9. SQLException with invalid column type when running simple select query    forums.oracle.com

Hi, The following query works fine in my database client, but not in my application: select * from attributes The following is my stack trace: QL error codes for 'Oracle' found Unable to translate SQLException with Error code '17004', will now try the fallback translator Extracted SQL state class '99' from value '99999' Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException ...