Hi Roman have fixed the bug in the next Camel 2.1 release https://issues.apache.org/activemq/browse/CAMEL-2077
On Mon, Oct 19, 2009 at 1:33 PM, SoaMattH <[email protected]> wrote: > > > I have set up my ide with the source so I can debug into the > SqlProducer.java > > When the trigger is a Quartz Cron as I have in an XML Route > line 50 in SqlProducer.java gets executed. - It proberably should not > > THe iterator ends up containing: > From Eclipse Debugger: > ---------------------- > 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] > > > So the line 50 tries to set the Prepared statement to the details of my > quartz job which is clearly > a bug .... > ps.setObject(argNumber++, iterator.next()); > > So It seems I neet to put a step in my route to set the message to nothing > ...... > > > > > 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-tp25955346p25956806.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
