Inserts are working fine. But updates are not.
On Friday, 3 August 2012 09:11:24 UTC-7, Steve McLeod wrote:
>
> Vineela,
>
> When you say "doesn't work", what exactly do you mean? What do you expect
> and what actually happens?
>
> Can you post a complete example that reproduces the problem?
>
> On Thursday, 2 August 2012 20:29:12 UTC+2, Vineela Gampa wrote:
>>
>> "CREATE TABLE IF NOT EXISTS states ("
>> + "time TIMESTAMP,"
>> + "state INT,"
>> + "test VARCHAR,"
>> + "test12 VARCHAR,"
>> + "CONSTRAINT latest_pk PRIMARY KEY
>> (test,test12),"
>> ");
>>
>> MERGE INTO states(time,state,test,test12)" +
>> " KEY(test,test12)
>> VALUES(?,?,?,?)"
>>
>> ,timestamp,2,"<test>abc</test>","<test12>abc12</test12>");
>>
>> This doesn't seem to work incase of an update. Inserts are happening
>> fine.
>> Is there something wrong with the statement?
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/beHRaU09Tf0J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
