discriminator and submap

2005-05-17 Thread Gregg D Bolinger
Do these new features in the new 2.1 release help improve my mapping file as shown below?  If so, can someone tell me how?  where I have specified the select=".." in the resultMap "issue-result", I am using the namespace and a select id to query for that object.  I am looking for a quicker/better/m

Re: Very Confused.

2005-05-17 Thread Brice Ruth
Hi Dave, If you're new to Java, I wouldn't suggest trying to setup jPetstore ... that can be kinda tricky even for folks who've been around Java for a while. I would suggest setting up your SqlMap.xml and sql-map-config.xml files, as provided in the tutorial, and then creating a SqlConfig file th

Re: Very Confused.

2005-05-17 Thread Matt Raible
I've created a couple of web applications designed to help you get started using frameworks like iBATIS quickly. http://equinox.dev.java.net http://appfuse.dev.java.net Let me know if you'd like me to build one with a particular web framework (Struts, JSF, Spring, WebWork or Tapestry) and I'll

Re: Very Confused.

2005-05-17 Thread Brandon Goodin
It is difficult to give you advice on this sort of proble. Check your logs and make sure you aren't getting an exception. Also, please post your environment and give more detail on your setup. What Servlet container are you running, what version of ibatis jpetstore, what version of jdk etc... Than

Re: Question on dynamic prepend and using multiple properties

2005-05-17 Thread Brandon Goodin
Don't forget the new functionality available in 2.1.0 count > #countA# count < #countB# Brandon On 5/17/05, Ron Grabowski <[EMAIL PROTECTED]> wrote: > Have you tried this: > > > ( > > count > #countA# > > > count < #countB# > > ) > > > --- Narasimha Prasad <[EMAIL PROTECT

Re: iBatis DAO - How to turn off data connection pool

2005-05-17 Thread Brandon Goodin
There really is no simple answer to what you need. I believe we have discussed your dilemna in the past haven't we? The answer is the same... Bite the bullet and swap out your connection manager with a common connection manager so that both implementations use the same connection manager. This path

Re: Another custom type handler issue

2005-05-17 Thread Ken Katsma
I would like to see an example of how the list approach might work (when using a nested resultset). In the case of the array, I found the solution. You just have to define the array in the custom type handler using the format [Lpackage.ClassName; and it will fire the custom type handler. I t

Very Confused.

2005-05-17 Thread Dave Guzda
Hello,   I'm trying to get *anything* to work with the iBatis setup and I'm having very little success...   I've tried to follow the tutorial and setup the PetStore example but nothing runs for me. I'm sure it is some sort of configuration issue...   I'm very new to Java ... so I'm sure tha

Article on running iBATIS JPetStore using a Derby database on WebSphere

2005-05-17 Thread Stanley Bradbury
Hi - Some of the readers of this list might be interested in an article just posted about running JPetStore using a Derby database on a WebSphere server. The link to the article is: http://incubator.apache.org/derby/integrate/JPetStoreDerby.html I welcome any feedback.

Re: iBATIS for Java 2.1.0 Released

2005-05-17 Thread Graham Cruickshanks
The update for IBATIS to use .execute instead of .executeQuery sadly does not resolve the Oracle Cursor issue (IBATIS-53) Bellow is an example of the issue with SqlExecutor problem in straight JDBC. This shows how the SqlExecutor.java will not work without being adjusted to loop over the out par

Re: Another custom type handler issue

2005-05-17 Thread Brice Ruth
Do you have to use arrays? How about lists instead? iBATIS (to my knowledge) doesn't support returning arrays. My guess is if you were to have List addresses and List communications (type specification not necessary, just highlighting what its doing) - then iBATIS would "do the right thing". Brice

Re: Question on dynamic prepend and using multiple properties

2005-05-17 Thread Ron Grabowski
Have you tried this: ( count > #countA# count < #countB# ) --- Narasimha Prasad <[EMAIL PROTECTED]> wrote: > Here is a problem that I am facing. > > > > My parameter class has two counts, say countA and countB and I need > to use > these in a ‘HAVING’ clause in the

RE: iBatis DAO - How to turn off data connection pool

2005-05-17 Thread Folashade Adeyosoye
Thanks for your response, I have actually been battling this for a while, this is my situation.   I currently have a system that works, but with embedded SQL in my classes, and the classes and implementation are well separated using interfaces and implementation classes.

Another custom type handler question

2005-05-17 Thread Ken Katsma
I posted this last night but I'm posting it again because I didn't see my mail come through on the mailing list.  Do I have a gmail problem?  Or are users not cc'd on their own posts? Now that I have the custom type handler executing correctly for the nested cursor, I have another question :) I

Re: Custom Type Handler question

2005-05-17 Thread Ken Katsma
Actually, I found my problem.  It was me.  A couple lines above I already made a call to getObject().  Which, of course counts as a fetch.  When I made my second call to getObject it failed.  No problem there for iBatis. But this brings me to another issue which I'll post a new message onOn 5

Question on dynamic prepend and using multiple properties

2005-05-17 Thread Narasimha Prasad
Here is a problem that I am facing.   My parameter class has two counts, say countA and countB and I need to use these in a ‘HAVING’ clause in the sql query.  Both the values could be empty. For eg. if they both have values, the query would look like:   Select …. --- from… where…. H

Re: iBATIS for Java 2.1.0 Released

2005-05-17 Thread Ken Katsma
Graham, Oracle doesn't support the getResultSet call in it's JDBC drivers.  Though it does appear to be a step in the right direction :) Ken On 5/16/05, Graham Cruickshanks <[EMAIL PROTECTED]> wrote: Hi Clinton,Great news on the 2.1.0 release. I see in the change log "Changed SQLexecutor to alway

Another custom type handler issue

2005-05-17 Thread Ken Katsma
Now that I have the custom type handler executing correctly for the nested cursor, I have another question :) I'm trying to use the custom type handler to populate an array of objects in my class.  For instance, I have a Client, which contains Address[] arrays and Communication[] arrays.  I'd like

Re: Custom Type Handler question

2005-05-17 Thread Sven Boden
Read it too quickly... so you have the problem before the parts I comment on. One further question: where do you set the "return type" as a cursor in your Ibatis version (the "cstmt.registerOutParameter(1,OracleTypes.CURSOR)" in the original version)? The problem with cursor types is that they ar