Hi, A silly mistake on my part. Thanks for the hint. Right before doing the select/insert I was running a "DELETE FROM table;". It's that query that's causing problems. I guess I can fix that by doing a delete all from where id in ....
thanks for the help, Wim On Mon, Mar 18, 2013 at 3:59 PM, Noel Grandin <[email protected]> wrote: > Sorry, I can't see anything obvious in the code. > > The only thing I can suggest is to run your code under a debugger with the > H2 source code available, and put a breakpoint at the > org.h2.table.TableLink#execute > method, > which is where it passes the SQL to the linked database engine, > and see if you can track down what it's doing. > > If you can't figure out the code, generate a stacktrace at that point and > post it here. > > > On 2013-03-18 16:50, Wim De Smet wrote: > > Should have given you both! It's an embedded database, relying on > registered drivers to connect: > jdbc:h2:grsdb2 > > Can't get much simpler I guess. > > > On Mon, Mar 18, 2013 at 3:47 PM, Noel Grandin <[email protected]>wrote: > >> Sorry, I meant your H2 database URL. >> Some of the settings impact how linked tables work. >> >> >> On 2013-03-18 16:44, Wim De Smet wrote: >> >> It's a thin connection to oracle, so: >> jdbc:oracle:thin:@host:port:sid >> >> Usually when using this all metadata etc. can be queried, or at least >> I've been able to do so before. >> >> >> On Mon, Mar 18, 2013 at 3:43 PM, Noel Grandin <[email protected]>wrote: >> >>> What does your database URL look like? >>> >>> >>> On 2013-03-18 16:37, Wim De Smet wrote: >>> >>>> 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). >>>> >>>> >>>> >>> >> >> > > -- 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.
