Re: Performance & SQL Formatting Issue

2009-06-04 Thread Pascal Jacob
he "poolPreparedStatements" property. On a side track, I had horrible (slow) performance of batch insert, and I solve my problem by turning off the "defaultAutoComit" property. Pascal J. Pascal Jacob wrote: Please, could you publish your updated Spring.xml file. I '

Re: Performance & SQL Formatting Issue

2009-06-03 Thread Pascal Jacob
Please, could you publish your updated Spring.xml file. I 'm unable to find the place where to put that "poolPreparedStatements" property (It's more than probable that I'm missing one or more Spring bean declaration in my own context file ;) ). ZC. M Goodell wrote: Found the issue. Within t

Re: dynamic CREATE TABLE woe

2008-10-27 Thread Pascal Jacob
https://issues.apache.org/jira/browse/IBATIS-550 Poitras Christian wrote: Can you add it to JIRA and submit your patch? http://issues.apache.org/jira/browse/IBATIS This will greatly help to add it to main build. Christian -Original Message- From: Pascal Jacob [mailto:[EMAIL PROTECTED

Re: dynamic CREATE TABLE woe

2008-10-23 Thread Pascal Jacob
rn ret; } And in xml: CREATE TABLE data $list[].name$ $list[].type$ This should work. Christian -Original Message- From: Pascal Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2008 4:59 PM To: user-jav

How to iterate over two (or more) collections simultaneously ?

2008-10-22 Thread Pascal Jacob
Hi again, Is it possible to iterate over two (or more) collections SIMULTANEOUSLY using the same indice ? Here is a example: parameterMap="create-data-table-param"> CREATE TABLE data $names[]$ $

Re: dynamic CREATE TABLE woe

2008-10-22 Thread Pascal Jacob
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-12} Executing Statement: CREATE TABLE seqnsdb.seqnsdata ( {name=ID, t

dynamic CREATE TABLE woe

2008-10-21 Thread Pascal Jacob
Hi all, I encountered a 'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException' while executing the following SQL script: CREATE TABLE data $[].name$ $[].type$ The java code that prepare the list parameter and execute the SQL script is