camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roman Kalukiewicz <roman.kalukiew...@gmail.com>
Subject Re: sql throwing oracle 17004 ORA-17004 error
Date Mon, 19 Oct 2009 09:38:19 GMT
I believe before you send your message to jms endpoint you should clear your
message body.

SQL componet assumes your body is used as query parameters. If you don't
have any parameters in your query, but you send some body, there could be an
exception thrown.

Roman

2009/10/19 SoaMattH <matthew@netpacket.com.au>

>
>
> If I change the Query to
>    <camel:endpoint id="sabaOmsCoursesSQLEndPoint"
>      uri="sql:select 'MyTitle' title from
> dual?dataSourceRef=sabaDataSource"/>
>
> I get the same error ?? Any Thoughts??
>
> I can query the db and tables with dbVisualizer and the dame odbc14.jar
> for oracle 10.2.0.3.0
>
> Thanks Matt Hannay
>
>
>
> SoaMattH wrote:
> >
> > I have the following End point and route:
> >
> >   <camel:endpoint id="sabaOmsCoursesSQLEndPoint"
> >     uri="sql:select * from
> > RPV_DES_OMS_COURSES?dataSourceRef=sabaDataSource"/>
> >
> > ....
> >
> >   <camel:route id="omsSabaCoursesRoute">
> >     <camel:from uri="quartz://omsSabaCourses/?cron=0+0+20+?+*+MON-SUN" />
> >     <!-- <camel:policy ref="SABA_READ_ONLY" /> -->
> >     <camel:to ref="sabaOmsCoursesSQLEndPoint" />
> >     <camel:to uri="bean:sabaCourseService" />
> >   </camel:route>
> >
> > The Endpoint is a view that consists of CHAR, VARCHAR2 and DATE coulmns
> > so nothing out of the ordinary.
> >
> >
> >
> >
> > When the SQL is called the following Error is given:
> >
> > DEBUG [DefaultQuartzScheduler_QuartzSchedulerThread]
> > (SimpleJobFactory.java:50) - Producing instance of Job
> > 'DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN',
> > class=org.apache.camel.component.quartz.CamelJob
> > DEBUG [DefaultQuartzScheduler_Worker-1] (JobRunShell.java:201) - Calling
> > execute on job DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN
> > DEBUG [DefaultQuartzScheduler_Worker-1] (QuartzEndpoint.java:115) -
> Firing
> > Quartz Job with context: JobExecutionContext: trigger:
> > 'Camel.omsSabaCourses job:
> > DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN fireTime: 'Mon
> > Oct 19 20:00:00 EST 2009 scheduledFireTime: Mon Oct 19 20:00:00 EST 2009
> > previousFireTime: 'null nextFireTime: Tue Oct 20 20:00:00 EST 2009
> > isRecovering: false refireCount: 0
> > DEBUG [DefaultQuartzScheduler_Worker-1] (QuartzEndpoint.java:115) -
> Firing
> > Quartz Job with context: JobExecutionContext: trigger:
> > 'Camel.omsSabaCourses job:
> > DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN fireTime: 'Mon
> > Oct 19 20:00:00 EST 2009 scheduledFireTime: Mon Oct 19 20:00:00 EST 2009
> > previousFireTime: 'null nextFireTime: Tue Oct 20 20:00:00 EST 2009
> > isRecovering: false refireCount: 0
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractPlatformTransactionManager.java:371) - Creating new transaction
> > with name [null]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> (DriverManagerDataSource.java:163)
> > - Creating new JDBC DriverManager Connection to
> > [jdbc:oracle:thin:@aserver:1521:sabpdb]
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DataSourceTransactionManager.java:202) - Acquired Connection
> > [oracle.jdbc.driver.T4CConnection@19f1bac] for JDBC transaction
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DataSourceTransactionManager.java:219) - Switching JDBC Connection
> > [oracle.jdbc.driver.T4CConnection@19f1bac] to manual commit
> > DEBUG [DefaultQuartzScheduler_Worker-1] (DefaultProducer.java:66) -
> > Starting producer: Producer[sql://select * from
> > RPV_DES_OMS_COURSES?dataSourceRef=sabaDataSource]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (DefaultProducer.java:66) -
> > Starting producer: Producer[sql://select * from
> > RPV_DES_OMS_COURSES?dataSourceRef=sabaDataSource]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (ProducerCache.java:201) - Adding
> > to producer cache with key: Endpoint[sql://select * from
> > RPV_DES_OMS_COURSES?dataSourceRef=sabaDataSource] for producer:
> > Producer[sql://select * from
> > RPV_DES_OMS_COURSES?dataSourceRef=sabaDataSource]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (ProducerCache.java:201) - Adding
> > to producer cache with key: Endpoint[sql://select * from
> > RPV_DES_OMS_COURSES?dataSourceRef=sabaDataSource] for producer:
> > Producer[sql://select * from
> > RPV_DES_OMS_COURSES?dataSourceRef=sabaDataSource]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (JdbcTemplate.java:574) -
> > Executing prepared SQL statement [select * from RPV_DES_OMS_COURSES]
> >  INFO [DefaultQuartzScheduler_Worker-1]
> (XmlBeanDefinitionReader.java:323)
> > - Loading XML bean definitions from class path resource
> > [org/springframework/jdbc/support/sql-error-codes.xml]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (DefaultDocumentLoader.java:72) -
> > Using JAXP provider [org.apache.xerces.jaxp.DocumentBuilderFactoryImpl]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (BeansDtdResolver.java:72) -
> Found
> > beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in
> > classpath: spring-beans-2.0.dtd
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultBeanDefinitionDocumentReader.java:86) - Loading bean definitions
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'DB2'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'DB2'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> 'DB2'
> > to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'DB2'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'Derby'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'Derby'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'Derby' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'Derby'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'H2'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'H2'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean 'H2'
> > to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'H2'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'HSQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'HSQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'HSQL' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'HSQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'Informix'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'Informix'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'Informix' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'Informix'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'MS-SQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'MS-SQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'MS-SQL' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'MS-SQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'MySQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'MySQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'MySQL' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'MySQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'Oracle'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'Oracle'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'Oracle' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'Oracle'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'PostgreSQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'PostgreSQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'PostgreSQL' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'PostgreSQL'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DefaultSingletonBeanRegistry.java:214) - Creating shared instance of
> > singleton bean 'Sybase'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:383) - Creating instance of bean
> > 'Sybase'
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:459) - Eagerly caching bean
> > 'Sybase' to allow for resolving potential circular references
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractAutowireCapableBeanFactory.java:411) - Finished creating
> instance
> > of bean 'Sybase'
> >  INFO [DefaultQuartzScheduler_Worker-1] (SQLErrorCodesFactory.java:128) -
> > SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL,
> > Oracle, PostgreSQL, Sybase]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (SQLErrorCodesFactory.java:201) -
> > Looking up default SQLErrorCodes for DataSource
> > [org.springframework.jdbc.datasource.DriverManagerDataSource@19c123d]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (SQLErrorCodesFactory.java:220) -
> > Database product name cached for DataSource
> > [org.springframework.jdbc.datasource.DriverManagerDataSource@19c123d]:
> > name is 'Oracle'
> > DEBUG [DefaultQuartzScheduler_Worker-1] (SQLErrorCodesFactory.java:177) -
> > SQL error codes for 'Oracle' found
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (SQLErrorCodeSQLExceptionTranslator.java:266) - Unable to translate
> > SQLException with Error code '17004', will now try the fallback
> translator
> > DEBUG [DefaultQuartzScheduler_Worker-1] (Pipeline.java:99) - Message
> > exchange has failed so breaking out of pipeline: Exchange[Message:
> > JobDetail 'DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN':
> > jobClass: 'org.apache.camel.component.quartz.CamelJob isStateful: false
> > isVolatile: false isDurable: false requestsRecovers: false] Exception:
> > org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> > DEBUG [DefaultQuartzScheduler_Worker-1] (Pipeline.java:99) - Message
> > exchange has failed so breaking out of pipeline: Exchange[Message:
> > JobDetail 'DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN':
> > jobClass: 'org.apache.camel.component.quartz.CamelJob isStateful: false
> > isVolatile: false isDurable: false requestsRecovers: false] Exception:
> > org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> > DEBUG [DefaultQuartzScheduler_Worker-1] (Logger.java:197) - Failed
> > delivery for exchangeId: ID-AQ4397-4530-1255946375104-0-0. On delivery
> > attempt: 0 caught: org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> > DEBUG [DefaultQuartzScheduler_Worker-1] (Logger.java:197) - Failed
> > delivery for exchangeId: ID-AQ4397-4530-1255946375104-0-0. On delivery
> > attempt: 0 caught: org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> > DEBUG [DefaultQuartzScheduler_Worker-1] (RedeliveryErrorHandler.java:361)
> > - This exchange is not handled so its marked as failed: Exchange[Message:
> > JobDetail 'DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN':
> > jobClass: 'org.apache.camel.component.quartz.CamelJob isStateful: false
> > isVolatile: false isDurable: false requestsRecovers: false]
> > DEBUG [DefaultQuartzScheduler_Worker-1] (RedeliveryErrorHandler.java:361)
> > - This exchange is not handled so its marked as failed: Exchange[Message:
> > JobDetail 'DEFAULT.quartz://omsSabaCourses/?cron=0+0+20+%3F+*+MON-SUN':
> > jobClass: 'org.apache.camel.component.quartz.CamelJob isStateful: false
> > isVolatile: false isDurable: false requestsRecovers: false]
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> (TransactionErrorHandler.java:127)
> > - Setting transaction to rollbackOnly due to exception being thrown:
> > org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> (TransactionErrorHandler.java:127)
> > - Setting transaction to rollbackOnly due to exception being thrown:
> > org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> > DEBUG [DefaultQuartzScheduler_Worker-1] (TransactionTemplate.java:152) -
> > Initiating transaction rollback on application exception
> > org.apache.camel.spring.spi.TransactedRuntimeCamelException:
> > org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> >       at
> >
> org.apache.camel.spring.spi.TransactionErrorHandler.wrapTransactedRuntimeException(TransactionErrorHandler.java:171)
> >       at
> >
> org.apache.camel.spring.spi.TransactionErrorHandler$1.doInTransactionWithoutResult(TransactionErrorHandler.java:121)
> >       at
> >
> org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
> >       at
> >
> org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
> >       at
> >
> org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:86)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.processExchange(RedeliveryErrorHandler.java:186)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:155)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:88)
> >       at
> >
> org.apache.camel.processor.DefaultErrorHandler.process(DefaultErrorHandler.java:49)
> >       at
> >
> org.apache.camel.processor.DefaultChannel.process(DefaultChannel.java:148)
> >       at
> >
> org.apache.camel.processor.UnitOfWorkProcessor.processNext(UnitOfWorkProcessor.java:54)
> >       at
> >
> org.apache.camel.processor.DelegateProcessor.process(DelegateProcessor.java:48)
> >       at
> >
> org.apache.camel.processor.loadbalancer.QueueLoadBalancer.process(QueueLoadBalancer.java:41)
> >       at
> >
> org.apache.camel.component.quartz.QuartzEndpoint.onJobExecute(QuartzEndpoint.java:119)
> >       at
> org.apache.camel.component.quartz.CamelJob.execute(CamelJob.java:32)
> >       at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
> >       at
> >
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
> > Caused by: org.springframework.jdbc.UncategorizedSQLException:
> > PreparedStatementCallback; uncategorized SQLException for SQL [select *
> > from RPV_DES_OMS_COURSES]; SQL state [null]; error code [17004]; Invalid
> > column type; nested exception is java.sql.SQLException: Invalid column
> > type
> >       at
> >
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
> >       at
> >
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
> >       at
> > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
> >       at
> > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619)
> >       at
> > org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:43)
> >       at
> >
> org.apache.camel.processor.SendProcessor$1.doInProducer(SendProcessor.java:81)
> >       at
> >
> org.apache.camel.processor.SendProcessor$1.doInProducer(SendProcessor.java:79)
> >       at
> > org.apache.camel.impl.ProducerCache.doInProducer(ProducerCache.java:141)
> >       at
> > org.apache.camel.processor.SendProcessor.process(SendProcessor.java:78)
> >       at
> >
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:61)
> >       at
> >
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:61)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.processExchange(RedeliveryErrorHandler.java:186)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:155)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:88)
> >       at
> >
> org.apache.camel.processor.DefaultErrorHandler.process(DefaultErrorHandler.java:49)
> >       at
> >
> org.apache.camel.processor.DefaultChannel.process(DefaultChannel.java:148)
> >       at org.apache.camel.processor.Pipeline.process(Pipeline.java:74)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.processExchange(RedeliveryErrorHandler.java:186)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:155)
> >       at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:88)
> >       at
> >
> org.apache.camel.spring.spi.TransactionErrorHandler.access$101(TransactionErrorHandler.java:41)
> >       at
> >
> org.apache.camel.spring.spi.TransactionErrorHandler$1.doInTransactionWithoutResult(TransactionErrorHandler.java:114)
> >       ... 15 more
> > Caused by: java.sql.SQLException: Invalid column type
> >       at
> >
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> >       at
> >
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> >       at
> >
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
> >       at
> >
> oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9262)
> >       at
> >
> oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8843)
> >       at
> >
> oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9565)
> >       at
> >
> oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9548)
> >       at
> >
> org.apache.camel.component.sql.SqlProducer$1.doInPreparedStatement(SqlProducer.java:50)
> >       at
> > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
> >       ... 34 more
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (AbstractPlatformTransactionManager.java:821) - Initiating transaction
> > rollback
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DataSourceTransactionManager.java:273) - Rolling back JDBC transaction
> on
> > Connection [oracle.jdbc.driver.T4CConnection@19f1bac]
> > DEBUG [DefaultQuartzScheduler_Worker-1]
> > (DataSourceTransactionManager.java:314) - Releasing JDBC Connection
> > [oracle.jdbc.driver.T4CConnection@19f1bac] after transaction
> > DEBUG [DefaultQuartzScheduler_Worker-1] (DataSourceUtils.java:312) -
> > Returning JDBC Connection to DataSource
> >
> >
> > Any clues on this error ?
> >
> > Matt
> >
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/sql-throwing-oracle-17004-ORA-17004-error-tp25955346p25955499.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message