You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Charles Anthony <ch...@hpdsoftware.com> on 2005/08/19 15:19:16 UTC

RE: optimistic locking problems (P6Spy question)

Hi,

In this case, you would have to modify your jndi-datasource to use the
P6SpyDriver...

Cheers,

Charles.

-----Original Message-----
From: Vamsi Atluri [mailto:vkatluri@yahoo.com]
Sent: 19 August 2005 14:22
To: OJB Users List
Subject: Re: optimistic locking problems (P6Spy question)


Hello all,

Sorry to hijack the thread into a question about P6Spy. The P6Spy document
that Armin pointed out here says that we have to modify the "driver"
parameter in the "jdbc-connection-descriptor" of the repository.xml file.
However, I have a managed environment (WSAD/WAS) wherein I do not specify
the driver in the repository.xml file. More specifically, my connection
descriptor is like this:

<jdbc-connection-descriptor 
		jcd-alias="OJBDb" 
		default-connection="true" 
		platform="Db2" 
		jdbc-level="1.0" 
		jndi-datasource-name="jdbc/ojbDataSource"		
		username="*****" 
		password="*****" 
		batch-mode="false" 
		useAutoCommit="1" 
		ignoreAutoCommitExceptions="false">
		<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl">
		    <attribute attribute-name="grabSize"
attribute-value="1"></attribute>
		</sequence-manager>
	</jdbc-connection-descriptor>

Since I am using jndi-datasource-name, I didn't have to specify the
driver. How do I use P6Spy in such cases? Do I just add an additional
parameter for driver? Any help is appreciated. Thank you.

Regards,
-Vamsi


> Did you
> 
> > check the generated sql statements, e.g. via P6Spy (jar is shipped
> with 
> > OJB)?
> > http://db.apache.org/ojb/docu/faq.html#traceProfileSQL
> > 
> > 
> > regards,
> > Armin
> > 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
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

RE: optimistic locking problems (P6Spy question)

Posted by Vamsi Atluri <vk...@yahoo.com>.
Charles,

Thanks for the prompt reply. I will try that. 

Regards,
-Vamsi

--- Charles Anthony <ch...@hpdsoftware.com> wrote:

> Hi,
> 
> In this case, you would have to modify your jndi-datasource to use the
> P6SpyDriver...
> 
> Cheers,
> 
> Charles.
> 
> -----Original Message-----
> From: Vamsi Atluri [mailto:vkatluri@yahoo.com]
> Sent: 19 August 2005 14:22
> To: OJB Users List
> Subject: Re: optimistic locking problems (P6Spy question)
> 
> 
> Hello all,
> 
> Sorry to hijack the thread into a question about P6Spy. The P6Spy
> document
> that Armin pointed out here says that we have to modify the "driver"
> parameter in the "jdbc-connection-descriptor" of the repository.xml
> file.
> However, I have a managed environment (WSAD/WAS) wherein I do not
> specify
> the driver in the repository.xml file. More specifically, my connection
> descriptor is like this:
> 
> <jdbc-connection-descriptor 
> 		jcd-alias="OJBDb" 
> 		default-connection="true" 
> 		platform="Db2" 
> 		jdbc-level="1.0" 
> 		jndi-datasource-name="jdbc/ojbDataSource"		
> 		username="*****" 
> 		password="*****" 
> 		batch-mode="false" 
> 		useAutoCommit="1" 
> 		ignoreAutoCommitExceptions="false">
> 		<sequence-manager
>
className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl">
> 		    <attribute attribute-name="grabSize"
> attribute-value="1"></attribute>
> 		</sequence-manager>
> 	</jdbc-connection-descriptor>
> 
> Since I am using jndi-datasource-name, I didn't have to specify the
> driver. How do I use P6Spy in such cases? Do I just add an additional
> parameter for driver? Any help is appreciated. Thank you.
> 
> Regards,
> -Vamsi
> 
> 
> > Did you
> > 
> > > check the generated sql statements, e.g. via P6Spy (jar is shipped
> > with 
> > > OJB)?
> > > http://db.apache.org/ojb/docu/faq.html#traceProfileSQL
> > > 
> > > 
> > > regards,
> > > Armin
> > > 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> ---------------------------------------------------------------------
> 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
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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