Re: Insert oracle BLOB's with iBatis

2008-09-24 Thread AbelGG
Hi! In reply to my own post I've discovered my problem. It was in the code generated by abator; in the instruction "insert" puts the function nvl in all columns, including the BLOB column and this is causing, attempting to insert a NUMBER instead of a BLOB (BINARY). I don't know why but seems that

Re: Insert oracle BLOB's with iBatis

2008-09-24 Thread AbelGG
Hi! In reply to my own post I've discovered my problem. It was in the code generated by abator; in the instruction "insert" puts the function nvl in all columns, including the BLOB column and this is causing, attempting to insert a NUMBER instead of a BLOB (BINARY). I don't know why but seems that

Re: Insert oracle BLOB's with iBatis

2008-09-24 Thread AbelGG
Hi! In reply to my own post I've discovered my problem. It was in the code generated by abator; in the instruction "insert" puts the function nvl in all columns, including the BLOB column and this is causing, attempting to insert a NUMBER instead of a BLOB (BINARY). I don't know why but seems that

AW: Shutting down Connection Pool at runtime (for maintenance)

2008-09-24 Thread Leucht, Axel
I have to admit that I know Oracle only very basically, though bare with me :-) But what I think seems to be complicate matters is that you're backing up your database cold. I remember that I did this also a couple of years ago when I didn't know that RMAN can do this while the database is sti

Shutting down Connection Pool at runtime (for maintenance)

2008-09-24 Thread Ian Zabel
Very soon we're releasing our first build of our legacy app using iBATIS! We've converted about 10% of our legacy SQL to iBATIS so far, and it's really working great. Things are 15-30% faster compared to our old framework (homegrown SOAP server for all data access). We're using iBATIS with Tomcat

Re: Sort resultset from multiple requests

2008-09-24 Thread Heliodromel
Hi Kay, Thanks for your answer. Actually, the getCatName is just a example, it could be "select * from Cat" and the table Cat would be constituted with 2 fields : a name and an age. I had already tried to use the groupBy property but it didn't work. Actually i was using it wrong. This morning,