Re: [JNDI] datasource on remote server

2005-10-26 Thread Eugeny N Dzhurinsky
On Tue, Oct 25, 2005 at 10:23:54AM -0500, Jeff Butler wrote: Hmmm...another undocumented feature :( From browsing through the source code, it looks like you can do this: dataSource type=JNDI property name=DataSource value=somevalue/ property name=context.java.naming.provider.url

calling trim() on sql map returned strings

2005-10-26 Thread Gareth Moorst
Before acting on this e-mail or opening any attachments you are advised to read The Caudwell Holdings group of companies' disclaimer at the end of this e-mail. === Hi All my iBatis created objects have large amounts of spaces in their string

RE: calling trim() on sql map returned strings

2005-10-26 Thread Gareth Moorst
Before acting on this e-mail or opening any attachments you are advised to read The Caudwell Holdings group of companies' disclaimer at the end of this e-mail. === It would appear that I didn't make myself at all clear in that last email - it

Re: calling trim() on sql map returned strings

2005-10-26 Thread Daniel Henrique Ferreira e Silva
Hi Gareth, Doesn't Informix have a trim-like function you could apply in your query? Like: select trim(mycolumn) as mycolumn from mytable Doing that kind of stuff in the database is the best pick IMHO. Cheers, Daniel Silva. On 10/26/05, Gareth Moorst [EMAIL PROTECTED] wrote: Before acting

cacheModel question

2005-10-26 Thread Rao, Satish
Title: cacheModel question Does cacheModel only work with resultClass and resultMap? Currently I have the following entry in the sqlMap cacheModel id=cacheFullname type=OSCACHE /cacheModel parameterMap id=some-param class=SomeParams parameter property=someId mode=IN

Re: how to map unsigned bigint in MySql to long value

2005-10-26 Thread Siming Weng
I'll have a go later. Thank you for the quick response. On 10/26/05, Jeff Butler [EMAIL PROTECTED] wrote: iBATIS does not have a type handler for BigInteger - because there is no getBigInteger() method on a result set. iBATIS will call getObject() if it doesn't know what the data type is

Re: How to set up a select map

2005-10-26 Thread Larry Meadors
Three ways: 1) Use where value like #property# and put the pattern in your property. 2) Use where value like '%' || #property# || '%'and put the value in your property. 3) Use where value like '%$property$% and put the value in your property. The last option will open you you up to SQL

RE: calling trim() on sql map returned strings

2005-10-26 Thread Ron Grabowski
IBatisNet has support for replacing the built-in type handlers: typeHandlers typeHandler type=String callback=TrimStringTypeHandlerCallback / /typeHandlers TrimStringTypeHandlerCallback could be implemented in such a way that it automatically calls trim() before sending values to the

RE: calling trim() on sql map returned strings

2005-10-26 Thread Gareth Moorst
That's interesting... I'll have a look at that tomorrow- The sqlmapconfig dtd does have a typehandler child.. Cheers -Original Message- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 17:13 To: user-java@ibatis.apache.org Subject: RE: calling trim() on sql map

Re: dataSource simple or dbcp?

2005-10-26 Thread Clinton Begin
I think it is. :-) It's a 3 year old piece of code, with nearly no bug reports. So it's pretty darn stable. The other nice thing is that it doesn't spawn threads or anything crazy. So it's predictable and solid. Try it out to see what you think. Cheers, Clinton On 10/20/05, Zsolt Koppany [EMAIL

Re: update() accepts insert?

2005-10-26 Thread Clinton Begin
Yes, ibatis allows you to call inserts or updates regardless of the XML element used...the primary reason is that some people need to call update() on selects. Consider them separate intentions. One is a descriptive XML document synax, the other is a descriptive Java syntaxeven if they

Re: java.net.SocketException: Unexpected end of file from server

2005-10-26 Thread Clinton Begin
Looks like a messed up XML parser can you use Xerces or the JDK parser instead of the Oracle one? ClintonOn 10/24/05, Jani Lall [EMAIL PROTECTED] wrote: Hi!I am using iBATIS with Oracle OC4J and when I am trying to readSqlMapConfig file AS throws exception mentioned in subject. The log

Multiple Statements in one transaction/command

2005-10-26 Thread H.E. Sum
What's a good pattern to perform multiple statements on a single DAO method. Suppose I have a bunch of User objects each containing a list of Group objects. Right now I'm doing the following: (Pseudocode) AddUser(User) { [BeginTransaction] Mapper.Instance().Insert(InsertUser, user);

Re: Paginated List Problem in Ibatis

2005-10-26 Thread Sabyasachi Biswas
Hi Larry, Thank You for your response. I have a instance variable Paginated List , that all my methods use . There are a large number of methods that use this Paginated List object. I had thought it would not be feasible by making so many objects of The Paginated List in each of my methods.