RE: Intercepting updates and inserts

2004-06-01 Thread Göschl,Siegfried
Hi Robert,

I don't work with OJB but your requirement could be fulfilled with a JDBC proxy such 
as P6Spy. Or an elegant solution would be a clustered JDBC driver such as C-JDBC 
http://c-jdbc.objectweb.org/ 

Cheers,

Siegfried Goeschl

-Original Message-
From: Coup, Robert Muir [mailto:[EMAIL PROTECTED] 
Sent: Sonntag, 30. Mai 2004 06:51
To: OJB Users List
Subject: Intercepting updates and inserts


Hi all,

We're using OJB to interface our application to an online database
(Postgre) as well as an offline database (HSQLDB). I'm in the process of writing some 
simple replication code to allow offline updates to be reconciled when the data is 
synchronised with the online database.

What I would like to do is to intercept each update or delete being run by OJB and log 
some information about it (statement type, table, user, time, etc) it to another 
table. I could make all the persistent objects implement PersistenceBrokerAware and 
then do the logging in afterUpdate and afterDelete, but that isn't a stunningly 
elegant solution and I was wondering if there was another place I could hook into 
which wouldn't involve making changes to my persistent classes? If not, where would be 
the best place to jump into the OJB source to do what I need?

Thanks again,

Rob :)

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: WebSphere Site Developer Test Env with P6Spy

2004-01-28 Thread Göschl,Siegfried
Hi Jay,

for IDE debugging with WSAD I'm not using a Datasource but a JDBC connection because 
in the case of the datasource you have to set up the datasource for each developer box 
manually

Cheers,

Siegfried Goeschl


-Original Message-
From: Jay Xu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 2:14 AM
To: OJB Users List
Subject: WebSphere Site Developer Test Env with P6Spy


Hello, group,

Has anyone successfully configured P6Spy in Websphere Test Environment (5.0)  with 
DataSource?

I have a DataSource myDS defined and then changed name to myDSReal. Then I configured 
P6Spy DataSource with name myDS. Then I modified spy.properties as follows,

realdriver=com.ibm.as400.access.AS400JDBCDriver
realdatasource=myDSReal
realdatasourceclass=com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
realdatasourceproperties=port;3306,serverName;myserver

I do see a spy.log file is created, but see following error from console,

[1/27/04 16:53:20:851 PST]  de42baf FreePool  E J2CA0046E: Method 
createManagedConnctionWithMCWrapper caught an exception during creation of the 
ManagedConnection for resource jdbc/ms4pib, throwing ResourceAllocationException.  
Original exception: com.ibm.ws.exception.WsException: DSRA8101E: DataSource class 
cannot be used as one-phase: ClassCastException: 
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource

  at 
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.init(DataStoreAdapterException.java:222)

  at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.

If you have successfully configured P6Spy  in WebSphere Test Env 5.0 with DataSource, 
please help! 

Thank you!

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: CVS access

2004-01-14 Thread Göschl,Siegfried
Hi Guillaume,

are you behind a firewall?!

Siegfried Goeschl

-Original Message-
From: Guillaume Nodet [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 11:48 AM
To: OJB Users List
Subject: CVS access


I'm trying to access the cvs server, but i can not figure how to login in.
I tried the following using 'anoncvs' as password:

$ cvs login
Logging in to :pserver:[EMAIL PROTECTED]:2401/home/cvspublic
CVS password:
cvs [login aborted]: connect to cvs.apache.org(209.237.227.194):2401 failed:
Connection refused

Guillaume



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]