connection problem with ojb and Sql server

2005-09-22 Thread Davide Emanuele Denicolo
Hi at all! I have this problem: I'm using MS SQL Server 2000 as information repository and ojb with java My problem is that when the connection between tomcat and sql server has broken or SQL gets down,I receive this message to browser org.apache.ojb.broker.PersistenceBrokerSQLException:

Re: connection problem with ojb and Sql server

2005-09-22 Thread Thomas Dudziak
On 9/22/05, Davide Emanuele Denicolo [EMAIL PROTECTED] wrote: Hi at all! I have this problem: I'm using MS SQL Server 2000 as information repository and ojb with java My problem is that when the connection between tomcat and sql server has broken or SQL gets down,I receive this message to

Advice needed: conf of cache locking in non-clustered webapp with Spring PB-Api

2005-09-22 Thread Thomas Dudziak
Hi folks, has anybody some advice as to how to best configure Spring OJB (1.0.3) with regard to caching and locking ? My thoughts were to use either the 2-level or the oscache impl, and use pessimistic read-committed locking (how to do that with spring transactions and the PB-Api ?) ideas,

Re: connection problem with ojb and Sql server

2005-09-22 Thread Thomas Franke
Davide Emanuele Denicolo wrote: My problem is that when the connection between tomcat and sql server has broken or SQL gets down,I receive this message to browser How about to use the validationQuery attribute in the connection-pool element of the repository_database.xml like this:

Re: connection problem with ojb and Sql server

2005-09-22 Thread Davide Emanuele Denicolo
-Messaggio originale- Da: Thomas Franke [xxx] Inviato: giovedì 22 settembre 2005 13.20 A: OJB Users List Oggetto: Re: connection problem with ojb and Sql server Thomas Franke wrote: How about to use the validationQuery attribute in the connection-pool element of the

Re: connection problem with ojb and Sql server

2005-09-22 Thread Thomas Franke
Davide Emanuele Denicolo wrote: I've tried it, but i receive the same problem! OK, did you change datenklasse with a table of your database? Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: connection problem with ojb and Sql server

2005-09-22 Thread Davide Emanuele Denicolo
-Messaggio originale- Da: Thomas Franke [xxx] Inviato: giovedì 22 settembre 2005 15.26 A: OJB Users List Oggetto: Re: connection problem with ojb and Sql server Thomas Franke wrote: OK, did you change datenklasse with a table of your database? o...soorry ;) Yes, I have changed

R: connection problem with ojb and Sql server

2005-09-22 Thread Davide Emanuele Denicolo
-Messaggio originale- Da: Thomas Franke [xxx] Inviato: giovedì 22 settembre 2005 15.26 A: OJB Users List Oggetto: Re: connection problem with ojb and Sql server Thomas Franke wrote: OK, did you change datenklasse with a table of your database? o...soorry ;) Yes, I have

ojb-blank.jar

2005-09-22 Thread Thomas Franke
Hello, I downloaded the ojb-blank.jar from 'http://mirrorspace.org/apache/db/ojb/db-ojb-1.0.3/'. But I'm missing the profile directory with the database profiles in it. I thought this is necessary. What does that mean? Regards, Thomas

Re: ojb-blank.jar

2005-09-22 Thread Thomas Dudziak
On 9/22/05, Thomas Franke [EMAIL PROTECTED] wrote: I downloaded the ojb-blank.jar from 'http://mirrorspace.org/apache/db/ojb/db-ojb-1.0.3/'. But I'm missing the profile directory with the database profiles in it. I thought this is necessary. What does that mean? Nope, the profiles are

Re: Advice needed: conf of cache locking in non-clustered webapp with Spring PB-Api

2005-09-22 Thread Jason McKerr
Thomas, I wrote the following article which should allow you to use locking and 2-level caching with Spring and OJB quite easily. My implementation is simple, but you should be able to change it to use whatever you want. http://staff.osuosl.org/~mckerrj/?p=8 J Thomas Dudziak wrote: Hi

Re: Advice needed: conf of cache locking in non-clustered webapp with Spring PB-Api

2005-09-22 Thread Thomas Dudziak
On 9/22/05, Jason McKerr [EMAIL PROTECTED] wrote: I wrote the following article which should allow you to use locking and 2-level caching with Spring and OJB quite easily. My implementation is simple, but you should be able to change it to use whatever you want.

Re: connection problem with ojb and Sql server

2005-09-22 Thread Thomas Franke
Davide Emanuele Denicolo wrote: but the problem is the same!!! strange. Could you send your repository_database.xml and ojb.properties? Or I send you mine and you can compare your settings. I think it is a good idea to align both files. I have heard sometimes there are problems if in both files

Joining a subquery to parent across non-decomposed m:n

2005-09-22 Thread Steve_Clark
I have a query that I can't figure out how to write. I'm using 1.0.4 and PersistenceBroker. Here's my situation: Project has a Collection of Activities; this is a non-decomposed m:n via ACTIVITY_PROJECT. Activity has attribute 'conclusionDate'. I want to find all Projects for which every