Hi, Sorry I don't know what you want to do. What you marked as "query" is not just one query, but a list of statements. And I don't know how this is related to the update count.
Maybe you want to use a user defined function? If yes see the documentation there. Regards, Thomas On Thu, Oct 9, 2014 at 8:35 AM, Omer Seyithan <[email protected]> wrote: > 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. > -- 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.
