refid

Hi Folks, is it possible to include sqlparts dynamically: Or Thx for any hint! Mit freundlichem Gruss NSD Communication Consulting GmbH Dipl.-Kfm. Timo Schnölzer (Geschäftsführer) _ NSD Communication Consulting GmbH Ludwig-Er

[VOTE] Release iBATIS 2.3

Hi all, I'd like to release iBATIS 2.3 sometime this week. The changes listed for the release are as follows: o DEPRECATED All PaginatedList related features due to misuse, minimal applicability and inflexibility o DEPRECATED DAO Framework -- Removed from primary distribution, available as a se

refid

Hi Folks, please have a look for the sql part include in the sqlMaps: 1. the information have to be defined before (on top) of the include tag within an 2. it is not possible to use "dynamic" includes like or This is very important for y application as including a lot of

Re: [VOTE] Release iBATIS 2.3

+1 on GA 2.2 +1 on 2.3 - since we have made changes to the jar organization it would be good to get it out there. From that point we can begin to work our bug fixes. 2.3.x... On 11/20/06, Clinton Begin <[EMAIL PROTECTED]> wrote: We can vote for GA anytime, even after another release makes it to

Re: [VOTE] Release iBATIS 2.3

Agreed! Brandon Goodin wrote: +1 on GA 2.2 +1 on 2.3 - since we have made changes to the jar organization it would be good to get it out there. From that point we can begin to work our bug fixes. 2.3.x... On 11/20/06, Clinton Begin <[EMAIL PROTECTED]> wrote: We can vote for GA anytime, even

Re: how to use function

Like you would use any other field. iBATIS doesn't care where the column data comes from, so using "count(*)" or "my_great_field" are the same to it. Larry On 11/20/06, puneet arya <[EMAIL PROTECTED]> wrote: Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW -

RE: read-write cache with external transaction manager

I'll reply to my own message for posterity: The EXTERNAL transaction manager is not JTA-aware, it just does nothing (assuming a JTA-aware DataSource will handle commits/rollbacks) if you use the SqlMapClient transaction demarcation. However, the functionality hinted at by the documentation (au

Re: iBATIS docs/book by Sandeep Jain

I have taken a look at it, and I think: * It should notice to new users that ibatis DAO framework is going to be deprecated. * Maybe queryForPaginatedList (page 22) shouldn't be documented, as its use is considered (at least by me :) as a bad practice. Regards, Guido García Bernardo. PD. Anywa

Re: Passing ArrayList of Object for insert

If you database supports multiple inserts in a single jdbc call. But I don't know which databases support that. Is there a reason you can't iterate over your list and save each record via your dao? Brandon On 11/21/06, Premanand Kumarapillai <[EMAIL PROTECTED]> wrote: Hi, I have a ArrayLi

Re: [VOTE] Release iBATIS 2.3

Does this mean 2.2 will never be a GA release or that it already is? On 11/21/06, Clinton Begin <[EMAIL PROTECTED]> wrote: Hi all, I'd like to release iBATIS 2.3 sometime this week. The changes listed for the release are as follows: o DEPRECATED All PaginatedList related features due to misu

Re: stored function: NUMBER result, NUMBER IN parameter !

"Jeff Butler" <[EMAIL PROTECTED]> scritti il 20/11/2006 17:24:45 > NUMBER is not a valid JDBC Type (it is Oracle specific). See here > for the valid options: ohps :/ Right. [...] The corrected SQL map {#result,mode=OUT,javaType=java.lang.Integer,jdbcType=NUMERIC# = call tipo_d

Re: Passing ArrayList of Object for insert

Can someone give an example of doing this? Nathan Maves wrote: Even better would be to iterate as Brandon stated but use the batch functionality of ibatis. This will dramatically increase your performance. Nathan On 11/21/06, * Brandon Goodin* <[EMAIL PROTECTED] >

Re: refid

Did you try it? If you didn't, please do and let us know. :) If you did and it worked: yes. Larry On 11/20/06, Timo Schnölzer <[EMAIL PROTECTED]> wrote: Hi Folks, is it possible to include sqlparts dynamically: Or Thx for any hint! Mit freundlichem Gruss NSD Communication Consultin

executing several delete statements as one

hi, I am trying to execute these Oracle delete statements with no parameters as one pl/sql block: TabsDelete.xml: ... using this statement: ... int ret = sqlMapClient.update( "tabsDelete" ); but the statement fails showing error: [ERROR] com.ibatis.common.jdbc.exception.NestedSQLExc

Dynamic Mapped Statement Iterate Question

I want to pass a list of objects to a SQL map and get the following SQL Statement SELECT field1, field2, ... FROM table WHERE (field1 = 'value1' AND field2 = 'value2') OR (field1 = 'value3' AND field2 = 'value4') ... x n Is the folowing SQL Map correct? resultMap="batchedItemsResult">

help wanted: sql + java full time w/ ibatis

http://seeker.dice.com/jobsearch/servlet/JobSearch?op=101&engine=2&dockey=xml/7/4/[EMAIL PROTECTED]&source=19&FREE_TEXT=keibi .V

Re: Passing ArrayList of Object for insert

Even better would be to iterate as Brandon stated but use the batch functionality of ibatis. This will dramatically increase your performance. Nathan On 11/21/06, Brandon Goodin <[EMAIL PROTECTED]> wrote: If you database supports multiple inserts in a single jdbc call. But I don't know which

How to convert data type in java code with ibatis framework

I have a common table that stores data with id and value. The value field defined in DB is varchar2. Currently each time I store or retrieve data from db, I convert value from object to string in inserting, updating. Or convert value from string to objec in selectinig. I'd like to know how to achi

Re: process large result set

Look into the RowHandler interface, I think it is what you are looking for. Larry On 11/20/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote: Ji: I have a (hopefully) simple question with a (hopefully) simple answer. I am using iBatis DAO to get to iBatis maps. I need to issue a SELECT