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

["Sai Zhang (JIRA)" <ji...@apache.org>]

Sai Zhang created DERBY-6707:
--------------------------------

             Summary: 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


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)