Re: Can I see the actual SQL that ibatis running?

2006-11-06 Thread Koka Kiknadze
Look at logging section in dev guide. All you'll have to do is configure logging level in your log4j.properties.On 11/7/06, Carfield Yim < [EMAIL PROTECTED]> wrote:Can I see the SQL that ibatis generated and log it before press to database? --View this message in context: http://www.nabble.com/Can-

sqlservr(insert to varchar field fill in with blank)

2006-11-06 Thread weijie jin
i used ibatis for sqlserver, i found if the field type is varchar(255),then if content insert is 100 length,ibatis will fill in blank for other 155 length use mysql hasn't this problem. i am sorry ,my english is so poor. thanks for help!

Can I see the actual SQL that ibatis running?

2006-11-06 Thread Carfield Yim
Can I see the SQL that ibatis generated and log it before press to database? -- View this message in context: http://www.nabble.com/Can-I-see-the-actual-SQL-that-ibatis-running--tf2587040.html#a7213317 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-06 Thread navrsale
I also tried the other example on the same Wiki, the one that uses stored procedure and not stored function. I also used physical table this time to reproduce example exactly. There were no error this time but the List returned from stored procedure was empty!? Again, I checked stored procedure a

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-06 Thread navrsale
I tried this example but got following error. I am using 2.2 iBatis, Oracle 9i database and OC4J application server. Runtime Error: = Caused by: java.sql.SQLException: ORA-06550: line 1, column 13: PLS-00306: wrong number or types of arguments in call to 'GET_POST_VALIDATION_RE PORT' ORA

Re: Issues on converting Old Dao to Ibatis sql-map

2006-11-06 Thread Larry Meadors
Use a Map, and please read the developer's guide. http://ibatis.apache.org/javadownloads.html Larry On 11/6/06, Makunda Thapa <[EMAIL PROTECTED]> wrote: Hi, I all, I have been involved to convert old daos to sql mapper xml. One of the problem I having is.My old daos uses same field in more t

Issues on converting Old Dao to Ibatis sql-map

2006-11-06 Thread Makunda Thapa
Hi, I all, I have been involved to convert old daos to sql mapper xml. One of the problem I having is.My old daos uses same field in more than one params. I have to keep adding these fields in to my VO to pass in to the sql mappers. For example Object[] params

RE: discriminator and submap

2006-11-06 Thread Christopher . Mathrusse
This worked like a charm. Thanks for the suggestion. I hadn't really thought of doing this but it makes perfect sense and it's extremely easy. From: "Niels Beekman" <[EMAIL PROTECTED]> [mailto:"Niels Beekman" <[EMAIL PROTECTED]>] Sent: Saturday, November 04, 2006 3:35 AMTo: Subject: RE: d

RE: Migr WAS 5.0->6.0

2006-11-06 Thread Paul Carr
Thanks All,   I think there was a bug in WAS 6.0.2.3 that was causing the “Null ComponentMetaData” message. Upgraded to WAS 6.0.2.15 and it’s fine now.   Best Regards Paul.     From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: 06 November 2006 16:06 To: user-java@ibatis.

Re: Migr WAS 5.0->6.0

2006-11-06 Thread Jeff Butler
iBATIS works fine on WAS 6.0.  There is some information on this WIKI page about configuring iBATIS in different WAS scenarios:   http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information     Jeff Butler   On 11/6/06, Paul Carr <[EMAIL PROTECTED]> wrote: More Ne

RE: Migr WAS 5.0->6.0

2006-11-06 Thread Paul Carr
More News I tried changing to a stand-alone transaction manager (not using JTA) and it works fine

Re: Cached list from queryForList() ...

2006-11-06 Thread Larry Meadors
Yes: Make sure that the cache is not marked as read-only. Larry On 11/6/06, Eric Tan <[EMAIL PROTECTED]> wrote: Hi, I was testing Spring Acegi Security's AfterInvocationProviderManager which deals with domain object instance security (ACL). With ibatis caching enabled and queryForList(), I

Re: NumberFormatException: For input string: ""

2006-11-06 Thread Nereida
Thanks Jeff. On 11/6/06, Jeff Butler <[EMAIL PROTECTED]> wrote: Sort of - we didn't support nested tags before version 2.2.0. If you need to stick with an older version of iBATIS, then regenerate your objects with Abator - but specify generatorSet="Legacy" on your . Jeff Butler On 11/6/06,

Re: NumberFormatException: For input string: ""

2006-11-06 Thread Jeff Butler
Sort of - we didn't support nested tags before version 2.2.0.  If you need to stick with an older version of iBATIS, then regenerate your objects with Abator - but specify generatorSet="Legacy" on your .   Jeff Butler  On 11/6/06, Nereida <[EMAIL PROTECTED]> wrote: Thanks JeffIs it a bug of previ

Re: NumberFormatException: For input string: ""

2006-11-06 Thread Nereida
Thanks Jeff Is it a bug of previous versions? On 11/6/06, Jeff Butler <[EMAIL PROTECTED]> wrote: Upgrade to iBATIS version 2.2.0. Jeff Butler On 11/6/06, Nereida <[EMAIL PROTECTED]> wrote: > Hi all, > i'm trying to get iBatis work with Abator. > I'm able to selct, update and delete by pri

Re: NumberFormatException: For input string: ""

2006-11-06 Thread Jeff Butler
Upgrade to iBATIS version 2.2.0.   Jeff Butler     On 11/6/06, Nereida <[EMAIL PROTECTED]> wrote: Hi all,i'm trying to get iBatis work with Abator.I'm able to selct, update and delete by primary key but in get an error when i try to select by example:   TaskExample te = new TaskExample();  

RE: Migr WAS 5.0->6.0

2006-11-06 Thread Hariharan, Vadivelu \(IE10\)
I migrated one of the apps recently to WAS 6.0.2.5 I use Spring + iBatis. Datasource are created by Apache basic datasource I'm yet to check it with WAS connection will let you know. Thx -Hari -Original Message- From: Paul Carr [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006

RE: Migr WAS 5.0->6.0

2006-11-06 Thread Paul Carr
Hi Nathan, I was running fine on WAS 5.0 with JDK 1.3.1, so I doubt it's a JDK issue. When I started trying to move to WAS 6.0 I had some naming difficulties ... my sqlmapconfig had "java:comp" in the JNDI names and it didn't like itso I went from :- TO THIS :-

RE: Migr WAS 5.0->6.0

2006-11-06 Thread Nathan Ward
WAS 6.0 uses JDK 1.4 doesn't it? Does iBATIS require JDK 1.5? I doubt it, but thought I'd mention it. I attended a NFJS conference that past weekend where Ted Neward said that WAS has a very complicated classloader structure. I had a problem recently with static variables in a class that worked f

RE: Migr WAS 5.0->6.0

2006-11-06 Thread Paul Carr
News... Since creating this problem I've deployed an older app ( which doesn't use iBatis) to the same env and it works perfectly well with my DataSource. Therefore the problem must lie in the iBatis config somewhere Has anyone else experienced difficulties migrating to WAS 6 ( 6.0.2.3 to be

Cached list from queryForList() ...

2006-11-06 Thread Eric Tan
Hi,I was testing Spring Acegi Security's AfterInvocationProviderManager which deals with domain object instance security (ACL). With ibatis caching enabled and queryForList(), I realised that returned result list was the actual cached list. With AfterInvocationProviderManager performing object filt

Migr WAS 5.0->6.0

2006-11-06 Thread Paul Carr
Hi All, I'm having trouble moving from a working WAS 5.0 env to WAS 6.0. First I had to change my sqlmapconfig so that it used "jdbc/db2Connection" rather than "java:comp/jdbc/db2Connection" which got me past my first problem, but now I keep getting NULL Component MetaData whenever

NumberFormatException: For input string: ""

2006-11-06 Thread Nereida
Hi all, i'm trying to get iBatis work with Abator. I'm able to selct, update and delete by primary key but in get an error when i try to select by example: TaskExample te = new TaskExample(); te.createCriteria().andStatoGreaterThan(new Integer(0)); List al = new ArrayList()