On 12/07/2010 12:15 PM, John English wrote:
Can anyone explain what this means? It occurs when I issue what should
be a straightforward insert:
INSERT INTO resource_usage (resid,xmlid,xmltable)
(SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?)
The select returns 64 results, but the ibsert fails.
Can you provide a complete stack trace, e.g., from a derby.log file
from a failed run?
Also, I think that -Derby.language.logStatementText=true will show the
actual values that Derby read for the substituted '?' parameters, which
may provide some additional clues.
thanks,
bryan