db-ojb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Reda Benzair <reda.benz...@smartjog.com>
Subject un outil interessant pour la supervission des statment JDBC
Date Thu, 04 Mar 2004 11:17:39 GMT
suite à une discution dans OJB forum
il y un autil tres interessant Open Source pour la suppervission au 
niveau du JDBC
interessant de voir ça si en peut l'integer chez nous
http://www.irongrid.com/catalog/product_info.php?products_id=32


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.
>It's available under the Apache license too.
>
>I believe the only thing it doesn't do is the analysis of the data to
>suggest indices.
>
>http://www.irongrid.com/catalog/product_info.php?products_id=32
>
>I've only glanced at the tool, not used it.
>
>Even if that tool is not what you want, it's probably better to extend the
>p6spy driver  to do what you want - as it would be applicable across all
>environments that use jdbc
>
>Cheers,
>
>Charles.
>
>
>  
>
>>-----Original Message-----
>>From: sschloesser@intermediate.de [mailto:sschloesser@intermediate.de]
>>Sent: 03 March 2004 08:32
>>To: ojb-user@db.apache.org
>>Subject: 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 analyzes this table and suggests the 
>>"best" indices to
>>create on the database.
>>
>>To make sure I really catch all statements I would like to 
>>directly hook
>>into ojb. Also, this could then easily be re-used.
>>
>>We thought about a trace but the amount of data just seems to big.
>>
>>Any ideas / suggestions ?
>>
>>Thanks,
>>  Stefan Schlösser
>>
>>
>>--------------------------------------------------------------
>>-----------
>>
>>I N T E R M E D I A T E GmbH & Co. KG
>>eSolutions & Integration
>>
>>Durmersheimer Straße 55     t +49 (0)721.98644-50
>>76185 Karlsruhe             f +49 (0)721.98644-99
>>http://www.intermediate.de
>>
>>P.S. Als Beratungs- und Systemhaus optimiert Intermediate die
>>Geschäftsprozesse mittelständischer Unternehmen in Vertrieb,
>>Marketing und Kundenservice.
>>Tätigkeitsschwerpunkte sind Angebots- und Produkt-Konfiguration
>>sowie Enterprise Content-Management-Systeme.
>>Unsere besondere Stärke liegt in der Integration bestehender
>>Systeme, insbesondere von ERP-Systemen wie SAP R/3, BRAIN AS,
>>MAS90 etc.
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>>    
>>
>
>
>___________________________________________________________
>HPD Software Ltd. - Helping Business Finance Business
>Email terms and conditions: www.hpdsoftware.com/disclaimer 
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>  
>


-- 
*Reda BENZAIR**
*Software Analyst

***
*Phone: +33 (0)1 4996 6324
Fax: +33 (0)1 4996 6405
Mobile: +33 (0)6 6240 6192
reda.benzair@smartjog.com <mailto:reda.benzair@smartjog.com>

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


Mime
View raw message