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.

Reply via email to