Hi, I have tested db2 as the database with IS-5.4.1, at the server startup, I got SQL exception (see the attachment for stack trace). In order to verify the exception with older versions, I have tested older versions with DB2.
Following are the observations. version :- 5.3.0-GA, 5.4.0 - alpha2 *validation query :- SELECT 1* Status :- Got exception at the server startup (Due to syntax error in db2 script) Fixed the syntax errors with [1] for later versions. version :- 5.4.0 - alpha5 *validation query :- SELECT 1* Status:- Server starts without any errors version :- 5.4.0 - GA & 5.4.1-GA *validation query :- SELECT 1* Status :- validation query exception at server startup Changed the validation query according to [2] and tested version :- 5.4.0 - GA & 5.4.1-GA *validation query :- SELECT 1 FROM SYSIBM.SYSDUMMY1 (modify and tested)* Status:- Server starts without any errors. For more details regarding the stack trace, please see the attachment. created a git issue[3] to track the problem. What is the reason of this behavior?. With the existing validation query 5.4.0 - alpha5 works fine, but 5.4.0-GA giving an exception. Any help on this would be appreciated. [1] https://wso2.org/jira/browse/IDENTITY-6377 [2] https://stackoverflow.com/questions/10684244/dbcp-validationquery-for-different-databases [3] https://github.com/wso2/product-is/issues/2246 Thanks, Nila. -- Nilasini Thirunavukkarasu Software Engineer - WSO2 Email : [email protected] Mobile : +94775241823 <+94%2077%20524%201823> Web : http://wso2.com/ <http://wso2.com/signature>
db2_testing_results
Description: Binary data
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
