Re: IBatis Array feild insertion problem in postgres database()Please help me)

2009-10-13 Thread jishnu123
Hai, Thank you for your replyI got exception details as follows.please reply immediately... org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in org/ada/kms/sqlma

Re: two parametr in Mapper method

2009-10-13 Thread Clinton Begin
Ah, no problem. If you do leave out the annotation, the variables will simply be named in order, like: #{1}, #{2}, etc. Clinton 2009/10/13 Tomáš Procházka > > No. I think that when I use XML, anotation is not necessary. This was my > fault. Thanks you. > > _

Re: two parametr in Mapper method

2009-10-13 Thread Tomáš Procházka
No. I think that when I use XML, anotation is not necessary. This was my fault. Thanks you. __ > Od: "Clinton Begin" > Komu: user-java@ibatis.apache.org > Datum: 13.10.2009 12:45 > Předmět: Re: two parametr in Mapper method > >In your

Re: [ibatis 3] insert return generated id?

2009-10-13 Thread Clinton Begin
This is the code for insert, update and delete (there's only one concept of "update"). PreparedStatement ps = (PreparedStatement) statement; ps.execute(); int rows = ps.getUpdateCount(); Object parameterObject = boundSql.getParameterObject(); KeyGenerator keyGenerator = mappedS

Re: [ibatis 3] insert return generated id?

2009-10-13 Thread Josh Joy
If the feature has been removed, could you please clarify what is the expected behavior if the return value for insert is not void? On Tue, Oct 13, 2009 at 10:46 AM, Clinton Begin wrote: > Yes, removed.  It was made clear long ago, that iBATIS 3 would be a > completely new implementation.  Some f

Re: [ibatis 3] insert return generated id?

2009-10-13 Thread Clinton Begin
Yes, removed. It was made clear long ago, that iBATIS 3 would be a completely new implementation. Some features are not carried forward, others are changed and there's a lot of new ones. iBATIS is 7 years old. It was time to make some changes. Cheers, Clinton On Tue, Oct 13, 2009 at 9:32 AM, R

RE: [ibatis 3] insert return generated id?

2009-10-13 Thread Rick . Wellman
I have not looked at the source you're referring to but did you "deprecate" the behavior or "remove" the behavior. I am not sure if you have a standing policy on things like this but here is my opinion: I understand the need to "clean things up" in a major release but I tend to favor "formal depr

Re: [ibatis 3] insert return generated id?

2009-10-13 Thread Clinton Begin
I deprecated that behaviour, because the API was inconsistent. And then the question would arise, how do I get the row count for the number of rows inserted? (it's possible). So now the only way is to set the id on the objects themselves. If you have a weird case where the ID is not on the parame

[ibatis 3] insert return generated id?

2009-10-13 Thread Josh Joy
Hi, I'm using MS Sql Server 2005, previously with iBatis v2.x, I was able to get the generated id from an insert as the return value for a method. With iBatis v3, the return value is always "1", which I'm assuming means 1 row was inserted. How can I configure the api to return the generated id f

Re: two parametr in Mapper method

2009-10-13 Thread Clinton Begin
In your second XML example, are you still using the same method signature? Like this: List getAllItems(@Param("offset") int offset, @Param("limit") int limit); http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd";> select * from send LIMIT #{offset}, #{limit} Cl