[jira] Resolved: (DERBY-1608) Execution of builtin functions by a user who is not the owner of system schemas gives NPE when authentication and SQL authorization are on.

2006-08-01 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1608?page=all ] Satheesh Bandaram resolved DERBY-1608. -- Resolution: Fixed Submitted a fix to trunk and also added test cases. Execution of builtin functions by a user who is not the owner of system

[jira] Updated: (DERBY-1619) Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name

2006-08-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1619?page=all ] Andrew McIntyre updated DERBY-1619: --- Attachment: derby-1619-v1.diff Attached is a simple patch to convert URL spaces ('%20') to real spaces when comparing filenames in sysinfo. This should

Regression Test Failure! - Derby 427184 - Sun DBTG

2006-08-01 Thread Ole . Solberg
[Auto-generated mail] *Derby* 427184/2006-07-31 19:46:09 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.6* 16729713 0 107.21% SunOS-5.10_i86pc-i386 Details in

Patches for DERBY-1609 (was: Re: svn commit: r427293 - in /db/derby/code/trunk/java/tools/org/apache/derby/impl/tools/ij: Main.java mtTestCase.java utilMain.java utilMain14.java)

2006-08-01 Thread John Embretsen
Daniel John Debrunner wrote: I think I fixed them, just checking in another codeline. I'malso changing wisconsin.java to use the new ij.runScript method so I didn't see that compile error. The change to use runScript isn't ready yet, some diffs exist ddue to a cursor name. Dan, Speaking of

[jira] Commented: (DERBY-1616) Lots of jdk1.6 regression test failures with diffs because of SQL Exception instead of java.sql.SQLException

2006-08-01 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1616?page=comments#action_12424804 ] Kristian Waagan commented on DERBY-1616: Just want to inform that the jdbc40 suite now runs without failures (with JDK1.6). All planned interface changes

Building 10.2

2006-08-01 Thread x.genster
Greetings all, Just a Heads up, If you DON'T FOLLOW THE BUILDING.txt and install jdbc2_0-stdext.jar You get the following error. Oh and this has nothing to do with JSR169, the compile_jsr169: can be miss leading compile_jsr169: [javac] Compiling 1 source file to C:\Derby\10.2\classes

Regression Test Failure! - TinderBox_Derby 427354 - Sun DBTG

2006-08-01 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 427354/2006-08-01 01:12:25 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 3682679 2 541.99% SunOS-5.10_i86pc-i386 Details in

Building 10.2 Errors

2006-08-01 Thread x.genster
Greetings all, Just a Heads up, If you DON'T FOLLOW THE BUILDING.txt and install jdbc2_0-stdext.jar You get the following error. Oh and this has nothing to do with JSR169, the compile_jsr169: can be miss leading compile_jsr169: [javac] Compiling 1 source file to C:\Derby\10.2\classes

[jira] Commented: (DERBY-1619) Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name

2006-08-01 Thread John H. Embretsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1619?page=comments#action_12424832 ] John H. Embretsen commented on DERBY-1619: -- I tried derby-1619-v1.diff, and it works as a remedy against the spaces in path issue. However: The same

[jira] Updated: (DERBY-700) Derby does not prevent dual boot of database from different classloaders on Linux

2006-08-01 Thread V.Narayanan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-700?page=all ] V.Narayanan updated DERBY-700: -- Attachment: DERBY-700.diff DERBY-700.stat Hi, We could solve this problem by setting a System property before booting a database and checking for

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

2006-08-01 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12424850 ] Kathey Marsden commented on DERBY-1516: --- The new positive cases sound fine to me. If I understand all you wrote, you are saying that getSubstring(pos,0)

Regression Test Failure! - TinderBox_Derby 427510 - Sun DBTG

2006-08-01 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 427510/2006-08-01 12:03:02 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 4686682 2 146.13% SunOS-5.10_i86pc-i386 Details in

[jira] Commented: (DERBY-244) with linux, depending on env setting $LANG and console encoding, some i18n tests fail

2006-08-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-244?page=comments#action_12424854 ] Rick Hillegas commented on DERBY-244: - I'm afraid I see diffs in these tests when run against jar files on Linux and jdk1.4: urlLocale messageLocale

[jira] Commented: (DERBY-1489) Provide ALTER TABLE DROP COLUMN functionality

2006-08-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1489?page=comments#action_12424863 ] Rick Hillegas commented on DERBY-1489: -- Hi Bryan: Thanks for this great feature. The parser changes look good: thanks for cleaning up the LOOKAHEADs in

[jira] Updated: (DERBY-1341) LOB setBytes method(s) are currently no supported, but part of the Java 1.4 JDBC interface

2006-08-01 Thread Fernanda Pizzorno (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1341?page=all ] Fernanda Pizzorno updated DERBY-1341: - Attachment: LobStreamTest.java I am planning to use similar stream to those implemented in the patch (derby-1341-blob-forreview.diff) for

[jira] Assigned: (DERBY-1252) Old clients with new server return wrong database metadata values for some methods

2006-08-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1252?page=all ] Dag H. Wanvik reassigned DERBY-1252: Assignee: Dag H. Wanvik Old clients with new server return wrong database metadata values for some methods

Re: Influencing the standards which govern Derby

2006-08-01 Thread Rick Hillegas
I wanted to summarize where I think this discussion stands now: 1) SQL - Individuals can influence the SQL spec by renting cheap seats from ANSI for $500/year. See http://www.ansi.org/membership/overview/overview.aspx?menuid=2. 2) JDBC - Fortunately, the JDBC spec lead will continue to be a

[jira] Updated: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-08-01 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=all ] Kristian Waagan updated DERBY-1417: --- Attachment: derby-1417-7a-clientborderfix.diff derby-1417-7a-clientborderfix.stat 'derby-1417-7a-clientborderfix.diff' fixes bugs in the

[jira] Updated: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-08-01 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=all ] Kristian Waagan updated DERBY-1417: --- Derby Info: [Patch Available] Add new, lengthless overloads to the streaming api --

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

2006-08-01 Thread Craig Russell (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12424887 ] Craig Russell commented on DERBY-1516: -- Thanks for the feedback. I'll make some positive and negative test cases and update the patch. Yes, I'm suggesting

[jira] Created: (DERBY-1620) SQL CASE statement returns ERROR 42X89 when including NULL as a return value

2006-08-01 Thread John Peterson (JIRA)
SQL CASE statement returns ERROR 42X89 when including NULL as a return value Key: DERBY-1620 URL: http://issues.apache.org/jira/browse/DERBY-1620 Project: Derby

[jira] Commented: (DERBY-1616) Lots of jdk1.6 regression test failures with diffs because of SQL Exception instead of java.sql.SQLException

2006-08-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1616?page=comments#action_12424893 ] Rick Hillegas commented on DERBY-1616: -- One small amendment: I'm aware of one more JDBC4 interface change (DERBY-1530). I expect the interface change will

[jira] Commented: (DERBY-1610) Engine take it as type compatibility error to update column typed as CHAR to value passed via setBinaryStream(null), though Network Client and Network Server does not ta

2006-08-01 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1610?page=comments#action_12424892 ] Tomohito Nakayama commented on DERBY-1610: -- I surveyed execution of Network Server with jdb when TestNullChar.java was executed. In both of

[jira] Updated: (DERBY-1620) SQL CASE statement returns ERROR 42X89 when including NULL as a return value

2006-08-01 Thread John Peterson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1620?page=all ] John Peterson updated DERBY-1620: - Attachment: SQL2003_Standard_Case_Expression.doc Derby_Community_Discussion.doc sysinfo_and_example.txt These attachments are

Re: [jira] Commented: (DERBY-1610) Engine take it as type compatibility error to update column typed as CHAR to value passed via setBinaryStream(null), though Network Client and Network Server does no

2006-08-01 Thread TomohitoNakayama
Hello Dag. I linked it :) Best regards. Dag H. Wanvik wrote: Hi, You may want to link this issue to DERBY-310. Thanks, Dag -- /* Tomohito Nakayama [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Naka

[jira] Commented: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-08-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=comments#action_12424900 ] Rick Hillegas commented on DERBY-1417: -- Thanks for these bug fixes, Kristian. My only questions about the IllegalArgumentException would be: a) How would a

[jira] Closed: (DERBY-1608) Execution of builtin functions by a user who is not the owner of system schemas gives NPE when authentication and SQL authorization are on.

2006-08-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1608?page=all ] Deepa Remesh closed DERBY-1608. --- Verified fix by running the repros and the modified upgrade test. Thanks Satheesh. Execution of builtin functions by a user who is not the owner of system

[jira] Updated: (DERBY-1521) Upgrade test needs to be enhanced to test grant revoke

2006-08-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1521?page=all ] Deepa Remesh updated DERBY-1521: Attachment: d1521-patch2-v1.diff d1521-patch2-v1.status Attaching patch 'd1521-patch2-v1.diff' which is same as the draft patch

[jira] Commented: (DERBY-1341) LOB setBytes method(s) are currently no supported, but part of the Java 1.4 JDBC interface

2006-08-01 Thread Anurag Shekhar (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1341?page=comments#action_12424910 ] Anurag Shekhar commented on DERBY-1341: --- Thanks Fernanda for the test. I will prefer to keep LOBStreamControl's scope at the package. Let me try to modify

GRANT/REVOKE doc review - comments needed for DERBY-1057

2006-08-01 Thread Laura Stewart
Hi - I posted a doc review for GRANT/REVOKE and would like to post the patch later this week. Please take a few minutes to review the updates to the Reference Manual and the Developers Guide. Here is the link - https://issues.apache.org/jira/browse/DERBY-1057 Thanks! -- Laura Stewart

[jira] Commented: (DERBY-1539) As per the functional spec attached to DERBY-1330, a trigger should be dropped when a privilege required by the trigger is revoked.

2006-08-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1539?page=comments#action_12424913 ] Daniel John Debrunner commented on DERBY-1539: -- On the trigger re-compile issue it seems there is a serious problem currently (regardless of

[jira] Created: (DERBY-1621) Trigger action statement is not recompile when there is a change that would affect it.

2006-08-01 Thread Daniel John Debrunner (JIRA)
Trigger action statement is not recompile when there is a change that would affect it. -- Key: DERBY-1621 URL: http://issues.apache.org/jira/browse/DERBY-1621

Re: Influencing the standards which govern Derby

2006-08-01 Thread Jean T. Anderson
Rick Hillegas wrote: I wanted to summarize where I think this discussion stands now: ... 2) JDBC - Fortunately, the JDBC spec lead will continue to be a member of our community. In addition, individuals can join the JCP for free. See http://jcp.org/en/participation/membership. Individuals can

[jira] Commented: (DERBY-939) NullPointerException at ResultSet.close() time for simple query using UNION and INTERSECT

2006-08-01 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-939?page=comments#action_12424921 ] David Van Couvering commented on DERBY-939: --- Has anyone besides Yip run derbyall on this patch yet? If it passes derbyall, I'd be happy to check it in.

[jira] Updated: (DERBY-1619) Sysinfo in 10.2 shows multiple entries if the derby jars reside in a directory with spaces in its name

2006-08-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1619?page=all ] Andrew McIntyre updated DERBY-1619: --- Attachment: derby-1619-v2.diff Thanks, John. There is a general solution for this problem: java.net.URLDecoder. :-) Attaching patch -v2, which uses

[jira] Commented: (DERBY-1584) store/encryptionKey_jar.sql fails on Cygwin

2006-08-01 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1584?page=comments#action_12424925 ] Sunitha Kambhampati commented on DERBY-1584: Thanks Rick for trying this test out on cygwin in your environment.I looked at Ole's reports and this

[jira] Commented: (DERBY-1620) SQL CASE statement returns ERROR 42X89 when including NULL as a return value

2006-08-01 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1620?page=comments#action_12424927 ] Jean T. Anderson commented on DERBY-1620: - For any who don't have Word, the start for the discussion in Derby_Community_Discussion.doc can be viewed at

[jira] Updated: (DERBY-1584) store/encryptionKey_jar.sql and lang/dcl.sql fails on Cygwin

2006-08-01 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1584?page=all ] Sunitha Kambhampati updated DERBY-1584: --- Summary: store/encryptionKey_jar.sql and lang/dcl.sql fails on Cygwin (was: store/encryptionKey_jar.sql fails on Cygwin) Updating the summary.

[jira] Commented: (DERBY-1621) Trigger action statement is not recompile when there is a change that would affect it.

2006-08-01 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1621?page=comments#action_12424931 ] Mamta A. Satoor commented on DERBY-1621: While on the topic of recompilation, I think there might be an issue with views as well. I don't see any code in

[jira] Assigned: (DERBY-1530) DatabaseMetaData.getFunctionParameters() changing name to getFunctionColumns()

2006-08-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1530?page=all ] Rick Hillegas reassigned DERBY-1530: Assignee: Rick Hillegas DatabaseMetaData.getFunctionParameters() changing name to getFunctionColumns()

[jira] Commented: (DERBY-1577) DatabaseMetaData.getIndexInfo() returns internal names

2006-08-01 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1577?page=comments#action_12424942 ] Kathey Marsden commented on DERBY-1577: --- I think that the name of the backing index created is in fact different than the primary key, so I think it is

Re: [jira] Updated: (DERBY-700) Derby does not prevent dual boot of database from different classloaders on Linux

2006-08-01 Thread Mike Matrigali
I haven't looked at this yet, just wanted to say that when I proposed a single system property (vs. one system prop per database), there was opposition in the community. Some things to think about: o can the same database ever have 2 names - ie. if the location is /x/y/wombat and one person

[jira] Commented: (DERBY-952) DerbyNet/derbynetmats/NSinSameJVM fails on Win XP / Cygwin

2006-08-01 Thread Rajesh Kartha (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-952?page=comments#action_12424944 ] Rajesh Kartha commented on DERBY-952: - The test is passing under both DerbyNetClient and JCC on Windows XP (command prompt) using the 10.2.0.5 alpha -

[jira] Created: (DERBY-1622) Add documentation for encrypted database using encryptionKey

2006-08-01 Thread Sunitha Kambhampati (JIRA)
Add documentation for encrypted database using encryptionKey Key: DERBY-1622 URL: http://issues.apache.org/jira/browse/DERBY-1622 Project: Derby Issue Type: Task

[jira] Created: (DERBY-1623) Consider ANSI TRIM implementation

2006-08-01 Thread Emmanuel Bernard (JIRA)
Consider ANSI TRIM implementation - Key: DERBY-1623 URL: http://issues.apache.org/jira/browse/DERBY-1623 Project: Derby Issue Type: Improvement Components: SQL Reporter: Emmanuel Bernard

[jira] Commented: (DERBY-700) Derby does not prevent dual boot of database from different classloaders on Linux

2006-08-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-700?page=comments#action_12424948 ] Daniel John Debrunner commented on DERBY-700: - Using system properties will require that every user running with the security manager grant a new

[jira] Commented: (DERBY-1584) store/encryptionKey_jar.sql and lang/dcl.sql fails on Cygwin

2006-08-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1584?page=comments#action_12424949 ] Andrew McIntyre commented on DERBY-1584: I also tried both of these tests and could get neither of them to fail in my Cygwin environment with several

[jira] Commented: (DERBY-700) Derby does not prevent dual boot of database from different classloaders on Linux

2006-08-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-700?page=comments#action_12424951 ] Daniel John Debrunner commented on DERBY-700: - LUCENE-305 and LUCENE-635 may be worth looking at, lucene is re-factoring their locking (similar

[jira] Commented: (DERBY-1616) Lots of jdk1.6 regression test failures with diffs because of SQL Exception instead of java.sql.SQLException

2006-08-01 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1616?page=comments#action_12424956 ] David Van Couvering commented on DERBY-1616: Finally tracked down the source of this problem. I was very confused because the output files were

[jira] Created: (DERBY-1624) use of direct column name rather than alias make aggregation fail (Hibernate depends on that)

2006-08-01 Thread Emmanuel Bernard (JIRA)
use of direct column name rather than alias make aggregation fail (Hibernate depends on that) - Key: DERBY-1624 URL: http://issues.apache.org/jira/browse/DERBY-1624

[jira] Commented: (DERBY-1624) use of direct column name rather than alias make aggregation fail (Hibernate depends on that)

2006-08-01 Thread Emmanuel Bernard (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1624?page=comments#action_12424957 ] Emmanuel Bernard commented on DERBY-1624: - Somehow related to DERBY-127 use of direct column name rather than alias make aggregation fail (Hibernate

[jira] Commented: (DERBY-1624) use of direct column name rather than alias make aggregation fail (Hibernate depends on that)

2006-08-01 Thread Emmanuel Bernard (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1624?page=comments#action_12424959 ] Emmanuel Bernard commented on DERBY-1624: - All but Derby DB works fine with it original issue from the hibernate dev list. I am working on enhancing

[jira] Commented: (DERBY-1456) Network Server agentError calls log only to console and are hard to diagnose

2006-08-01 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1456?page=comments#action_12424960 ] Kathey Marsden commented on DERBY-1456: --- Sunitha, I have not had time to look at this patch, but wonder: will the errors get logged to derby.log? Network

[jira] Assigned: (DERBY-1621) Trigger action statement is not recompile when there is a change that would affect it.

2006-08-01 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1621?page=all ] Yip Ng reassigned DERBY-1621: - Assignee: Yip Ng Trigger action statement is not recompile when there is a change that would affect it.

Checking for required classes from within Derby?

2006-08-01 Thread Army
As part of my work for DERBY-688 I've made some slight changes to the XML operators that were added in DERBY-334 and I've also added a new operator, XMLQUERY. These operators depend on the presence of classes that are technically external to Derby. Or more specifically, they expect that the

[jira] Commented: (DERBY-1456) Network Server agentError calls log only to console and are hard to diagnose

2006-08-01 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1456?page=comments#action_12424966 ] Sunitha Kambhampati commented on DERBY-1456: Yes. The errors will get logged to derby.log. Network Server agentError calls log only to console and

[jira] Commented: (DERBY-1620) SQL CASE statement returns ERROR 42X89 when including NULL as a return value

2006-08-01 Thread John Peterson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1620?page=comments#action_12424967 ] John Peterson commented on DERBY-1620: -- It has been brought to my attention that the SQL2003_Standard_Case_Expression.doc is a violation of the ISO

[jira] Commented: (DERBY-1621) Trigger action statement is not recompile when there is a change that would affect it.

2006-08-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1621?page=comments#action_12424968 ] Daniel John Debrunner commented on DERBY-1621: -- Thanks for looking at this Yip - note that Derby has an existing dependency system already, thus it

[jira] Updated: (DERBY-1620) SQL CASE statement returns ERROR 42X89 when including NULL as a return value

2006-08-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1620?page=all ] Andrew McIntyre updated DERBY-1620: --- Attachment: (was: SQL2003_Standard_Case_Expression.doc) SQL CASE statement returns ERROR 42X89 when including NULL as a return value

[jira] Commented: (DERBY-1620) SQL CASE statement returns ERROR 42X89 when including NULL as a return value

2006-08-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1620?page=comments#action_12424969 ] Andrew McIntyre commented on DERBY-1620: Removed SQL2003_Standard_Case_Expression.doc attachment at attcher's request. SQL CASE statement returns ERROR

Re: [jira] Commented: (DERBY-1616) Lots of jdk1.6 regression test failures with diffs because of SQL Exception instead of java.sql.SQLException

2006-08-01 Thread Myrna van Lunteren
On 8/1/06, David Van Couvering (JIRA) derby-dev@db.apache.org wrote: [ http://issues.apache.org/jira/browse/DERBY-1616?page=comments#action_12424956 ] David Van Couvering commented on DERBY-1616: Finally tracked down the source of this problem.

Re: [jira] Assigned: (DERBY-1621) Trigger action statement is not recompile when there is a change that would affect it.

2006-08-01 Thread Kathey Marsden
Yip Ng (JIRA) wrote: Trigger action statement is not recompile when there is a change that would affect it. -- Is it possible DERBY-1603 is at all related to this bug, where the change is changing

Re: Checking for required classes from within Derby?

2006-08-01 Thread Daniel John Debrunner
Army wrote: As part of my work for DERBY-688 I've made some slight changes to the XML operators that were added in DERBY-334 and I've also added a new operator, XMLQUERY. [snip] While this works, I can't help but wonder if Derby has some sort of existing mechanism/utilities to check for the

Re: [jira] Updated: (DERBY-1547) Add svn version number to DatabaseMetaData getDatabaseProductVersion and getDriverVersion() to improve supportability

2006-08-01 Thread Mike Matrigali
Does anyone think this is a bad idea? Seems simple and a good idea to me but it is changing an exported format. Kathey Marsden (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1547?page=all ] Kathey Marsden updated DERBY-1547: -- Urgency:

[jira] Commented: (DERBY-1057) documentation to address Grant/Revoke (Derby-464)

2006-08-01 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1057?page=comments#action_12424974 ] Satheesh Bandaram commented on DERBY-1057: -- All the answers provided by Mamta earlier are correct. Grant/Revoke statements can only operate on one object

Re: Checking for required classes from within Derby?

2006-08-01 Thread Army
Daniel John Debrunner wrote: Derby's loading of modules from modules.properties has a mechanism where a module is not loaded if its declared list of classes are not loadable. snip Otherwise the utility class org.apache.derby.iapi.services.loader.ClassInspector has some methods, you could

Re: [jira] Assigned: (DERBY-1621) Trigger action statement is not recompile when there is a change that would affect it.

2006-08-01 Thread Yip Ng
Hmm.. not sure, but I'll dig into it.On 8/1/06, Kathey Marsden [EMAIL PROTECTED] wrote: Yip Ng (JIRA) wrote:Trigger action statement is not recompile when there is a change that would affect it. --Is it possible

Re: svn commit: r427293 - in /db/derby/code/trunk/java/tools/org/apache/derby/impl/tools/ij: Main.java mtTestCase.java utilMain.java utilMain14.java

2006-08-01 Thread Myrna van Lunteren
On 7/31/06, Andrew McIntyre [EMAIL PROTECTED] wrote: On 7/31/06, Army [EMAIL PROTECTED] wrote: [javac] Compiling 2 source files to C:\p4clients\main_codeline\classes [javac]

[jira] Commented: (DERBY-1330) Provide runtime privilege checking for grant/revoke functionality

2006-08-01 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1330?page=comments#action_12424980 ] Laura Stewart commented on DERBY-1330: -- In the spec AuthorizationModelForDerbySQLStandardAuthorizationV2.html, I am not sure that I understand the sentences

[jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality

2006-08-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12424985 ] Deepa Remesh commented on DERBY-1579: - I went through this patch and it looks good to me. With this patch, I confirmed that SYS.SYSREQUIREDPERM table does

[jira] Created: (DERBY-1625) wisconsin test unable to establish connection

2006-08-01 Thread Rick Hillegas (JIRA)
wisconsin test unable to establish connection - Key: DERBY-1625 URL: http://issues.apache.org/jira/browse/DERBY-1625 Project: Derby Issue Type: Bug Components: Test Affects Versions:

[jira] Created: (DERBY-1626) TransactionTable.sql fails

2006-08-01 Thread Rick Hillegas (JIRA)
TransactionTable.sql fails -- Key: DERBY-1626 URL: http://issues.apache.org/jira/browse/DERBY-1626 Project: Derby Issue Type: Bug Components: Test Affects Versions: 10.2.0.0 Environment: linux

Re: [jira] Commented: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality

2006-08-01 Thread Yip Ng
Will do. =)On 8/1/06, Deepa Remesh (JIRA) derby-dev@db.apache.org wrote: [ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12424985 ]Deepa Remesh commented on DERBY-1579: -I went through this patch and it looks good to me. With this patch, I

[jira] Commented: (DERBY-1597) Scripts in frameworks direcotry needs to be revisted to set up CLASSPATH properly

2006-08-01 Thread Ramandeep Kaur (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1597?page=comments#action_12425010 ] Ramandeep Kaur commented on DERBY-1597: --- Actually, after thinking about it more, I am proposing the following solution:- Give classpath while invoking java

Re: [jira] Commented: (DERBY-1621) Trigger action statement is not recompile when there is a change that would affect it.

2006-08-01 Thread Yip Ng
Thanks for the info, Dan. I briefly looked at the reported issue, I think I know what the problem is. When Derby binds the trigger's action node (insert stmt in this case) in CreateTriggerNode, the action node bind phase creates a dependency from the compilation context but however, the context's

[jira] Updated: (DERBY-1241) When booting a database under security manager, boot may fail with message java.sql.SQLException: Java exception: 'access denied (java.io.FilePermission for logmirror

2006-08-01 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1241?page=all ] Myrna van Lunteren updated DERBY-1241: -- Attachment: DERBY-1241_20060801.diff I'm attaching a patch -DERBY-1241_20060801.diff - that fixes the reproducible case described in this bug,

[jira] Created: (DERBY-1627) Need a regression test for DERBY-1241

2006-08-01 Thread Myrna van Lunteren (JIRA)
Need a regression test for DERBY-1241 - Key: DERBY-1627 URL: http://issues.apache.org/jira/browse/DERBY-1627 Project: Derby Issue Type: Test Affects Versions: 10.2.0.0 Reporter: Myrna van

[jira] Updated: (DERBY-1241) When booting a database under security manager, boot may fail with message java.sql.SQLException: Java exception: 'access denied (java.io.FilePermission for logmirror

2006-08-01 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1241?page=all ] Myrna van Lunteren updated DERBY-1241: -- Derby Info: [Patch Available] When booting a database under security manager, boot may fail with message java.sql.SQLException: Java

[jira] Updated: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality

2006-08-01 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1579?page=all ] Yip Ng updated DERBY-1579: -- Attachment: derby1579trunkstat02.txt derby1579trunkdiff02.txt Resubmitting patch - derby1579trunkdiff02.txt Remove SYS.SYSREQUIREDPERM from Derby 10.2.

Re: [jira] Commented: (DERBY-1616) Lots of jdk1.6 regression test failures with diffs because of SQL Exception instead of java.sql.SQLException

2006-08-01 Thread David Van Couvering
Yes, it's easy for data like this to slip through with the volume of email on this list. I'm not sure how to resolve that, there's just going to be some amount of lossiness in the system... David Myrna van Lunteren wrote: On 8/1/06, David Van Couvering (JIRA) derby-dev@db.apache.org wrote:

[jira] Updated: (DERBY-1252) Old clients with new server return wrong database metadata values for some methods

2006-08-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1252?page=all ] Dag H. Wanvik updated DERBY-1252: - Attachment: derby1252.stat derby1252.diff derby1252-10.1.stat Old clients with new server return wrong database metadata

[jira] Created: (DERBY-1628) Update name of driver - IBM DB2 JDBC Universal Driver to IBM DB2 Driver for JDBC

2006-08-01 Thread Laura Stewart (JIRA)
Update name of driver - IBM DB2 JDBC Universal Driver to IBM DB2 Driver for JDBC Key: DERBY-1628 URL: http://issues.apache.org/jira/browse/DERBY-1628 Project: Derby

[jira] Updated: (DERBY-1252) Old clients with new server return wrong database metadata values for some methods

2006-08-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1252?page=all ] Dag H. Wanvik updated DERBY-1252: - Attachment: derby1252-10.1.diff Old clients with new server return wrong database metadata values for some methods

Re: [jira] Created: (DERBY-1626) TransactionTable.sql fails

2006-08-01 Thread David Van Couvering
Note that you have multiple failures on TransactionTable right now in JDK 1.6, because it also is involved in the SQL Exception toString() debacle... I hope to be submitting a patch later today that will fix the SQL Exception problem... David Rick Hillegas (JIRA) wrote:

[jira] Commented: (DERBY-1252) Old clients with new server return wrong database metadata values for some methods

2006-08-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1252?page=comments#action_12425042 ] Dag H. Wanvik commented on DERBY-1252: -- Two patches are uploaded to solve this issue. derby1252-10.1.{diff,stat} derby1252.{diff,stat} The first

[jira] Updated: (DERBY-1252) Old clients with new server return wrong database metadata values for some methods

2006-08-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1252?page=all ] Dag H. Wanvik updated DERBY-1252: - Attachment: derby1252.diff whitespace fix for derby1252.diff Old clients with new server return wrong database metadata values for some methods

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-08-01 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12425045 ] David Van Couvering commented on DERBY-1377: Do we have any conclusion about how we should take care of this? I'm thinking of unassigning myself from

[jira] Updated: (DERBY-1252) Old clients with new server return wrong database metadata values for some methods

2006-08-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1252?page=all ] Dag H. Wanvik updated DERBY-1252: - Derby Info: [Patch Available, Existing Application Impact, Regression] (was: [Existing Application Impact, Regression]) Old clients with new server return

[jira] Commented: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-08-01 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=comments#action_12425048 ] Kristian Waagan commented on DERBY-1417: Thanks for looking at the patch, Rick :) I added the test case mostly to demonstrate the expected behavior. a)

[jira] Commented: (DERBY-1241) When booting a database under security manager, boot may fail with message java.sql.SQLException: Java exception: 'access denied (java.io.FilePermission for logmirr

2006-08-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1241?page=comments#action_12425051 ] Andrew McIntyre commented on DERBY-1241: This is a pretty obvious fix for a serious problem. I think we should get this in for 10.2, even if writing a

Re: [jira] Commented: (DERBY-1241) When booting a database under security manager, boot may fail with message java.sql.SQLException: Java exception: 'access denied (java.io.FilePermission for log

2006-08-01 Thread Mike Matrigali
patch looks good to me - one line change seems obvious fix, and looks like what suresh suggested was probably the fix. Since it fixes the by hand check case I say check it in, even if no new test. Andrew McIntyre (JIRA) wrote: [

Building Derby

2006-08-01 Thread Craig L Russell
Hi,I ran across an interesting issue while building Derby. I checked out the latest sources and ran ant from the top. I read the ant output and found this:genParser:     [echo]   Generating SQL parser...     [java] Java Compiler Compiler Version 4.0 (Parser Generator)     [java] (type "javacc"

Re: [jira] Updated: (DERBY-1579) Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality

2006-08-01 Thread Deepa Remesh
On 8/1/06, Yip Ng (JIRA) derby-dev@db.apache.org wrote: [ http://issues.apache.org/jira/browse/DERBY-1579?page=all ] Yip Ng updated DERBY-1579: -- Attachment: derby1579trunkstat02.txt derby1579trunkdiff02.txt Resubmitting patch -

[jira] Updated: (DERBY-1530) DatabaseMetaData.getFunctionParameters() changing name to getFunctionColumns()

2006-08-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1530?page=all ] Rick Hillegas updated DERBY-1530: - Attachment: derby-1530_v01.diff Attaching derby-1530_v01.diff, which makes the following changes: 1) Renames getFunctionParameters() as getFunctionColumns()

Unexplained diff in procedureInTrigger.sql for JDK 1.6

2006-08-01 Thread David Van Couvering
Hi, all. In evaluating diffs currently happening in JDK 1.6 derbyall, I ran across this strange diff: 398d397 ERROR 38000: The exception 'java.sql.SQLException: The external routine is not allowed to execute SQL statements.' was thrown while evaluating an expression. Basically what is

[jira] Resolved: (DERBY-1241) When booting a database under security manager, boot may fail with message java.sql.SQLException: Java exception: 'access denied (java.io.FilePermission for logmirro

2006-08-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1241?page=all ] Andrew McIntyre resolved DERBY-1241. Resolution: Fixed Derby Info: (was: [Patch Available]) Verified manual test case. Committed to trunk with revision 427796. Seems like a good

Re: Building Derby

2006-08-01 Thread David Van Couvering
These error messages are to be expected. I agree BUILDING.txt should warn people to expect this, I agree it is disconcerting. David Craig L Russell wrote: Hi, I ran across an interesting issue while building Derby. I checked out the latest sources and ran ant from the top. I read the ant

Re: Unexplained diff in procedureInTrigger.sql for JDK 1.6

2006-08-01 Thread Daniel John Debrunner
David Van Couvering wrote: Hi, all. In evaluating diffs currently happening in JDK 1.6 derbyall, I ran across this strange diff: 398d397 ERROR 38000: The exception 'java.sql.SQLException: The external routine is not allowed to execute SQL statements.' was thrown while evaluating an

[jira] Commented: (DERBY-1489) Provide ALTER TABLE DROP COLUMN functionality

2006-08-01 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1489?page=comments#action_12425063 ] Bryan Pendleton commented on DERBY-1489: Thanks for the review, Rick! I will work on investigating the issues you raised. Provide ALTER TABLE DROP COLUMN

[jira] Commented: (DERBY-119) Add ALTER TABLE option to change column from NULL to NOT NULL

2006-08-01 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-119?page=comments#action_12425064 ] Bryan Pendleton commented on DERBY-119: --- Thank you very much for the review, Deepa. I will investigate the issues that you raised. Add ALTER TABLE option

  1   2   >