Try using "EMIT UPDATES"
On 2013-03-18 16:14, Wim De Smet wrote:
Hello,
I'm trying to use linked tables to insert some data into an oracle
database. But before inserting H2 generates a faulty delete query.
The query is:
DELETE FROM BioProject WHERE DTYPE=? AND PROJECTID=? AND ACCESSION=?
AND ARCHIVE=? AND DESCRIPTION=? AND NAME=? AND TITLE=? AND
DESCRIPTIONOTHER IS NULL AND SUBTYPE IS NULL;
"DESCRIPTION" is a CLOB field and cannot appear in the where clause. I
really don't need the deletes to run in the first place. Is there any
way to disable them?
I'm also not clear how this works with transactions. If you run
multiple DML queries on the linked tables, do they all belong to the
same transaction, or is the database autocommitting them?
regards,
Wim
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
