gmane.comp.apache.db.derby.devel

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

2008-12-01T16:35:44

Issue Subscription Filter: Derby: JIRA issues with patch available (6 issues) Subscriber: derby-dev Key Summary DERBY-3270 Delayed (on-demand) creation of current user schema makes select from view belonging to other schema fail. https://issues.apache.org/jira/browse/DERBY-3270 DERBY-3193 SQL roles: Add documentation https://issues.apache.org/jira/browse/DERBY-3193 DERBY-481 implement SQL generated columns https://issues.apache.org/jira/browse/DERBY-481 DERBY-3958 ImportExportProcedures imports ./testData/ImportExport/position_info.del using US-ASCII but the file contains non-ascii characters https://issues.apache.org/jira/browse/DERBY-3958 DERBY-3788 Provide a zero-admin way of updating the statisitcs of an index https://issues.apache.org/jira/browse/DERBY-3788 DERBY-2895 convert lang/declareGlobalTempTableJavaJDBC30.java to JUnit https://issues.apache.org/jira/browse/DERBY-2895

JDK 1.4 support

Rick Hillegas — 2008-12-01T14:32:09

The user list has been discussing Derby's future support for JDK 1.4: http://www.nabble.com/JDK-1.4-support--td20650279.html#a20650279 I am moving that thread over to the developer list now. Dag and Knut have raised the issue of small device support. BUILDING.txt suggests that Derby will run on CDC/Foundation Profile 1.0. I don't believe that's true anymore. I think that we abandoned CDC/FP 1.0 when we abandoned JDK 1.3. For the last couple releases, I believe that we have only been claiming that Derby will run on CDC/FP 1.1.2. That api is a subset of JDK 1.4.2 (see for instance http://java.sun.com/products/foundation/ ). Our current small device claims aren't based on compile-time checks. Instead, we rely on warnings raised by community members who run the tests on small platforms. If we want to continue supporting small devices, then I think that we ought to be compiling the bulk of the core engine against CDC/FP 1.1.2 libraries, not against JDK 1.4.2 libraries. Regards, -Rick

[jira] Created: (DERBY-3967) NPE when reading from stream/reader after commit or connection close

Kristian Waagan (JIRA — 2008-12-01T10:00:45

NPE when reading from stream/reader after commit or connection close -------------------------------------------------------------------- Key: DERBY-3967 URL: https://issues.apache.org/jira/browse/DERBY-3967 Project: Derby Issue Type: Bug Components: JDBC Affects Versions: 10.4.2.0, 10.3.3.0, 10.5.0.0 Reporter: Kristian Waagan Priority: Minor If a stream with a LOB as source is obtained through one of the result set getXStream methods, a NullPointerException is thrown if an attempt to read from the stream after connection commit or close is made. Derby should fail more gracefully by informing the user that the LOB has been closed or made unavailable due to a commit/rollback.

Regression Test Report - Daily 721688 - Sun DBTG

2008-11-30T16:55:20

[Auto-generated mail] *Daily* 721688/2008-11-29 18:01:22 MET Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.6* lin 0 10857 10857 0 1662.30% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 82.05% derbyall 0 2 2 0 335.52% compatibility 0 2 2 0 .% demoSuite sles 0 10857 10857 0 1046.65% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 69.73% derbyall 0 2 2 0 166.39% compatibility 0 2 2 0 .% demoSuite sol F:1,E:0 10857 10856 0

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

2008-11-30T16:35:45

Regression Test Report - Daily 721534 - Sun DBTG

2008-11-29T16:55:21

[Auto-generated mail] *Daily* 721534/2008-11-28 18:01:55 MET Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.6* lin NA NA NA NA suitesAll NA NA NA NA jdbcapiAutoLoad NA NA NA NA JDBCDriversAll NA NA NA NA JDBCDriversClient NA NA NA NA JDBCDriversEmbedded NA NA NA NA derbyall NA NA NA NA compatibility NA NA NA NA demoSuite sles F:0,E:1 10857 10856 0 1086.12% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 69.87% derbyall 0 2 2 0 138.05% compatibility 0 2 2 0 .% demoSuite

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

2008-11-29T16:36:44

Regression Test Report - Daily 721241 - Sun DBTG

2008-11-28T16:55:32

[Auto-generated mail] *Daily* 721241/2008-11-27 18:01:50 MET Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.6* lin NA NA NA NA suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 83.27% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite sles 0 10857 10857 0 1052.95% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 68.16% derbyall 0 2 2 0 134.76% compatibility 0 2 2 0 .% demoSuite sol F:1,E:0 10857 10856 0

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

2008-11-28T16:35:44

Issue Subscription Filter: Derby: JIRA issues with patch available (5 issues) Subscriber: derby-dev Key Summary DERBY-481 implement SQL generated columns https://issues.apache.org/jira/browse/DERBY-481 DERBY-3193 SQL roles: Add documentation https://issues.apache.org/jira/browse/DERBY-3193 DERBY-3958 ImportExportProcedures imports ./testData/ImportExport/position_info.del using US-ASCII but the file contains non-ascii characters https://issues.apache.org/jira/browse/DERBY-3958 DERBY-3788 Provide a zero-admin way of updating the statisitcs of an index https://issues.apache.org/jira/browse/DERBY-3788 DERBY-2895 convert lang/declareGlobalTempTableJavaJDBC30.java to JUnit https://issues.apache.org/jira/browse/DERBY-2895

Tomcat Derby JSP Help needed! please

teamderby — 2008-11-28T16:12:22

hi guys, I'm having a bit of trouble configuring apache tomcat to work with a derby database on mac OS. Below are the steps I took. The error I get when trying to acces the page from a jsp page is "java.sql.SQLException: No suitable driver". Can anyone please help, i'd be very very grateful. Thanks, Mike I've created a derby database using the ij tool at location: home/derby/db I've installed Tomcat 6.0.18 at home/applications/apache-tomcat-6.0.18/ and created a webapp at /apache-tomcat-6.0.18/webapps/ROOT i've attempted to integrate the db with tomcat by: sever.xml. adding: and to webapps/ROOT/server.xml

javax.servlet.jsp.jstl.sql.dataSource

[jira] Created: (DERBY-3966) Do not require JRE 1.4 libraries at compile time since SUN's JDK 1.4 went out of support and can be used on JRE 1.4 without any problem

Pedro Faundez Gonzalez (JIRA — 2008-11-27T18:42:44

Do not require JRE 1.4 libraries at compile time since SUN's JDK 1.4 went out of support and can be used on JRE 1.4 without any problem --------------------------------------------------------------------------------------------------------------------------------------- Key: DERBY-3966 URL: https://issues.apache.org/jira/browse/DERBY-3966 Project: Derby Issue Type: Task Components: Build tools Reporter: Pedro Faundez Gonzalez In the "JDK 1.4 support" conversation at Derby Users: http://www.nabble.com/JDK-1.4-support--td20650279.html I made a point that JRE 1.4 should not be required for build since SUN's JRE 1.4 went End Of Life.

Regression Test Report - Daily 720917 - Sun DBTG

2008-11-27T16:55:34

[Auto-generated mail] *Daily* 720917/2008-11-26 18:01:55 MET Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.6* lin 0 10857 10857 0 1664.85% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 84.21% derbyall 0 2 2 0 367.39% compatibility 0 2 2 0 .% demoSuite sles UNKOWN UNKOWN UNKOWN UNKOWN 0.00% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 70.10% derbyall UNKOWN UNKOWN UNKOWN UNKOWN 0.00% compatibility 0 2 2 0 .% demoSuite sol F:

[jira] Created: (DERBY-3965) Eclipse plugin fails to load on x86_64 platforms

James Davis (JIRA — 2008-11-27T16:38:44

Eclipse plugin fails to load on x86_64 platforms ------------------------------------------------ Key: DERBY-3965 URL: https://issues.apache.org/jira/browse/DERBY-3965 Project: Derby Issue Type: Bug Components: Eclipse Plug-in Affects Versions: 10.4.2.0 Environment: Ubuntu 8.10 x86_64 linux, Sun JDK 5.0_u16, Eclipse 3.4 SR 1 Reporter: James Davis I just recently re-install ubuntu on my laptop and used the x86_64 version of Ubuntu. Before the re-install, I had eclipse 3.4 SR1 installed and functional with the derby plugin. After a fresh install of ubuntu and eclipse, the derby plugin fails to load (even on the same projects it worked with before). I cannot find any errors in any log files either.

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

2008-11-27T16:36:44

SYSCS_UTIL.SYSCS_COMPRESS_TABLE

Wei Jiang — 2008-11-26T21:48:06

Hi, Can I use SYSCS_UTIL.SYSCS_COMPRESS_TABLE and SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE when the database is working with insert/delete/update? Thanks.

[jira] Issue Comment Edited: (DERBY-481) implement SQL generated columns

Dag H. Wanvik (JIRA — 2008-11-27T02:52:46

[ https://issues.apache.org/jira/browse/DERBY-481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651231#action_12651231 ] dagw edited comment on DERBY-481 at 11/26/08 6:52 PM: --------------------------------------------------------------- Reviewed derby-481-14-ab-dropColumn. Thanks again Rick! The patch is good to commit. My notes: * AlterTableConstantAction.java: - The following fragment threw me off at first: Surely,, since we are talkign about size after cascaded drops, th test should be against 0? But no, the quantity sizeAfterCascadedDrops does not include the original dropped column, so the code works, but is a bit misleading. Maybe do: int sizeAfterCascadedDrops = td.getColumnDescriptorList().size() - 1 - cascadedDrops; // Can not drop a column if it there would be no columns left: if (sizeAfterCascadedDrops == 0) - Maybe it would be informative to add a comment on the recursive call that it never exceeds 2 in depth since generated columns

[jira] Commented: (DERBY-481) implement SQL generated columns

Dag H. Wanvik (JIRA — 2008-11-27T02:50:44

[ https://issues.apache.org/jira/browse/DERBY-481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651231#action_12651231 ] Dag H. Wanvik commented on DERBY-481: ------------------------------------- Reviewed derby-481-14-ab-dropColumn. Thanks again Rick! The patch is good to commit. My notes: * AlterTableConstantAction.java: - The following fragment threw me off at first: Surely,, since we are talkign about size after cascaded drops, th test should be against 0? But no, the quantity sizeAfterCascadedDrops does not include the original dropped column, so the code works, but is a bit misleading. Maybe do: int sizeAfterCascadedDrops = td.getColumnDescriptorList().size() - 1 - cascadedDrops; // Can not drop a column if it there would be no columns left: if (sizeAfterCascadedDrops == 0) - Maybe it would be informative to add a comment on the recursive call that it never exceeds 2 in depth since generated columns don't reference other generated columns

[jira] Commented: (DERBY-481) implement SQL generated columns

Dag H. Wanvik (JIRA — 2008-11-26T17:20:44

[ https://issues.apache.org/jira/browse/DERBY-481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651068#action_12651068 ] Dag H. Wanvik commented on DERBY-481: ------------------------------------- Looked at derby-481-13-aa-alterDatatype.diff, looks good! Thanks. tedColumns.html

[jira] Commented: (DERBY-481) implement SQL generated columns

Dag H. Wanvik (JIRA — 2008-11-26T17:08:44

[ https://issues.apache.org/jira/browse/DERBY-481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651062#action_12651062 ] Dag H. Wanvik commented on DERBY-481: ------------------------------------- Looking at derby-481-12-aa-padding, thanks for the new tests. - Shouldn't the type of column a in table t_cc_varchar be a varchar? It is a char now. tedColumns.html

[jira] Commented: (DERBY-481) implement SQL generated columns

Dag H. Wanvik (JIRA — 2008-11-26T16:58:44

[ https://issues.apache.org/jira/browse/DERBY-481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651059#action_12651059 ] Dag H. Wanvik commented on DERBY-481: ------------------------------------- Reviewing derby-481-11-aa-notNull. Thanks for the good explanations, Rick, really helped! Good patch. Notes: Index: java/engine/org/apache/derby/impl/sql/execute/NormalizeResultSet.java Good that you refactored this class a bit; was a bit messy before.. * Javadoc for normalizeColumn starts with the text "Normalize a row". It should probably be "Normalize a column". What about the rest of that comment? It speaks of not yet having data type conversions.. Is this still relevant? We do have casts, but maybe this is something else. Asking since you touched it by moving it around ;-) * I think the normalizeColumn method should take sourceCol as an argument, rather than sourceRow (less scope; only one column is ever used inside normalizeColumn). * nor

Regression Test Report - Daily 720539 - Sun DBTG

2008-11-26T16:55:36

[Auto-generated mail] *Daily* 720539/2008-11-25 18:02:01 MET Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.6* lin 0 10853 10853 0 1627.05% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 81.97% derbyall 0 2 2 0 363.74% compatibility 0 2 2 0 .% demoSuite sles 0 10853 10853 0 1046.97% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 235 235 0 69.63% derbyall 0 2 2 0 230.80% compatibility 0 2 2 0 .% demoSuite sol F:1,E:0 10853 10852 0