Re: Derby SQL ideas needed

2010-09-18 Thread Karl Wright
For what it's worth, defining a Derby function seems like the only way to do it. These seem to call arbitrary java that can accept a query as an argument and return a resultset as the result. But in order to write such a thing I will need the ability to call Derby at a java level, I think,

Re: Derby SQL ideas needed

2010-09-18 Thread Karl Wright
The Derby table-result function syntax requires all output columns to be declared as part of the function definition, and more importantly it does not seem to allow calls into Derby itself to get results. So this would not seem to be a viable option for that reason. Back to square 1, I guess.

[jira] Commented: (CONNECTORS-109) Queue status report fails under Derby

2010-09-18 Thread Karl Wright (JIRA)
[ https://issues.apache.org/jira/browse/CONNECTORS-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1293#action_1293 ] Karl Wright commented on CONNECTORS-109: Made most of the necessary code

[jira] Commented: (CONNECTORS-109) Queue status report fails under Derby

2010-09-18 Thread Karl Wright (JIRA)
[ https://issues.apache.org/jira/browse/CONNECTORS-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12911146#action_12911146 ] Karl Wright commented on CONNECTORS-109: Committed the set of changes necessary

[jira] Created: (CONNECTORS-110) Max activity and Max bandwidth reports fail under Derby with a stack trace

2010-09-18 Thread Karl Wright (JIRA)
Max activity and Max bandwidth reports fail under Derby with a stack trace -- Key: CONNECTORS-110 URL: https://issues.apache.org/jira/browse/CONNECTORS-110 Project: Apache