Question on iBatis Implicit Transactions ?

Hello Guys, I have got a couple of questions relating to iBatis starting out implicit trasactions..Let me add that i am using iBatis "JDBC" TransactionManager. Please comment/correct me on the following understanding, given COMMITREQUIRED="TRUE" : 1a) iBatis implicitly starts a transaction if o

Re: URGENT : Does the ResultSet get closed by iBatis when using jdbcType=ResultSet

. We can provide general answers, > but there's nothing like checking it right at the source. > > Of course the result set "should be" closed. Only you can confirm if it > actually is. > > Clinton > > On Mon, Nov 24, 2008 at 1:51 PM, mfs <[EMAIL PROTECT

URGENT : Does the ResultSet get closed by iBatis when using jdbcType=ResultSet

Hi Guys, We are facing a critical issue in production and while looking into the possible causes, we came accross this code segment where we using jdbcType=ORACLECURSOR with corresponding jdbcType="ResultSet"..as below XML MAPPING { call packagename.procedu

Re: DAO Framework - how to disable connection pooling..

Just thought to post the complete configuration of dao.xml and sql-map-config.. dao.xml sql-map-config.xml === mfs wrote: > > Ok, well these would sound funny, but i didn

Re: DAO Framework - how to disable connection pooling..

the pool defined by the container. Tomcat, > jboss, whatever - that's where you'd need to change things. > > Larry > > > On Thu, Oct 9, 2008 at 2:39 AM, mfs <[EMAIL PROTECTED]> wrote: >> >> Ok, well these would sound funny, but i didn't knew at al

DAO Framework - how to disable connection pooling..

Ok, well these would sound funny, but i didn't knew at all before today that iBatis DAO framework uses connection pooling internally. Anyways i am somewhat struggling to figure out as to how to disable it..I dont have any attribute relating to it (and thats why didnt knew at all) but apparently a

Re: DAO Framework - question on thread-safety

Thanks for the quick followup Clinton. That does handle my concerns.. Clinton Begin wrote: > > It's all thread safe, including getDao(Class). Each instance will be > thread > safe as well. > > Clinton > > On Mon, Jun 23, 2008 at 4:48 PM, mfs <[EMAIL PROTECTED

DAO Framework - question on thread-safety

Guys, I am using ibatis DAO Framework and i had certain questions/concerns, that whether my current DAO Manager implementation is thread safe, since apparently the getDAO(MyDAOClass.class) method (which i am using to retrieve the dao implementation) isn't thread safe. Also Larry mentioned in one

Function returning rowtype (recordtype) - Is it possible to map it to a bean ?

I believe what i am trying to do is not possible with ibatis, but just want to be sure. I have an oracle function which returns a table's record type (i.e. location%rowtype), which i want to be able to call and to the result to a bean, is it possible to do so ? or would i have to write my own cus

Re: Calling a function with Integer param and return type an inline params

't u think... Jeff Butler-2 wrote: > > You might try setting the jdbcType of the OUT parameter to INTEGER. If > that > doesn't work, then you'll need to define an actual class to hold your > results (not just a Map). > > Jeff Butler > > On Sat, Ma

Re: Calling a function with Integer param and return type an inline params

; <-- Expecting Integer here Thanks in advance.. mfs wrote: > > still doesnt work.. and as per the javadoc the SqlMapDaoTemplate.update() > javadoc "Executes a mapped SQL UPDATE statement", i dont think it will > work here, just guessing.. > > > Jeff Butle

Re: Calling a function with Integer param and return type an inline params

in > your > DAO: > > Map parms = new HashMap(); > parms.put("stateId", new Integer(1)); > update("getState", parms); > Integer stateId = (Integer) parms.get("result"); > > Jeff Butler > > > > On Sat, May 24, 2008 at 4:01 AM, mf

Calling a function with Integer param and return type an inline params

Guys, I am trying to call an oracle function (using inline parameters) and it just doesnt seem to work and returns null (though the same has been tested from a standalone plsql client returns the result as expected).. Can anyone suggest as to what the problem is in the code below, the oracle fun

Re: PreparedStatement for procedure calls ?

thanks.. Clinton Begin wrote: > > It uses CallableStatements for procs. CallableStatements are > PreparedStatements so it can still be said that iBATIS always uses > PreparedStatements. :-) > > On Mon, May 12, 2008 at 11:48 AM, mfs <[EMAIL PROTECTED]> wrote: >&g

Re: PreparedStatement for procedure calls ?

anyone..? mfs wrote: > > Guys, > > My understanding is that ibatis internally uses preparedstatement for all > db calls, which offcourse eliminates the sql-injection vulnerability (to > some extend atleast).. > > Now, I haven't really played around with Prepare

PreparedStatement for procedure calls ?

Guys, My understanding is that ibatis internally uses preparedstatement for all db calls, which offcourse eliminates the sql-injection vulnerability (to some extend atleast).. Now, I haven't really played around with Preparedstatements much, thats why putting up a pretty naive question. Q. So

Re: DaoFramework - Are the DAO instances shared ?

so it is a actually a singleton DAO.. Larry Meadors wrote: > > There is one instance of each implementation. > > Larry > > > On Sun, May 11, 2008 at 10:09 PM, mfs <[EMAIL PROTECTED]> wrote: >> >> So is there a pool of DAOImpl instances ? whats the size

Re: DaoFramework - Are the DAO instances shared ?

> > > On Sun, May 11, 2008 at 9:28 PM, mfs <[EMAIL PROTECTED]> wrote: >> >> Guys, >> >> I know that DAO Framework has been deprecated and one is suggested to >> look >> for better alternatives out in the market like Sping and all. I >>

DaoFramework - Are the DAO instances shared ?

Guys, I know that DAO Framework has been deprecated and one is suggested to look for better alternatives out in the market like Sping and all. I eventually plan to move over to them but due to the time crunch, i have just found using the iBatis DAO Framework to be pretty easy to start/integerate

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

Sure..! bpamarti wrote: > > Perfect!! > > Thanks a bunch! > > mfs <[EMAIL PROTECTED]> wrote: > > Actually i dont work on the List of beans (and i thought thats what u > meant > earlier)..i dont work on the resultset type at all, thats what i would &

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

Actually i dont work on the List of beans (and i thought thats what u meant earlier)..i dont work on the resultset type at all, thats what i would expect the ibatis framework to take care of transform the resultset entries into a list of bean as i configured in sql-map config file.. Here is my t

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

like this right now > sqlMap.update("getCertificateByCertificateId", params); > ResultSet rset = (ResultSet) map.get("outputCursorParam"); > > > > mfs wrote: >> >> Guys, >> >> I just started using iBatis, and i think its a gre

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

So turns out it was jdbc driver version issue, though initially i was using the jdbc driver version as my database version but i had to upgrade to the next rather the latest version in the 10 series i.e. 10.2.0.4.0 to get the problem fixed.. Thanks anyways.. mfs wrote: > > Guys, >

Re: i wonder why ibatis is not made available on public maven repo ?

s > ibatis-sqlmap > 2.3.0 > > > Brandon > > On Tue, May 6, 2008 at 4:13 PM, mfs <[EMAIL PROTECTED]> wrote: > >> >> Guys, >> >> I wonder why is ibatis is not available at repo1.maven.org, is there any >> particular reason ? Any parti

Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

Guys, I just started using iBatis, and i think its a great framework, and would want to employ the same in our company for the persistance layer...Also "iBatis in Action" is a very well written book, great job Clinton, Larry and Brandon... Anyways coming to the problem...So am facing this "proto

i wonder why ibatis is not made available on public maven repo ?

Guys, I wonder why is ibatis is not available at repo1.maven.org, is there any particular reason ? Any particular reason, since every using maven would certainly repo1.maven.org as their primary repository. I see 1.3.1 available there and just the pom for 2.1.0.565 Thanks Farhan. -- View t