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.
