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

[ https://issues.apache.org/jira/browse/DERBY-4551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070977#comment-13070977 ] Thomas Hill commented on DERBY-4551: Thanks for your reply and for sharing background

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

[ https://issues.apache.org/jira/browse/DERBY-4249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070975#comment-13070975 ] Knut Anders Hatlen commented on DERBY-4249: --- Some comments in addition to what D

[jira] [Closed] (DERBY-5349) Clean docs build fails to pick up customized map2htmtoc.xsl

[ https://issues.apache.org/jira/browse/DERBY-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen closed DERBY-5349. - Resolution: Fixed Fix Version/s: 10.9.0.0 The fix that went in with DERBY-4408 fix

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

[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070953#comment-13070953 ] Knut Anders Hatlen commented on DERBY-4408: --- Looks good. +1 > missing DOCTYPE a

New developer, need a little help with a subquery

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 wor

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

[ https://issues.apache.org/jira/browse/DERBY-5342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070882#comment-13070882 ] Bryan Pendleton commented on DERBY-5342: For me, too, the individual tests run cor

[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

[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070878#comment-13070878 ] Kathey Marsden commented on DERBY-3676: --- In terms of compatibility, I think it is f

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

[ 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 addr

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

[ 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 updat

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

[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070774#comment-13070774 ] Dag H. Wanvik commented on DERBY-5350: -- Back-ported to 10.8 branch as svn 1150919, re

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

[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070751#comment-13070751 ] Dag H. Wanvik commented on DERBY-5350: -- Committed to docs trunk at svn 1150905, will

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

[ https://issues.apache.org/jira/browse/DERBY-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070741#comment-13070741 ] Brett Mason commented on DERBY-5351: Sorry about the duplicate, the other issue didn't

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

[ 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 i

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

[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070682#comment-13070682 ] Knut Anders Hatlen commented on DERBY-4408: --- Yes, that ought to do the trick. +1

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

[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070675#comment-13070675 ] Kim Haase commented on DERBY-4408: -- That was careless of me! I see the same warning now -

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

"Bergquist, Brett" 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" class and othe

Re: Topic at Derby IRC channel

On 7/25/11 9:16 AM, Dag H. Wanvik wrote: Kathey Marsden 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

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

[ 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

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

[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070667#comment-13070667 ] Knut Anders Hatlen commented on DERBY-4408: --- Yes, but the property should be nam

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

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-5350) Devguide needs update for definer's rights

[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070624#comment-13070624 ] Kim Haase commented on DERBY-5350: -- This looks great, Dag -- +1. Glad you corrected the r

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

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 load

RE: Question on Derby Style Table Functions

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 _

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

[ 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 DE

[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

[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070595#comment-13070595 ] Kathey Marsden commented on DERBY-3676: --- I checked officers/iclas.txt and the email

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

[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070586#comment-13070586 ] Knut Anders Hatlen commented on DERBY-4408: --- I think it's sufficient to run "svn

Re: Topic at Derby IRC channel

Kathey Marsden 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 resource to put there que

[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

[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070579#comment-13070579 ] Kathey Marsden commented on DERBY-3676: --- The list of ICLA's is here: http://people.a

Re: Question on Derby Style Table Functions

"Bergquist, Brett" 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 or updates requ

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

[ 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 prev

Regression Test Report - Daily 1150425 - Sun DBTG

[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] [Commented] (DERBY-5350) Devguide needs update for definer's rights

[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070555#comment-13070555 ] Dag H. Wanvik commented on DERBY-5350: -- Thanks, Kim! I also noticed I should have use

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

[ https://issues.apache.org/jira/browse/DERBY-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070553#comment-13070553 ] Dag H. Wanvik commented on DERBY-5329: -- +1, looks good to me. > Document who is all

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

[ https://issues.apache.org/jira/browse/DERBY-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070552#comment-13070552 ] Kim Haase commented on DERBY-5350: -- Thanks, Dag, for picking this up! I was puzzling it o

[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

[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070549#comment-13070549 ] Dag H. Wanvik commented on DERBY-3676: -- Tiago, I am inclined to agree with your two p

[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

[ https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070547#comment-13070547 ] Dag H. Wanvik commented on DERBY-3676: -- Siddharth: Cf. org.apache.derby.diag.Statemen

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

[ 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] [Updated] (DERBY-5350) Devguide needs update for definer's rights

[ 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] [Updated] (DERBY-5350) Devguide needs update for definer's rights

[ 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 t

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

[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070539#comment-13070539 ] Kim Haase commented on DERBY-4408: -- I can file a patch that changes the eol-style for tho

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

[ https://issues.apache.org/jira/browse/DERBY-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070508#comment-13070508 ] Kim Haase commented on DERBY-4408: -- Committed patch DERBY-4408-4.diff to documentation tr

[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

[ https://issues.apache.org/jira/browse/DERBY-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070497#comment-13070497 ] Dag H. Wanvik commented on DERBY-5044: -- Referring to https://issues.apache.org/jira/

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

[ https://issues.apache.org/jira/browse/DERBY-4249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070495#comment-13070495 ] Dag H. Wanvik commented on DERBY-4249: -- I tried to let the nested VM exit with a Syst

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

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-4551) Allow database user to execute stored procedures with same permissions as database owner and/or routine definer

[ https://issues.apache.org/jira/browse/DERBY-4551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070479#comment-13070479 ] Dag H. Wanvik commented on DERBY-4551: -- You are right that there is no SESSION_ROLE t

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

[ https://issues.apache.org/jira/browse/DERBY-5342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070468#comment-13070468 ] Houx Zhang commented on DERBY-5342: --- When tested individually, each of them is OK. It's

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

[ https://issues.apache.org/jira/browse/DERBY-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070351#comment-13070351 ] Knut Anders Hatlen commented on DERBY-5351: --- I ran the attached test case with 1