Re : blocked with issue 311

Hello, I didn't get any feedback to my code proposition. Did I do something wrong ? Maybe my request isn't clear enough ? If it is the case, please tell me. I would really be grateful if the patch could be committed or if I could get any explanation telling me why it can't be (or just get an ans

Re: DEFAULT CURRENT_TIMESTAMP doesn't work

Hi I wanted to update the LASTMODIFIED column when ever any row is updated. Your solution is perfect. I am using hibernate and it sends null value which writes null value in the LASTMODIFIED column. Thanks for your help. Lule On Aug 20, 11:30 am, Thomas Mueller wrote: > Hi, > > > When inse

Re: Invalid SQL result

Thank you Thomas On Aug 20, 9:48 pm, Thomas Mueller wrote: > Hi, > > The SQL statement > > > SELECT COUNT(NAME) as C FROM TEST HAVING COUNT(NAME) = 1; > > is valid, and all databases I tested with returned 0 rows. The problem > is that there is no GROUP BY, so the group is actually the complete

Re: Invalid SQL result

Hi, The SQL statement > SELECT COUNT(NAME) as C FROM TEST HAVING COUNT(NAME) = 1; is valid, and all databases I tested with returned 0 rows. The problem is that there is no GROUP BY, so the group is actually the complete table ('test'), which has more than one name. > ORDER BY CAT1.CAT2; This

Re: Invalid SQL result

With respect, I did my bit by reporting and giving example. On Aug 20, 8:53 pm, Noel Grandin wrote: > On Sat, Aug 20, 2011 at 13:21, Nitin wrote: > > I do not have time really to setup and test this in another DBs > > Then why should we take the time to identify the problem? It's not > like we'r

Re: Invalid SQL result

On Sat, Aug 20, 2011 at 13:21, Nitin wrote: > I do not have time really to setup and test this in another DBs > Then why should we take the time to identify the problem? It's not like we're being paid for this. -- You received this message because you are subscribed to the Google Groups "H2 Da

Re: Invalid SQL result

Example: DROP TABLE IF EXISTS TEST; Update count: 0 (0 ms) CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255), CAT1 VARCHAR(255), CAT2 VARCHAR(255)); Update count: 0 (0 ms) INSERT INTO TEST VALUES(1, 'Hello','A','B'); Update count: 1 (15 ms) INSERT INTO TEST VALUES(2, 'World','B','A'); Upd

Re: Invalid SQL result

Hi, Please provide complete examples, and try with other databases as well. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send

Invalid SQL result

Hi Thomas, This query SELECT count(name) as c FROM mytable having count(name) = 1 should return names exactly once from the table but it returns 0 where I know there are many names that are not duplicate. Also, SELECT count(*) as c,cat1,cat2,cat3 FROM mytable where cat1 is not null group by ca

Re: DEFAULT CURRENT_TIMESTAMP doesn't work

Hi, > When inserting a row How do you insert the row? Do you use: insert into resourcelisttype values(default, default); or insert into resourcelisttype(id) values(default); Both works for H2 according to my test. (Meaning, the timestamp is set.) Do you want to update the timestamp every time

Re: Looking for info on abilities and usage of Array datatype in H2

Hi, > I haven't been very successful in finding info about what can be done with > Arrays in H2 and how to use them, and would appreciate references to any > documentation/examples. Well, what do you _want_ to do, that is, what problem do you have and want to solve? The documentation is at http:

Re: CSV import and bad data...

Hi, In H2 version 1.2.x, the '#' is the default comment character. In version 1.3, it is a regular character. What version of H2 do you use currently? I suggest to use version 1.3.x. If you can't, see Csv.setLineCommentCharacter. Regards, Thomas -- You received this message because you are sub

Re: H2 , Wicket, Hibernate

Hi, See the documentation of DbStarter. The default user name and password for the DbStarter is "sa" and "sa". I guess you didn't set a user name and password when creating the database, so you have to configure that in the context-param in the web.xml. Regards, Thomas -- You received this mess

Re: Problems to integrate H2 into a Wicket project (beginner question)

Hi, > When i run my App. i get this error : > org.h2.jdbc.JdbcSQLException: Falscher Benutzer Name oder Passwort > Wrong user name or password [28000-158] > > What do i do wrong ? See the documentation of DbStarter. The default user name and password for the DbStarter is "sa" and "sa". I guess yo