I see the comment in the Parameter interface about default values only 
being supported in 11g.  I know that mssql's metadata doesn't contain the 
default values (stupidly) but it wouldn't be that hard to parse the 
definition from sql_modules to get the default value? Probably don't need a 
full tsql grammer or this.  I realize its hacky...but we have thousands of 
stored procedures that take default values and its really unfortunate that 
we lose the feature entirely.

In the meantime - I'm not entirely sure why AbstractRoutine#addInParameter 
defaults the values to null.  Maybe it could default to something that you 
could detect later and chose to just omit that parameter so that the 
database would use its default?

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to