Namespace aware resultMaps

2005-06-08 Thread Ersin Er
Hi, Why some resultMaps should be namespace aware like ? Thanks. -- Ersin

Re: Connection leak

2005-06-08 Thread Clinton Begin
>>  What happened to returning connection to the pool? You can't compare the logging output between DataSource implementations.  They will be completely different.  So to answer your question:  The return of the connection to the pool wasn't logged by DBCPwhich doesn't mean it wasn't retu

Re: bug with running sybase stored procedures

2005-06-08 Thread
Sven, I don't think so. sorry, I don't know what a TypeHandler is. I am calling the sql map to map it to the object. just as a proof of concept. our team is shifting to oracle. so this won't hold us up. Could the fix just be a hack like adding a method called ifSybaseDriverThenWor

Re: groupBy

2005-06-08 Thread Brandon Goodin
file a JIRA issue on that and we'll update the docs. Thanks for your insight on this. Brandon On 6/8/05, Ersin Er <[EMAIL PROTECTED]> wrote: > The main problem with the developer guide for Complex List Properties > section was > > 1) The example uses groupBy attribute value as the table column

Re: groupBy

2005-06-08 Thread Ersin Er
The main problem with the developer guide for Complex List Properties section was 1) The example uses groupBy attribute value as the table column name which is same as class property. I thought its value comes from table column. It the table column's and class property's names were different

Re: groupBy

2005-06-08 Thread Brandon Goodin
sorry, for my engrish. I should have read that a second time. Try #2 You can solve the "circular" with the groupBy. Depending on the direction of your query. If you query from the category then you want to populate the list of products. If you query from the Product you want to populate the Categ

Re: groupBy

2005-06-08 Thread Brandon Goodin
you could solve it this way depending on the direction of your query. If you query from the category then you want to populatte the list. If you query from the Product you want to populate the Category and this can be accomplished with the groupBy. Brandon On 6/8/05, Ersin Er <[EMAIL PROTECTED]>

Re: groupBy

2005-06-08 Thread Ersin Er
Hi, Thanks for the detailed reply. Today, I have implemented a similar example and understood the concept. I've realized that groupBy attribute take the related key from the "class property", not db table column. When I've tried the table column as the value of the groupBy, it worked without

Re: groupBy

2005-06-08 Thread Ron Grabowski
You may find this thread helpful: http://tinyurl.com/co6tt http://www.mail-archive.com/ibatis-dev%40incubator.apache.org/msg01015.html --- Ersin Er <[EMAIL PROTECTED]> wrote: > Brandon Goodin wrote: > > >This will help you: > >http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+d

Re: groupBy

2005-06-08 Thread Brandon Goodin
The real issue that is addressed with the groupBy is the ability to use a single query for populating complex properties mapped in the resultMap with the tag. In the past you would be required to map to a statement with the select attribute of the result tag which meant multiple additional queries

Re: Circular dependency?

2005-06-08 Thread Brandon Goodin
It is always better to write to the list. This will allow for other's to provide info to you as well. I work during the day and am not able to always respond quickly. I'll forward this on to the list and see if others can provide you info. Otherwise, I'll try to get some time this evening. Brandon

Re: groupBy

2005-06-08 Thread Ersin Er
Brandon Goodin wrote: This will help you: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F Infact, the document is the same as the Developer's Guide. What a pity, it did not help me. Anyway, I'm trying and learning myself. Th

Proper way to map ref cursor in stored proc

2005-06-08 Thread Mike Fagan
Hi, I saw that IBATIS-53 was closed as fixed today so I am trying to upgrade my mappings to use version 2.1.0 of sql maps. Does anyone know what is the type to use for the ref cursor? I was using ORACLECURSOR as in the following mapping. mode="IN" /> javaType="lon

Re: iBatis and multiple databases

2005-06-08 Thread Brandon Goodin
Currently, i do not think this is documented. But, the idea is that the discriminator defines a column whose value will be examined and compared against the subMap tag's value attribute to see which subMap's resultMap should be included. You may also use the extend functionality on the resultMap t

Re: iBatis and multiple databases

2005-06-08 Thread Brandon Goodin
oops bad advice. Forget option (1). Mapped statements do not have extend... only resultMap. Sorry Brandon On 6/8/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: > There is not one way to support multiple databases with ibatis. There > are several options to manage multiple database support. > > Ex

Re: iBatis and multiple databases

2005-06-08 Thread Brandon Goodin
There is not one way to support multiple databases with ibatis. There are several options to manage multiple database support. Examples (1) Use the extends functionality to override particular statements that are specific to your database while leaving cross database sql statements alone. (2) sepa

iBatis and multiple databases

2005-06-08 Thread Emiliano Armellin
Hello, I've got this problem: my application (spring+ibatis) works good on a Sybase DB but now I have to make it work on Oracle DB. Oracle uses a different syntax for left/right join so I have to change sql-maps files. Well it's not so difficult but I'm asking: which is the best way to manage