DBExecute SQL side effects

newscientist

• December 01, 2010 00:00

• Answered

Follow

I'm using CloverETL Community version.

I wish to use DBExecute with some simple (Postgres) SQL such as: select setval('table_col_seq',1); or select count(*) from table;

I always get the error: "org.postgresql.util.PSQLException: A result was returned when none was expected." How do I get around this? I cannot change the db from PG btw.


Regards
Chris

• 

  avackova

  • December 01, 2010 12:05

  0

  Comment actions Permalink

  Hello Chris,
  to get data from database use DBInputTable component. DBExecute component can execute update or procedure call. You can find examples of reading/writing data to/from databases among our examples (http://sourceforge.net/projects/clovere ... p/download)
• 

  newscientist

  • December 01, 2010 13:58

  0

  Comment actions Permalink

  Thanks.
  
  I have read the documentation in some detail. If I enter: select setval('table_col_seq',1); into DBExecute (I'm not interested in return data), it fails with the error given previously. How do I avoid getting this error?
  
  
  Regards
  Chris
• 

  avackova

  • December 01, 2010 14:38

  0

  Comment actions Permalink

  Select statement can't be executed with DBExecute component. If you want to execute the statement, that (may) returns the result set, you have to use DBInputTable.
• 

  newscientist

  • December 01, 2010 15:38

  0

  Comment actions Permalink

  Thanks!
  
  Perhaps you could update the DBExecute doc section to make this clear.
  
  Regards
  Chris

Please sign in to leave a comment.