Hello everybody,
scenario:
I have two databases with the same tables A and B. Only differents is that the primary key in table A is a database identity and in table B the primary key has no sequence. I set the sequence type of table B to none of the primary key column.
Aim:
What I would like to do is to copy the data from table A to table B with the exact same primary keys. This job runs once a day and the data rows in Table A are sequencial but could have gaps in the squence due to deleting and reentering data.
Error:
ERROR com.servoy.j2db.util.Debug - Error executing sql: insert into B (id, txt) values (?, ?) with params: [1 ,type: java.lang.Integer, 'Test' ,type: java.lang.String]
I get this error for each new record I try to insert.
Information:
When I insert that SQL with a SQL-Tool ist simply works.
When I use a different sequnecy type it seams to work, but not realy the new record does not have the same primary key value. It gets it from the sequence.
Anything I can do?