Important links of Oracle REST Data Services

Important Links

• https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets
• https://www.mkyong.com/oracle/oracle-stored-procedure-cursor-example/
• http://ora-00001.blogspot.mx/2010/02/ref-cursor-to-json.html
• http://www.thatjeffsmith.com/archive/2017/03/auto-rest-with-ords-an-overview-and-whats-next/
• https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-create-basic-rest-web-services-using-plsql
• http://dgielis.blogspot.mx/2015/01/generate-nested-json-from-sql-with-ords.html 
• http://krisrice.blogspot.mx/2013/09/restful-cursor-support-for-json.html
• https://jsao.io/2015/07/relational-to-json-with-ords/

Requirements for Mysql Workbench installation

Some dependencies must need to be installed if Mysql Workbench is used:

sudo yum install epel-release
sudo yum install proj
sudo yum install tinyxml
sudo yum install libzip

There is another important file where the password installation is located:

/var/log/mysqld.log

Important links:

• https://dba.stackexchange.com/questions/158509/install-mysql-workbench-failed-requires-proj-tinyxml-python-paramiko-1-15
• http://www.linuxpcfix.com/how-to-install-and-configure-mysql-workbench-on-linux-system/

Possible solution to preflight problem with Options request in a Rest Service under Chrome.

There is a common error under rest service development with AngularJS framework after that understood that internally the framework do OPTIONS requests to know who is invoking an error like follows can occur:

Response for preflight has invalid HTTP status code 400

The possible solution to this problem is to check CORSFilter and when the request contains a OPTIONS just respond an OK status:

...

    if ("OPTIONS".equalsIgnoreCase(request.getMethod())) {
        response.setStatus(HttpServletResponse.SC_OK);
    } else {
        chain.doFilter(req, res);
    }

Important links:

• http://www.concretepage.com/spring-4/spring-4-rest-cors-integration-using-crossorigin-annotation-xml-filter-example
• http://corpus.hubwiz.com/2/angularjs/23786722.html
• http://websystique.com/spring-security/secure-spring-rest-api-using-oauth2/
• http://zhentao-li.blogspot.mx/2012/06/enable-cors-support-in-rest-services.html

How to solve IBM MQ NoClassDefFoundError over jms configuration?

I f you are using IBM MQ jars to development, you must carry about jms specification you are using, sometimes not all distributions is not used over application instend of that the following error can occurs:

java.lang.NoClassDefFoundError: com.ibm.mq.internal.MQCommonServices
...

The solution is to use jms.jar and part of the jars inside IBM MQ distribution as example like:

• com.ibm.mq.jar
• com.ibm.mq.jmqi.jar
• com.ibm.mq.headers.jar
• com.ibm.mq.commonservices.jar

Best Regards,