Re: [h2] Just tried to run the coverage test on a Win7 system

2014-03-31 Thread Thomas Mueller
Hi, Sorry, that was my mistake, I added a feature and (partially) committed it without running all tests. I hope things will get more stable in the next days. Regards, Thomas On Tuesday, April 1, 2014, Roger Thomas wrote: > Any ideas/comments? > > On Friday, March 28, 2014 6:46:35 PM UTC, Ro

Re: [h2] CachedRowSet Support

2014-03-31 Thread Thomas Mueller
Hi, No, server side cursors are regular result sets. Server side cursors will be much easier to implement with the MVStore engine, so this will be done first. H2 does not implement row sets. But anyway, what issues did you see? If the issues are not fully related to H2, I guess it makes sense to

Re: [h2] Syntax error in SQL statement "WITH" keyword

2014-03-31 Thread Noel Grandin
On 2014-03-31 17:57, SARAVANAMANI S wrote: Hi Noel, Thank you for your response. We did modified the query to recursive like WITH x(n) as (select n from t1) select n from x then it started working fine but if we include one more select statement it fails again. Query: WITH x(n) as (select n

Re: [h2] Re: Just tried to run the coverage test on a Win7 system

2014-03-31 Thread Noel Grandin
Thomas is working on some stuff and there is a little fallout along the way. Should be fixed in a day or two. On 2014-04-01 02:58, Roger Thomas wrote: Any ideas/comments? On Friday, March 28, 2014 6:46:35 PM UTC, Roger Thomas wrote: Hi, I've just tried to build H2 and run it's coverage te

[h2] CachedRowSet Support

2014-03-31 Thread danap
Hello, In the Roadmap, Priority 1, is listed Server side cursors. Does the com.sun.rowset.CachedRowSetImpl, javax.sql.rowset.CachedRowSet classes fall into this category? I have been testing these classes with the MyJSQLView GUI client and the H2 database and have seen some issues. Dana M. Proct

[h2] CachedRowSet Support

2014-03-31 Thread danap
Hello, In the Roadmap, Priority 1, is listed Server side cursors. Does the com.sun.rowset.CachedRowSetImpl, javax.sql.rowset.CachedRowSet classes fall into this category? I have been testing these classes with the MyJSQLView GUI client and the H2 database and have seen some issues. Dana M. Proct

[h2] Re: Just tried to run the coverage test on a Win7 system

2014-03-31 Thread Roger Thomas
Any ideas/comments? On Friday, March 28, 2014 6:46:35 PM UTC, Roger Thomas wrote: > > Hi, I've just tried to build H2 and run it's coverage tests. The build > worked but when the coverage tests are run they mainly return > JdbcSQLException errors regarding the use of relative path for the > dat

[h2] Re: Syntax error in SQL statement "WITH" keyword

2014-03-31 Thread Anteneh Mamo
On Thursday, March 27, 2014 2:57:14 PM UTC-7, Anteneh Mamo wrote: > > Hi, > > jdbc:h2:mem:request_no;MODE=Oracle > > We are using the h2 version 1.3.171 with windows 7 (64 bit) and jdk > 1.7.0_25. > > when we try to run the sql statement : *WITH TMP1 AS (SELECT col1 FROM > table1) SELECT TMP1.c

Re: [h2] Syntax error in SQL statement "WITH" keyword

2014-03-31 Thread Anteneh Mamo
Hi Noel, Thank you for your response. We did modified the query to recursive like WITH x(n) as (select n from t1) select n from x then it started working fine but if we include one more select statement it fails again. Query: WITH x(n) as (select n from t1), y(m) as (select m from t2) select m

Re: [h2] Requesting minor change to get console to work with Vertica database.

2014-03-31 Thread Noel Grandin
No problem, change committed. On 2014-03-31 16:23, WillyMac wrote: The Vertica SQL engine is based on postgresql, so if the following change is made, the console comes up fine: -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

[h2] Requesting minor change to get console to work with Vertica database.

2014-03-31 Thread WillyMac
When connecting to a Vertica db through the H2 console, the nav panel on the left shows an error complaining about ORDINAL_POSITION. The Vertica SQL engine is based on postgresql, so if the following change is made, the console comes up fine: In org.h2.bnf.context.DbContents change line 139 to

Re: [h2] Fix Variable arguments on table function

2014-03-31 Thread Noel Grandin
No problem! I'm very happy to see the great work you guys are doing with H2! On 2014-03-31 16:10, Nicolas Fortin (OrbisGIS) wrote: Thank you for the merge. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and st

Re: [h2] Fix Variable arguments on table function

2014-03-31 Thread Nicolas Fortin (OrbisGIS)
Hi, Thank you for the merge. Regards, Nicolas Fortin RISING team CNRS - Ecole Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France http://www.ec-nantes.fr/ Le lundi 31 mars 2014 16:07:07 UTC+2, Noel Grandin a écrit : > > Just noting that this patch has been pushed. > > On

Re: [h2] Syntax error in SQL statement "WITH" keyword

2014-03-31 Thread Noel Grandin
On 2014-03-27 23:57, Anteneh Mamo wrote: when we try to run the sql statement : *WITH TMP1 AS (SELECT col1 FROM table1) SELECT TMP1.col1 FROM TMP1*. we are getting the below exception At the moment we only support recursive with statements i.e. WITH X(N) so you'll have to rewrite that us

Re: [h2] Fix Variable arguments on table function

2014-03-31 Thread Noel Grandin
Just noting that this patch has been pushed. On 2014-03-26 10:40, Nicolas Fortin (OrbisGIS) wrote: I wrote a patch in order to fix a bug with var arguments. Table function is called with the wrong number of arguments (the first and second call only) if it requires var arguments. -- You recei

Re: [h2] Important fix on ValueGeometry

2014-03-31 Thread Noel Grandin
On 2014-03-28 17:09, Nicolas Fortin (OrbisGIS) wrote: There is another patch also, you can wait that svn2github synchronise your commits before applying the following patch: https://github.com/nicolas-f/H2-Mirror/compare/fix;TableFunctionVarArgs Thank you, this patch has been committed.