Re: [h2] Re: H2 is missing org.osgi.service.jdbc in older OSGI environments

2013-09-22 Thread Christoph Läubrich
It will work in the case you are using H2 directly, but will break the H2 OSGi integration. If you are not using H2 special features, you really should take a look at the OSGi JDBC spec since this will allow you to work with JDBC in a complete driver indipendent way. Am 21.09.2013 00:53,

Re: [h2] Re: Re: Re: Insert if row does not already exist, cache PreparedStatement in a function

2013-09-22 Thread Thomas Mueller
Hi, How can we insert a new row unless one already exists, and in either case return the primary key of the inserted/matched row? Well, how could you insert the row if you don't know the primary key already when inserting? Regards, Thomas On Mon, Sep 16, 2013 at 4:38 AM, Gili

Re: [h2] packaging a database for deployment

2013-09-22 Thread Thomas Mueller
Hi, This is basically a duplicate of this question: http://stackoverflow.com/questions/18924873/h2-embedded-database-loses-tables-data-on-deploymen Regards, Thomas On Sat, Sep 21, 2013 at 8:34 PM, Josh theinkedge...@gmail.com wrote: Hi there, I need a step by step instructions on how to

[h2] Issues with H2 and generated queries from Hibernate

2013-09-22 Thread Markus Waltl
Hi, I am using H2 in combination with Hibernate in our project. Now we are selecting data from tables and Hibernate creates us the query. I have now two issue from which I solved one myself. First, H2 and temporary tables from Hibernate are not working very well. The issue is that Hibernate

Re: [h2] Re: Re: Re: Insert if row does not already exist, cache PreparedStatement in a function

2013-09-22 Thread Gili
Hi Thomas, Like this: create table employee (id identity not null, email varchar(100) not null); insert into employee (email) values ('f...@bar.com'); If the row does not exist, I'd retrieve the inserted primary key. If it does exist, I'd want to (but don't know how) retrieve the existing