[jira] Updated: (DERBY-4272) SQL Authorization Support for dblook

2009-12-15 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-4272: --- Attachment: DERBY-4272-changes-u6.txt DERBY-4272-u6.patch Uploading

Re: Using ij to Run Scripts

2009-09-28 Thread Hiranya Jayathilaka
On Mon, Sep 28, 2009 at 1:38 PM, Knut Anders Hatlen wrote: > Hiranya Jayathilaka writes: > > > Hi Folks, > > > > I'm using ij#runScript method to execute a script against a database. > When ij > > encounters an error while running the script (say due to

Using ij to Run Scripts

2009-09-27 Thread Hiranya Jayathilaka
stead? Thanks -- Hiranya Jayathilaka Software Engineer; WSO2 Inc.; http://wso2.org E-mail: hira...@wso2.com; Mobile: +94 77 633 3491 Blog: http://techfeast-hiranya.blogspot.com

[jira] Commented: (DERBY-4272) SQL Authorization Support for dblook

2009-08-23 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12746725#action_12746725 ] Hiranya Jayathilaka commented on DERBY-4272: > Does that make

[jira] Updated: (DERBY-4272) SQL Authorization Support for dblook

2009-08-23 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-4272: --- Attachment: DERBY-4272-changes-u5.txt DERBY-4272-u5.patch * Removed

[jira] Commented: (DERBY-4272) SQL Authorization Support for dblook

2009-08-23 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12746626#action_12746626 ] Hiranya Jayathilaka commented on DERBY-4272: BTW you can get the CON

[jira] Commented: (DERBY-4272) SQL Authorization Support for dblook

2009-08-21 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12746148#action_12746148 ] Hiranya Jayathilaka commented on DERBY-4272: The resulting script (dag-sa

[jira] Commented: (DERBY-4272) SQL Authorization Support for dblook

2009-08-21 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12746140#action_12746140 ] Hiranya Jayathilaka commented on DERBY-4272: $ ant -q all [j

Re: Derby Test Framework and New dblook Test

2009-08-17 Thread Hiranya Jayathilaka
On Mon, Aug 17, 2009 at 10:08 PM, Dag H. Wanvik wrote: > > Hi Hiranya, > > Hiranya Jayathilaka writes: > > > Hi Folks, > > > > I'm in the middle of writing the new tests for dblook. When going through > > the existing dblook tests I realized that they

Derby Test Framework and New dblook Test

2009-08-16 Thread Hiranya Jayathilaka
Hi Folks, I'm in the middle of writing the new tests for dblook. When going through the existing dblook tests I realized that they are not junit tests. Some of the test classes have main methods. So I was wondering how should I organize the new tests. Should they be written as junit tests or shoul

[jira] Updated: (DERBY-4272) SQL Authorization Support for dblook

2009-08-08 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-4272: --- Attachment: new.sql old.sql Attaching two DDL files generated by

[jira] Updated: (DERBY-4272) SQL Authorization Support for dblook

2009-08-08 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-4272: --- Attachment: DERBY-4272-changes-u4.txt DERBY-4272-u4.patch Attaching

Improved dblook Implementation: Progress Update

2009-08-02 Thread Hiranya Jayathilaka
Hi Folks, I'm happy to inform you that I have implemented support for manipulating roles in dblook. Therefore now all the roles are created at the begining of the generated script and setting and unsetting of roles take place interleaved with object creation. Granting of privileges to roles also h

Re: Roles Support for dblook

2009-07-28 Thread Hiranya Jayathilaka
comments inline... > > Hiranya Jayathilaka wrote: > >> Hi Rick, >> >> Thanks for the explanation. See my comments inline. >> >> On Mon, Jul 20, 2009 at 9:45 PM, Rick Hillegas >> > richard.hille...@sun.com>> wrote: >> >>Hirany

Re: Roles Support for dblook

2009-07-24 Thread Hiranya Jayathilaka
Hi Rick, Thanks for the explanation. See my comments inline. On Mon, Jul 20, 2009 at 9:45 PM, Rick Hillegas wrote: > Hiranya Jayathilaka wrote: > >> One more question. >> We initially intended to use a dependency graph to capture the >> dependencies among different r

Re: Roles Support for dblook

2009-07-19 Thread Hiranya Jayathilaka
orming all the grants (also recorded in SYSROLES table) sufficient? I can't seem to realize how this will break any inter-dependencies among roles. Thanks, Hiranya On Sun, Jul 19, 2009 at 4:21 PM, Hiranya Jayathilaka wrote: > Hi Folks, > I'm now into implementing roles suppo

Roles Support for dblook

2009-07-19 Thread Hiranya Jayathilaka
g any object. What is the SQL for this? Is it something like SET ROLE {ROLENAME}? Also I guess I might have to 'unset' roles after creating an object? Is that correct? Thanks, Hiranya Jayathilaka

[jira] Updated: (DERBY-4272) SQL Authorization Support for dblook

2009-07-13 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-4272: --- Attachment: DERBY-4272-changes-u3.txt DERBY-4272-u3.patch

[GSoC] Automated Testing for Improved dblook Implementation

2009-07-05 Thread Hiranya Jayathilaka
rovide your own ideas on this issue. Thanks, Hiranya Jayathilaka

[jira] Updated: (DERBY-4272) SQL Authorization Support for dblook

2009-06-22 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-4272: --- Attachment: DERBY-4272-changes-u2.txt DERBY-4272-u2.patch Made

Re: [jira] Commented: (DERBY-4272) SQL Authorization Support for dblook

2009-06-17 Thread Hiranya Jayathilaka
ce the "while" with an "if .. else" for > better legibility. Same for getKeyOwner and the "while > (authorResultSet.next()" loop in getVertices. That makes sense. Since there is only record in the result set, right? > > > - in doKeys, the variable

[jira] Commented: (DERBY-4272) SQL Authorization Support for dblook

2009-06-16 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12720521#action_12720521 ] Hiranya Jayathilaka commented on DERBY-4272: My plan was to make the DiG

[jira] Updated: (DERBY-4272) SQL Authorization Support for dblook

2009-06-14 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-4272: --- Attachment: DERBY-4272-changes-u1.txt DERBY-4272-u1.patch Attaching

[jira] Commented: (DERBY-4272) SQL Authorization Support for dblook

2009-06-14 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12719303#action_12719303 ] Hiranya Jayathilaka commented on DERBY-4272: Please find the detailed prop

[jira] Created: (DERBY-4272) SQL Authorization Support for dblook

2009-06-14 Thread Hiranya Jayathilaka (JIRA)
Reporter: Hiranya Jayathilaka Currently dblook suffers from two major shortcomings. 1. dblook doesn't take the object dependencies into consideration when generating DDL scripts 2. dblook doesn't have any support for SQL authorization I intend to fix these two issues and impr

Re: SQL Authorization for dblook: Progress Update

2009-05-31 Thread Hiranya Jayathilaka
gt; Generate CONNECT/DISCONNECT statements instead of the comments WDYT? Thanks, Hiranya > > > If we later find an elegant solution to this problem, it should be > fairly easy to replace the comment with whatever we come up with. But I > don't think the lack of an elegant solution

Re: SQL Authorization for dblook: Progress Update

2009-05-31 Thread Hiranya Jayathilaka
Hi Rick, On Tue, May 26, 2009 at 9:17 PM, Rick Hillegas wrote: > Hi Hiranya, > > Thanks for tackling this project. Some comments inline... > > Hiranya Jayathilaka wrote: > >> Hi Devs, >> >> I have started writing code for my GSoC project (SQL authorization sup

SQL Authorization for dblook: Progress Update

2009-05-24 Thread Hiranya Jayathilaka
eciated. Thanks, Hiranya -- Hiranya Jayathilaka E-mail: hira...@apache.org; Mobile: +94 77 633 3491 Blog: http://techfeast-hiranya.blogspot.com

Re: Wiki Page for dblook SQL Authorization Support Project

2009-05-13 Thread Hiranya Jayathilaka
Hi Dag, Thanks a lot for taking time to go through the wiki page and providing your valuable insight. I'll soon update the wiki with the things you have mentioned here. See my comments in-line. On Wed, May 13, 2009 at 9:59 PM, Dag H. Wanvik wrote: > > Hi Hiranya, > > Hi

Wiki Page for dblook SQL Authorization Support Project

2009-05-09 Thread Hiranya Jayathilaka
ur own ideas to the wiki page regarding this project and also feel free to discuss the matters mentioned in the wiki on the mailing list. Your feedback and comments are most appreciated. Thanks, Hiranya [1] - http://wiki.apache.org/db-derby/sqlAuth4Dblook -- Hiranya Jayathilaka E-mail: hir

[GSoC] SQL Authorization for dblook - Proposal Accepted

2009-04-21 Thread Hiranya Jayathilaka
Hi Folks, My proposal for implementing SQL authorization support for dblook has been accepted for GSoC 2009. I would like to thank you all, specially Dag, for all the support given to me so far getting familiar with the Derby codebase and the community. I look forward to working with you closely i

[jira] Updated: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-14 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-3610: --- Attachment: DERBY-3610-update2.patch Updated the GrantRevokeTest. Verified the

[jira] Commented: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-14 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12699055#action_12699055 ] Hiranya Jayathilaka commented on DERBY-3610: Looks like the error mess

[jira] Updated: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-13 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-3610: --- Attachment: DERBY-3610-update1.patch Attaching the updated patch. Please review and

[jira] Commented: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-08 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12696923#action_12696923 ] Hiranya Jayathilaka commented on DERBY-3610: Thanks for all the comments f

[jira] Assigned: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-08 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka reassigned DERBY-3610: -- Assignee: Hiranya Jayathilaka > Confusing error message when granting exec

[jira] Updated: (DERBY-2676) Class name "com.ibm.db2j.aggregates.Aggregator" refered in error message is no longer correct

2009-04-04 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-2676: --- Attachment: DERBY-2676.patch This is a simple issue unfortunately without a patch

[jira] Updated: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-04 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hiranya Jayathilaka updated DERBY-3610: --- Attachment: DERBY-3610.patch I'm uploading a patch for a review. This patch s

[jira] Commented: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-02 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12695052#action_12695052 ] Hiranya Jayathilaka commented on DERBY-3610: Thanks for the tips Dag. I&

[jira] Commented: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-01 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12694517#action_12694517 ] Hiranya Jayathilaka commented on DERBY-3610: In the proposed solution we d

[jira] Commented: (DERBY-3610) Confusing error message when granting execute privilege

2009-04-01 Thread Hiranya Jayathilaka (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12694515#action_12694515 ] Hiranya Jayathilaka commented on DERBY-3610: I ran some debug sessions

[GSoC] SQL Authorization for dblook

2009-03-31 Thread Hiranya Jayathilaka
Hi Folks, I'm feeling interested in applying for the project idea 'implementing SQL authorization support for dblook'. I had a talk with Dag regarding this project idea during the ApacheCon and I believe even though the underlying concepts are slightly advanced I can handle it. I have created a dra

Re: [GSoC] Derby Test and Fix

2009-03-23 Thread Hiranya Jayathilaka
Hi Myrna, I'll further analyze the problem and provide you folks with a more detailed report. Thanks for the guide lines. Thanks, Hiranya On Mon, Mar 23, 2009 at 3:38 PM, Myrna van Lunteren wrote: > On Mon, Mar 23, 2009 at 12:39 AM, Hiranya Jayathilaka > wrote: > ... > &

Re: [GSoC] Derby Test and Fix

2009-03-23 Thread Hiranya Jayathilaka
Hi Folks, This is just a progress update. I checked out the Derby trunk and built the jars from the source. Then I tried out each and every test suite possible. Most test suites turned out just fine with 100% success rate. But when trying out the derbyall suite there was a one test failure. I have

Re: [GSoC] Derby Test and Fix

2009-03-15 Thread Hiranya Jayathilaka
Hi Folks, Sorry for not keeping you up-to-date on my progress. But I've been reading Derby documentation and trying out various test suites. I must say that Derby is one of the best documented open source projects I've ever encountered :) Really good work folks. I've tried out most of the test suit

[GSoC] Derby Test and Fix

2009-03-06 Thread Hiranya Jayathilaka
Hi Folks, I'm Hiranya Jayathilaka, an undergraduate from University of Moratuwa, Sri Lanka. I was going through the list of GSoC project ideas from ASF and I noticed the Derby-Test and Fix project listed there. I'm really interested in taking up this task since it will give me a great o