Hi
We're using H2 version 1.2.145 with iBATIS in an app. I noticed that
1.2.147 had been released and added the {? = call} support, which I
need, so I upgraded the version.
Unfortunately that seems to cause an error with the first row of a
stored procedure result set not being returned properly (the stored
procedure is pretty simple - just one select statement, no
parameters). This is what the log output looks like when using H2
1.2.145:
04 Feb 2011 15:33:16,730 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
Cache 'Setting.SettingCache': cache miss
04 Feb 2011 15:33:16,730 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{conn-100009} Preparing Call: {call spEPCGetSettings()}
04 Feb 2011 15:33:16,730 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{pstm-100010} Executing Statement: {call spEPCGetSettings()}
04 Feb 2011 15:33:16,730 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{pstm-100010} Parameters: []
04 Feb 2011 15:33:16,730 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{pstm-100010} Types: []
04 Feb 2011 15:33:17,215 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} ResultSet
04 Feb 2011 15:33:17,230 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} Header: [Id, SettingName, SettingValue]
04 Feb 2011 15:33:17,230 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} Result: [1, value, value]
04 Feb 2011 15:33:17,230 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} Result: [2, value, value]
So far so good. When I upgrade to 1.2.147, without changing anything
else, this is the log output:
04 Feb 2011 15:29:09,369 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
Cache 'Setting.SettingCache': cache miss
04 Feb 2011 15:29:09,369 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{conn-100009} Preparing Call: {call spEPCGetSettings()}
04 Feb 2011 15:29:09,369 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{pstm-100010} Executing Statement: {call spEPCGetSettings()}
04 Feb 2011 15:29:09,369 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{pstm-100010} Parameters: []
04 Feb 2011 15:29:09,369 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{pstm-100010} Types: []
04 Feb 2011 15:29:09,416 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} ResultSet
04 Feb 2011 15:29:09,416 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} Header: [Id, SettingName, SettingValue]
04 Feb 2011 15:29:09,416 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} Result: [2, value, value]
04 Feb 2011 15:29:09,416 - DEBUG - JakartaCommonsLoggingImpl.java:27 -
{rset-100011} Result: [3, value, value]
As you can see, in the second example the first result return has ID
2. The row with ID 1 simply isn't being returned (it's not a question
of a different order or anything like that).
I've run up the web front-end and the table definitely has the data,
also if I execute that procedure from the front-end it seems to work
OK, i.e. all results are returned!
If anyone has any bright ideas about this I'm open to suggestions. I'm
pretty stumped at this.
Thanks,
Phill
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
