Generation of a PDF file

Hi, I use OJB 0.9.7 and for my project, I want to generate a PDF file with the data of a query. I want to use FOP for generate a PDF file directly with an XML stream. I think to keep a collection with my query and put them in an XML stream but it can take a lot of memory to create. Have you done

RE: Problem with Oracle9i and ReportQuery

Hi, my answer is a little late for you : For count with a query, you have broker.getCount(query) It will make select count(*) from ... without using an iterator Second thing for using iterator (you can have this problem later) : There is a big problem with Iterators, when you don't take all the l

RE: Criteria with select with no where clause?

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 Li

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

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 d

RE: Date problem ?

Hi, Have you try to use TIMESTAMP for your jdbc-type, you can try like this : The class for the conversion is already define in OJB. Hope that help. -Message d'origine- De : eric barbe [mailto:[EMAIL PROTECTED] Envoyé : jeudi 15 janvier 2004 09:22 À : OJB Users List Objet : RE: Date p

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

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) : Here, my example convert a Date in an sql

RE: Problem with cursors

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 it

Problem with cursors

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 i

RE: select question (again)

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 implemen

RE: How to force collection to Vector

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

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 w

Keep one colum

#x27;t got any primary and foreign keys. Do you have any idea of how I could retrieve only one column in OJB in order to pass it as an argument to Criteria#addIn ? Thanks in advance. Olivier Hennebelle mail : [EMAIL PROTECTED] -

RE: Problem with the cache on OJB

ginal Message- From: Hennebelle [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:30 AM To: [EMAIL PROTECTED] Subject: Problem with the cache on OJB Hello, I've got a problem with OJB's cache. In my program, I make two requests in SQL. I retrieve the two requests in the spy

Problem with the cache on OJB

ectCacheEmptyImpl' in my OJB.properties for the Object cache because I 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&#x

Problem with conditionnal joins

Hello, I tried making joins by using multiple reference-descriptors. Here is an explanation of the schema I have : table A is related to tables B and C ; the join between tables A and B depends on the value of column C : if this column contains "XXX", then A's D column joins B on its "XXX" column