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