Re: c3p0 vs dbcp?

2007-02-28 Thread Clinton Begin
Absolutely. You can use any DataSource implementation you like. All you need to do is build a DataSourceFactory and pass the fully qualified classname (or type alias) into the datasource type in the element of your SqlMapConfig.xml public interface DataSourceFactory { public void initialize(M

c3p0 vs dbcp?

2007-02-28 Thread JoeSmith
Is it possible to use the c3p0 datasource/connection pool with iBatis? Does anyone know how this package compares to dbcp? Are there any known issues or problems?

Re: using typeHandler

2007-02-28 Thread Nathan Maves
IMHO this is a bad way or trying to reduce code. Let me point out a few reasons :) 1. Why use a map if you are only ever going to pass 1 string in. That is twice the amount of memory needed to object creation. 2. You have moved database specific information into your java code. I think it i

Re: Avoiding N+1 Selects

2007-02-28 Thread Brad Handy
I think I could use a row handler to arrange the objects in a situation like this. One question I have: Do the results of a query with a custom RowHandler still get cached when using OSCache? Brad On 2/22/07, Brad Handy <[EMAIL PROTECTED]> wrote: iBatis came back with an error message indic

using typeHandler

2007-02-28 Thread Stefano Mancini
Hi, I've the following problem: I want to read the rows of a generic table into a List of HashMaps using a statement like this one select * from $table$ If the table contains a column of type BLOB in the resulting map is inserted an object of type oracle.sql.BLOB (I'm using orac