"stream database operator"

Hi Dan,
what exactly does happen when the operator fails?
Does your table have a primary key? If not I would suggest adding one.

Greetings,
  Sebastian

Hi Sebastian,

Thanks.

Actually my table does not have a primary key, but according to the documentation for this operator, a primary key would be created by RM for this operator application to succeed. Is it possible that this option is not functional? Have you tried it on other DBMS with tables without primary keys?

The error message is:
"Process failed. Reason: Database error occurred: ERROR: syntax error at or near AUTO_INCREMENT"

Best,
Dan

Hi Dan,
it has been tested on some DBMS, but altering tables is a much more DBMS dependent thing than simply reading the table using JDBC. The problem is, that each database system interprets the SQL "standard" a little bit different, changing keywords and so on. I guess, you system does not support the option AUTO_INCREMENT or something following this keyword in the statement. The simplest solution would be to introduce a primary key.

Greetings,
Sebastian

Hello I am having the same problem, and added a primary key on the table named id, but steel doesnt work, and gives me the same message, any ideas on whats cousing the problem.

Thanks

Hi,
which database system do you use?

Greetings,
  Sebastian

Hello.

I'm having the same troubles, and i have a primary key. The database is postgresql 8.4, anybody has a solution?