This is query; ------------------ query ------------------ ------------------ query ------------------
SET @StartDateTime = $StartDateTime; SET @RecordCount = (SELECT COUNT(*) FROM WindowTitle WHERE SyncID IS NULL); INSERT INTO SyncLog ( EntityType ,StartDateTime ,RecordCount ) SELECT 'WT' ,@StartDateTime ,@RecordCount WHERE @RecordCount > 0; SET @MaxID = (SELECT ID FROM SyncLog WHERE EntityType = 'WT' AND EndDateTime IS NULL LIMIT 1); UPDATE WindowTitle AS it SET SyncID = @MaxID WHERE it.GUID IN ( SELECT GUID FROM WindowTitle WHERE SyncID IS NULL ORDER BY DateCreated ASC LIMIT 100 ) AND @RecordCount > 0; SELECT IFNULL(@MaxID, -1) AS MaxID; ------------------ query ------------------ ------------------ query ------------------ I want to get result set on JAVA side. But, when I am trying that, it's giving no result (as null) But, if I tries as just a SELECT query like; "SELECT * FROM WindowTitle" it's happening. How can I get any result after the updates or Insert queries. -- some updates -- some Inserts -- just a select query (end of the script) Please help me :)) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
