Re: dynamic sql within an iterate tag

2005-06-06 Thread Brandon Goodin
Sam, Sorry, I meant to respond to you in your prior email. Currently this is not supported. But, we do want it to work. So, please file a JIRA report. I'll work on it this evening and see if i can get the fix in tonight. Brandon On 6/6/05, Abeyratne, Sam <[EMAIL PROTECTED]> wrote: > > > > H

Re: groupBy

2005-06-06 Thread Brandon Goodin
This will help you: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > Hi, > > What is the porpose of "groupBy" attribute used in the SQL Mapper doc for > "Complex Collection Properties

dynamic sql within an iterate tag

2005-06-06 Thread Abeyratne, Sam
Hey All,   I had asked this question before, but I didn’t get an answer, so I am re-posting this question:   I am getting the following error when I try to run a simple query that has a dynamic within an iterate tag. Can you tell me if this is even possible to do in iBatis?   Thanks

groupBy

2005-06-06 Thread Ersin Er
Hi, What is the porpose of "groupBy" attribute used in the SQL Mapper doc for "Complex Collection Properties" subject? It says "The important items here are the groupBy="quarter" attribute.." but it doesn't say why. I've tried my own example for 1:M relations and I did not the effect of groupBy at

Re: Connection leak

2005-06-06 Thread Brandon Goodin
Please provide your full transaction manager configuration. Brandon On 6/6/05, vi am <[EMAIL PROTECTED]> wrote: > Is there a way to limit the maximum number of connections (at any given > time) Apache's DBCP pool? iBATIS does seem to support DBCP. Whenever I > access JSP pages, there is const

Re: Circular dependency?

2005-06-06 Thread Brandon Goodin
Currently a circular dependency would not be possible because of the way configurations are loaded. One sql map must be loaded before the other can. So, if you attempted a circular reference it would fail during intialization because the referenced mapped statement would not be found in the configu

Circular dependency?

2005-06-06 Thread Ersin Er
On page 27 of iBatis SQL Mapper Doc the following mapping xml file is given: select * from CATEGORY where CAT_ID = #value# select * from PRODUCT where PRD_CAT_ID = #value# For the corresponding object model, the Category class should have productList property, OK. What about Product

Re: Connection leak

2005-06-06 Thread vi am
Is there a way to limit the maximum number of connections (at any given time) Apache's DBCP pool? iBATIS does seem to support DBCP. Whenever I access JSP pages, there is constant increase of connections at Oracle backend. I was hoping the following config will limit the DBCP pool to a max

Re: [ANNOUNCEMENT] iBATIS graduates to top-level ASF project

2005-06-06 Thread Clinton Begin
    Sorry, used a tankard.  ;-)  On 6/6/05, netsql <[EMAIL PROTECTED]> wrote: .VTed Husted wrote:> Recently, the Apache Software Foundation Board of Directors approved > our application to become an official top-level ASF project. This is> great news, and, even better news is that the disruption t

Re: Unexplained exception in GeneralStatement.executeQueryForObject

2005-06-06 Thread Clinton Begin
  java.lang.NoClassDefFoundError is a secondary exception that occurs usually because a static initializer in a class throws an exception causing the loading of the class to fail.  The ClassLoader will usually not try twice in this case.   The other reason is that the class is not on the classpat

multiple resultsets question

2005-06-06 Thread
quick question on using oracle with multiple resultsets bound as output parameters: Will multiple these be able to be mapped to object properly? also is this done via the parameter map instead of resultmap? thanks DS --- On Mon 06/06, Wulf, Andrew < [EMAIL PROTECTED] > w

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
excellent! thanks Ersin. On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > > Finally, don't forget... you have the power to help. > > > > Brandon > > OK. I'll try to produce a sample section. > > -- > Ersin >

RE: Unexplained exception in GeneralStatement.executeQueryForObject

2005-06-06 Thread Wulf, Andrew
Title: RE: Unexplained exception in GeneralStatement.executeQueryForObject Hmm another tidbit: --- Cause: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] Was the actual exception, which is some hideous internal oracle exception.

Unexplained exception in GeneralStatement.executeQueryForObject

2005-06-06 Thread Wulf, Andrew
Title: Unexplained exception in GeneralStatement.executeQueryForObject In 2.1.0.565 I get this exception which makes little sense to me. Running on Weblogic 8.1 JDK 1.42. Basically it gets to line 100 and never returns. The database is Oracle 10g. The code worked fine on the prior version of

Re: [iBatis] Documentation

2005-06-06 Thread Clinton Begin
Ersin,   Feel free to use the wiki to fill in content for the undocumented features, or the examples.  Only if it's easier for you though.  Otherwise, you can download the Open Office documents from our subversion repository.   Cheers, Clinton  On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > Fina

RE: Is there a way to Debug SQL statements

2005-06-06 Thread Jason Hall
thanks this is what i was looking for. -Original Message- From: Ersin Er [mailto:[EMAIL PROTECTED] Sent: Monday, June 06, 2005 2:15 PM To: ibatis-user-java@incubator.apache.org Subject: RE: Is there a way to Debug SQL statements It's also listed as a FAQ at http://opensource.atlassian.c

Re: [iBatis] Documentation

2005-06-06 Thread Ersin Er
> Finally, don't forget... you have the power to help. > > Brandon OK. I'll try to produce a sample section. -- Ersin

RE: Is there a way to Debug SQL statements

2005-06-06 Thread Ersin Er
It's also listed as a FAQ at http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+SqlMapClient+to+log+SQL+statements%3F -- Ersin Er > Thanks:) > J.H. > > -Original Message- > From: Larry Meadors [mailto:[EMAIL PROTECTED] > Sent: Monday, June 06, 2005 1:44 PM > To: i

Re: Connection leak

2005-06-06 Thread Brandon Goodin
The connections are returned to the pool automatically. Your pool implementation determines how to manage the connections. So, you will see connections staying active because they continue to exist in the pool. iBatis merly checks them out and uses them. So, there is no connection leak in iBatis.

Re: [ANNOUNCEMENT] iBATIS graduates to top-level ASF project

2005-06-06 Thread netsql
.V Ted Husted wrote: Recently, the Apache Software Foundation Board of Directors approved our application to become an official top-level ASF project. This is great news, and, even better news is that the disruption to our resources will be minimal. Soon, we will be moving the website and ma

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
Let's not start a flame here. Please keep your criticisms constructive and away from the edge of insulting. The bottom line is that we should all appreciate constructive criticism. The documentation is excellent even compared to many commercial products on the market and it can ALWAYS be improved.

Connection leak

2005-06-06 Thread vi am
I am evaluating iBATIS. How can we close connections to avoid connection leak? Are the connections are automatically closed? couldn't find this anywhere in the documentation. The following SQL statement shows connections getting incremented for every JSP page access.

Re: [iBatis] Documentation

2005-06-06 Thread Ersin Er
> Whoaa: > > One of the great attributes of iBatis is its documentation. > > I have seen commercial products that do not measure to the well organized > and detailed documentation ofiBatis an Open Source based product. I appreciate the current condition of the documentation as being a

RE: [iBatis] Documentation

2005-06-06 Thread Wulf, Andrew
Title: Message The descriminator and submap don't seem to be documented anywhere unless I missed something. -Original Message-From: J.F. Zarama [mailto:[EMAIL PROTECTED] Sent: Monday, June 06, 2005 2:02 PMTo: ibatis-user-java@incubator.apache.orgSubject: Re: [iBatis] Document

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
Ersin, That is true. There are some undocumented features. If there is anything that you see that is not in the documentation, please feel free to submit a patch. We are thrilled to include any valuable contributions into the docs. I do apologize for some of the features that are not documented. B

Re: [iBatis] Documentation

2005-06-06 Thread J.F. Zarama
Whoaa: One of the great attributes of iBatis is its documentation. I have seen commercial products that do not measure to the well organized and detailed documentation ofiBatis an Open Source based product. For the authors and for us users of iBatis, it will be beneficial for you to

Re: [iBatis] Documentation

2005-06-06 Thread Ersin Er
> is there a reason for a major update to the ibatis sql mapper > documentation? I think yes. It seems to be unorganized and there are undocumented features, to me.. -- Ersin > On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: >> Hi, >> >> Is there any plan for a major update for iBatis SQL Mapper

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
is there a reason for a major update to the ibatis sql mapper documentation? On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > Hi, > > Is there any plan for a major update for iBatis SQL Mapper documentation? > > Thanks. > > -- > Ersin Er >

[iBatis] Documentation

2005-06-06 Thread Ersin Er
Hi, Is there any plan for a major update for iBatis SQL Mapper documentation? Thanks. -- Ersin Er

RE: Is there a way to Debug SQL statements

2005-06-06 Thread Jason Hall
Thanks:) J.H. -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Monday, June 06, 2005 1:44 PM To: ibatis-user-java@incubator.apache.org Subject: Re: Is there a way to Debug SQL statements P6Spy (http://www.p6spy.com) is commonly used, too. Larry On 6/6/05, Carbonel

Re: Is there a way to Debug SQL statements

2005-06-06 Thread Larry Meadors
P6Spy (http://www.p6spy.com) is commonly used, too. Larry On 6/6/05, Carbonell Soler, Jorge <[EMAIL PROTECTED]> wrote: > > > > Just use log4j or any other logging framework. This way you'll get, for > example, the querys or the resultsets those querys return. > > > > -Mensaje origi

RE: Is there a way to Debug SQL statements

2005-06-06 Thread Carbonell Soler, Jorge
Title: Is there a way to Debug SQL statements Just use log4j or any other logging framework. This way you’ll get, for example, the querys or the resultsets those querys return.   -Mensaje original- De: Jason Hall [mailto:[EMAIL PROTECTED] Enviado el: lunes, 06 de junio de 2005

SVN is up

2005-06-06 Thread Gilles Bayon
  https://svn.apache.org/repos/asf/ibatis/

Is there a way to Debug SQL statements

2005-06-06 Thread Jason Hall
Title: Is there a way to Debug SQL statements Hi, I just wanted to know is there a way in Java to debug sql statments being passed to the database? J.H.

RE: MORE ON IBATIS.COM DOMAIN UPDATE...YEP, IT BROKE

2005-06-06 Thread Nilesh Bhattad
Hi,   --- The DTDs should be resolving from the JAR files by default, so you shouldn't need to do anything.  Unfortunatley some XML parsers don't use entity --- resolvers properly.  Also, your IDE might want to resolve from the network too.  Good IDEs like IntelliJ IDEA use locally mapp

Re: MORE ON IBATIS.COM DOMAIN UPDATE...YEP, IT BROKE

2005-06-06 Thread Clinton Begin
PS:  As an added bonus, my ibatis.com email is also quite fried.  Use my gmail or apache account to contact me directly. Clinton On 6/6/05, Clinton Begin <[EMAIL PROTECTED]> wrote: Hi everyone, My worst fears have come true, and I managed to screw up the DNS configuration.  Yay.  :-) My sugges

MORE ON IBATIS.COM DOMAIN UPDATE...YEP, IT BROKE

2005-06-06 Thread Clinton Begin
Hi everyone, My worst fears have come true, and I managed to screw up the DNS configuration.  Yay.  :-) My suggestion is that you turn this obstacle into an "opportunity" to update all of your SQL Map XML files to validate against: ibatis.apache.org which will continue to be the new host for th

Re: bug with running sybase stored procedures

2005-06-06 Thread Brandon Goodin
We made that change to accomodate Oracle drivers that use ref cursors. I am so sick of crappy lame companies who don't know how to write freakin code!!! Is this something that can be a configuration change on the transactionManager level? Thoughts anyone? Brandon On 6/6/05, [EMAIL PROTECTED] <[EM

bug with running sybase stored procedures

2005-06-06 Thread
using sybase with IBatis to call a store procedure results in an error.(null pointer exception) At first I thought Ibatis could not handle stored procedure without output params but this was not the case. The issue seems to be with Sybase's jdbc code. To fix the issue I changed the foll

Re: IBATIS DOMAIN NAME UPDATE - DTD WARNING

2005-06-06 Thread Larry Meadors
For the same reason we use DNS instead of editing our /etc/hosts file. ;-) Larry On 6/6/05, netsql <[EMAIL PROTECTED]> wrote: > I allways forget why this is not the default.

Re: IBATIS DOMAIN NAME UPDATE - DTD WARNING

2005-06-06 Thread netsql
Clinton Begin wrote: Option 2) Use local filesystem Every iBATIS JAR file comes with the DTDs. You can extract the DTDs and put them on your local filesystem. This is a lame approach, but some people already do it for performance or other security reasons. This will also stop your DTDs fr

Re: IBATIS DOMAIN NAME UPDATE - DTD WARNING

2005-06-06 Thread Clinton Begin
PS:  The .NET folks obviously aren't impacted.  Their XML schemas aren't validated against ibatis.com. On 6/6/05, Clinton Begin <[EMAIL PROTECTED]> wrote: Hi everyone, Sorry for the scary subject, I just wanted to make sure everyone wasn't surprised if DTDs stop validating against ibatis.com in t

IBATIS DOMAIN NAME UPDATE - DTD WARNING

2005-06-06 Thread Clinton Begin
Hi everyone, Sorry for the scary subject, I just wanted to make sure everyone wasn't surprised if DTDs stop validating against ibatis.com in the next 24 hours. I've moved all of the ibatis.com/net/org domains to be parked on the new apache domain ibatis.apache.org This means we'll have one nice