Is it possible to call H2 from bash

I have the web and tcp server running. From java (scala really) I make a connection with jdbc:h2:tcp://localhost/. Is it also possible to retrieve a query from a bash script? Like it can be done with mySQL. I could of-course call a java program, but this would have a lot of overhead. So I was wonde

Re: Is it possible to call H2 from bash

The Shell or the RunScript tool should do the job. http://h2database.com/html/tutorial.html#command_line_tools -- 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

Re: Is it possible to call H2 from bash

2013/4/14 Noel Grandin > The Shell or the RunScript tool should do the job. > > http://h2database.com/html/tutorial.html#command_line_tools > I'll look into it. But in this way I start a jvm. That is quite expensive I think. There is not a better way? -- Cecil Westerhof -- You received this

Re: Is it possible to call H2 from bash

2013/4/14 Cecil Westerhof > 2013/4/14 Noel Grandin > >> The Shell or the RunScript tool should do the job. >> >> http://h2database.com/html/tutorial.html#command_line_tools >> > > I'll look into it. But in this way I start a jvm. That is quite expensive > I think. There is not a better way? > I

Left Join vs Inner Join performance

Hi, On a number of occasions I have found that replacing LEFT JOIN with INNER JOIN dramatically improved poorly performing queries. Generally the queries I run are generated so it was more convenient to use LEFT JOIN but depending on various criteria I have been able to use inner joins where it is

Clearing Cache

Hi, Is it possible to clear the query cache? For the purposes of comparing query performance. Even restarting the database does not seem to work, so they must be getting cached to disk, thanks, Mike -- You received this message because you are subscribed to the Google Groups "H2 Database" gr

Re: Is it possible to call H2 from bash

On 2013-04-14 21:06, Cecil Westerhof wrote: I'll look into it. But in this way I start a jvm. That is quite expensive I think. There is not a better way? How exactly do you think H2 works? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. T

Re: Left Join vs Inner Join performance

- What version are you testing on? Would be great if you could test with the nightly build because I made some index selection improvements recently. - What does your DB URL look like? - Can you do an EXPLAIN on both variants and post the results here? Regards, Noel Grandin -- You received