datasource passwords

2004-04-22 Thread Guerrero, Axel
I run OJB using Datasources setup in JBoss. Do I have to specify the userid/password combination in repository.xml given that the same information is already stored by JBoss when I setup the datasource? Axel Guerrero [EMAIL PROTECTED]

Re: deploying OJB in Jboss

2004-04-22 Thread Armin Waibel
Hi Stephen, Stephen Ting wrote: Hi Armin, Thanks for your help + suggestion. I had successfully package everything in an ear file and it is redeployable. Congratulation! This isn't everybody's job ;-) So nice. Actually, there is not much changes to what was suggested in the ojb deployment doc.

getCount() bug

2004-04-22 Thread Stephen Ting
I encounter a bug in PB api, whenever i pass the order by attribute at Criteria object instead of Query object, i will get error in the broker.getCount(query); OJB will generate an invalid SQL query which look like SELECT count(*),A0.LABEL as ojb_col_1,A0.RECEIVING_DATE as ojb_col_2 FROM

Re: datasource passwords

2004-04-22 Thread Armin Waibel
Hi Axel, Guerrero, Axel wrote: I run OJB using Datasources setup in JBoss. Do I have to specify the userid/password combination in repository.xml given that the same information is already stored by JBoss when I setup the datasource? yep, OJB does not know about the JBoss configuration files.

Re: getCount() bug

2004-04-22 Thread Armin Waibel
Hi Stephen, did you tried latest from CVS, I think Jakob fixed a similar problem yesterday. http://www.mail-archive.com/ojb-user%40db.apache.org/msg09400.html regards, Armin Stephen Ting wrote: I encounter a bug in PB api, whenever i pass the order by attribute at Criteria object instead of

Re: Clustered cache with OSCache JavaGroups

2004-04-22 Thread Enrique Medina
Websphere Server within WSAD 5.1 Windows 2000 Professional From: Jason McKerr [EMAIL PROTECTED] Reply-To: OJB Users List [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Subject: Re: Clustered cache with OSCache JavaGroups Date: Wed, 21 Apr 2004 12:45:45 -0700 Not really sure what the

RE: OJB - Query for two table join

2004-04-22 Thread Enrique Medina
Hi Wallace, You have to use a ReportQueryByCriteria() where you can specify which attributes you want OJB to return instead of a getCollection(). Following your example: Criteria crit = new Criteria(); // Set criterias ... crit.addEqualTo(...); // Create the report query.

RE: OJB - Query for two table join

2004-04-22 Thread Enrique Medina
Hi again and just one comment to my previous message, setAttributes() is new to RC6, and substitutes deprecated setColumns() from older versions ... Regards, Enrique Medina. From: Enrique Medina [EMAIL PROTECTED] Reply-To: OJB Users List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: OJB

transactions in a managed environment: help needed!

2004-04-22 Thread Andreas Bohnert
hello everybody, we do a jboss project and we use the persistence broker only. therefore we use the PersistenceBrokerFactorySyncImpl, which is recommend to use with managed environments and pb only. we don't use entity beans. we have a stateless OjbSessionBean, which is called for any db

Re: transactions in a managed environment: help needed!

2004-04-22 Thread Armin Waibel
Hi Andreas, Andreas Bohnert wrote: hello everybody, we do a jboss project and we use the persistence broker only. therefore we use the PersistenceBrokerFactorySyncImpl, which is recommend to use with managed environments and pb only. we don't use entity beans. we have a stateless

RE: Problem with clearing cache

2004-04-22 Thread Guillaume Nodet
It also seems that cached anonymous keys are not removed from the cache when an object is deleted from database. Will these problems be solved, or should i try not to use anonymous keys ? Guillaume -Message d'origine- De : Guillaume Nodet [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21

Re: Problem with clearing cache

2004-04-22 Thread Brian McCallister
Anonymous PK's are risky things -- I apologize for using them in the original anonymous keys tutorial. Anonymous FK's are great, and not using them is usually a bad ida in my opinion =) I don't think the anonymous PK issues you are having will be resolved very soon, the anonymous key

RE: Problem with clearing cache

2004-04-22 Thread Guillaume Nodet
I use both anonymous PK's and FK's. But the use i do of anonymous primary keys is limited to objects that belongs to collections of main objects. Main objects have *real* primary keys and only these ones are used directly in the broker (all collections are prefetched) and cached. So i think that

Re: Problem with clearing cache

2004-04-22 Thread Armin Waibel
Hi Guillaume,Brian, I think the anonymous key (AK) feature should be modified/rewriten because currently it is object identity based. This means you will loose all AK information when the object will be de-/serialized or copied. The upcoming two-level cache will do so and the OTM

Re: transactions in a managed environment: help needed!

2004-04-22 Thread Andreas Bohnert
thanks very much, armin! I throwed just an Exception not an EJBException, so in case of a non SQLException the container didn't recognize the error. Now I just throw the EJBException and the rollback takes place. cool! Do you know why the container (or transaction manager) don't handle normal

Re: transactions in a managed environment: help needed!

2004-04-22 Thread Armin Waibel
Andreas Bohnert wrote: thanks very much, armin! I throwed just an Exception not an EJBException, so in case of a non SQLException the container didn't recognize the error. Now I just throw the EJBException and the rollback takes place. cool! Do you know why the container (or transaction

repository.dtd in CVS outdated?

2004-04-22 Thread Chiah Tong Kiat
Heres a snippet of the current repository.dtd file from the CVS residing on db-ojb/src/test/org/apache/ojb/repository.dtd From repository.dtd file platform (Db2 | Hsqldb | Informix | MsAccess | MsSQLServer | MySQL | Oracle | PostgreSQL | Sybase | SybaseASE | SybaseASA | Sapdb |

ResourceClosedException

2004-04-22 Thread Keith Rogers
I'm developing a web application using OJB, and every now and then I have the ResourceClosedException come up when iterating over a list. I think I understand what the exception means, but I'm pretty sure that the transaction I queried for the list in is not closed or aborted while I am iterating

Re: ResourceClosedException

2004-04-22 Thread Edson Carlos Ericksson Richter
Are you trying to iterate over the list after calling a broker.close()? Richter Keith Rogers wrote: I'm developing a web application using OJB, and every now and then I have the ResourceClosedException come up when iterating over a list. I think I understand what the exception means, but I'm

Re: Clustered cache with OSCache JavaGroups

2004-04-22 Thread Jason McKerr
OK, I won't be able to exactly duplicate your environment since we don't have any windows computers here at the Open Source Lab, but I'll see what I can get. Shouldn't matter anyway, but it always seems too... Jason On Thu, 2004-04-22 at 00:10, Enrique Medina wrote: Websphere Server within

Re: auto-update=link with ODMG

2004-04-22 Thread Armin Waibel
Hi Pirmin, when using the top-level api (OTM, ODMG, JDO) it is (currently) madatory for all types of references to use 'false' for auto-delete/update, e.g. see http://db.apache.org/ojb/repository.html#reference-descriptor Pirmin Kalberer wrote: It seems that auto-update=link or none is not

Re: OJB - Query for two table join

2004-04-22 Thread Info
Enrique Medina wrote: Hi Wallace, You have to use a ReportQueryByCriteria() where you can specify which attributes you want OJB to return instead of a getCollection(). Following your example: Criteria crit = new Criteria(); // Set criterias ... crit.addEqualTo(...); // Create the report

Re: Description Repositories at Thread level

2004-04-22 Thread Armin Waibel
Hi Sridhar, in your case you can setup two different repository and read the second one at runtime (with both jdbc-connection-descriptor declared in the default repository, in the second one only declare object metadata - then you don't need to read and merge the second ConnectionRepository)

RE: deploying OJB in Jboss

2004-04-22 Thread Stephen Ting
Hi Armin, Please find below howto to deploy ojb as an ear file. Here is an example of the .ear package structure. It is redeployable without having to restart Jboss. /ejb.jar/ ...EJBs ...META-INF/ ..ejb-jar.xml ..jboss.xml ..MANIFEST.MF /web-app.war/ ...JSP ...WEB-INF/