[jira] Updated: (DERBY-2524) DataTypeDescriptor(DTD) needs to have collation type and collation derivation. These new fields will apply only for character string types. Other types should ignore them.

2007-04-05 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor updated DERBY-2524: --- Attachment: DERBY2524_Collation_Info_In_DTD_v2_stat.txt

[jira] Updated: (DERBY-2506) Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data (FDODTA) of the SQLDTA objects

2007-04-05 Thread V.Narayanan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] V.Narayanan updated DERBY-2506: --- Attachment: PreparedCallable_DRDA_Test_diff_v3.stat

[jira] Updated: (DERBY-2506) Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data (FDODTA) of the SQLDTA objects

2007-04-05 Thread V.Narayanan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] V.Narayanan updated DERBY-2506: --- Attachment: PreparedCallable_DRDA_v3.stat PreparedCallable_DRDA_v3.diff Fixed the

Regression Test Report - tinderbox_trunk16 525729 - Sun DBTG

2007-04-05 Thread Ole . Solberg
[Auto-generated mail] *tinderbox_trunk16* 525729/2007-04-05 08:42:22 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 1361360 097.84% derbyall F:1,E:172937291 0

[jira] Updated: (DERBY-2444) Implement not implemented methods Blob.getBinaryStream(long pos, long length) and Clob. getCharacterStream(long pos, long length) in the Network Client

2007-04-05 Thread V.Narayanan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] V.Narayanan updated DERBY-2444: --- Attachment: ClobBlobNotImplemented_v4.stat ClobBlobNotImplemented_v4.diff I have

[jira] Commented: (DERBY-2444) Implement not implemented methods Blob.getBinaryStream(long pos, long length) and Clob. getCharacterStream(long pos, long length) in the Network Client

2007-04-05 Thread V.Narayanan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486940 ] V.Narayanan commented on DERBY-2444: The last check should have been pos+length (length of LOB) in the above

[jira] Commented: (DERBY-2444) Implement not implemented methods Blob.getBinaryStream(long pos, long length) and Clob. getCharacterStream(long pos, long length) in the Network Client

2007-04-05 Thread V.Narayanan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486941 ] V.Narayanan commented on DERBY-2444: Also it should not have been satisfy the following but rather do not

running the XML tests

2007-04-05 Thread Rick Hillegas
I'd like to setup my environment so that our XML tests run. I'm having a hard time finding instructions for how to do this. Can someone point me at the instructions for how to do this (which versions of which jar files should be put where, any additional bootclasspath/classpath directives,

Re: running the XML tests

2007-04-05 Thread V Narayanan
Hi, This issue seems to contain some information related to your question https://issues.apache.org/jira/browse/DERBY-563 Narayanan Rick Hillegas wrote On 04/05/07 19:39,: I'd like to setup my environment so that our XML tests run. I'm having a hard time finding instructions for how to do

Re: running the XML tests

2007-04-05 Thread Bryan Pendleton
I'd like to setup my environment so that our XML tests run. I think if you're using a modern enough JDK, no special setup is needed. If you're using JDK 1.4, in my environment it was sufficient to grab a modern copy of the xalan jars (I used 2.7 I believe) and copy them to my jre/lib/ext

[jira] Commented: (DERBY-1054) Starting Derby with the NetServlet inside of tomcat does not allow binding to non localhost interface.

2007-04-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486977 ] Bryan Pendleton commented on DERBY-1054: Are there tests in our test suite for NetServlet? Starting Derby

[jira] Commented: (DERBY-2526) Wrong query results due to column ordering in UNION view

2007-04-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486979 ] Bryan Pendleton commented on DERBY-2526: The two query plans are *substantially* different. They seem to

Re: running the XML tests

2007-04-05 Thread Rick Hillegas
Thanks Bryan and Narayanan, I have downloaded xalan 2.7.0 (that seems to be the latest release available from the xalan site). I copied the four jar files mentioned by Bryan into the jre/lib/ext directory of my JDK 1.4. This did slightly change the output of the environmental report created

Re: running the XML tests

2007-04-05 Thread Bryan Pendleton
available from the xalan site). I copied the four jar files mentioned by Bryan into the jre/lib/ext directory of my JDK 1.4. Ooops, I'm sorry. Copy the files to the jre/lib/endorsed directory, not the jre/lib/ext directory. thanks, bryan

Re: running the XML tests

2007-04-05 Thread V Narayanan
Hi, I am lost here because placing the jar files in the jre/lib/ext is the standard override mechanism. The information here http://xml.apache.org/xalan-j/faq.html#faq-N100D6 seems to concur with that. Narayanan Rick Hillegas wrote On 04/05/07 20:37,: Thanks Bryan and Narayanan, I have

Re: running the XML tests

2007-04-05 Thread V Narayanan
I did not read it properly I read the information in the link as java-home\lib\endorsed directory not jre/ext/lib. Sorry about the mistake. Narayanan V Narayanan wrote On 04/05/07 20:52,: Hi, I am lost here because placing the jar files in the jre/lib/ext is the standard override

Re: running the XML tests

2007-04-05 Thread Army
Rick Hillegas wrote: I have downloaded xalan 2.7.0 (that seems to be the latest release available from the xalan site). I copied the four jar files mentioned by Bryan into the jre/lib/ext directory of my JDK 1.4. This did slightly change the output of the environmental report created by

Re: running the XML tests

2007-04-05 Thread V Narayanan
Army wrote On 04/05/07 20:56,: Rick Hillegas wrote: I have downloaded xalan 2.7.0 (that seems to be the latest release available from the xalan site). I copied the four jar files mentioned by Bryan into the jre/lib/ext directory of my JDK 1.4. This did slightly change the output of the

[jira] Subscription: Derby: JIRA issues with patch available

2007-04-05 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (19 issues) Subscriber: derby-dev Key Summary DERBY-2444 Implement not implemented methods Blob.getBinaryStream(long pos, long length) and Clob. getCharacterStream(long pos, long length) in the Network Client

Regression Test Report - Daily 524622S3 - Sun DBTG

2007-04-05 Thread Henri . Vandescheur
[Auto-generated mail] *Daily* 524622S3/2007-04-01 18:00:11 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin NA NA NANA derbyall NA NA NANA suitesAll sles NA

Re: running the XML tests

2007-04-05 Thread Rick Hillegas
Thanks Army, Bryan, and Narayanan. I can now run the XML tests. The following worked for me: 1) Copying the xalan 2.7.0 jars into jre/lib/endorsed in my JDK 1.4 installation. 2) Simply wiring those jars into my CLASSPATH when running Java 6. I think this deserves being documented somewhere.

Re: running the XML tests

2007-04-05 Thread Army
Rick Hillegas wrote: Thanks Army, Bryan, and Narayanan. I can now run the XML tests. Good to hear! I think this deserves being documented somewhere. Maybe under Running Tests on the DerbyJUnitTesting wiki page? Is there a better place for this advice? I think the wiki would be helpful,

Re: running the XML tests

2007-04-05 Thread Army
Army wrote: I think the wiki would be helpful, yes. It also might be helpful to include these as javadoc comments somehow, perhaps for the checkXalanVersion() method of junit/XML.java? Or maybe someplace else that you looked when you yourself were trying to figure out why the tests

Re: running the XML tests

2007-04-05 Thread Rick Hillegas
Army wrote: Army wrote: I think the wiki would be helpful, yes. It also might be helpful to include these as javadoc comments somehow, perhaps for the checkXalanVersion() method of junit/XML.java? Or maybe someplace else that you looked when you yourself were trying to figure out why the

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

2007-04-05 Thread Mike Matrigali
Overall I prefer your proposal to mine, assuming it works. Have you had a chance to prototype this on a non-windows system? I couldn't find a problem in the pseudo-code from reading it. My concerns are: 1) Can we count on class finalizers? What, if any situations are there that should have

Re: DERBY-1478 : Making the correct collation type available in CreateTableNode for character string type columns

2007-04-05 Thread Mamta Satoor
Here is what I am thinking of how to make the correct default collation Type available in SchemaDescriptor(SD). DataDictionary(DD) will have two additional fields and two additional apis. The field names will be int collationTypeOfSystemSchemas int collationTypeOfUserSchemas The apis associated

Re: DERBY-1478 : Making the correct collation type available in CreateTableNode for character string type columns

2007-04-05 Thread Mamta Satoor
Just one clarificaiton, the reason I am having SD's constructor call DD to get the collation type rather than collationType simply getting passed to SD's constructor is that the later approach would require us to change all the places where a SD object is created and have them pass the additional

Re: running the XML tests

2007-04-05 Thread Army
Rick Hillegas wrote: I like the idea of recording this advice in the javadoc too. Another possibility would be to beef up the javadoc header for the XML class. +1, works for me. Army

[jira] Updated: (DERBY-2502) Unclosed ResultSets choke JUnit lang _Suite on java 6

2007-04-05 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-2502: - Attachment: derby-2502-02.diff Committed derby-2502-02.diff at subversion revision 525924. This

[jira] Updated: (DERBY-2500) Assertion failure preparing query with AND and OR in where clause

2007-04-05 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] A B updated DERBY-2500: --- Attachment: d2500_v3.patch Committed d2500_v3.patch, which is the same as the _v2 patch except that the second new

[jira] Resolved: (DERBY-2500) Assertion failure preparing query with AND and OR in where clause

2007-04-05 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] A B resolved DERBY-2500. Resolution: Fixed Fix Version/s: 10.3.0.0 Derby Info: (was: [Patch Available]) Assertion failure

[jira] Commented: (DERBY-2502) Unclosed ResultSets choke JUnit lang _Suite on java 6

2007-04-05 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487075 ] A B commented on DERBY-2502: I verified that lang/XMLTypeAndOpsTest is now running cleanly again. Thank you for

[jira] Updated: (DERBY-378) support for import/export of tables with clob/blob and the other binary data types will be good addition to derby,

2007-04-05 Thread Suresh Thalamati (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Thalamati updated DERBY-378: --- Attachment: iexlobs_v1.txt updated the spec and added some notes for dcoumnentation.

[jira] Created: (DERBY-2527) Add documentation for import/export of LOBS and other binary data types.

2007-04-05 Thread Suresh Thalamati (JIRA)
Add documentation for import/export of LOBS and other binary data types. --- Key: DERBY-2527 URL: https://issues.apache.org/jira/browse/DERBY-2527 Project: Derby

[jira] Updated: (DERBY-2527) Add documentation for import/export of LOBS and other binary data types.

2007-04-05 Thread Suresh Thalamati (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Thalamati updated DERBY-2527: Attachment: iexlobs_v1.txt updated version of spec and some notes for the documentation.

[jira] Updated: (DERBY-2502) Unclosed ResultSets choke JUnit lang _Suite on java 6

2007-04-05 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-2502: - Attachment: derby-2502-03.diff Committed derby-2503-03.diff at subversion revision 525933: M

Regression Test Report - tinderbox_trunk16 525870 - Sun DBTG

2007-04-05 Thread Ole . Solberg
[Auto-generated mail] *tinderbox_trunk16* 525870/2007-04-05 18:52:44 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 1361360 097.64% derbyall F:1,E:172937291 0

[jira] Created: (DERBY-2528) Set the correct collation type in SchemaDescriptor. The collation type will be UCS_BASIC for system schemas but it can be TERRITORY_BASED/UCS_BASIC for user schemas.

2007-04-05 Thread Mamta A. Satoor (JIRA)
Set the correct collation type in SchemaDescriptor. The collation type will be UCS_BASIC for system schemas but it can be TERRITORY_BASED/UCS_BASIC for user schemas.

[jira] Commented: (DERBY-2528) Set the correct collation type in SchemaDescriptor. The collation type will be UCS_BASIC for system schemas but it can be TERRITORY_BASED/UCS_BASIC for user schemas.

2007-04-05 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487103 ] Mamta A. Satoor commented on DERBY-2528: Here is what I am thinking of how to make the correct default

Re: DERBY-1478 : Making the correct collation type available in CreateTableNode for character string type columns

2007-04-05 Thread Mamta Satoor
I have created Jira entry DERBY-2528 for work that needs to go in for collation type in SD. Mamta On 4/5/07, Mamta Satoor [EMAIL PROTECTED] wrote: Just one clarificaiton, the reason I am having SD's constructor call DD to get the collation type rather than collationType simply getting passed

[jira] Updated: (DERBY-2467) Convert lang/updateCursor.java to JUnit

2007-04-05 Thread Ugo Matrangolo (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ugo Matrangolo updated DERBY-2467: -- Attachment: DERBY-2467_stat_050407.txt DERBY-2467_diff_050407.txt Hi Andrew,

[jira] Updated: (DERBY-2467) Convert lang/updateCursor.java to JUnit

2007-04-05 Thread Ugo Matrangolo (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ugo Matrangolo updated DERBY-2467: -- Attachment: DERBY-2467_diff_050407_2.txt Fixed a missing fail string. Convert

[jira] Updated: (DERBY-2467) Convert lang/updateCursor.java to JUnit

2007-04-05 Thread Ugo Matrangolo (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ugo Matrangolo updated DERBY-2467: -- Derby Info: [Patch Available] Convert lang/updateCursor.java to JUnit

Regression Test Report - tinderbox_trunk16 525953 - Sun DBTG

2007-04-05 Thread Ole . Solberg
[Auto-generated mail] *tinderbox_trunk16* 525953/2007-04-05 22:22:45 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 1361360 097.39% derbyall F:1,E:172947292 0

[jira] Updated: (DERBY-2488) When loaded by jvm1.6 - EmbeddedConnectionPoolDataSource is not returning a JDBC 4 compliant PooledConnection object

2007-04-05 Thread Stan Bradbury (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stan Bradbury updated DERBY-2488: - Description: Updated the problem description to reflect the actual issue [Stan 4/5/07]:

Re: [jira] Commented: (DERBY-1054) Starting Derby with the NetServlet inside of tomcat does not allow binding to non localhost interface.

2007-04-05 Thread Myrna van Lunteren
n 4/5/07, Bryan Pendleton (JIRA) [EMAIL PROTECTED] wrote: [ https://issues.apache.org/jira/browse/DERBY-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486977 ] Bryan Pendleton commented on DERBY-1054: Are there

Re: Page could not be read from disk

2007-04-05 Thread Stanley Bradbury
Jessie Lee wrote: --- SNIP --- Hi, Stanley, Thanks for the reply. I got the following error from derby.log. I tried to restart the database and kept getting the same error. I guess the database is corrupted? Is there a way to fix the database? Thanks, Jessie java.io.EOFException

Re: Page could not be read from disk

2007-04-05 Thread Bryan Pendleton
thrown executing the JAVA method java.io.RandomAccessFile.readFully caused by the end of the file (EOF) being reached unexpectedly. It would be good to check your disk and system logs for reports of Disk or I/O problems. Perhaps also check to see if your disk filled up. It seems that Derby

Re: [jira] Commented: (DERBY-1054) Starting Derby with the NetServlet inside of tomcat does not allow binding to non localhost interface.

2007-04-05 Thread Bryan Pendleton
Thanks for the comments, Myrna! I am also wondering if allowing remote servers to get started - and stopped - would pose a security risk. Unless the app server is started with security manager, I guess. Do you think that allowing the hostname value to be set in the web.xml makes the security

[jira] Commented: (DERBY-2526) Wrong query results due to column ordering in UNION view

2007-04-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487128 ] Bryan Pendleton commented on DERBY-2526: In the good query plan, table B4 is joined against the UNION, and

Database implementation help

2007-04-05 Thread Steve Morin
I am looking to implement a sql parser, I have been looking for a book or paper on the subject with little to no luck. Can any one point me in the right direction or suggest a book on the subject? I would appreciate any pointers to resources on the subject. Steve

Re: [jira] Commented: (DERBY-1054) Starting Derby with the NetServlet inside of tomcat does not allow binding to non localhost interface.

2007-04-05 Thread Myrna van Lunteren
On 4/5/07, Bryan Pendleton [EMAIL PROTECTED] wrote: Thanks for the comments, Myrna! I am also wondering if allowing remote servers to get started - and stopped - would pose a security risk. Unless the app server is started with security manager, I guess. Do you think that allowing the

Re: [jira] Commented: (DERBY-1054) Starting Derby with the NetServlet inside of tomcat does not allow binding to non localhost interface.

2007-04-05 Thread Bryan Pendleton
Myrna van Lunteren wrote: I don't think there's much of any warning in or near the servlet re security issues. This is an excellent point. I think it would be good to add text such as the following in two places: 1) As XML comments in the web.xml file for the host init-param 2) In the

Re: [jira] Commented: (DERBY-1054) Starting Derby with the NetServlet inside of tomcat does not allow binding to non localhost interface.

2007-04-05 Thread Myrna van Lunteren
On 4/5/07, Bryan Pendleton [EMAIL PROTECTED] wrote: Myrna van Lunteren wrote: I don't think there's much of any warning in or near the servlet re security issues. This is an excellent point. I think it would be good to add text such as the following in two places: 1) As XML comments in the