ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pascal Jacob <za...@wanadoo.fr>
Subject Re: dynamic CREATE TABLE woe
Date Thu, 23 Oct 2008 19:41:43 GMT
I finally achieve success with my original SQLScript by patching ibatis 
instead of having to do convoluted things in my source code that I could 
not stand before a QA session.
in file: 
ibatis-2.3.4.726\src\ibatis-src\com\ibatis\common\beans\ProbeFactory.java
in method: getProbe(), line: 33
replaced: return GENERIC;
by: return BEAN;

Hope this will make its way into the main build.

regards.


Poitras Christian wrote:
> This is a bug in how iBATIS handles maps inside a list parameter.
> Curiously, using #[].name# and #[].type# gave the expected result, but not $[].name$
and $[].type$...
>
> You can use a simple patch by putting your list of maps inside a map:
>     private Map<String, List<Map<String, String>>> prepareCreateTableParams(
>             final String[] columnNames, final String[] columnTypes) {
>         Map<String, List<Map<String, String>>> ret = new HashMap<String,
List<Map<String, String>>>();
>         List<Map<String, String>> params =
>             new ArrayList<Map<String, String>>();
>         for(int i = 0; i < columnNames.length; i++) {
>             HashMap<String, String> map = new HashMap<String, String>();
>             map.put("name", columnNames[i]);
>             map.put("type", columnTypes[i]);
>             params.add(map);
>         }
>         ret.put("list", params);
>         return ret;
>     }
>
> And in xml:
>     <statement id="create-table" parameterClass="map">
>         CREATE TABLE data
>             <iterate open="(" close=")" conjunction="," property="list">
>                 $list[].name$ $list[].type$
>             </iterate>
>     </statement>
>
>
> This should work.
>
> Christian
>
>
> -----Original Message-----
> From: Pascal Jacob [mailto:zartc@wanadoo.fr]
> Sent: Wednesday, October 22, 2008 4:59 PM
> To: user-java@ibatis.apache.org
> Subject: Re: dynamic CREATE TABLE woe
>
> Investigating more, I found the following evidences in the PreparedStatement sent by
iBatis (I finally found the way to make iBatis log under SLF4J):
>
> 22:29:39.296 [DEBUG] [main] [java.sql.PreparedStatement:26] - {pstm-100002} Executing
Statement:
> CREATE TABLE seqnsdb.seqnsdata ( {name=ID, type=INTEGER} {name=ID, type=INTEGER}, {name=ARISING_SEQ_ID,
type=INTEGER} {name=ARISING_SEQ_ID, type=INTEGER}, {name=AC_SERIAL_NO, type=VARCHAR(255)}
{name=AC_SERIAL_NO, type=VARCHAR(255)} ... )
>
> It is evident that iBatis is not transforming the SQLScript as expected !
> It seems like the whole Map.Entry is printed each time instead of only the name value
first then only the type value.
> AAMOF I did replace $[].name$ and $[].type$ by simply  $[]$ in the script and get the
exact same result, which confirms that $[].name$ don't do anything more than $[]$ which is
obviously not what is expected (or there is something i didn't understood)
>
> Hope this helps someone helping me ;)
>
> Tanks in advance.
>
> ---------------------------------------------------------------------------------------
> Orange vous informe que cet  e-mail a ete controle par l'anti-virus mail. 
> Aucun virus connu a ce jour par nos services n'a ete detecte.
>
>
>
>   


Mime
View raw message