Re: 'Column Foo must be in the GROUP BY list' appear with version .144

2010-11-08 Thread Steffen Bach
On Nov 3, 7:49 am, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Try IN instead of =: WHERE metric_id IN ( SELECT me.id ...) Using IN still produces the error. The nested SELECT only returns 1 row anyway. Any other suggestions as to what is causing this? - Steffen -- You received this

3 QUESTIONS

2010-11-08 Thread RICCARD
I have been asked some questions from potential customers concerning the use of H2 together in connection with OOBase and I can`t find any answers in the documentation for H2 or in this forum. My knowledge in database technicalities is not so deep so I hope somebody can help me and I have to be

Re: H2 DB filename

2010-11-08 Thread abc6587
Could it present a security hazard, with a possibility to override any file on the file system under certain configurations? On Nov 7, 2010 9:46 PM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, There is a feature request for Database file name suffix: a way to use no or a different

Re: 'Column Foo must be in the GROUP BY list' appear with version .144

2010-11-08 Thread Stefan
Hi list, I'm getting the same error on version 145. I haven't tested 144. But for me it only shows up when I'm using MULTI_THREADED=1 In my case the error and query look like this: org.h2.jdbc.JdbcSQLException: Column RNG.RANGE must be in the GROUP BY list; SQL statement: INSERT INTO

Pass database connections used in PgServer

2010-11-08 Thread alexander.nesterov
Hi, We would like to use Postgre server in our application which is configured with Spring IoC (dependency injection pattern). We have DataSource bean representing H2 database and use it throughout the application as database connections factory. Seems that PgServer was not designed to be used

Re: Pass database connections used in PgServer

2010-11-08 Thread Harpal Grover
On Mon, Nov 8, 2010 at 11:52 AM, alexander.nesterov alexander.neste...@gmail.com wrote: Seems that PgServer was not designed to be used as a bean and there is Could it be possible to slightly redesign PgServer and PgServerThread to make it configurable with DataSource and use it as

Re: h2database to replace SQLite in Android

2010-11-08 Thread Thomas Mueller
Hi, I'm not sure if it makes sense to create a new project for Android support. I planned to support Android within the regular H2 project, possibly using different build targets. Your project uses a different license (GPL, while H2 uses EPL / MPL), is there a specific reason for this

Re: Compact databases without having to close the database (vacuum)

2010-11-08 Thread Thomas Mueller
Hi, You wrote that it's a performance problem. You also wrote that you need compact database at runtime. Are you *sure* that compacting the database at runtime would solve the performance problem? If yes, why do you think so? Maybe it's just a regular performance problem, something common, such

Re: Pass database connections used in PgServer

2010-11-08 Thread Sergi Vladykin
Hi, Why can't you use current implementation which just creates new connection each time? regards, S.Vladykin On 8 ноя, 19:52, alexander.nesterov alexander.neste...@gmail.com wrote: Hi, We would like to use Postgre server in our application which is configured with Spring IoC (dependency

Re: LOB creation

2010-11-08 Thread Thomas Mueller
Hi, As far as I see from the Hibernate sources, Hibernate uses the following methods: Clob.setCharacterStream(1), Clob.setString(1, s), Blob.setBytes(1, x), Blob.setBinaryStream(1), for Clob and Blob objects created using Connection.createClob() and createBlob(). I have implemented those

Re: Triggers and Functions in Groovy, or Javascript, or Java, or any BSF language...

2010-11-08 Thread Kerry Sainsbury
Hi Thomas, I'll go ahead and tidy it up a bit, and see if I can break it down into smaller patches, although that might be tricky. Mostly the change is about rearranging the code to make it language-pluggable -- Groovy support is wrapped up in a couple of independent files. Cheers Kerry I had

Re: Linux Bash Script for H2 Server

2010-11-08 Thread Thomas Mueller
Hi, Thanks a lot! I wonder if there is a way to simplify using the H2 tools from the command line. You have used: echo Starting H2 Web Server Admin Tool :: [CTRL-C] to terminate... java -cp $H2_HOME/h2.jar org.h2.tools.Server -web Currently the second line writes the following to system out:

Re: Pass database connections used in PgServer

2010-11-08 Thread alexander.nesterov
On Nov 8, 9:15 pm, Harpal Grover harpal.gro...@gmail.com wrote: On Mon, Nov 8, 2010 at 11:52 AM, alexander.nesterov Perhaps you could download the source and make the necessary changes and rebuild your sources? Sure we can, but we don't want to have a separate H2 branch and update it each

Re: Pass database connections used in PgServer

2010-11-08 Thread alexander.nesterov
On Nov 8, 9:44 pm, Sergi Vladykin sergi.vlady...@gmail.com wrote: Hi, Why can't you use current implementation which just creates new connection each time? The main reason is that those connections are configured basing on data received from a client (databaseName, user, password) while we

Re: Pass database connections used in PgServer

2010-11-08 Thread Sergi Vladykin
The main reason is that those connections are configured basing on data received from a client (databaseName, user, password) while we already have pre-configured connections pointing to a proper database used by application. May be you should configure your clients properly instead of

Re: Pass database connections used in PgServer

2010-11-08 Thread alexander.nesterov
On Nov 8, 11:36 pm, Sergi Vladykin sergi.vlady...@gmail.com wrote: The main reason is that those connections are configured basing on data received from a client (databaseName, user, password) while we already have pre-configured connections pointing to a proper database used by

H2 Database Engine: New version 1.3.146 Beta available

2010-11-08 Thread Thomas Mueller
Hello, A new version of H2 is available at http://www.h2database.com (you may have to click 'Refresh'). This is a beta version. The next version will be 1.2.147, possibly followed by 1.3.148 and 1.2.149 (alternating). To see the differences between 1.2.x and 1.3.x, see the change log. For