camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Claus Ibsen <claus.ib...@gmail.com>
Subject Re: sql throwing oracle 17004 ORA-17004 error
Date Mon, 19 Oct 2009 12:42:16 GMT
On Mon, Oct 19, 2009 at 2:01 PM, SoaMattH <matthew@netpacket.com.au> wrote:
>
>
> Any hints on how to set the exchange message body to be empty ??
>

<setBody><constant></constant></setBody>


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



-- 
Claus Ibsen
Apache Camel Committer

Open Source Integration: http://fusesource.com
Blog: http://davsclaus.blogspot.com/
Twitter: http://twitter.com/davsclaus

Mime
View raw message