I am using emit updates. Here's the query from the trace log (connection
details omitted)
/*SQL t:79*/CREATE LINKED TABLE
extern.BioProject('*,'*','*','*','BioProject') EMIT UPDATES;It seems to make no difference (still generating DELETEs). thanks, Wim On Mon, Mar 18, 2013 at 3:34 PM, Noel Grandin <[email protected]> wrote: > 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 >> h2-database+unsubscribe@**googlegroups.com<h2-database%[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<http://groups.google.com/group/h2-database?hl=en> >> . >> For more options, visit >> https://groups.google.com/**groups/opt_out<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.
