I was a little bit fast here. What is actually happening is this: - I'm trying to execute the insert - it fails -> I do a rollback (with con.rollback()) - this generates a faulty query with the clob as above
I've worked around this for now, but I do wonder whether this means that the underlying oracle connection transactions are not being used? On Mon, Mar 18, 2013 at 4:19 PM, Wim De Smet <[email protected]> wrote: > 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.
