[jira] [Resolved] (DERBY-5351) SYSCS_UTIL.SYSCS_COMPRESS_TABLE causes concurrent transactions to fail

2011-07-25 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen resolved DERBY-5351. --- Resolution: Duplicate This is most likely the same bug as DERBY-4275. A fix was

[jira] [Commented] (DERBY-5351) SYSCS_UTIL.SYSCS_COMPRESS_TABLE causes concurrent transactions to fail

2011-07-25 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070351#comment-13070351 ] Knut Anders Hatlen commented on DERBY-5351: --- I ran the attached test case with

[jira] [Commented] (DERBY-5342) make ScriptTestCase support ij.showNoCountForSelect and ij.showNoConnectionsAtStart

2011-07-25 Thread Houx Zhang (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070468#comment-13070468 ] Houx Zhang commented on DERBY-5342: --- When tested individually, each of them is OK. It's

[jira] [Commented] (DERBY-4551) Allow database user to execute stored procedures with same permissions as database owner and/or routine definer

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070479#comment-13070479 ] Dag H. Wanvik commented on DERBY-4551: -- You are right that there is no SESSION_ROLE

Re: Problem in trying to get a Restricted Table Function loaded

2011-07-25 Thread Bergquist, Brett
In case this got missed as I could really use the help. Just need to know what I need to do to get the VYI classes to be accessible to my table function. As a straight table function it registers and works fine but as soon as I reference something like VTITemplate it fails saying it could not

[jira] [Commented] (DERBY-4249) Create a simple store recovery test in JUnit

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070495#comment-13070495 ] Dag H. Wanvik commented on DERBY-4249: -- I tried to let the nested VM exit with a

[jira] [Commented] (DERBY-5044) ALTER TABLE DROP COLUMN will not detect triggers defined on other tables with their trigger action using the column being dropped

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070497#comment-13070497 ] Dag H. Wanvik commented on DERBY-5044: -- Referring to

[jira] [Commented] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070508#comment-13070508 ] Kim Haase commented on DERBY-4408: -- Committed patch DERBY-4408-4.diff to documentation

[jira] [Commented] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070539#comment-13070539 ] Kim Haase commented on DERBY-4408: -- I can file a patch that changes the eol-style for

[jira] [Updated] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-5350: - Attachment: cdevcsecureroles.html derby-5330a.diff Uploading a patch that fixes

[jira] [Updated] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-5350: - Issue fix info: [Patch Available] Devguide needs update for definer's rights

[jira] [Assigned] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik reassigned DERBY-5350: Assignee: Dag H. Wanvik Devguide needs update for definer's rights

[jira] [Commented] (DERBY-3676) Make the toString() method of Derby PreparedStatements print out SQL text with ? parameters replaced by the values that have been set so far

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070547#comment-13070547 ] Dag H. Wanvik commented on DERBY-3676: -- Siddharth: Cf.

[jira] [Commented] (DERBY-3676) Make the toString() method of Derby PreparedStatements print out SQL text with ? parameters replaced by the values that have been set so far

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070549#comment-13070549 ] Dag H. Wanvik commented on DERBY-3676: -- Tiago, I am inclined to agree with your two

[jira] [Commented] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070552#comment-13070552 ] Kim Haase commented on DERBY-5350: -- Thanks, Dag, for picking this up! I was puzzling it

[jira] [Commented] (DERBY-5329) Document who is allowed to run which system procedures/functions.

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070553#comment-13070553 ] Dag H. Wanvik commented on DERBY-5329: -- +1, looks good to me. Document who is

[jira] [Commented] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070555#comment-13070555 ] Dag H. Wanvik commented on DERBY-5350: -- Thanks, Kim! I also noticed I should have

Regression Test Report - Daily 1150425 - Sun DBTG

2011-07-25 Thread Ole . Solberg
[Auto-generated mail] *Daily* 1150425/2011-07-24 18:00:25 MEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin F:1,E:11421014208 0 1547.11% suitesAll 01515 0 .% jdbcapiAutoLoad

[jira] [Updated] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-5350: - Attachment: derby-5350b.diff cdevcsecureroles.html Uploading a new patch and

Re: Question on Derby Style Table Functions

2011-07-25 Thread Dag H. Wanvik
Bergquist, Brett bbergqu...@canoga.com writes: I am implementing a poor man's data partitioning with data being inserted into different tables depending on the week of the year. I want to bring these tables back together as single virtual unified table that can be queried up only, no inserts

[jira] [Commented] (DERBY-3676) Make the toString() method of Derby PreparedStatements print out SQL text with ? parameters replaced by the values that have been set so far

2011-07-25 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070579#comment-13070579 ] Kathey Marsden commented on DERBY-3676: --- The list of ICLA's is here:

Re: Topic at Derby IRC channel

2011-07-25 Thread Dag H. Wanvik
Kathey Marsden kmarsdende...@sbcglobal.net writes: Wouldn't it be a good idea, to include URLs to derby user mailing list and developer mailing lists in the topic of Derby IRC channel, so that those users/developers who migrate from projects frequently using IRC can easily know the best

[jira] [Commented] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070586#comment-13070586 ] Knut Anders Hatlen commented on DERBY-4408: --- I think it's sufficient to run svn

[jira] [Commented] (DERBY-3676) Make the toString() method of Derby PreparedStatements print out SQL text with ? parameters replaced by the values that have been set so far

2011-07-25 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070595#comment-13070595 ] Kathey Marsden commented on DERBY-3676: --- I checked officers/iclas.txt and the email

[jira] [Updated] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase updated DERBY-4408: - Attachment: DERBY-4408-5.stat DERBY-4408-5.diff Thanks, Knut, for that info. Attaching

RE: Question on Derby Style Table Functions

2011-07-25 Thread Bergquist, Brett
Thanks Dag. I have tested this and it does work. I did not know how or when to close the prepared statements, etc., but through the example I can see that when I implement the ResultSet interface I can leverage on its close method. Thanks for taking the time to get back. Brett

Code loaded through SQL.INSTALL_JAR does not have access to derby API code. Is this expected?

2011-07-25 Thread Bergquist, Brett
I found some information. I found that if I include my JAR file containing my Restricted Table code in the classpath before starting the network server, then the code can load correctly and it has access to the org.apache.derby.vti.RestrictedVTI class and others. If however the code is

[jira] [Commented] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070624#comment-13070624 ] Kim Haase commented on DERBY-5350: -- This looks great, Dag -- +1. Glad you corrected the

RE: Code loaded through SQL.INSTALL_JAR does not have access to derby API code. Is this expected?

2011-07-25 Thread Bergquist, Brett
So in UpdateLoader.java there is: private static final String[] RESTRICTED_PACKAGES = { // While loading java. classes is blocked by the standard // class loading mechanism, javax. ones are not. However // allowing database applications to override jvm classes

[jira] [Commented] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070667#comment-13070667 ] Knut Anders Hatlen commented on DERBY-4408: --- Yes, but the property should be

[jira] [Resolved] (DERBY-5329) Document who is allowed to run which system procedures/functions.

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase resolved DERBY-5329. -- Resolution: Fixed Issue fix info: (was: [Patch Available]) Thanks, Dag! I think we're all

Re: Topic at Derby IRC channel

2011-07-25 Thread Jean T. Anderson
On 7/25/11 9:16 AM, Dag H. Wanvik wrote: Kathey Marsdenkmarsdende...@sbcglobal.net writes: Wouldn't it be a good idea, to include URLs to derby user mailing list and developer mailing lists in the topic of Derby IRC channel, so that those users/developers who migrate from projects frequently

Re: Code loaded through SQL.INSTALL_JAR does not have access to derby API code. Is this expected?

2011-07-25 Thread Knut Anders Hatlen
Bergquist, Brett bbergqu...@canoga.com writes: I found some information. I found that if I include my JAR file containing my Restricted Table code in the classpath before starting the network server, then the code can load correctly and it has access to the org.apache.derby.vti.RestrictedVTI

[jira] [Commented] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070675#comment-13070675 ] Kim Haase commented on DERBY-4408: -- That was careless of me! I see the same warning now

[jira] [Commented] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070682#comment-13070682 ] Knut Anders Hatlen commented on DERBY-4408: --- Yes, that ought to do the trick. +1

[jira] [Updated] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Kim Haase (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase updated DERBY-4408: - Attachment: DERBY-4408-6.stat DERBY-4408-6.diff Thanks again, Knut. Well, now the patch

[jira] [Commented] (DERBY-5351) SYSCS_UTIL.SYSCS_COMPRESS_TABLE causes concurrent transactions to fail

2011-07-25 Thread Brett Mason (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070741#comment-13070741 ] Brett Mason commented on DERBY-5351: Sorry about the duplicate, the other issue didn't

[jira] [Commented] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070751#comment-13070751 ] Dag H. Wanvik commented on DERBY-5350: -- Committed to docs trunk at svn 1150905, will

[jira] [Commented] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070774#comment-13070774 ] Dag H. Wanvik commented on DERBY-5350: -- Back-ported to 10.8 branch as svn 1150919,

[jira] [Resolved] (DERBY-5350) Devguide needs update for definer's rights

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik resolved DERBY-5350. -- Resolution: Fixed Issue fix info: (was: [Patch Available]) Devguide needs update

[jira] [Updated] (DERBY-5325) Checkpoint fails with ClosedChannelException in InterruptResilienceTest

2011-07-25 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-5325: - Attachment: derby-5325-refactor-b.diff Attaching version b of the refactoring patch, which

[jira] [Commented] (DERBY-3676) Make the toString() method of Derby PreparedStatements print out SQL text with ? parameters replaced by the values that have been set so far

2011-07-25 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070878#comment-13070878 ] Kathey Marsden commented on DERBY-3676: --- In terms of compatibility, I think it is

[jira] [Commented] (DERBY-5342) make ScriptTestCase support ij.showNoCountForSelect and ij.showNoConnectionsAtStart

2011-07-25 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-5342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070882#comment-13070882 ] Bryan Pendleton commented on DERBY-5342: For me, too, the individual tests run

New developer, need a little help with a subquery

2011-07-25 Thread Conor66
Hi everyone. Ive recently started using apache derby. Im a recent graduate and I have a question for you more experienced developers out there. I would be grateful with any help on this. I want to make the two following queries into one, but the count(*) is giving me alot of trouble. They both

[jira] [Commented] (DERBY-4408) missing DOCTYPE and META tags in toc.html and index.html pages

2011-07-25 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13070953#comment-13070953 ] Knut Anders Hatlen commented on DERBY-4408: --- Looks good. +1 missing DOCTYPE