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]
<mailto:[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] <mailto:[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.
