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