-
1. Re: SQL Server NOCOUNT alternative for teiid?
shawkins Mar 30, 2016 3:02 PM (in response to gadeyne.bram)Can you give an example of how you would use this with Teiid?
-
2. Re: SQL Server NOCOUNT alternative for teiid?
gadeyne.bram Apr 1, 2016 11:10 AM (in response to shawkins)Yes,
We're using jasperserver from Jaspersoft to generate some reports. These use a jdbc connection to the Teiid server.
We'd like to create some temporary tables before executing the final select statement. However jasperserver can't handle this since it expects only one resultset.
-
3. Re: SQL Server NOCOUNT alternative for teiid?
shawkins Apr 1, 2016 12:17 PM (in response to gadeyne.bram)I'm still not quite sure how this fits in as the usage here implies it's for use within a stored procedure. Are you talking about issuing statements directly from the client or from within a stored procedure? Note that a stored procedure can only ever return a single result set - and will only return an update count if it's a procedure that defines an instead of trigger.
-
4. Re: SQL Server NOCOUNT alternative for teiid?
gadeyne.bram Apr 19, 2016 8:36 AM (in response to shawkins)Hi Steven,
I'm talking about issuing statements from a client not within a stored procedure.
-
5. Re: SQL Server NOCOUNT alternative for teiid?
shawkins Apr 19, 2016 10:29 AM (in response to gadeyne.bram)So if I understand you correctly Jasper server is issuing a CREATE LOCAL TEMPORARY TABLE ... statement and getting back an update count and then failing?
Can the whole sequence of operations be done as an anonymous procedure issued as a single statement?
"begin
create ...
...
select ...
end"
-
6. Re: SQL Server NOCOUNT alternative for teiid?
gadeyne.bram Apr 26, 2016 2:32 AM (in response to shawkins)This works! Thank you Steven!
-
7. Re: SQL Server NOCOUNT alternative for teiid?
gadeyne.bram Jun 8, 2016 7:24 AM (in response to shawkins)Hi,
Just a quick side note on this. Today we had an example of an anonymous procedure that did not want to work. We always got the exception that using multiple last resources is not allowed. I know that configuring the datasources as xa-datasources resolves this issue. And indeed the procedure did work with xa-datasources.