Issue Details (XML | Word | Printable)

Key: NUCRDBMS-249
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Improve debug SQL info to allow output of param values without angle brackets

Created: 25/Aug/09 02:01 PM   Updated: 11/Sep/09 08:41 AM   Resolved: 25/Aug/09 02:19 PM
Component/s: Schema
Affects Version/s: None
Fix Version/s: 2.0.0.m2


 Description  « Hide
When DEBUG logging is turned on the actual SQL is output. By default any parameter values are shown in angle brackets like this
INSERT INTO LIST1_ITEMS (LIST1_ID_OID,CONTAINERITEM_ID_EID,IDX) VALUES (<1>,<3>,<2>)

It would be nice to have a persistence property that allows this to be displayed as
INSERT INTO LIST1_ITEMS (LIST1_ID_OID,CONTAINERITEM_ID_EID,IDX) VALUES (1,3,2)

to allow direct usage of the SQL

Andy Jefferson added a comment - 25/Aug/09 02:19 PM
Persistence property "datanucleus.rdbms.sqlParamValuesInBrackets" allows this to be turned off

Andy Jefferson made changes - 25/Aug/09 02:19 PM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 11/Sep/09 08:41 AM
Status Resolved [ 5 ] Closed [ 6 ]