RE: BATCH-MODE problem (repost)

2003-12-18 Thread Ron Gallagher
Oleg/Stephane -- I am pretty certain that this problem is gone in RC5. Back in July, I submitted a bug report/patch to document/fix this problem. Revision 1.7 of o.a.o.b.util.batch.PreparedStatementInvocationHandler was created on/about July 29, and it contains this fix. Ron Gallagher Atlanta,

JDO only work with Sun's jar (and not my own build)

2003-12-18 Thread Hubert Behaghel
Hi all, Since two days I couldn't get rid of this failure when in tutorial5 I tried to do whatever the program propose : The list of available products: [JDO] DEBUG: OjbStoreConnector.begin: connectionReadyForRelease=false java.lang.NoSuchFieldError: tokenTypeToASTClassMap at

SQLException Socket Closed with Oracle 9 and RC5

2003-12-18 Thread robert
For some reason, it looks like OJB doesn't know when a connection has been closed, or there is something wrong with my setup. I'm using OJB rc5, with Oracle 9.2.0, and ojdbc4.jar (for JDK 1.4.x). It seems that when the app is not used and left idle, that connections are closed, but then when it

Re: JDO only work with Sun's jar (and not my own build)

2003-12-18 Thread Thomas Mahler
Hi Hubert, did you compile the jdori source with JDK 1.3 or 1.4 ? AFAIK only 1.3 is supported by SUN. I really can't tell you what's up with the JDORI sources. But it's not an OJB issue at least ;-) Thomas Hubert Behaghel wrote: Hi all, Since two days I couldn't get rid of this failure when

RE: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'temporary'.

2003-12-18 Thread oliver . matz
Hello, -Original Message- com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'temporary'. at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2429) do you use temporary as a column / field name? That might cause the problem. In order to find out,

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

RE: Sample ant build files for OJB?

2003-12-18 Thread De Swert Pierre (GFDI)
Hi Thomas, Many thanks for your help. I have successfully built the ojb-blank.jar library to start my project. I needed to add the Sun's connector-api.jar in /lib, otherwise the main-opt target fails. Apparently the connector-api.jar library is not listed in the libraries needed to deploy OJB.

RE: Mapping problem

2003-12-18 Thread Stephan Wannenwetsch
Hallo Armin, I've changed the mapping and the code but nothing changed. I can't get the Suppliers of an Item ;-(( Mapping now: class-descriptor class=demo.myshop.model.ojb2.Supplier table=OJB_SUPPLIER field-descriptor name=supId

RE: SQLException Socket Closed with Oracle 9 and RC5

2003-12-18 Thread Lance Eason
The only way OJB can know whether the connection has been closed is if you set it up to test the connections in the pool. Your connection descriptor is set up halfway to do that, it specifies testOnBorrow, testOnReturn and testWhileIdle but you haven't provided a validationQuery for it to test

Re: SQLException Socket Closed with Oracle 9 and RC5

2003-12-18 Thread Armin Waibel
Lance, thanks for answer. Seems my post (this morning) was lost in space ;-) regards, Armin Lance Eason wrote: The only way OJB can know whether the connection has been closed is if you set it up to test the connections in the pool. Your connection descriptor is set up halfway to do that, it

Re: select question (again)

2003-12-18 Thread Martin Kalén
Hennebelle wrote: personnally, I put : criteria.addSql(date = TO_DATE('2004', '')); There's also: criteria.addEqualTo(date, TO_DATE('2004', '')); Works similar with all operators/'add'-methods on a Criteria. Regards, Martin -- Martin Kalén Curalia AB Web:

RE: Sample ant build files for OJB?

2003-12-18 Thread Brian McCallister
Thank you for the heads up on this! -Brian On Thu, 2003-12-18 at 05:04, De Swert Pierre (GFDI) wrote: Hi Thomas, Many thanks for your help. I have successfully built the ojb-blank.jar library to start my project. I needed to add the Sun's connector-api.jar in /lib, otherwise the main-opt

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 Martin Kalén
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 but is not close. You can cast the returned

RE: select question (again)

2003-12-18 Thread Brian McCallister
Be careful doing this in code that which gets executed a lot in a multi-threaded environment (ie, a servlet container), SDF has some serious synchronization bottlenecks =/ -Brian On Thu, 2003-12-18 at 09:29, Gelhar, Wallace Joseph wrote: Hi, Personally I would use SimpleDateFormat df =

Database not found

2003-12-18 Thread Jim Theodoridis
Hi I am using ojb with struts and Tomcat 4.1.24 I am getting the following message org.apache.jasper.JasperException: org.odmg.DatabaseNotFoundException: OJB can't open database repository.xml Borrow broker from pool failed: Creation of a new PB instance failed at

3 questions about ODMG

2003-12-18 Thread João Mota
-Using Pb with ODMG Question: When you use the PB methods with the ODMG broker, the query includes the objects touched by the current transaction? If not this could lead to problems with locks if the cache is cleared (see thread with title: Multiple reads within the same transaction). We are

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 but is not

Order of field-descriptor id entries at repository

2003-12-18 Thread Guido Beutler
Hello, I had some stange values aut objects since updated to RC5. After some debuging I found out that I got illegal values at attributes which does not match with the database. For example I got a attribute at tahe object with the value 15 where a 0 is stored at the corresponding database row.

old thread: Re: ConnectionFactoryManagedImpl and rollbacks

2003-12-18 Thread kristian meier
Hi Armin, I am very sorry to come back to the same topic after such a long time, but we are super bussy to get our thing up and running. we are using the Persistent Broker API in an managed enviroment as jboss or OC4J (oracle application server). using the

Re: automatic failover

2003-12-18 Thread kristian meier
Hi Stephen, Stephen Ting wrote: Hi, I think that's make no different than catching PersistenceBrokerException because it is the Subclass of OJBRuntimeException. for me here is a subtle difference, since OJBRuntimeException is a subclass of RuntimeException. so if in one component such an

Re: SQLException Socket Closed with Oracle 9 and RC5

2003-12-18 Thread Armin Waibel
Hi Robert, OJB checks per default with connection.isClosed() before return a connection from the pool. But most jdbcDrivers don't recognize timed out connections closed by the server. To do a more serious check you can use attribute 'validationQuery' (e.g. SELECT 1 FROM DUAL) if you don't have

Re: old thread: Re: ConnectionFactoryManagedImpl and rollbacks

2003-12-18 Thread Armin Waibel
Hi Kristian, I will try to test ConnectionFactoryManagedImpl with a noop-rollback methods ASAP. Currently I'm very busy with other OJB stuff. Please remember me (with severe criticism) again if I don't post my experience within the next few days ;-) regards, Armin kristian meier wrote: Hi

How to restrict result of 1:N mappings

2003-12-18 Thread Guido Beutler
Hello, I've got a 1:N mapping between classes. I would like to restrict the entries at the retrieved collection. I got two Classes A and B with a 1:n mapping between it. B has 17000 entries so I would like to restrict the collection to a small set of B's by using the primary key of B. By

Re: How to restrict result of 1:N mappings

2003-12-18 Thread Jakob Braeuchi
hi guido, please have a look at the query customizer. jakob Guido Beutler wrote: Hello, I've got a 1:N mapping between classes. I would like to restrict the entries at the retrieved collection. I got two Classes A and B with a 1:n mapping between it. B has 17000 entries so I would like to

Re: AW: JDO - Unable to build object instance

2003-12-18 Thread Gus Heck
It might be because you havn't followed the javabean get/set pattern... you wrote: public String GetName() { public void SetName(String name) { but the standard pattern is public String getName() { public void setName(String name) { This probably causes the enhancer to not recognize your object

XDoclet OJB module src in CVS

2003-12-18 Thread Thomas Dudziak
Since monday the XDoclet OJB module is part of the OJB CVS (including source, documentation, unit tests). Therefore, the pre-build jars are now in the lib folder (built with the official 1.2b4 XDoclet release from the sourceforge download site), and the documentation is part of the standard

RE: automatic failover

2003-12-18 Thread Stephen Ting
Hi Kristian, -Original Message- From: kristian meier [mailto:[EMAIL PROTECTED] Sent: 18 December 2003 23:56 To: OJB Users List Subject: Re: automatic failover Hi Stephen, Stephen Ting wrote: Hi, I think that's make no different than catching PersistenceBrokerException because

RE: ODMG - getIteratorByQuery

2003-12-18 Thread Stephen Ting
Hi Armin, This morning I read a thread about OJBIterator. It's mention to cast the PB Iterator To OJBIterator and invoke releaseDbResources() if I break half way of the iteration. This somehow make some difference in the Exception. However, Jboss still complain the connection is not close. Your