Re: Sort resultset from multiple requests

2008-09-23 Thread Kai Grabfelder
Hi Helio, what does your getCatName select looks like? Can't you just use an order by in that select? Furthermore, you may want to have a look at the groupBy feature of iBATIS to avoid the n+1 select problem. The documentation [1] describes this in more detail. Regards Kai [1] http://svn.apa

Sort resultset from multiple requests

2008-09-23 Thread Heliodromel
Hi everybody, i've got a question about sorting. It's maybe stupid but i can't find the solution. Here is my problem : I make a simple request in a database, for example : select firstname, lastname, age, ref_cat from MyTable And i got a simple resultmap, something like that :

Insert oracle BLOB's with iBatis

2008-09-23 Thread AbelGG
Hi!, I've a DB Oracle 9i and I want to insert a BLOB using iBatis. I've mapped a BLOB column as follows: The java class that I mapped here has the property "fichero" as byte[] with getter's and setter's. The iBatis versión that I'm using is 2.3.0 and the oracle driver ojdbc14.jar (is the versi

Insert oracle BLOB's with iBatis

2008-09-23 Thread AbelGG
Hi!, I've a DB Oracle 9i and I want to insert a BLOB using iBatis. I've mapped a BLOB column as follows: The java class that I mapped here has the property "fichero" as byte[] with getter's and setter's. The iBatis versión that I'm using is 2.3.0 and the oracle driver ojdbc14.jar (is the versi

Insert oracle BLOB's with iBatis

2008-09-23 Thread AbelGG
Hi!, I've a DB Oracle 9i and I want to insert a BLOB using iBatis. I've mapped a BLOB column as follows: The java class that I mapped here has the property "fichero" as byte[] with getter's and setter's. The iBatis versión that I'm using is 2.3.0 and the oracle driver ojdbc14.jar (is the versi