Re: iBatis Unit Testing

2005-10-17 Thread Dan Bradley
If you're using Spring then this is a godsend: http://static.springframework.org/spring/docs/1.2.x/api/org/springframework/test/AbstractTransactionalDataSourceSpringContextTests.html Transactions rollback the data no matter what happens. The db is always left in a consistent state and unit testin

Re: iBatis Unit Testing

2005-10-17 Thread Clinton Begin
I use HSQLDB for 90% of my unit testing.  Cheers, ClintonOn 10/17/05, Larry Meadors <[EMAIL PROTECTED]> wrote: Have you looked into dbunit?LarryOn 10/17/05, Gajendra Naidu <[EMAIL PROTECTED]> wrote:> Hi>> Can some body suggest me on writting Unit Test cases using JUNIT for DAOs > which have been

Re: How to insert large BLOBs?

2005-10-17 Thread Larry Meadors
Depends on what you mean by big.. if it's 100s of MB, you should look at direct jdbc. if it's 100s of KB, you could use a byte[]. Larry On 10/17/05, Zsolt <[EMAIL PROTECTED]> wrote: > Hi, > > What is he preferred way to insert large blobs? I would like to do that via > InputStream. > > Zsolt >

Re: iBatis Unit Testing

2005-10-17 Thread Larry Meadors
Have you looked into dbunit? Larry On 10/17/05, Gajendra Naidu <[EMAIL PROTECTED]> wrote: > Hi > > Can some body suggest me on writting Unit Test cases using JUNIT for DAOs > which have been extended SqlMapDaoTemplate.class. > > Thanks in advance. > > Gaj

iBatis Unit Testing

2005-10-17 Thread Gajendra Naidu
Hi   Can some body suggest me on writting Unit Test cases using JUNIT for DAOs which have been extended SqlMapDaoTemplate.class.   Thanks in advance.   Gaj

Re: Problem calling a oracle stored procedure

2005-10-17 Thread Vincent NICOLAS
Title: Message Does the procedure return anything ? You should use a insert() method to call the procedure in the Java code to avoid iBatis to try and retrieve a value from the procedure. DelCastillo, Alberto a écrit :  I have problem calling a stored procedure (I'm using

How to insert large BLOBs?

2005-10-17 Thread Zsolt
Hi, What is he preferred way to insert large blobs? I would like to do that via InputStream. Zsolt

Problem calling a oracle stored procedure

2005-10-17 Thread DelCastillo, Alberto
Title: Message  I have problem calling a stored procedure (I'm usingoracle 10g).===This is my iBatis-sqlMap-CreditScoreCache file:class="com.axacanada.creditscore.implementation.cache.CreditScoreCacheAction">nullValue="" javaType=" java.l

Re: Keyed sub selects

2005-10-17 Thread Alan Chandler
Gareth Moorst writes: Isn't this the classic use of groupBy? See the thread earlier entitled "Group By for multiple column primary keys" Particularly my last contribution - where I lay out how I was doing this in a some detail (I am using Lists rather than hashmaps but whatever). ---

FW: Keyed sub selects

2005-10-17 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. === -Original Message- From: Gareth Moorst Sent: 11 October 2005 15:35 To: