Any hints on how to set the exchange message body to be empty ??
Matt 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.t4cconnect...@19f1bac] for JDBC transaction > DEBUG [DefaultQuartzScheduler_Worker-1] > (DataSourceTransactionManager.java:219) - Switching JDBC Connection > [oracle.jdbc.driver.t4cconnect...@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.drivermanagerdatasou...@19c123d] > DEBUG [DefaultQuartzScheduler_Worker-1] (SQLErrorCodesFactory.java:220) - > Database product name cached for DataSource > [org.springframework.jdbc.datasource.drivermanagerdatasou...@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.t4cconnect...@19f1bac] > DEBUG [DefaultQuartzScheduler_Worker-1] > (DataSourceTransactionManager.java:314) - Releasing JDBC Connection > [oracle.jdbc.driver.t4cconnect...@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-tp25955346p25957173.html Sent from the Camel - Users mailing list archive at Nabble.com.
