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-tp25955346p25955346.html
Sent from the Camel - Users mailing list archive at Nabble.com.
