[jira] [Commented] (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
[ https://issues.apache.org/jira/browse/DERBY-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13036415#comment-13036415 ] Kim Haase commented on DERBY-484: - Forgot to say thank you to Knut and Rick for the reviews and information. > Documentation for derby.database.classpath in developers guide is misleading > > > Key: DERBY-484 > URL: https://issues.apache.org/jira/browse/DERBY-484 > Project: Derby > Issue Type: Bug > Components: Documentation >Affects Versions: 10.1.2.1 >Reporter: Daniel John Debrunner >Assignee: Kim Haase >Priority: Minor > Fix For: 10.8.1.3, 10.9.0.0 > > Attachments: DERBY-484-2.diff, DERBY-484-2.stat, DERBY-484-2.zip, > DERBY-484.diff, DERBY-484.stat, DERBY-484.zip, cdevdeploy21645.html, > derby484.diff > > > 10.1 alpha docs (from site) > http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html > 1) Remove sentence 'The first time you set the property, you must reboot to > load the classes.' > This is not true and is tested with lang/dcl.sql > 2) This implies there is more infomation in the tuning guide, but I don't > see any. > 'See "derby.database.classpath" in Tuning Derby for more information about > the property.' > Searching the tuning guide I find no mention of derby.database.classpath > http://db.apache.org/derby/docs/tuning/tuningderby.pdf -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
[ https://issues.apache.org/jira/browse/DERBY-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13036199#comment-13036199 ] Knut Anders Hatlen commented on DERBY-484: -- The latest revision of the patch looks good. +1 to commit. > Documentation for derby.database.classpath in developers guide is misleading > > > Key: DERBY-484 > URL: https://issues.apache.org/jira/browse/DERBY-484 > Project: Derby > Issue Type: Bug > Components: Documentation >Affects Versions: 10.1.2.1 >Reporter: Daniel John Debrunner >Assignee: Kim Haase >Priority: Minor > Attachments: DERBY-484-2.diff, DERBY-484-2.stat, DERBY-484-2.zip, > DERBY-484.diff, DERBY-484.stat, DERBY-484.zip, cdevdeploy21645.html, > derby484.diff > > > 10.1 alpha docs (from site) > http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html > 1) Remove sentence 'The first time you set the property, you must reboot to > load the classes.' > This is not true and is tested with lang/dcl.sql > 2) This implies there is more infomation in the tuning guide, but I don't > see any. > 'See "derby.database.classpath" in Tuning Derby for more information about > the property.' > Searching the tuning guide I find no mention of derby.database.classpath > http://db.apache.org/derby/docs/tuning/tuningderby.pdf -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
[ https://issues.apache.org/jira/browse/DERBY-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13031898#comment-13031898 ] Kim Haase commented on DERBY-484: - Thank you, Rick! That answers the next question I was going to ask (which kind of dynamic -- immediate effect, or future connections only). I will file another issue for moving the sqlj routines to the Ref Manual. DERBY-1780, way back when, pointed out that the sqlj routines don't really belong in the Tools Guide (although that was not its primary focus). > Documentation for derby.database.classpath in developers guide is misleading > > > Key: DERBY-484 > URL: https://issues.apache.org/jira/browse/DERBY-484 > Project: Derby > Issue Type: Bug > Components: Documentation >Affects Versions: 10.1.2.1 >Reporter: Daniel John Debrunner >Assignee: Kim Haase >Priority: Minor > Attachments: DERBY-484.diff, DERBY-484.stat, DERBY-484.zip, > cdevdeploy21645.html, derby484.diff > > > 10.1 alpha docs (from site) > http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html > 1) Remove sentence 'The first time you set the property, you must reboot to > load the classes.' > This is not true and is tested with lang/dcl.sql > 2) This implies there is more infomation in the tuning guide, but I don't > see any. > 'See "derby.database.classpath" in Tuning Derby for more information about > the property.' > Searching the tuning guide I find no mention of derby.database.classpath > http://db.apache.org/derby/docs/tuning/tuningderby.pdf -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
[ https://issues.apache.org/jira/browse/DERBY-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13031885#comment-13031885 ] Rick Hillegas commented on DERBY-484: - Hi Kim, I find that call syscs_util.syscs_set_database_property( 'derby.database.classpath', ... ); takes effect immediately. There is no need to reboot the database. I also agree that the sqlj routines should be documented in the Reference Guide alongside the other database procedures. The import/export procedures are documented in the Reference Guide even though the broader topic of data migration is discussed in the Tools Guide. I don't know why the sqlj routines are documented in the Tools Guide--looks weird to me but I see that it goes back at least as far as Cloudscape 3.5. > Documentation for derby.database.classpath in developers guide is misleading > > > Key: DERBY-484 > URL: https://issues.apache.org/jira/browse/DERBY-484 > Project: Derby > Issue Type: Bug > Components: Documentation >Affects Versions: 10.1.2.1 >Reporter: Daniel John Debrunner >Assignee: Kim Haase >Priority: Minor > Attachments: DERBY-484.diff, DERBY-484.stat, DERBY-484.zip, > cdevdeploy21645.html, derby484.diff > > > 10.1 alpha docs (from site) > http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html > 1) Remove sentence 'The first time you set the property, you must reboot to > load the classes.' > This is not true and is tested with lang/dcl.sql > 2) This implies there is more infomation in the tuning guide, but I don't > see any. > 'See "derby.database.classpath" in Tuning Derby for more information about > the property.' > Searching the tuning guide I find no mention of derby.database.classpath > http://db.apache.org/derby/docs/tuning/tuningderby.pdf -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
Re: [jira] [Commented] (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
"Kim Haase (JIRA)" writes:
> 2) A pointer to the exact topic(s) on SQLJ.INSTALL_JAR are a good
> idea. This procedure is shown briefly in the Dev Guide
Yes, at first I actually didn't understand the property explanation at
all before I read the explanation in ttoolsjarload1002986.html: the
crucial fact that the externally named jar-files are given a legal
schema qualified SQL identifier name in that process. If you miss that
fact, the explanation of the property doesn't make much sense, so yes, a
pointer would be good, with a hint to "why the jar-files' names don't
look like file names, please see link".
> I wonder where the documentation of these procedures actually
> belongs. (SQLJ.REMOVE_JAR and SQLJ.REPLACE_JAR are the others.) What
> kind of procedures are they? The only system procedures and functions
> we document in the Reference Manual are the SYSCS_UTIL ones. Should
> the basic reference info on the SQLJ ones be moved to the Reference
> Manual?
This has always confuses me. I like all my detailed technical
information to be available in the reference manual, if not necessary
readable for a newbie. Other guides should be task centered IMHO:
Administration, tuning, getting to know... etc. A prior, I am all for
it, but it may upset the total structure.. what do people think?
At the very least, the reference manual should contain entries for all
builtin procedures with links to the tools manual we we choose to keep
the explanations there.
>
> 3) I just realized that I ignored one of the original problems
> reported in the issue, that the statement "The first time you set the
> property, you must reboot to load the classes" is not true. If this is
> in fact the case, the property is truly dynamic, and I should change
> http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html ("Enable
> database class loading with a property" too.
I don't know how this feature really work, I'd need to experiment to
find out. Does anybody know for sure how we behave here?
Dag
>
>
>> Documentation for derby.database.classpath in developers guide is misleading
>>
>>
>> Key: DERBY-484
>> URL: https://issues.apache.org/jira/browse/DERBY-484
>> Project: Derby
>> Issue Type: Bug
>> Components: Documentation
>>Affects Versions: 10.1.2.1
>>Reporter: Daniel John Debrunner
>>Assignee: Kim Haase
>>Priority: Minor
>> Attachments: DERBY-484.diff, DERBY-484.stat, DERBY-484.zip,
>> cdevdeploy21645.html, derby484.diff
>>
>>
>> 10.1 alpha docs (from site)
>> http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html
>> 1) Remove sentence 'The first time you set the property, you must reboot to
>> load the classes.'
>> This is not true and is tested with lang/dcl.sql
>> 2) This implies there is more infomation in the tuning guide, but I don't
>> see any.
>> 'See "derby.database.classpath" in Tuning Derby for more information about
>> the property.'
>> Searching the tuning guide I find no mention of derby.database.classpath
>> http://db.apache.org/derby/docs/tuning/tuningderby.pdf
>
> --
> This message is automatically generated by JIRA.
> For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
[
https://issues.apache.org/jira/browse/DERBY-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13031697#comment-13031697
]
Kim Haase commented on DERBY-484:
-
Thanks for these very helpful comments, Knut. They actually lead in several
directions.
1) The bullet-list split needs to be made in the Dev Guide topic too. I'll do
that.
2) A pointer to the exact topic(s) on SQLJ.INSTALL_JAR are a good idea. This
procedure is shown briefly in the Dev Guide
(http://db.apache.org/derby/docs/dev/devguide/rdevdeploy856845.html) and
described a bit more fully in the Tools Guide, in a badly formatted topic
(http://db.apache.org/derby/docs/dev/tools/ttoolsjarload1002986.html).
I wonder where the documentation of these procedures actually belongs.
(SQLJ.REMOVE_JAR and SQLJ.REPLACE_JAR are the others.) What kind of procedures
are they? The only system procedures and functions we document in the Reference
Manual are the SYSCS_UTIL ones. Should the basic reference info on the SQLJ
ones be moved to the Reference Manual?
3) I just realized that I ignored one of the original problems reported in the
issue, that the statement "The first time you set the property, you must reboot
to load the classes" is not true. If this is in fact the case, the property is
truly dynamic, and I should change
http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html ("Enable database
class loading with a property" too.
> Documentation for derby.database.classpath in developers guide is misleading
>
>
> Key: DERBY-484
> URL: https://issues.apache.org/jira/browse/DERBY-484
> Project: Derby
> Issue Type: Bug
> Components: Documentation
>Affects Versions: 10.1.2.1
>Reporter: Daniel John Debrunner
>Assignee: Kim Haase
>Priority: Minor
> Attachments: DERBY-484.diff, DERBY-484.stat, DERBY-484.zip,
> cdevdeploy21645.html, derby484.diff
>
>
> 10.1 alpha docs (from site)
> http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html
> 1) Remove sentence 'The first time you set the property, you must reboot to
> load the classes.'
> This is not true and is tested with lang/dcl.sql
> 2) This implies there is more infomation in the tuning guide, but I don't
> see any.
> 'See "derby.database.classpath" in Tuning Derby for more information about
> the property.'
> Searching the tuning guide I find no mention of derby.database.classpath
> http://db.apache.org/derby/docs/tuning/tuningderby.pdf
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
[ https://issues.apache.org/jira/browse/DERBY-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13031603#comment-13031603 ] Knut Anders Hatlen commented on DERBY-484: -- The new topic looks good to me. Some possible improvements: - It's a bit opaque where the jar files come from. Perhaps change "This property must be set to enable Derby to load classes from the jar files" to "This property must be set to enable Derby to load classes from jar files installed with the SQLJ.INSTALL_JAR system procedure"? Unfortunately, there's no topic describing INSTALL_JAR in the reference manual, so we cannot create a link to it. - Should the last bullet in the bullet list be split into two separate bullets? - "Use two-part names for the jar files" -> "Use fully qualified identifiers for the jar files"? > Documentation for derby.database.classpath in developers guide is misleading > > > Key: DERBY-484 > URL: https://issues.apache.org/jira/browse/DERBY-484 > Project: Derby > Issue Type: Bug > Components: Documentation >Affects Versions: 10.1.2.1 >Reporter: Daniel John Debrunner >Assignee: Kim Haase >Priority: Minor > Attachments: DERBY-484.diff, DERBY-484.stat, DERBY-484.zip, > cdevdeploy21645.html, derby484.diff > > > 10.1 alpha docs (from site) > http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html > 1) Remove sentence 'The first time you set the property, you must reboot to > load the classes.' > This is not true and is tested with lang/dcl.sql > 2) This implies there is more infomation in the tuning guide, but I don't > see any. > 'See "derby.database.classpath" in Tuning Derby for more information about > the property.' > Searching the tuning guide I find no mention of derby.database.classpath > http://db.apache.org/derby/docs/tuning/tuningderby.pdf -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-484) Documentation for derby.database.classpath in developers guide is misleading
[ https://issues.apache.org/jira/browse/DERBY-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12626720#action_12626720 ] Kim Haase commented on DERBY-484: - This issue is related to the DERBY-2389 work (moving the property documentation to the Reference Manual). I will be happy to document the derby.database.classpath property if someone can point me to information about it. It is mentioned in several places in the Developer's Guide (4 topics under "Loading classes from a database"). > Documentation for derby.database.classpath in developers guide is misleading > > > Key: DERBY-484 > URL: https://issues.apache.org/jira/browse/DERBY-484 > Project: Derby > Issue Type: Bug > Components: Documentation >Affects Versions: 10.1.2.1 >Reporter: Daniel John Debrunner >Assignee: Kim Haase >Priority: Minor > Attachments: cdevdeploy21645.html, derby484.diff > > > 10.1 alpha docs (from site) > http://db.apache.org/derby/docs/devguide/cdevdeploy21645.html > 1) Remove sentence 'The first time you set the property, you must reboot to > load the classes.' > This is not true and is tested with lang/dcl.sql > 2) This implies there is more infomation in the tuning guide, but I don't > see any. > 'See "derby.database.classpath" in Tuning Derby for more information about > the property.' > Searching the tuning guide I find no mention of derby.database.classpath > http://db.apache.org/derby/docs/tuning/tuningderby.pdf -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
