How to solve pluggable problem in 'Continuous Query Notification'?

A required feature for CQN registration of store procedure is that the database where is creating objects should be not pluggable an error will appear like below:

65131. 00000 -  "The feature %s is not supported in a pluggable database."
*Cause:    An attempt was made to use a feature that is not supported in a
           pluggable database.
*Action:   Do not use this feature in a pluggable database.

The solution is to create a new database with not PDB configurate that make enable pluggable parameter not appear in ora file.

Another problem is when you are doing a registration of a store procedure via CQN a problem will occur with other DML executed after by CQN registration, the error will be as the follow text:

ORA-29973: Unsupported query or operation during change notification registration


Important links:

• http://oraerrormsgs.blogspot.mx/2012/05/ora-29973-unsupported-query-or.html
• http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_cqnotif.htm#CIHBBFDD
• https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm#BGBGAGEF
• https://jsao.io/2015/02/real-time-data-with-node-js-socket-io-and-oracle-database/
• http://stackoverflow.com/questions/33388155/alternatives-for-continuous-query-notifications-in-oracle-12c-cdb-pdb-setup
• https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9522537800346597791
• https://technology.amis.nl/2015/05/11/invoke-a-rest-service-from-plsql-make-an-http-post-request-using-utl_http-in-oracle-database-11g-xe/

How to install weblogic maven plugin 12.2.1?

For installation you have to follow the next steps:

and finally add plugin for weblogic:deploy purpose:
Important Links:

• http://ruleoftech.com/2014/using-the-weblogic-12c-maven-plug-in-for-deployment 
• http://docs.oracle.com/middleware/1212/wls/WLPRG/maven.htm#WLPRG591
• http://docs.oracle.com/cd/E24329_01/web.1211/e24378/jarbuilder.htm#SACLT239

Best regards,

How to solve common error on Oracle Weblogic using Spring Websocket?

The fooling error clarify the handshake use in Spring Websocket as it is said in the folling line:

registry.addEndpoint("/portafolio").setAllowedOrigins("*").withSockJS();

Error:


The solution to this error should be review Spring Messaging and Websocket version to charge 4.3.5.RELEASE version, there are somes changes from version 4.1.2.RELEASE to 4.3.5.RELEASE specially in Tyrus container and application server distribution.

Error:
Error during WebSocket handshake: Unexpected response code: 500

Solution: Add handshakehandler.-
registry.addEndpoint("/portafolio").setHandshakeHandler(new DefaultHandshakeHandler(new WebLogicRequestUpgradeStrategy()))
    .setAllowedOrigins("*").withSockJS();



Best regards,