camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SoaMattH <matt...@netpacket.com.au>
Subject Re: sql throwing oracle 17004 ORA-17004 error
Date Mon, 19 Oct 2009 09:32:20 GMT


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
View raw message