RE: p6spy in webapp
http://www.p6spy.com/documentation/install.htm#tomcat The properties file is the spy.properties file (a sample should be in your p6spy download). You can put that anywhere in the classpath. P6Spy will use the classloader to pick it up. In the spy.properties you'd specify your "real" JDBC driver (example Mysql or SQLServer driver). In OJB you'd edit your repository.xml and specify p6spy (not your realdriver) as your driver in your jdbc descriptor. So p6spy is just a wrapper around your real driver, it'll catch your OJB generated queries and print them out to where ever you told it too in your spy.properties file. -Original Message- From: Gerhard Hipfinger [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 6:22 PM To: OJB Users List Subject: Re: p6spy in webapp hi charlie, take a look at http://www.p6spy.com/ there you can get much more information about p6spy than on the ojb site. the properties file you mentioned is thy spy.properties. put it to your classpath (i.e. WEB-INF/classes). you can get an example from the url above. the file is documented very well, you should have no problems whith. gerhard Am Fre, den 20.02.2004 schrieb Charles N. Harvey III um 00:32: > Hello. > I looked for this on mail-archive.com but could not find exactly what I > was looking for. The FAQ on the site explains how to setup p6spy when > running test cases. I want to run it in my webapp. Put the p6spy-1.3.jar > in my WEB-INF/lib/ directory and set some settings in some properties > file. Well, which properties file? I'm just uncertain of what to change > and where. > > If someone can maybe send me a link to where this has been explained before > I would be greatful. Thanks. > > > Charlie > > > - > 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: p6spy in webapp
http://www.p6spy.com/documentation/install.htm#tomcat The properties file is the spy.properties file (a sample should be in your p6spy download). You can put that anywhere in the classpath. P6Spy will use the classloader to pick it up. In the spy.properties you'd specify your "real" JDBC driver (example Mysql or SQLServer driver). In OJB you'd edit your repository.xml and specify p6spy (not your realdriver) as your driver in your jdbc descriptor. So p6spy is just a wrapper around your real driver, it'll catch your OJB generated queries and print them out to where ever you told it too in your spy.properties file. -Original Message- From: Gerhard Hipfinger [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 6:22 PM To: OJB Users List Subject: Re: p6spy in webapp hi charlie, take a look at http://www.p6spy.com/ there you can get much more information about p6spy than on the ojb site. the properties file you mentioned is thy spy.properties. put it to your classpath (i.e. WEB-INF/classes). you can get an example from the url above. the file is documented very well, you should have no problems whith. gerhard Am Fre, den 20.02.2004 schrieb Charles N. Harvey III um 00:32: > Hello. > I looked for this on mail-archive.com but could not find exactly what I > was looking for. The FAQ on the site explains how to setup p6spy when > running test cases. I want to run it in my webapp. Put the p6spy-1.3.jar > in my WEB-INF/lib/ directory and set some settings in some properties > file. Well, which properties file? I'm just uncertain of what to change > and where. > > If someone can maybe send me a link to where this has been explained before > I would be greatful. Thanks. > > > Charlie > > > - > 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Create Table in OJB
I need to develop an application that will create tables dynamically. Is there a way to do that in OJB without using QueryBySQL. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
MS SQL Server Sequence Solution
My Dev group is planning on implementing the MSSQL sequence solution describe here http://db.apache.org/ojb/sequencemanager.html#Oracle-style%20sequencing One of our developers raised a concern about using this method within transactions. What happens during a rollback? For example. One process gets the next val. Let's say it returns 10, and another process get's 11. What happens to the OJB_NEXT_VAL table if the transaction (the one that got 10) was rolled back? Also on a side note. Is there anyone developing a MS SQL Server Sequencer? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
select column criteria
Hey I am trying to limit the columns returned in a select query. Instead of doing a "select * from table" I'd like to do a "select id from table" the reason is that the table is HUGE. And returning all the rows would probably kill the VM. Anyone know how? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
How to do Max Query
I am trying to do the equivilant of select * from account where date_last_updated IN (Select max(date_last_updated) from account ) IN OJB. I am using the PersistanceBroker. Does anyone know who to do this? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]