Re: Retrieving next page using pagenatedList

Hi, 1) you can use some code like below to get next page if(results.isNextPageAvailable()){ results.nextPage(); } 2) If you pass pageSize to the call: queryForPaginatedList(java.lang.String id, java.lang.Object parameterObject, int pageSize), first time it will fetch at most 2*pageSize re

Re: stored procedure multiple resultsets

Hi Nilesh, Quick question on multiple resultsets: does JDBC perform as many roundtrips to the database as there are outbound resultsets or are the resultsets brought back in a single roundtrip from the db? Kind regards Abdullah Nilesh Bhattad wrote: Hi, Does iBatis support stored proce

Re: stored procedure multiple resultsets

Short answer - not suported (sorry). See: http://issues.apache.org/jira/browse/IBATIS-28 For some discussion about this. Jeff Butler On 8/2/05, Nilesh Bhattad <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > Does iBatis support stored procedure calls which return multiple resultsets? > Could

stored procedure multiple resultsets

Hi,   Does iBatis support stored procedure calls which return multiple resultsets? Could someone plz post an example? I couldn’t find it over the internet or the forum. Help please!   ~ Nilesh

Executing stored procedures

Title: Executing stored procedures I have a query with 3 input parameters to the WHERE clause and the query returns a list. Some of the input parameters are optional (i.e. they can be NULL). The entry is shown below                SELECT             col1,

Re: Stored procedure with queryForList skipresults and maxresults

I wonder if it is possible to use skip/max in sql statement.   Every database has it's own solution for limiting rows: - sql server has top - postgresql : limit and offset - mysql: also limit and offset ( if I have a good memory:) - oracle prior to 9i combination of: rownum, order like this:

Re: Example of a queryForMap() call

Yeah how simple is that.  I got it to work right after I sent the email.  I only ran into one small gotcha.  I was trying to use an implicit result map so when I tried to pull the value out I was getting null.  I assumed that this was because the implicit map was not using a java.lang.String to sto

Re: Example of a queryForMap() call

queryForMap("getStudentNames", parameterMap, "studentId", "studentName");On 8/2/05, Nathan Maves < [EMAIL PROTECTED]> wrote:In the given example below select student_id as studentId student_name as studentName from students wher

Example of a queryForMap() call

In the given example below select student_id as studentId student_name as studentName from students where student_id in ( #studentIds[]# ) Ho

Retrieving next page using pagenatedList

Hi All,   I looked at PagenatedList for implementing "Next" and "Previous" features on JSP page.   I am getting the list for  first time to display a subset of records in the list, when user clicks Next button, I called isNextPageAvailable() and then nextPage(), but nothing happens.   My q

Re: Result set map to multiple object

Hi Guna, Have you read iBATIS DevGuide? It has all the info you need to solve your issue. Point your browser to http://ibatis.apache.org and get it. It's been way useful for me ;-) Cheers, Daniel Silva. On 8/2/05, Meindert <[EMAIL PROTECTED]> wrote: > Did you have a look at the jpetstore as an e

Re: StaleConnection error

Hi Vamir, It is mandatory if you want us to help you to provide environment data like which database, which iBatis version and how your iBATIS maps are configured. iBATIS team (i'm not included) is great, but they are not still jedi knights ;-) Cheers, Daniel Silva. On 8/1/05, [EMAIL PROTECTED]

Re: docs for tag

thanks! richard On 8/2/05, Roberto R <[EMAIL PROTECTED]> wrote: > Here's an example mapping found in SVN: > > http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper2/test/com/ibatis/sqlmap/maps/Documents.xml > > > > > On 8/1/05, rich oates <[EMAIL PROTECTED]> wrote: > > Hi, > > c

Re: Xml Validation

Jeff Butler wrote This could be a known issue that was fixed in 2.1.5.  Did you justrecently change to the new URL from the  the old location"http://www.ibatis.com/dtd/sql-map-2.dtd"; ?  You can only use the newibatis.apache.org location with iBATIS version 2.1.5.  Clintonreferences t

RE: Temporary table causing problems?

Did you try to escape the # using ##? Niels -Original Message- From: Bing Qiao [mailto:[EMAIL PROTECTED] Sent: dinsdag 2 augustus 2005 11:26 To: user-java@ibatis.apache.org Subject: Temporary table causing problems? This problem seems to only exist after 2.0.9b.550 I use queryForList t

Temporary table causing problems?

This problem seems to only exist after 2.0.9b.550 I use queryForList to retrieve dataset from a stored procedure. Everything gos well except I can't use temporary table when using the 2.1 version of ibatis. Code like the follows will cause trouble: select top 10 * into #payments from paymenttable

Re: dynamic where clause with mapping

Sorry to all, I've found it in the developers guide. Really nice, iBATIS rocks =) -- Eugene N Dzhurinsky

dynamic where clause with mapping

Hello! Is there any way to pass dynamic where clause portion to the iBATIS mapper? for example: select name,description from sometable where $clause$ if the user provided the just name pattern, the clause will look like name like '%#name#$' if the user will provide the both name and descriptio

RE: Result set map to multiple object

Did you have a look at the jpetstore as an example? http://sourceforge.net/projects/ibatisjpetstore/ -Original Message- From: Varathan, Gunaselan [mailto:[EMAIL PROTECTED] Sent: 01 August 2005 03:43 PM To: user-java@ibatis.apache.org Subject: Result set map to multiple object Hi, I am ne