RE: Criteria with select with no where clause?

2004-02-04 Thread Hennebelle
Hi, You can create an empty criteria and not had clauses, like this : Criteria criteria = new Criteria(); Query query = QueryFactory.newQuery(SitBO.class, criteria); -Message d'origine- De : Robert S. Sfeir [mailto:[EMAIL PROTECTED] Envoyé : mercredi 4 février 2004 05:17 À : OJB Users

RE: properly way to lookup a java.sql.Connection from the connection pool

2004-01-29 Thread Hennebelle
Hi, I don't know if this method is well but I use it : ClassDescriptor classD = broker.getClassDescriptor(DualBO.class); JdbcConnectionDescriptor jcd = classD.getConnectionDescriptor(); //Creation of the connection java.sql.Connection connection = null; try { //Initialisation of the JDBC

RE: Date problem ?

2004-01-15 Thread Hennebelle
Hi, Have you try to use TIMESTAMP for your jdbc-type, you can try like this : field-descriptor id=18 name=d8cleh column=D8CLEH jdbc-type=TIMESTAMP conversion=org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimest ampFieldConversion / The class for the

RE: Update Problem : Cannot convert class java.lang.Integer

2004-01-07 Thread Hennebelle
Hi ! Have you try to make a conversion in your repository ? You have a class in OJB who convert INT on INTEGER (and the opposite), the name is Int2IntegerFieldConversion. You put a field in the repository like this (my example is a date, it works) : !-- COLUMN D8CLEH -- field-descriptor

RE: select question (again)

2003-12-18 Thread Hennebelle
Hi, personnally, I put : criteria.addSql(date = TO_DATE('2004', '')); But I think there other possibilities -Message d'origine- De : Glauber Andrade [mailto:[EMAIL PROTECTED] Envoyé : jeudi 18 décembre 2003 00:19 À : OJB Users List Objet : select question (again) How do I implement

Problem with cursors

2003-12-18 Thread Hennebelle
Hi, When I make my tests with OJB (0.9.7), I have got an Oracle's error : ORA-01000: maximum open cursors exceeded This error appear when I use PB API and the method getIteratorByQuery, a cursor is use with the iterator I keep but is not close. For found this error, I have two tests, each test

RE: Problem with cursors

2003-12-18 Thread Hennebelle
Thank you, it works now. Hello, Hennebelle wrote: When I make my tests with OJB (0.9.7), I have got an Oracle's error : ORA-01000: maximum open cursors exceeded This error appear when I use PB API and the method getIteratorByQuery, a cursor is use with the iterator I keep

RE: How to force collection to Vector

2003-12-17 Thread Hennebelle
Hi, I make something for my project, I create a class for make the link between the database and the application, this class have methods who take in parameters a bean for make some criteria and return a list. In these methods, I use PB broker for make an Iterator and I pass the iterator for make

ERR : Borrow broker from pool failed

2003-12-09 Thread Hennebelle
Hello, I have got a big problem with OJB (I think it is OJB), I have an error : org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed This error comes after 1 or 2 days after the launch of the instance and comes just after an update (after this error, we can do as select as we

Problem with the cache on OJB

2003-03-19 Thread Hennebelle
will have many problems with it for making joints. In fact, when I use this class, my problem is solved but I've got my joint which take a lot of time (it jumps from 0.8 sec to 6 sec), that's why I want to do this in my program. Olivier Hennebelle mail : [EMAIL PROTECTED