You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "nilesh (JIRA)" <ib...@incubator.apache.org> on 2004/11/24 16:50:19 UTC
[jira] Created: (IBATIS-17) Generic SQL Map
Generic SQL Map
---------------
Key: IBATIS-17
URL: http://nagoya.apache.org/jira/browse/IBATIS-17
Project: iBatis for Java
Type: Bug
Components: SQL Maps
Reporter: nilesh
Priority: Minor
I created a generic SQL Map like below. I get a SQL stmt from somewhere and trying to use iBatis SQLMap just to execute the SQL. I'll provide the complete select stmt.
<select id="custom_sqlstmt" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
$custom_sql$
</select>
First call goes thro and comes back with proper results. But when I try to execute a different SQL using this same SQL Map, it gives me some mapping exceptions. Looking at the exception, all I can think of is that, sql map internally keeps the resultset metadata's structure somewhere in the cache and use the same information again for the subsequent sql calls. In above case, since I provide a different SQL stmt each time, resultset metadata would be different per call. And as a result, when sqlmap tries to map the result using old structure, it throws mapping exceptions.
Is there any work around to resolve this issue? Thanks in advance for your help!
- Nilesh -
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Closed: (IBATIS-17) Generic SQL Map
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ http://nagoya.apache.org/jira/browse/IBATIS-17?page=history ]
Clinton Begin closed IBATIS-17:
-------------------------------
Resolution: Won't Fix
> Generic SQL Map
> ---------------
>
> Key: IBATIS-17
> URL: http://nagoya.apache.org/jira/browse/IBATIS-17
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.8
> Reporter: nilesh
> Assignee: Clinton Begin
> Priority: Minor
> Fix For: 2.0.8
>
> I created a generic SQL Map like below. I get a SQL stmt from somewhere and trying to use iBatis SQLMap just to execute the SQL. I'll provide the complete select stmt.
> <select id="custom_sqlstmt" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
> $custom_sql$
> </select>
> First call goes thro and comes back with proper results. But when I try to execute a different SQL using this same SQL Map, it gives me some mapping exceptions. Looking at the exception, all I can think of is that, sql map internally keeps the resultset metadata's structure somewhere in the cache and use the same information again for the subsequent sql calls. In above case, since I provide a different SQL stmt each time, resultset metadata would be different per call. And as a result, when sqlmap tries to map the result using old structure, it throws mapping exceptions.
> Is there any work around to resolve this issue? Thanks in advance for your help!
> - Nilesh -
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Closed: (IBATIS-17) Generic SQL Map
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ http://nagoya.apache.org/jira/browse/IBATIS-17?page=history ]
Clinton Begin closed IBATIS-17:
-------------------------------
Assign To: Clinton Begin
Resolution: Fixed
Fix Version: 2.0.8
This was originally a feature of the beta releases. Unfortunately due to a number of serious performance and design considerations, it was removed.
Dynamic result maps and parameter maps are not supported.
This will be reconsidered for a future release as a feature request.
> Generic SQL Map
> ---------------
>
> Key: IBATIS-17
> URL: http://nagoya.apache.org/jira/browse/IBATIS-17
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.8
> Reporter: nilesh
> Assignee: Clinton Begin
> Priority: Minor
> Fix For: 2.0.8
>
> I created a generic SQL Map like below. I get a SQL stmt from somewhere and trying to use iBatis SQLMap just to execute the SQL. I'll provide the complete select stmt.
> <select id="custom_sqlstmt" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
> $custom_sql$
> </select>
> First call goes thro and comes back with proper results. But when I try to execute a different SQL using this same SQL Map, it gives me some mapping exceptions. Looking at the exception, all I can think of is that, sql map internally keeps the resultset metadata's structure somewhere in the cache and use the same information again for the subsequent sql calls. In above case, since I provide a different SQL stmt each time, resultset metadata would be different per call. And as a result, when sqlmap tries to map the result using old structure, it throws mapping exceptions.
> Is there any work around to resolve this issue? Thanks in advance for your help!
> - Nilesh -
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Reopened: (IBATIS-17) Generic SQL Map
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ http://nagoya.apache.org/jira/browse/IBATIS-17?page=history ]
Clinton Begin reopened IBATIS-17:
---------------------------------
> Generic SQL Map
> ---------------
>
> Key: IBATIS-17
> URL: http://nagoya.apache.org/jira/browse/IBATIS-17
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.8
> Reporter: nilesh
> Assignee: Clinton Begin
> Priority: Minor
> Fix For: 2.0.8
>
> I created a generic SQL Map like below. I get a SQL stmt from somewhere and trying to use iBatis SQLMap just to execute the SQL. I'll provide the complete select stmt.
> <select id="custom_sqlstmt" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
> $custom_sql$
> </select>
> First call goes thro and comes back with proper results. But when I try to execute a different SQL using this same SQL Map, it gives me some mapping exceptions. Looking at the exception, all I can think of is that, sql map internally keeps the resultset metadata's structure somewhere in the cache and use the same information again for the subsequent sql calls. In above case, since I provide a different SQL stmt each time, resultset metadata would be different per call. And as a result, when sqlmap tries to map the result using old structure, it throws mapping exceptions.
> Is there any work around to resolve this issue? Thanks in advance for your help!
> - Nilesh -
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Updated: (IBATIS-17) Generic SQL Map
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ http://nagoya.apache.org/jira/browse/IBATIS-17?page=history ]
Clinton Begin updated IBATIS-17:
--------------------------------
Version: 2.0.8
> Generic SQL Map
> ---------------
>
> Key: IBATIS-17
> URL: http://nagoya.apache.org/jira/browse/IBATIS-17
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.8
> Reporter: nilesh
> Priority: Minor
>
> I created a generic SQL Map like below. I get a SQL stmt from somewhere and trying to use iBatis SQLMap just to execute the SQL. I'll provide the complete select stmt.
> <select id="custom_sqlstmt" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
> $custom_sql$
> </select>
> First call goes thro and comes back with proper results. But when I try to execute a different SQL using this same SQL Map, it gives me some mapping exceptions. Looking at the exception, all I can think of is that, sql map internally keeps the resultset metadata's structure somewhere in the cache and use the same information again for the subsequent sql calls. In above case, since I provide a different SQL stmt each time, resultset metadata would be different per call. And as a result, when sqlmap tries to map the result using old structure, it throws mapping exceptions.
> Is there any work around to resolve this issue? Thanks in advance for your help!
> - Nilesh -
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira