Hi All, I faced following oracle sql error while testing message broker in oracle database. Steps i followed are given below.
1. Configure oracle database as message store database with message broker in two node cluster environment. 2. Subscribe to "MyQueue" and publish 1 message to "MyQueue" using simple jms client (or using jmeter). 3. SQLSyntaxErrorException: ORA-00911: invalid character exception throws from org.wso2.andes.kernel.distruptor.delivery.ConcurrentContentReadTaskBatchProcessor class. (please refer jira[1] for more information) After remote debug mb nodes, i found that there's a issue with prepared statements executed. These prepared statements were working well in H2/mysql and mssql without any error but failed to execute on oracle. In oracle if semi-colon added at the end of prepared statement it will fail with ora-00911 error. Therefore, if you plan to support multiple databases don't add semicolon at end of prepare statements since it will fail if executed in oracle. [1] - https://wso2.org/jira/browse/MB-981 Regards, -- Pumudu Ruhunage Associate Software Engineer | WSO2 Inc M: +94 779 664493 | http://wso2.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
