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