[jira] [Updated] (DERBY-6707) Inadequate error messages for configuration errors in Derby

["Rick Hillegas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-6707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-6707:
---------------------------------

      Issue & fix info: Repro attached
    Bug behavior facts:   (was: Deviation from standard)

> Inadequate error messages for configuration errors in Derby
> -----------------------------------------------------------
>
>                 Key: DERBY-6707
>                 URL: https://issues.apache.org/jira/browse/DERBY-6707
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.10.2.0
>         Environment: All
>            Reporter: Sai Zhang
>              Labels: configuration, invald
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> Dear developers,
> Derby's error message for misconfiguration should be improved. Sometimes, the dumped error messages is very unclear, and costs users extra time to figure out a simple problem.
> Here is a reproducible example
> 1.  specify a wrong value for derby.stream.error.method option, and put the following line in the derby.properties file
> derby.stream.error.method=hello   (obvious it is wrong)
> 2. 
> connect to a derby db, and issue a selection query
> 3. 
> derby simply dumped the following error message, which is hard to be connected to the misconfigured option
> ij> CONNECT 'jdbc:derby:firstdb';
> JAVA ERROR: java.lang.ExceptionInInitializerError
> ij> select * from COUNTRIES;
> IJ ERROR: Unable to establish connection
> ij> Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class org.apache.derby.jdbc.EmbeddedDriver
> 	at org.apache.derby.jdbc.AutoloadedDriver.getDriverModule(Unknown Source)
> 	at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:579)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:243)
> 	at org.apache.derby.impl.tools.ij.utilMain.cleanupGo(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
> I would sugget to fix this problem by checking invalid configuration option names, and improve error message (at least the error message should pinpoint the likely misconfigured options).
> Please let me know your thoughts.
> Thanks
> -Sai



--
This message was sent by Atlassian JIRA
(v6.2#6252)