RE: Lazy load and serializable

2007-04-11 Thread MCCORMICK, Paul
Yes, create the JIRA please. -Original Message- From: Daigo Kobayashi [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 April 2007 10:41 PM To: user-java@ibatis.apache.org Subject: Re: Lazy load and serializable Hi, Thank you for replying. I know it is possible, if I modify iBatis' sourc

Re: Stored Procedure Call Returns Empty List But Does Create Beans

2007-04-11 Thread Paul Sanders
Thanks again for the replies - I have a working method - yea! In the end it seemed to take a little bit of everyone's suggestions for it to work. This is what I ended up with - my DAO method: public List fetchBanPolicies() { Map map = new HashMap();

RE: Stored Procedure Call Returns Empty List But Does Create Beans

2007-04-11 Thread Sudhir, Sudhir \(Contractor\)
Take a look at this post, you have couple of options to fetch the resultset. http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF +CURSOR+Solutions -Original Message- From: Paul Sanders [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 3:13 PM To: user-java@iba

Re: Stored Procedure Call Returns Empty List But Does Create Beans

2007-04-11 Thread Christopher . Mathrusse
You forgot to assign a resultMap to your element. Try the following:    resultMap="fetch-ban-policies-map"> Chris Mathrusse [EMAIL PROTECTED] Sybase, Inc One Sybase Drive Dublin, CA 94568 (925) 236-5553 Paul Sanders <[EMAIL PROTECTED]> 04/11/2007 01:13 PM Please respond to user-java@ib

Re: Stored Procedure Call Returns Empty List But Does Create Beans

2007-04-11 Thread Jeff Butler
The list is not returned from the queryForList method because the resultSet is an output parameter - not a resultSet from the procedure call. So you need to try something like this: Map parms = new HashMap(); getSqlMapClientTemplate().update("fetch-ban-policies", parms); return parms.get("o");

Stored Procedure Call Returns Empty List But Does Create Beans

2007-04-11 Thread Paul Sanders
[Hate to post again so quickly, I used to think I knew what I was doing in this space but it seems not hopefully someone can help me here and then I promise to go away.] I have a stored procedure that is just a wrapper around a "SELECT *" and I have straight JDBC code that uses it and works.

Re: Can You Map Column Indexes to Properties?

2007-04-11 Thread Paul Sanders
Jeff Butler-2 wrote: > > You can do it with a result map like this: > > > > > > > Jeff Butler > Ok, that looks perfect. Too bad I didn't see that in the docs I have, could have saved some bandwidth in the tubes. Thanks Jeff for taking the time to reply. -- View this message in cont

Re: Can You Map Column Indexes to Properties?

2007-04-11 Thread Larry Meadors
Dang it Jeff, you were too fast for me. :-P Larry On 4/11/07, Jeff Butler <[EMAIL PROTECTED]> wrote: You can do it with a result map like this: Jeff Butler On 4/11/07, Paul Sanders <[EMAIL PROTECTED]> wrote: > > I have stored procedures that return Oracle REFCURSORs that I want to

Re: Can You Map Column Indexes to Properties?

2007-04-11 Thread Larry Meadors
You can do that with a result map, yeah. Larry On 4/11/07, Paul Sanders <[EMAIL PROTECTED]> wrote: I have stored procedures that return Oracle REFCURSORs that I want to use from iBATIS in Java. I've seen instructions on how to do this but I need to be able to map column indexes to my bean pro

Re: Can You Map Column Indexes to Properties?

2007-04-11 Thread Jeff Butler
You can do it with a result map like this: Jeff Butler On 4/11/07, Paul Sanders <[EMAIL PROTECTED]> wrote: I have stored procedures that return Oracle REFCURSORs that I want to use from iBATIS in Java. I've seen instructions on how to do this but I need to be able to map column indexe

Can You Map Column Indexes to Properties?

2007-04-11 Thread Paul Sanders
I have stored procedures that return Oracle REFCURSORs that I want to use from iBATIS in Java. I've seen instructions on how to do this but I need to be able to map column indexes to my bean properties rather than column names. The reason for this is that our dba's, in their infinite wisdom, jus

Re: Lazy load and serializable

2007-04-11 Thread Daigo Kobayashi
Hi, Thank you for replying. I know it is possible, if I modify iBatis' source code. But if I modify iBatis' source code, I have to maintain it. So if possible, I want to avoid it. So should I create jira? MCCORMICK, Paul wrote: You'll need to modify the ibatis source code. If your not using

Re: Return as XML

2007-04-11 Thread Larry Meadors
Another way to do this (that will be less code, but an added dependency) is with a tool like xstream: http://xstream.codehaus.org/ If you search the archives, I know someone posted an example, and it was pretty darn slick. Larry On 4/11/07, André Rodrigues Pena <[EMAIL PROTECTED]> wrote: Mein

Abator-generated model object classes with toString

2007-04-11 Thread Mark Volkmann
As far as I can tell, there isn't a way to configure Abator to generate toString methods in Java model classes other than writing a custom generator. Is that correct? Has someone written a custom generator that adds toString methods that they can share?

Re: Return as XML

2007-04-11 Thread André Rodrigues Pena
Meindert, thanks for your reply. I'm gonna test your tips through the day, If I have questions I call you back. Cheers On 4/11/07, Meindert <[EMAIL PROTECTED]> wrote: Yes; And you probably want to have control on the rows returned so you might need to add a rowhandler Call to query

iBATIS return null while processing concurrent accesses

2007-04-11 Thread Kyohyoh Choh
Hello all We are using Spring(1.1.5)+iBATIS(2.0) in our system, for sqlMapClient, we use org.springframework.orm.ibatis.support.SqlMapClientDaoSupport to access a DB2 database. When we have multiple users access the system concurrently, we have found sometimes iBATIS returned null though there

RE: iBATIS, Spring, and transactions...

2007-04-11 Thread Meindert
To answer myself, I get the context back using two listeners in web.xml contextConfigLocation /WEB-INF/spring.xml org.springframework.web.context.ContextLoaderListener com.listeners.SpringInit Thanks Christian. _ Fr

RE: Return as XML

2007-04-11 Thread Meindert
Yes; And you probably want to have control on the rows returned so you might need to add a rowhandler Call to query RowHandler rowHandler=new xmlRowHandler("mailQueue"); queryWithRowHandler("messageQueue", myParam, rowHandler); // go through the list Document doc = ((xmlRowHandler) row

RE: iBATIS, Spring, and transactions...

2007-04-11 Thread Meindert
Hi Tom, Thanks for your reply, but I don't understand how this will get the spring managed service class into my struts created presentation bean. I think that Cristian's answer might be easier? Kind Regards Meindert _ From: Tom Duffey [mailto:[EMAIL PROTECTED] Sent: 10

RE: iBATIS, Spring, and transactions...

2007-04-11 Thread Meindert
Hi Christian, Thanks for your extensive answer, unfortunately I don't seem to be clever enough to understand it.. I've never worked with Listeners before and don't understand most of what is going on :-( Anyway, I added your sample code into a com.listeners package, and added a entry into