Re: [h2] cannot connect remotely when stating as a service

2013-09-16 Thread Ryan How
I'm not 100% sure on how the H2 service is set up, but Is the service starting with the -tcpAllowOthers flag? Also, is the windows firewallconfigured to allow connections to the service name executable?(Assuming itisn't running as javaw. If it is does javaw allow the incoming connections or th

[h2] cannot connect remotely when stating as a service

2013-09-16 Thread Pinky Thakkar
Hi, After installing H2 database as a service, I cannot connect to the database from another computer. I would like to use the database in a client/server mode. I can connect to the database remotely if I start the service from the command prompt java -cp h2*.jar org.h2.tools.Server -tcpA

Re: [h2] performance differences in insert commands

2013-09-16 Thread Brian Craft
One more data point: if copy the table by doing a bunch of inserts from the application code, this performance difference disappears. It's something peculiar to "insert into .. select" On Friday, September 13, 2013 5:22:05 PM UTC-7, Brian Craft wrote: > > Added the h2 profiler calls. Here's th

Re: [h2] Patch for org.h2.tools.Server.openBrowser

2013-09-16 Thread Noel Grandin
Thank you. Patch committed to SVN. On 2013-09-16 14:07, Felix Kaiser wrote: I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed under the H2 License, version 1.0, and under the Eclipse Public License, version 1.0. Thanks! Felix On Mon, Sep 16, 2013

Re: [h2] Patch for org.h2.tools.Server.openBrowser

2013-09-16 Thread Felix Kaiser
I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed under the H2 License, version 1.0, and under the Eclipse Public License, version 1.0. Thanks! Felix On Mon, Sep 16, 2013 at 1:56 PM, Noel Grandin wrote: > Awesome! > > Before I can accept this, have y

Re: [h2] Help for developments

2013-09-16 Thread Noel Grandin
I'm afraid our tests are not that organised :-) Running org.h2.test.db.TestScript by itself should make sure that the basics of the SQL command parser are working. I normally run TestAll and stop it after it has run through the first mode - the way TestAll works is that it runs the whole tes

Re: [h2] Patch for org.h2.tools.Server.openBrowser

2013-09-16 Thread Noel Grandin
Awesome! Before I can accept this, have you provided us with a license statement yet? e.g. see here: http://h2database.com/html/build.html#providing_patches Thanks, Noel. ' On 2013-09-13 15:55, Felix Kaiser wrote: here's a patch that: - makes openBrowser respect the $BROWSER environment varia

Re: [h2] More support needed for ClientInfo to make it work in websphere

2013-09-16 Thread Noel Grandin
I've added the bare minimum of support here, in the sense that it now returns an empty result from the DatabaseMetaData#getClientInfoProperties() method. On 2013-09-11 00:35, Sridhar G wrote: We are using Websphere 7.0.0.27. -- You received this message because you are subscribed to the

Re: [h2] H2 1.3.173 tcp server stops listening, java deadlock?

2013-09-16 Thread Noel Grandin
A fix for this has been committed to SVN. On 2013-09-10 12:52, RobAu wrote: Found 1 deadlock. -- 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+un