Yep...found that about 10 minutes before this email. Thanks,
Joe
On Thursday 10 October 2002 12:46 pm, you wrote:
> hi joe,
>
> there's an error in ojb.properties caused be renaming of pachages.
> use the following to enable logging of SqlGenerator:
>
> # Loger for SqlGenerator, useful for debugging generation of SQL
> org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=DEBU
>G
>
> hth
> jakob
>
> ----- Original Message -----
> From: "Joseph Campbell" <[EMAIL PROTECTED]>
> To: "OJB Users List" <[EMAIL PROTECTED]>
> Sent: Thursday, October 10, 2002 5:24 PM
> Subject: Re: SqlGenerator Debugging...
>
>
> The system I am using is small and I know the data being inserted... in
> this case I am just looking to verify the SQL that is being generated. We
> recently moved from 0.9.5 to 0.9.6 and this is now broken. Just looking to
> see if the generated SQL has changed as well.
>
> Thanks,
> joe
>
> PS: I am just really wondering why the setting for Loggin level in the
> OJB.properties file is being ignored (Or seeminly ignored...)
>
> On Thursday 10 October 2002 9:54 am, Charles Anthony wrote:
> > I'm not sure I can directly help you with the LOG entries (though I
>
> suspect
>
> > you are on the right track). However, I strongly suggest that for logging
> > SQL statements, you use the p6spy jdbc driver included in the OJB
> > distribution (for detailed usage information, see p6spy.sourceforge.net -
> > essentially in the repository.xml, change the driver class to the p6spy
> > driver class, and then configure spy.properties to point to your own JDBC
> > driver).
> >
> > The reason I recommend p6spy is that it logs both the SQL statement AND
>
> the
>
> > values bound to the prepared statement i.e. the full SQL statement
>
> executed
>
> > by the database. The OJB (AFAIK) logging only logs the generated SQL
> > statement e.g.
> > SELECT COL1, COL2, COL3 from TABLE where COL1 = ? AND COL2 = ?
> >
> > p6Spy would log
> > SELECT COL1, COL2, COL3 from TABLE where COL1 = ? AND COL2 = ? | SELECT
> > COL1, COL2, COL3 from TABLE where COL1 = 1 AND COL2 = 'Some Text'
> >
> > Which is frequently far more useful !
> >
> > Cheers,
> >
> > Charles.
> >
> > >-----Original Message-----
> >
> > From: Joseph Campbell [mailto:[EMAIL PROTECTED]]
> >
> > >Sent: 10 October 2002 14:59
> > >To: OJB Users List
> > >Subject: SqlGenerator Debugging...
> > >
> > >
> > >I just recently moved up to 0.9.6 and it seems that the
> > >SqlGenerator log4j
> > >entry of the OJB.properties file is being entirly ignored?
> > >Did this class
> > >move or change names? Is there a small bug that is keeping
> > >that setting from
> > >getting down to the SqlGenerator class?
> > >
> > >HELP - I am getting an INSERT error and I can not see the SQL
> > >that it is
> > >attempting to use.
> > >
> > >Thanks,
> > > Joe Campbell
> > >
> > >--
> > >You laugh at me because I am different,
> > >I laugh at you because you are the same.
> > >-----------------------------------------------------
> > >Joseph Campbell | EMAIL: [EMAIL PROTECTED]
> > >Staff Consultant | URL: www.inventa.com
> > >Inventa Technologies | PH: (856)914-5200
> > >
> > > | PGER: (888)454-0876
> > >
> > >-----------------------------------------------------
> > >
> > >
> > >--
> > >To unsubscribe, e-mail:
> >
> > <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> > This email and any attachments are strictly confidential and are intended
> > solely for the addressee. If you are not the intended recipient you must
> > not disclose, forward, copy or take any action in reliance on this
> > message or its attachments. If you have received this email in error
> > please notify the sender as soon as possible and delete it from your
> > computer systems. Any views or opinions presented are solely those of the
> > author and do not necessarily reflect those of HPD Software Limited or
> > its affiliates.
> >
> > At present the integrity of email across the internet cannot be
>
> guaranteed
>
> > and messages sent via this medium are potentially at risk. All liability
> > is excluded to the extent permitted by law for any claims arising as a
> > re- sult of the use of this medium to transmit information by or to
> > HPD Software Limited or its affiliates.
--
You laugh at me because I am different,
I laugh at you because you are the same.
-----------------------------------------------------
Joseph Campbell | EMAIL: [EMAIL PROTECTED]
Staff Consultant | URL: www.inventa.com
Inventa Technologies | PH: (856)914-5200
| PGER: (888)454-0876
-----------------------------------------------------
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
