[jira] Commented: (DERBY-1631) Derby needs to support drop view cascade in order for revoke privilege to function correctly

2006-08-02 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1631?page=comments#action_12425444 ] Mamta A. Satoor commented on DERBY-1631: One thing to note is we do not necessarily need the SQL support for drop view cascade. It can be supported at the

Re: Question on Grant revoke functional spec

2006-08-02 Thread Mamta Satoor
Hi Satheesh,   Was just curious if you found a section number in the SQL spec for the sample case in this thread?   thanks, Mamta  On 7/29/06, Satheesh Bandaram <[EMAIL PROTECTED]> wrote: Daniel John Debrunner wrote:>Satheesh Bandaram wrote:>Derby currently doesn't support WITH GRANT OPTION. So

Re: full stack trace with TestConnectionMethods.java

2006-08-02 Thread Narayanan
Hi, Absolutely no problem. There was no need to apologise at all. I will take a look at it. Although I really don't know how much insight I can provide. thanx, Narayanan Andrew McIntyre wrote: On 8/2/06, Narayanan <[EMAIL PROTECTED]> wrote: Hi, The subject of the email said JUnit. The TestCo

full stack trace with TestConnectionMethods.java

2006-08-02 Thread Andrew McIntyre
On 8/2/06, Narayanan <[EMAIL PROTECTED]> wrote: Hi, The subject of the email said JUnit. The TestConnectionMethods.java is not a JUnit test. My mistake, sorry. I incorrectly assumed that all of the jdbc4 tests were junit tests. Anyway, I suppose I'll look at instrumenting this test to return fu

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

2006-08-02 Thread Craig Russell (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Attachment: DERBY-1516.patch This patch solves the discrepancy between the treatment of getBytes and getSubString where the requested length is zero. This ma

[jira] Updated: (DERBY-1638) JUnit TestConfiguration class uses engine code to determine JDBC level.

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1638?page=all ] Daniel John Debrunner updated DERBY-1638: - Derby Info: [Patch Available] > JUnit TestConfiguration class uses engine code to determine JDBC level. >

[jira] Updated: (DERBY-1638) JUnit TestConfiguration class uses engine code to determine JDBC level.

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1638?page=all ] Daniel John Debrunner updated DERBY-1638: - Attachment: derby1638_diff.txt Patch that makes described changes, adding these methods supportsJDBC2() supportsJDBC3() supportsJSR169() Mig

Re: full stack trace with JUnit?

2006-08-02 Thread Narayanan
Hi, The subject of the email said JUnit. The TestConnectionMethods.java is not a JUnit test. thanx Narayanan Andrew McIntyre wrote: I'm trying to track down a weird problem related to my patch for DERBY-1424, packaging the network client code with classlister. There is one test that is failing

[jira] Created: (DERBY-1638) JUnit TestConfiguration class uses engine code to determine JDBC level.

2006-08-02 Thread Daniel John Debrunner (JIRA)
JUnit TestConfiguration class uses engine code to determine JDBC level. --- Key: DERBY-1638 URL: http://issues.apache.org/jira/browse/DERBY-1638 Project: Derby Issue Type: I

unused / unnecessary files in derbyclient.jar (DERBY-1424)

2006-08-02 Thread Andrew McIntyre
While working on DERBY-1424, building derbyclient.jar with classlister, I noticed the following classes which are either unused or shouldn't be included in derbyclient.jar. The ones which are unused appear to be have been used in the past, but are not used now, and should probably be removed compl

full stack trace with JUnit?

2006-08-02 Thread Andrew McIntyre
I'm trying to track down a weird problem related to my patch for DERBY-1424, packaging the network client code with classlister. There is one test that is failing, jdbc4/TestConnectionMethods, and the failure doesn't appear to be in the client code, it seems to be a test issue, but I don't get the

Re: Startup time for Derby

2006-08-02 Thread Andrew McIntyre
On 7/27/06, David Van Couvering <[EMAIL PROTECTED]> wrote: I am here at OSCON and a user of Derby was complaining rather energetically to me at the cost of startup time for Derby. He said this is a real problem for running unit tests, as this is compounded by running multiple tests, each one sta

Regression Test Failure! - TinderBox_Derby 428202 - Sun DBTG

2006-08-02 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 428202/2006-08-03 02:13:41 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1687686 2 191.57% SunOS-5.10_i86pc-i386 Details in http://www.mult

[jira] Updated: (DERBY-1637) OutBufferedStream.java fails on ibm131/jdk131 jvms.

2006-08-02 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1637?page=all ] Sunitha Kambhampati updated DERBY-1637: --- Attachment: outbuffstream_derbyall_report.txt The report file. > OutBufferedStream.java fails on ibm131/jdk131 jvms. > --

[jira] Created: (DERBY-1637) OutBufferedStream.java fails on ibm131/jdk131 jvms.

2006-08-02 Thread Sunitha Kambhampati (JIRA)
OutBufferedStream.java fails on ibm131/jdk131 jvms. --- Key: DERBY-1637 URL: http://issues.apache.org/jira/browse/DERBY-1637 Project: Derby Issue Type: Bug Components: Regression Test

[jira] Commented: (DERBY-1636) document encryption of an un-encrypted database and re-encryption with new password/key.

2006-08-02 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1636?page=comments#action_12425427 ] Suresh Thalamati commented on DERBY-1636: - Refence Guide Changes: 1) New Attributes doc for re-encryption newEncryptionKey=

[jira] Commented: (DERBY-1635) stress.multi fails on 10.1/ibm131/jcc2.4

2006-08-02 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1635?page=comments#action_12425417 ] Sunitha Kambhampati commented on DERBY-1635: Please note: For some reason I was looking at an old test run history - for the week of 07/07 and came acr

[jira] Created: (DERBY-1636) document encryption of an un-encrypted database and re-encryption with new password/key.

2006-08-02 Thread Suresh Thalamati (JIRA)
document encryption of an un-encrypted database and re-encryption with new password/key. --- Key: DERBY-1636 URL: http://issues.apache.org/jira/browse/DERBY-1636

[jira] Updated: (DERBY-1636) document encryption of an un-encrypted database and re-encryption with new password/key.

2006-08-02 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1636?page=all ] Suresh Thalamati updated DERBY-1636: Attachment: reencryptspec_1.html > document encryption of an un-encrypted database and re-encryption with new > password/key. > -

[jira] Updated: (DERBY-1156) allow the encrypting of an existing unencrypted db and allow the re-encrypting of an existing encrypted db

2006-08-02 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1156?page=all ] Suresh Thalamati updated DERBY-1156: Attachment: reencryptspec_1.html Minor updated to the spec. > allow the encrypting of an existing unencrypted db and allow the > re-encrypting of an

[jira] Created: (DERBY-1635) stress.multi fails on 10.1/ibm131/jcc2.4

2006-08-02 Thread Sunitha Kambhampati (JIRA)
stress.multi fails on 10.1/ibm131/jcc2.4 - Key: DERBY-1635 URL: http://issues.apache.org/jira/browse/DERBY-1635 Project: Derby Issue Type: Bug Components: Regression Test Failure Affects

[jira] Updated: (DERBY-1424) Build derbyclient.jar from a dependency list generated by classlister

2006-08-02 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1424?page=all ] Andrew McIntyre updated DERBY-1424: --- Attachment: derby-1424-v1.diff Attaching a patch for this issue. With the patch I'm seeing some odd behavior with jdbc4/TestConnectionMethods.java that I

Regression Test Failure! - TinderBox_Derby 428125 - Sun DBTG

2006-08-02 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 428125/2006-08-02 22:13:30 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1687686 2 186.21% SunOS-5.10_i86pc-i386 Details in http://www.mult

[jira] Updated: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

2006-08-02 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1633?page=all ] A B updated DERBY-1633: --- Attachment: d1633_repro.sql Attaching a simplified reproduction of the problem that does not rely on the database in DERBY-1205. (But the database in DERBY-1205 allowed me to w

[jira] Commented: (DERBY-1614) Test harness overrides heap size settings when starting Network Server

2006-08-02 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1614?page=comments#action_12425396 ] Andrew McIntyre commented on DERBY-1614: This looks good to me as well. My only comment is that the !jvmName.equals("jview") can be removed. I don't think

[jira] Updated: (DERBY-1320) Test lang/procedure.java fails with ibm1.5 jvm

2006-08-02 Thread Manjula Kutty (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1320?page=all ] Manjula Kutty updated DERBY-1320: - Attachment: svn_stat.txt > Test lang/procedure.java fails with ibm1.5 jvm > -- > > Key: DERBY-1320

[jira] Updated: (DERBY-1320) Test lang/procedure.java fails with ibm1.5 jvm

2006-08-02 Thread Manjula Kutty (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1320?page=all ] Manjula Kutty updated DERBY-1320: - Attachment: svn_diff.txt Hi Knut, Thanks for your valuable suggestions. As per that I had modified the patch. The white spaces are because I had edited the

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

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1521?page=all ] Deepa Remesh updated DERBY-1521: Derby Info: (was: [Patch Available]) > Upgrade test needs to be enhanced to test grant revoke > -- > >

[jira] Updated: (DERBY-1544) Address remaining upgrade task(s) to complete full upgrade mechanism for GRANT/REVOKE, specifically with changing database owner name from 'DBA' to authorizationId of user

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1544?page=all ] Deepa Remesh updated DERBY-1544: Derby Info: [Patch Available] > Address remaining upgrade task(s) to complete full upgrade mechanism for > GRANT/REVOKE, specifically with changing database ow

[jira] Updated: (DERBY-1544) Address remaining upgrade task(s) to complete full upgrade mechanism for GRANT/REVOKE, specifically with changing database owner name from 'DBA' to authorizationId of user

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1544?page=all ] Deepa Remesh updated DERBY-1544: Attachment: d1544-patch1-v1.diff d1544-patch1-v1.status Attaching a patch 'd1544-patch1-v1.diff' which is same as the draft patch + a test. Thi

[jira] Commented: (DERBY-1614) Test harness overrides heap size settings when starting Network Server

2006-08-02 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1614?page=comments#action_12425391 ] Myrna van Lunteren commented on DERBY-1614: --- I reviewed the patch, and the testing described. (Did not do any testing myself). I think this section of c

[jira] Created: (DERBY-1634) Documented syntax for storing jar files in a db has syntax errors

2006-08-02 Thread Kathey Marsden (JIRA)
Documented syntax for storing jar files in a db has syntax errors -- Key: DERBY-1634 URL: http://issues.apache.org/jira/browse/DERBY-1634 Project: Derby Issue Type: Bug

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

2006-08-02 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1628?page=all ] Laura Stewart closed DERBY-1628. > Update name of driver - "IBM DB2 JDBC Universal Driver" to "IBM DB2 Driver > for JDBC" >

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

2006-08-02 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1628?page=all ] Jean T. Anderson resolved DERBY-1628. - Fix Version/s: 10.2.0.0 Resolution: Fixed Committed patch derby1628.diff revision 428167. > Update name of driver - "IBM DB2 JDBC Universal Dr

Re: Enforcing length restrictions for streams of unknown length

2006-08-02 Thread Kristian Waagan
Mike Matrigali wrote: > > > Mike Matrigali wrote: >> This may or may not work, not sure. Here is stuff to be aware of. >> If you do this approach, the store will go ahead and insert and log >> data into the database. For it to work correctly you will >> have to make sure that the resulting erro

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

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1521?page=comments#action_12425384 ] Daniel John Debrunner commented on DERBY-1521: -- Patch d1521-patch2-v1.diff committed - Committed revision 428160. Thanks Deepa > Upgrade test needs to

[jira] Commented: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1548?page=comments#action_12425383 ] Daniel John Debrunner commented on DERBY-1548: -- The names of the DERBY functions are correct in the summary of this issue, ie. RADIANS and DEGREES .

[jira] Commented: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-08-02 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1548?page=comments#action_12425382 ] Laura Stewart commented on DERBY-1548: -- One more thing in the In the java class java.lang.StrictMath file that I need to clarify. That file uses "toRadians" a

[jira] Commented: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1548?page=comments#action_12425377 ] Daniel John Debrunner commented on DERBY-1548: -- NaN is "Not a number". Such a value cannot exist in Derby so it's not applicable for derby's documenta

[jira] Commented: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-08-02 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1548?page=comments#action_12425373 ] Laura Stewart commented on DERBY-1548: -- In the java class java.lang.StrictMath file, there is a description for the arguments that I don't understand. "If the

Re: Question around type in DRDA(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

2006-08-02 Thread Dag H. Wanvik
Hi, TomohitoNakayama <[EMAIL PROTECTED]> writes: > Concerning DERBY-1610, I'm surveying type definition part in current > DRDA relating code. > > I found there exists two word "DRDA_TYPE" and "FDOCA_TYPE". > Former was found in org.apache.derby.iapi.reference.DRDAConstants and > latter was found

Re: Re: Revised 10.2 plan for uncoupling the Mustang and Derby release trains

2006-08-02 Thread Andrew McIntyre
On 6/30/06, Jean T. Anderson <[EMAIL PROTECTED]> wrote: Rick's plan looks good to me as long as the license is resolved -- and it looks like it will be (with time to spare) given Lance's clarification of the mid July target in http://www.nabble.com/Re%3A-Revised-10.2-plan-for-uncoupling-the-Musta

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

2006-08-02 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1628?page=all ] Laura Stewart updated DERBY-1628: - Attachment: derby1628.diff cadminapps810777.html radminapps810699.html Attaching a patch for this issue. There are 2 external

[jira] Commented: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=comments#action_12425365 ] David Van Couvering commented on DERBY-1629: Added a comment to the procedureInTrigger.sql script and fixed the main master file. Also added a master

Heads up: procedureInTrigger.sql for j9 will likely fail

2006-08-02 Thread David Van Couvering
I just checked in revision 42818, where I added a comment to procedureInTrigger.sql. I noticed there is a procedureInTrigger.out that is specific to the j9 vm, so this will likely cause a failure with the j9 tests. I don't have a j9 vm so I couldn't fix this. Someone who runs these tests wil

Regression Test Failure! - TinderBox_Derby 428044 - Sun DBTG

2006-08-02 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 428044/2006-08-02 18:33:12 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1687686 2 171.02% SunOS-5.10_i86pc-i386 Details in http://www.mult

Re: In Derby SQL Authorization, is drop view the only way to drop a view created by a dba? Will revoke privilege ever drop such a view?

2006-08-02 Thread Daniel John Debrunner
Mamta Satoor wrote: > I have been thinking about some view testing and wrote a test case where > the > dba creates a view in a schema owned by some other user and the view is > accessing objects from couple different schemas on which the view's schema > owner doesn't have access to. The view creat

Re: [jira] Commented: (DERBY-1500) PreparedStatement#setObject(int parameterIndex, Object x) throws SQL Exception when binding Short value in embedded mode

2006-08-02 Thread Lance J. Andersen
I updated the JDBC 4 spec data conversion tables for Short and Byte so I would add support for  them when u can -lance Markus Fuchs (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1500?page=comments#action_12424627 ] Markus Fuchs commented on DERBY-1500: --

[jira] Updated: (DERBY-1544) Address remaining upgrade task(s) to complete full upgrade mechanism for GRANT/REVOKE, specifically with changing database owner name from 'DBA' to authorizationId of user

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1544?page=all ] Deepa Remesh updated DERBY-1544: Attachment: d1544-patch1-draft.diff Attaching a draft patch 'd1544-patch1-draft.diff' for the first part of this sub-task - Upgrading a database from 10.1 to 1

Re: derby-developers group request

2006-08-02 Thread Andrew McIntyre
On 8/2/06, Adams, James F <[EMAIL PROTECTED]> wrote: Could someone add me to the derby-developers group? (jira user james.f.adams) Hi James, Are you registered with this email address? If so, I couldn't find your user in JIRA. If it is registered with a different email address, please let me k

[jira] Commented: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=comments#action_12425356 ] David Van Couvering commented on DERBY-1629: I think what you described is in the SQL spec is not what is happening in this code right now, and should

[jira] Updated: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=all ] David Van Couvering updated DERBY-1629: --- Description: In Java SE 6 runtime environments, an application may not get the SQL Exception with SQL State 38000 when execution of a trigger or p

derby-developers group request

2006-08-02 Thread Adams, James F
Could someone add me to the derby-developers group? (jira user james.f.adams) James F. Adams

[jira] Commented: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=comments#action_12425354 ] Daniel John Debrunner commented on DERBY-1629: -- I think it's also worth re-validating the requirements, some of the assumptions about that method are

[jira] Commented: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=comments#action_12425349 ] Daniel John Debrunner commented on DERBY-1629: -- Can the summary of this bug be changed to reflect the impact on/change to/incorect behavaiour an appli

[jira] Updated: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

2006-08-02 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1633?page=all ] A B updated DERBY-1633: --- Component/s: SQL (was: Regression Test Failure) > Regression: The fields of views are not being calculated properly since > 10.1.2.4 > -

[jira] Assigned: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

2006-08-02 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1633?page=all ] A B reassigned DERBY-1633: -- Assignee: A B Looks like an issue with the predicate scoping that occurs as part of predicate pushdown for UNIONs--see DERBY-805. I will look into it... > Regression: Th

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

2006-08-02 Thread Craig Russell (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12425340 ] Craig Russell commented on DERBY-1516: -- There is different behavior between embedded and network in other areas as well as the one I'm looking at here. I'd li

[jira] Created: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

2006-08-02 Thread Prasenjit Sarkar (JIRA)
Regression: The fields of views are not being calculated properly since 10.1.2.4 Key: DERBY-1633 URL: http://issues.apache.org/jira/browse/DERBY-1633 Project: Derby

[jira] Commented: (DERBY-1522) Switch(if supported) from Derby Authorization to Derby SQL Standard Authorization needs to be tested

2006-08-02 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1522?page=comments#action_12425338 ] Satheesh Bandaram commented on DERBY-1522: -- 1) Mamta says: "after the upgrade, all the existing schemas and objects in them should be owned by the dba and

Re: Enforcing length restrictions for streams of unknown length

2006-08-02 Thread Mike Matrigali
Mike Matrigali wrote: This may or may not work, not sure. Here is stuff to be aware of. If you do this approach, the store will go ahead and insert and log data into the database. For it to work correctly you will have to make sure that the resulting error from the limit at least aborts the

[jira] Closed: (DERBY-1630) NetConnection40 references an engine class, org.apache.derby.impl.jdbc.Util

2006-08-02 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1630?page=all ] Andrew McIntyre closed DERBY-1630. -- > NetConnection40 references an engine class, org.apache.derby.impl.jdbc.Util > --- > >

Re: Enforcing length restrictions for streams of unknown length

2006-08-02 Thread Mike Matrigali
This may or may not work, not sure. Here is stuff to be aware of. If you do this approach, the store will go ahead and insert and log data into the database. For it to work correctly you will have to make sure that the resulting error from the limit at least aborts the statement which is doing

[jira] Resolved: (DERBY-1630) NetConnection40 references an engine class, org.apache.derby.impl.jdbc.Util

2006-08-02 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1630?page=all ] Andrew McIntyre resolved DERBY-1630. Resolution: Fixed Derby Info: (was: [Patch Available]) Commited to trunk with revision 428065. > NetConnection40 references an engine class, org.

Re: How to take connection from derby using DataSource class

2006-08-02 Thread David Van Couvering
Hi, Sube. Take a look at http://db.apache.org/derby/docs/dev/devguide/cdevresman89722.html David Sube Singh wrote: Can any one help me how to take connection from Derby using datasource class instead of using JDBC Driver.

Re: Unexplained diff in procedureInTrigger.sql for JDK 1.6

2006-08-02 Thread David Van Couvering
Thanks for the tips, Mike. I think I'd like to go for adjusting the output rather than comment out the statement or pull the test, since it is specific to JDK 1.6. David Mike Matrigali wrote: Daniel John Debrunner wrote: David Van Couvering wrote: Now that I think of it further, I susp

[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-02 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1619?page=comments#action_12425304 ] Andrew McIntyre commented on DERBY-1619: [JDK13CLEANUP] > Sysinfo in 10.2 shows multiple entries if the derby jars reside in a > directory with spaces in

Re: Using StorageFactory to create temporary files

2006-08-02 Thread Mike Matrigali
This is an unexpected usage, this was never designed for that purpose. It was originally designed as a module only to be used underneath the store module. The purpose was to allow alternate implementations of the underlying filesystem. I wonder why straight java i/o stream interfaces were not us

[jira] Updated: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=all ] David Van Couvering updated DERBY-1629: --- Priority: Minor (was: Major) > StandardException.unexpectedUserException() does not correctly catch > internally generated exceptions as of JDK

[jira] Commented: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=comments#action_12425296 ] David Van Couvering commented on DERBY-1629: Thanks for your thoughts, Rick. It seems to me that for (3) if a user set a Derby exception as a cause, g

[jira] Assigned: (DERBY-1544) Address remaining upgrade task(s) to complete full upgrade mechanism for GRANT/REVOKE, specifically with changing database owner name from 'DBA' to authorizationId of use

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1544?page=all ] Deepa Remesh reassigned DERBY-1544: --- Assignee: Deepa Remesh > Address remaining upgrade task(s) to complete full upgrade mechanism for > GRANT/REVOKE, specifically with changing database own

[jira] Commented: (DERBY-1522) Switch(if supported) from Derby Authorization to Derby SQL Standard Authorization needs to be tested

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1522?page=comments#action_12425295 ] Deepa Remesh commented on DERBY-1522: - Thanks for the clarification, Mamta. I'll take a look at DERBY-1544. > Switch(if supported) from Derby Authorization to

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

2006-08-02 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1456?page=all ] Sunitha Kambhampati closed DERBY-1456. -- Thanks very much Bryan for the review and commit of this fix. I ran some tests and have verified it as complete. So closing this issue. > Network Se

[jira] Updated: (DERBY-1473) Add cut-off and truncation logic to streaming classes in the embedded driver

2006-08-02 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1473?page=all ] Kristian Waagan updated DERBY-1473: --- Urgency: Normal Fix Version/s: 10.2.0.0 Affects Version/s: 10.2.0.0 (was: 10.3.0.0) Priority:

[jira] Commented: (DERBY-1522) Switch(if supported) from Derby Authorization to Derby SQL Standard Authorization needs to be tested

2006-08-02 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1522?page=comments#action_12425289 ] Mamta A. Satoor commented on DERBY-1522: Deepa, to be more precise, in my statement "after the upgrade, all the existing schemas and objects in them should

Enforcing length restrictions for streams of unknown length

2006-08-02 Thread Kristian Waagan
Hello, My initial work on the new JDBC4 length less overloads are approaching completion, but I still have one issue that must be solved. Currently, streams with unknown length are materialized to determine the length. This is the approach I have implemented in the client driver in lack of a

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

2006-08-02 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1616?page=all ] David Van Couvering resolved DERBY-1616. Resolution: Fixed Sending java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java Sending java/testing/org/apache/de

[jira] Commented: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=comments#action_12425281 ] Rick Hillegas commented on DERBY-1629: -- Here are various ways to tackle this problem: 1) We could create a parallel universe of SQLException subclasses, which

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

2006-08-02 Thread Laura Stewart
*** (LS) Thank you Mamta. This is very helpful. I don't think that the Derby docs do a good job of describing the difference between user authentication and user authorization, and I will update the draft text that I posted for grant/revoke to make it more clear what the different properties do.

Regression Test Failure! - TinderBox_Derby 427970 - Sun DBTG

2006-08-02 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 427970/2006-08-02 14:52:43 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1687686 2 167.52% SunOS-5.10_i86pc-i386 Details in http://www.mult

[jira] Assigned: (DERBY-1473) Add cut-off and truncation logic to streaming classes in the embedded driver

2006-08-02 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1473?page=all ] Kristian Waagan reassigned DERBY-1473: -- Assignee: Kristian Waagan > Add cut-off and truncation logic to streaming classes in the embedded driver > -

Re: is it expected that there is no "time" bomb for junit tests?

2006-08-02 Thread Kristian Waagan
Rick Hillegas wrote: The following link explains how to set the timeout for an individual JUnit test case--however, this mechanism requires jdk1.5 or higher: http://www.instrumentalservices.com/content/view/45/52/#_Timing_out_a_test I must admit that JUnit4 seems to have several nice features

[jira] Commented: (DERBY-1522) Switch(if supported) from Derby Authorization to Derby SQL Standard Authorization needs to be tested

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1522?page=comments#action_12425269 ] Deepa Remesh commented on DERBY-1522: - Thanks Mamta for sharing your thoughts on this. Reading this and the comments in DERBY-1544, I am confused and wondering

Re: is it expected that there is no "time" bomb for junit tests?

2006-08-02 Thread Rick Hillegas
The following link explains how to set the timeout for an individual JUnit test case--however, this mechanism requires jdk1.5 or higher: http://www.instrumentalservices.com/content/view/45/52/#_Timing_out_a_test In addition, if you run JUnit tests under ant, you can use the timeout attribute o

[jira] Commented: (DERBY-1630) NetConnection40 references an engine class, org.apache.derby.impl.jdbc.Util

2006-08-02 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1630?page=comments#action_12425267 ] Rick Hillegas commented on DERBY-1630: -- The patch looks good to me. It follows the standard pattern for creating SQLExceptions in the network client. > NetCo

Using StorageFactory to create temporary files

2006-08-02 Thread Rick Hillegas
The patch attached to DERBY-1341 uses the StorageFactory to create a temporary file on behalf of the embedded JDBC layer. Is this usage OK? Does this violate some assumptions about what server layers are allowed to use the StorageFactory? Would appreciate guidance here. I am out of my depth.

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

2006-08-02 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-700?page=comments#action_12425259 ] Rick Hillegas commented on DERBY-700: - Where can Derby store VM-global state? It has been pointed out that System properties are an awkward kind of VM-global st

has anyone seen the jdbcapi/SURTest.junit test hang?

2006-08-02 Thread Mike Matrigali
A run of derbyall hung for me last night while executing the jdbcapi/SURTest.junit. I was running against the latest codeline with only the patch for DERBY-1456, which bryan ran and passed for him. The test passed in this codeline when run standalone - I only tried it standalone a couple of time

is it expected that there is no "time" bomb for junit tests?

2006-08-02 Thread Mike Matrigali
While running derbyall my run hung all night on a junit test, I assume this is expected if the test hung.

Re: Unexplained diff in procedureInTrigger.sql for JDK 1.6

2006-08-02 Thread Mike Matrigali
Daniel John Debrunner wrote: David Van Couvering wrote: Now that I think of it further, I suspect it is not good practice to hold a test hostage waiting for this bug to be fixed, and I should probably add a jdk16-specific master file for procedureInTrigger.sql. I can point the reader of the

Question around type in DRDA(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 Clie

2006-08-02 Thread TomohitoNakayama
Hello. Concerning DERBY-1610, I'm surveying type definition part in current DRDA relating code. I found there exists two word "DRDA_TYPE" and "FDOCA_TYPE". Former was found in org.apache.derby.iapi.reference.DRDAConstants and latter was found in org.apache.derby.client.net.FdocaConstants. The

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

2006-08-02 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1456?page=all ] Bryan Pendleton resolved DERBY-1456. Fix Version/s: 10.2.0.0 Resolution: Fixed Derby Info: (was: [Patch Available]) Using the technique suggested by Sunitha in the notes, wh

How to take connection from derby using DataSource class

2006-08-02 Thread Sube Singh
Can any one help me how to take connection from Derby using datasource class instead of using JDBC Driver.

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

2006-08-02 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1579?page=comments#action_12425246 ] Deepa Remesh commented on DERBY-1579: - I ran derbyall using Sun jdk 1.4.2 on Windows XP with the updated patch 'derby1579trunkdiff02.txt'. I am seeing one diff

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

2006-08-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1625?page=all ] Daniel John Debrunner resolved DERBY-1625. -- Resolution: Fixed Assignee: Daniel John Debrunner Fixed by commit #427801 under DERBY-1609 > wisconsin test unable to establish conne

[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-02 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1610?page=comments#action_12425235 ] Tomohito Nakayama commented on DERBY-1610: -- Reading the code, it seems that NetworkServer recognize the type of the parameter, according to the SQL and no

[jira] Updated: (DERBY-1629) StandardException.unexpectedUserException() does not correctly catch internally generated exceptions as of JDK 1.6

2006-08-02 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1629?page=all ] Rick Hillegas updated DERBY-1629: - Urgency: Normal Fix Version/s: 10.2.0.0 > StandardException.unexpectedUserException() does not correctly catch > internally generated exceptions as

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

2006-08-02 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=comments#action_12425219 ] Rick Hillegas commented on DERBY-1417: -- Thanks for the explanation, Kristian. Committed at subversion revision 427969. > Add new, lengthless overloads to the

[jira] Commented: (DERBY-1614) Test harness overrides heap size settings when starting Network Server

2006-08-02 Thread John H. Embretsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1614?page=comments#action_12425214 ] John H. Embretsen commented on DERBY-1614: -- Here is an illustration of how the NetServer class handles heap size settings when 'DERBY-1614_v1.diff' is app

[jira] Updated: (DERBY-1614) Test harness overrides heap size settings when starting Network Server

2006-08-02 Thread John H. Embretsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1614?page=all ] John H. Embretsen updated DERBY-1614: - Derby Info: [Patch Available] > Test harness overrides heap size settings when starting Network Server > -

  1   2   >