Open source telecom solutions

http://www.imszone.org/documentation.html

http://clearwater.readthedocs.io/en/stable/Clearwater_Architecture.html

http://telecom.ashishbanerjee.com/

Jbilling

http://www.simetrictechnology.com/jbilling/jbilling-architecture.html

Oracle 11g RADIANS function

http://stackoverflow.com/questions/24937868/oracle-circle-distance-search-missing-results

http://www.liquibase.org/documentation/changes/create_procedure.html

Weblogic 11g + Oracle 11g + Spring boot

1. Reference project jar file path:

2. Hibernate Validation error:

(1) Create CustomPersistenceProviderResolver by implements PersistenceProviderResolver to ensure the PersistenceProviders which are or above JPA 2.0 will be loaded before default PersistenceProvider which Weblogic provided(such as Kodo and Toplink) . The content is mainly from the private class PersistenceProviderResolverPerClassLoader in PersistenceProviderResolverHolder. The loading sequence of PersistenceProvider will be

Hibernate -> Eclipse Link -> Kodo

(2) Explicitly assign CustomPersistenceProviderResolver  to PersistenceProviderResolverHolder
in entityManagerFactory() method under  DatabaseConfiguration as below:

PersistenceProviderResolverHolder.setPersistenceProviderResolver(new CustomPersistenceProviderResolver());

3. Weblogic 11g setting for JPA 2.0

(1) commEnv.cmd
-> Add classpath for javax.persistence_1.1.0.0_2-0.jar (Eclipse link ) & com.oracle.jpa2support_1.0.0.0_2-1.jar

echo eclipseLink
SET PRE_CLASSPATH=D:\dev\weblogic\weblogic11g\modules\javax.persistence_1.1.0.0_2-0.jar;D:\dev\weblogic\weblogic11g\modules\com.oracle.jpa2support_1.0.0.0_2-1.jar ?

-> Weblogic management console
 Change JPA adaptor type to Topdo

4. IllegalArgumentException in Tomcat

Caused by: java.lang.IllegalArgumentException: File [/D:/DevTools/weblogic/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/CMMAPP/WEB-INF/CMMBASE-0.0.1-SNAPSHOT.jar] referenced by given URL [file:/D:/DevTools/weblogic/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/CMMAPP/WEB-INF/CMMBASE-0.0.1-SNAPSHOT.jar] does not exist

Root cause: While using persistence.xml, reference project needs to be specifically assigned in persistence.xml.  However, the default path is different between Weblogic and Tomcat.

Below is the persistence.xml for Weblogic



             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
             version="2.0">
 

    org.hibernate.jpa.HibernatePersistenceProvider
         CMMBASE-0.0.1-SNAPSHOT.jar
         
       
             
     
     
     
     
         
         
       
  



In Tomcat the same has to be 

 /WEB-INF/CMMBASE-0.0.1-SNAPSHOT.jar

5. Weblogic autodeploy

D:\dev\weblogic\weblogic11g\wlserver_10.3\samples\domains\wl_server\autodeploy

6. Weblogic 


7. In order to make Liquibase Maven command work do steps below

 (1) Add oracle JDBC driver into local Maven resposiroty
  
mvn install:install-file -Dfile=D:\dev\databases\sqldeveloper\jdbc\lib\ojdbc7.jar       -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1.0 -Dpackaging=jar

(2) Add oracle db profile for liquibase into pom.xml

(3) Run below command to drop all tables

mvn -P oracledev liquibase:dropAll

8. Oracle 11g

(1) Identifier such as "password", "code" can't be used as table or column name
(2) Identifier length has length restriction of 30







  

SPRING BOOT FOR ORACLE

http://shengwangi.blogspot.tw/2014/12/how-to-configure-primary-key-generator-in-jpa-for-oracle.html

https://springframework.guru/using-h2-and-oracle-with-spring-boot/

https://springframework.guru/configuring-spring-boot-for-oracle/

https://www.mkyong.com/spring-boot/spring-boot-spring-data-jpa-oracle-example/

OpenNMS Remote Polling

http://www.sonney.com/blog/2010/09/15/opennms-remote-polling-how-im-doing-it/

http://www.jessewhite.ca/opennms/minion/2016/12/18/opennms-minion.html

IMS Charging

http://openepc.corenetdynamics.com/components/policy-and-charging-control

https://sites.google.com/site/amitsciscozone/home/lte-notes/pcc-architecture

https://docs.oracle.com/cd/E23943_01/doc.1111/e15461/diameter_3.htm#CHDJD113