Re: jpg file

You might find this wiki page a good place to start: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F Kris --- Sergey Livanov <[EMAIL PROTECTED]> wrote: > > Looking for a piece of advice. > I want to write the jpg file in b

Re: jpg file

This should help you: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F Brandon On 5/31/05, Sergey Livanov <[EMAIL PROTECTED]> wrote: > > I use Oracle 9i, ojdbc14.jar > > -- > regards > Sergey mailt

Re: jpg file

Depends on what driver and database you are using. But, if you have written a BLOB before... it wouldn't be any different for a jpg. Brandon On 5/31/05, Sergey Livanov <[EMAIL PROTECTED]> wrote: > > Looking for a piece of advice. > I want to write the jpg file in blob. > What is the best way to

jpg file

Looking for a piece of advice. I want to write the jpg file in blob. What is the best way to do so? -- regards , Sergey mailto:[EMAIL PROTECTED]

dynamic SQL within an iterate

I want to use dynamic SQL within an iterate. However, the dynamic sql refers to a non-iterate property variable. Is this possible? I am getting this error at the moment:   com.ibatis.common.beans.ProbeException: Error getting ordinal list from JavaBean. Cause java.lang.NumberFormatExcepti

RE: Calling DAO within TypeHandlerCallback

Update: Strange, when I do not use autocommit-semantics and explicitly demarcate my transactions, everything goes fine. Well, at least I have a workaround. Until now, I used autocommit-semantics for most of my reads, and only explicitly demarcated when updating/inserting/deleting, should I alwa

RE: TypeHandlerCallback and lazy loading

I use the typehandlers to retrieve other classes that are not managed by iBATIS, but to pass columnvalues transparently, so I do not have to store all kinds of int's in my classes but declare the properties directly of the appriopriate type. I don't know which data has to be retrieved at foreha

RE: Calling DAO within TypeHandlerCallback

With "calls the DAO" I mean invoking iBATIS from within a typehandler. I tried the MS driver (on MSSQL database), same results: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Sour

Re: Using a like statement

FAQ misses my favorite approach which is: select * from table1 where column like #parm# || '%' It gives all the advantages of using #parm# over $parm$ and you don't need special processing in the java code to add the '%' . The downside is that || is not universal for string concatenation, so por

Re: TypeHandlerCallback and lazy loading

Lazy loading won't reduce the number of queries, unless you're never accessing the data you're retrieving, in which case I'd ask why you're loading it at all. Consider joining the data and mapping it with groupBy="" and a nested resultMap.  This faq might help http://opensource.atlassian.com/conf

Re: Calling DAO within TypeHandlerCallback

DAOs never touch result sets.  So I wonder what you mean by that?  Similarly, iBATIS only closes result sets once all columns have been iterated through (and hence all TypeHandlers have been executed).  Unfortunately some drivers (like IBM's DB2 driver) like to close resultsets automatically when

Re: Using a like statement

Build your value before sending it to the select statement in your xml file. I set my values in my action by using this: itemQuery.setDescription('%' + request.getParameter("description").toUpperCase() + '%') I, then, pass the parameter itemQuery to my manager and DAO layers. Hope this helps.

RE: Querying Based on Date.

I fixed my problem. It had nothing to do with iBatis it was a simple overlook on my part. I didn't push a file into the correct place. Thank you for the interest in helping me. Jamie Cruz Software Engineering [EMAIL PROTECTED] -Original Message- From: Brandon Goodin [mailto:[EMAI

Calling DAO within TypeHandlerCallback

Hi, me again :) When using a TypeHandlerCallback-implementation that calls the DAO, any subsequent property that iBATIS tries to fetch results in the following error (this dump occurred with a Date-property): java.sql.SQLException: Invalid state, the ResultSet object is closed. at net.sou

Re: Using a like statement

It is in the FAQ: http://opensource.atlassian.com/confluence/oss/display/IBATIS Larry On 5/31/05, Steven Pannell <[EMAIL PROTECTED]> wrote: > Hi, > > Is there an easy way to describe a 'like' statement in the iBatis xml file. > for example I have: > > > select * from bush where bush_n

TypeHandlerCallback and lazy loading

Hi, I've successfully used TypeHandlerCallback to load some complex datatypes. Now I'm facing the following problem: I have a resultmap which has 5 typehandler-definitions, when I load an object using this resultmap, the typehandlers are called instantly, which cause lots of DB-queries to be execu

Using a like statement

Hi, Is there an easy way to describe a 'like' statement in the iBatis xml file. for example I have: select * from bush where bush_name like #value# Using Oracle I have to make the value look like this: String value = "hello%" Can't I do this in the map something like: