Execute multiple statements (pagination query port from oracle to mysql)

This is an attempt to convert the pagination query using rownum in Oracle to an equivalent pagination query using limit in mysql. I have an existing application that uses an Oracle database in production. I am trying to run the same application using mysql on my laptop. The entire application and

Re: Problem calling Stored function in Oracle

Declaimer: I am new to IBatis. I run into exact same error message when I passed a bad/misspelled "JDBCType" for my parameter in the parameterMap. According to this link: http://db.apache.org/ojb/docu/guides/jdbc-types.html it seems "ORACLECURSOR" is not a valid JDBCType. You may want to double c

Re: Problem calling Stored function in Oracle

Though I've never used oraclecursor with iBatis, I'll dare to note that from the image attached I see that parametermap property for the ORALECURSOR is the last one in the map. But it must be the first one (order parameter map properties must match order of ?,?... ). On Fri, Aug 21, 2009 at 8:

Re: Problem calling Stored function in Oracle

First thing, I'd make sure the datatypes of the actual passed arguments match the mapped datatypes. 2nd is the function valid in the database, can you create a pl/sql block that calls it and get a cursor back? Hi, I'm facing certain problems in getting my ibatis mapping to work with an oracle st

Re: Feature for iBatis

thanks ! I tried but it didn't work again, I forgot to mention ?im using jboss server On Fri, Aug 21, 2009 at 02:46, Richard Bibb wrote: > > This works for me. > > > > > http://jakarta.apache.org/log4j/";> > > > > > > > > >

Re: Separate iBATIS3 mailing list

> > #3 - I think I'm the only person who does moderation on the ibatis > lists and don't want another one to manage. (NOTE: If someone wants to > do that with me, let me know, it's easy, but when I'm out of the > office the "please subscribe" emails pile up). > I'll be out of the office till Septe

Problem calling Stored function in Oracle

Hi, I'm facing certain problems in getting my ibatis mapping to work with an oracle stored function Here is my mapping http://www.nabble.com/file/p25082929/query1.jpg

Re: Separate iBATIS3 mailing list

Heh - I hadn't had my coffee yet. ;-) Here are a few reasons: Pick one or take two, they're small. #1 - It's a bad idea to fragment an already small community (<1000 users on the list) because one user doesn't want to get the dozen or so emails a day that the list generates. #2 - Just like ibati

Re: Separate iBATIS3 mailing list

No. Lol On Fri, Aug 21, 2009 at 3:23 PM, Larry Meadors wrote: > Because it's a bad idea. > > Happy? > > Larry > > > On Fri, Aug 21, 2009 at 12:47 AM, Nicholoz Koka > Kiknadze wrote: > > No reply... > > > > Seems separate list idea is soo absurd that no one bothers to explain why > ;) > > > > On

Re: Separate iBATIS3 mailing list

Because it's a bad idea. Happy? Larry On Fri, Aug 21, 2009 at 12:47 AM, Nicholoz Koka Kiknadze wrote: > No reply... > > Seems separate list idea is soo absurd that no one bothers to explain why ;) > > On Tue, Aug 18, 2009 at 10:00 PM, Nicholoz Koka Kiknadze > wrote: >> >> I've enjoyed much usi

Re: iBATOR+iBATIS generation is successful, but test does not work.

Hi, Jeff Great thanks. Now this is worked! Alexander Jeff Butler-2 wrote: > > You need to enable statement namespaces. See here for an example: > > http://ibatis.apache.org/docs/tools/ibator/afterRunning.html > > Jeff Butler > > > On Thu, Aug 20, 2009 at 3:04 AM, bhaa wrote: >> >> Hi, >>