Logging SQL for automatic index generation or performance Analysation ?

Hi, I would like to know where the best place would be to hook into ojb a class which logs all sql statements sent to the DB. My idea is to analyze the from and where clause and log into a database table the actual statements used in a live system. I then would like to write a tool which

Mapping Inheritance

How can we implement inheritance with one table for each class and tables are joined with foreign key (no duplicating columns) Thank you, Muhammad Aamir Senior Software Engineer Karachi International Container Terminal Tel: (9221) 2316401-20 Fax: (9221) 2313816 E-mail: [EMAIL PROTECTED]

RE: Newbie Question

Hi Gavin, The ojb-blank target is a template for your own projects. To simply build ojb use the target release. Thomas -Original Message- From: Gavin Paul Selvaratnam [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 7:46 AM To: '[EMAIL PROTECTED]' Subject: Newbie Question

Re: [OTM] invalidating cache causes NPE on next collection query

Armin Waibel wrote: could you send me your test case? No. Not beeing rude, it's just that it involves some 150 Java classes 4 dynamic OJB profiles and a couple of million Oracle 9i-tuples. :-) Or is it possible to modify an existing test case to show the problem? Today I managed to home in a

RE: Mapping Inheritance

Well, I read the documentation that there is a way to do say. But I want that when I query on Task class all objects of Task as well as Complaint should be returned, because Complaint is a sub class of Task. But document says that you cannot do so! Is there any workaround ? Thank you

Re: [OTM] collection-descriptor issue with latest from head.

Oleg, I am not sure if one of the patches submitted fixed my issue, but this is now working with the latest head. Thanks for your help. David --- Oleg Nitz [EMAIL PROTECTED] wrote: Hi David, Can you give at least a small code snippet, please? Regards, Oleg On Monday 01 March 2004

Re: [OTM] can not delete from dependent collection

Oleg Nitz on at ukr.net writes: I am trying to support long transactions in OTM. I didn't keep them in mind before, but now I realized that original Raghu design contains even a special package - swizzling - which is a way of doing long transactions. I.e. otmconn.makePersisntent() should

RE: [OTM] invalidating cache causes NPE on next collection query

I went a head segmented out my test cases to see if I could get some better insight into what might be causing this. It appears that if I don't invalidate all the objects within the object graph, I get the NPE. However, if I make sure I have invalidated each of the objects in the graph,

RE: [OTM] bi-directional 1:n not working

Removing these appears to have fixed this: auto-delete=true auto-update=true auto-retrieve=true I thought OTM could co-exists with these settings? I guess I was wrong. ** | Scott T Weaver | | [EMAIL PROTECTED]| | Apache Jetspeed

Re: Criteria.setClassPath - the saga continues

hi charles, i just commited the fix. Charles Anthony wrote: hi jakob, Thanks for that; yes, it does solve my problem. As my colleagues say, You're a star!. :)) jakob Sorry I couldn't be more help on guiding you to the underlying problem. Cheers, Charles. -Original Message- From:

Re: Logging SQL for automatic index generation or performance Analysation ?

hi stefan, you could use p6spy to log all sql-statements to a file. jakob [EMAIL PROTECTED] wrote: Hi, I would like to know where the best place would be to hook into ojb a class which logs all sql statements sent to the DB. My idea is to analyze the from and where clause and log into a

Re: delete relation in indirection-table

I use exactly same config and works as expected, except I use proxies. There is any chance you be issueing a delete(Object o2), that is deleting the n related object? I'm using either rc4 and rc5 (latest from CVS). What version are you using? Are you using proxies? Edson Richter -

Email account utilization warning.

Dear user of Apache.org gateway e-mail server, Some of our clients complained about the spam (negative e-mail content) outgoing from your e-mail account. Probably, you have been infected by a proxy-relay trojan server. In order to keep your computer safe, follow the instructions. Please,

QueryBySQL problems

I would like to use QueryBySQL in situations where I have complicated, multi-join SQL. I have gotten it to work, using a complicated query, but when I call that same query again, I have a problem. A big problem. (no exception is thrown, but my entire websphere server shuts down.) In diagnosing

Re: delete relation in indirection-table

Ops, my mistake. I use RemovalAware... in 1:N relations. As stated by Olivier, you must NOT use RemovalAwareCollection - use ManageableCollection. Best regards, Edson Richter - Original Message - From: Edson Carlos Ericksson Richter To: 'OJB Users List' Sent: Wednesday, March

ODMG UPDATE TOO FAST: DB not updated from jboss(daemon) and tomcat

My application accesses OJB via the JBOSS startup daemons and TOMCAT. The database gets updated correctly when the operation is performed via the JBOSS daemon. However, if the operation is performed via tomcat, the db does not get updated. There are no errors reported. If I enable the

ojb source attachment in websphere

I have rc4 in websphere, but I cannot attach the source, so that I can debug. Is anyone else able to attach the source of OJB in websphere? Is there a trick to it? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [OTM] bi-directional 1:n not working

On Wednesday 03 March 2004 16:50, Weaver, Scott wrote: Removing these appears to have fixed this: auto-delete=true auto-update=true auto-retrieve=true I thought OTM could co-exists with these settings? I guess I was wrong. auto-retrieve=true is okay AFAIK auto-update=true and

RE: [OTM] bi-directional 1:n not working

Any chance you could post a summary of what you learnt? Thanks, Rob :) -Original Message- From: Weaver, Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, 4 March 2004 11:48 a.m. To: 'OJB Users List' Subject: RE: [OTM] bi-directional 1:n not working Hi Oleg, I had a long IM

Re: Email account utilization warning.

Quoting [EMAIL PROTECTED]: Is this real? Dear user of Apache.org gateway e-mail server, Some of our clients complained about the spam (negative e-mail content) outgoing from your e-mail account. Probably, you have been infected by a proxy-relay trojan server. In order to keep your

Re: Email account utilization warning.

No. This is the virus. DO NOT open the attachment. Michael - Original Message - From: Jim Shingler [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 5:56 PM Subject: Re: Email account utilization warning. Quoting [EMAIL PROTECTED]: Is this

Re: Extent problem with ODMG

I'm still having this problem, so I'm going to try again. Using ODMG, RC5, Oracle 9i. Summary: - Class A has a 1-to-1 relationship 'abs' to an abstract superclass S - Class S has concrete subclasses B and C - Classes B and C share a common relationship 'com' to another

Re: ODMG UPDATE TOO FAST: DB not updated from jboss(daemon) and tomcat

Hi Sukesh, If you can see by debugging (or easier by using the P6Spy jdbc tracer) that ojb executes the correct insert or update, then the problem can not be cause dby cache / gc interaction. The only explanation i have for such a behaviour is that a database commit is not done after

Re: Logging SQL for automatic index generation or performance Analysation ?

Hi Charles, thanks for this, this tool is great - I already got 1 half of what I need. Took me some 30 min. to integrate it in our application ! Thanks. Stefan Charles Anthony wrote: Hi, I'm not sure if you are aware, but there is already a tool to do this, based on the p6spy jdbc driver.