org.springframework.jdbc.UncategorizedSQLException

CallableStatementCallback; uncategorized SQLException for SQL [{call PKG_BATCH.selectFileBatch(?, ?, ?, ?, ?)}]; SQL state [99999]; error code [17004]; Tipo di colonna non valido: 2012; nested exception is java.sql.SQLException: Tipo di colonna non valido: 2012


Solutions on the web297

Solution icon of stackoverflow
CallableStatementCallback; uncategorized SQLException for SQL [{call PKG_BATCH.selectFileBatch(?, ?, ?, ?, ?)}]; SQL state [99999]; error code [17004]; Tipo di colonna non valido: 2012; nested exception is java.sql.SQLException: Tipo di colonna non valido: 2012

Solution icon of stackoverflow
CallableStatementCallback; uncategorized SQLException for SQL [{call VSC.GET_ALL_SYSTEM_USERS(?, ?, ?, ?)}]; SQL state [99999]; error code [17004]; Invalid column type: 1111; nested exception is java.sql.SQLException: Invalid column type: 1111

Solution icon of web
PreparedStatementCallback; uncategorized SQLException for SQL [select * from attributes]; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type

Solution icon of spring
via Spring JIRA by Jacques-Henri Berthemet, 1 year ago
PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO testNVARCHAR2 (ID) VALUES(?)]; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type

Solution icon of web
PreparedStatementCallback; uncategorized SQLException for SQL [select * from attributes]; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type

Solution icon of web
PreparedStatementCallback; uncategorized SQLException for SQL [select * from attributes]; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type

Solution icon of spring
via Spring JIRA by Li Cao, 1 year ago
PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type

Solution icon of spring
via Spring JIRA by Jacques-Henri Berthemet, 1 year ago
PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO testNVARCHAR2 (ID) VALUES(?)]; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type

Solution icon of spring
via Spring JIRA by Li Cao, 1 year ago
PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type

Solution icon of stackoverflow
via Stack Overflow by DeooK
, 2 months ago
CallableStatementCallback; uncategorized SQLException for SQL [{call MANDAMAIL.MANDA_MAIL(?)}]; SQL state [99999]; error code [22922]; ORA-22922: valore LOB non esistente ORA-06512: a "SYS.DBMS_LOB", line 837 ORA-06512: a "T1000_ADM.MANDAMAIL", line

Stack trace

  • org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{call PKG_BATCH.selectFileBatch(?, ?, ?, ?, ?)}]; SQL state [99999]; error code [17004]; Tipo di colonna non valido: 2012; nested exception is java.sql.SQLException: Tipo di colonna non valido: 2012 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1032) at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1066) at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:144) at org.apache.camel.component.sql.stored.TemplateStoredProcedure.execute(TemplateStoredProcedure.java:74) at org.apache.camel.component.sql.stored.CallableStatementWrapper.populateStatement(CallableStatementWrapper.java:104) at org.apache.camel.component.sql.stored.SqlStoredProducer$1.execute(SqlStoredProducer.java:69) at org.apache.camel.component.sql.stored.CallableStatementWrapper.call(CallableStatementWrapper.java:55) at org.apache.camel.component.sql.stored.SqlStoredProducer.process(SqlStoredProducer.java:43) at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) at org.apache.camel.processor.SendProcessor$2.doInAsyncProducer(SendProcessor.java:173) at org.apache.camel.impl.ProducerCache.doInAsyncProducer(ProducerCache.java:341) at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:168) at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196) at org.apache.camel.processor.Pipeline.process(Pipeline.java:121) at org.apache.camel.processor.Pipeline.process(Pipeline.java:83) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196) at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:681) at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:609) at org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:238) at org.apache.camel.processor.Splitter.process(Splitter.java:108) at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196) at org.apache.camel.processor.Pipeline.process(Pipeline.java:121) at org.apache.camel.processor.Pipeline.process(Pipeline.java:83) at org.apache.camel.processor.ChoiceProcessor.process(ChoiceProcessor.java:117) at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196) at org.apache.camel.processor.TryProcessor.process(TryProcessor.java:113) at org.apache.camel.processor.TryProcessor.process(TryProcessor.java:84) at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196) at org.apache.camel.component.file.GenericFileConsumer.processExchange(GenericFileConsumer.java:454) at org.apache.camel.component.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:226) at org.apache.camel.component.file.GenericFileConsumer.poll(GenericFileConsumer.java:190) at org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:175) at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:102) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Tipo di colonna non valido: 2012 at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:4188) at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:129) at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:326) at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:574) at oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1603) at org.springframework.jdbc.core.CallableStatementCreatorFactory$CallableStatementCreatorImpl.createCallableStatement(CallableStatementCreatorFactory.java:198) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1010) ... 44 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago