Mysql clustering

https://shazi.info/%E6%9E%B6%E8%A8%AD-ha-%E9%AB%98%E5%8F%AF%E7%94%A8%E6%80%A7%EF%BC%9Amysql-cluster-%E5%8F%A2%E9%9B%86-7-4-115-6-29/

http://stackoverflow.max-everyday.com/2017/10/mysql-for-commercial/

http://www.clusterdb.com/mysql-cluster/using-clusterjpa-part-of-mysql-cluster-connector-for-java-a-tutorial

Easily secure your Spring Boot applications with Keycloak

https://developers.redhat.com/blog/2017/05/25/easily-secure-your-spring-boot-applications-with-keycloak/

How to use JPA correctly to avoid complaints of a slow application

https://zeroturnaround.com/rebellabs/how-to-use-jpa-correctly-to-avoid-complaints-of-a-slow-application/

Modified Java Script Value & Dynamic SQL

https://stackoverflow.com/questions/36918706/pentaho-insert-a-list-in-sql-where-clause

Spring Batch With Spring Boot

http://ashismo.github.io/java-spring/2017/05/16/Spring-Batch-with-Spring-Boot

Java Generic Type & get-put principle

https://stackoverflow.com/questions/1292109/explanation-of-the-get-put-principle

Java 8: java.time.*

https://www.mkyong.com/spring-boot/spring-boot-spring-data-jpa-java-8-date-and-time-jsr310/

RRD Tool

http://www.study-area.org/tips/rrdtool/rrdtool.html

http://ycfu.blog.mypc.tw/2008/05/rrdtool.html

http://blog.csdn.net/jndxjing/article/details/8014410

SQL Server Data Format

1.   Get Date in a format such as: 2017/09/11

CONVERT(char(10),DATEADD(day,-(1),GETDATE()) ,111) AS Date

Select Into v.s. Insert into From

1. Select Into

Create a new table in the destination database
select * into sif.dbo.callDetail from I3_IC.dbo.calldetail_viw;

2.  Insert into From

Insert into existing table, column needs to assigned explicitly. * may not work in some databases.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

Pentaho Data Integration (Kettle)

http://ithelp.ithome.com.tw/articles/10186567

Logback

https://examples.javacodegeeks.com/enterprise-java/logback/logback-file-appender-example-2/

https://stackoverflow.com/questions/2488558/logback-to-log-different-messages-to-two-files

UI/UX process

https://blog.akanelee.me/posts/278602-ux-is-not-a-wireframe/

https://blog.akanelee.me/posts/686437-ui-design-process/

IOT

https://villesmartblog.wordpress.com/2016/11/29/iot-%E5%B8%B8%E7%94%A8%E7%9A%84%E5%82%B3%E8%BC%B8%E5%8D%94%E5%AE%9A%E4%BB%8B%E7%B4%B9/

JBOSS 教學

http://jbosstut-christina.rhcloud.com/archives/category/jboss-%E6%95%99%E5%AD%B8

The road ahead for WebLogic 12c

http://biemond.blogspot.tw/2013/10/the-road-ahead-for-weblogic-12c.html

Pollexsurvey data creation

1. Create data with excel template

2. Copy & paste to SQL Server Managment studio

3. Insert into local mysql database (Link server need to be configured in advance)
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent') SELECT * FROM pls_respondent WHERE uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent_role') SELECT * FROM pls_respondent_role WHERE respondent_uid >  4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondentdetail_extsat2017') SELECT * FROM pls_respondentdetail_extsat2017 WHERE uid >  4280;

4. Delete data of earlier batches
delete from pollexsurvey.pls_respondent WHERE uid <=4280;
delete from pollexsurvey.pls_respondentdetail_extsat2017 WHERE uid <=4280;
delete from pollexsurvey.pls_respondent_role WHERE respondent_uid <=4280;

select count(*) from pollexsurvey.pls_respondent;
select count(*) from pollexsurvey.pls_respondentdetail_extsat2017;
select count(*) from pollexsurvey.pls_respondent_role;

5. Export the SQL

personal appraisal v.s. agile development

https://www.scrumalliance.org/community/articles/2017/april/why-scrum-and-kpis-dont-mix

https://scrumology.com/how-to-do-agile-performance-reviews/

http://www.agilelearninglabs.com/2012/05/agile-performance-reviews-2/

Making OpenNMS highly available

https://wiki.opennms.org/wiki/Making_OpenNMS_highly_available#Making_OpenNMS_highly_available

OpenNMS general blog

https://www.adventuresinoss.com/category/opennms-general/

http://opennms.530661.n2.nabble.com/How-to-manually-define-a-topology-Map-1-12-X-td7585315.html

https://www.adventuresinoss.com/2016/01/22/opennms-at-scale/

https://github.com/j-white/opennms-events-stress-tools/tree/master/udpgen

https://searchcode.com/codesearch/view/33906804/

Customizing the OpenNMS home screen

http://jumboframe.net/jumboframe/customizing-the-opennms-home-screen

IMS service profile

http://theimslantern.blogspot.tw/2007/07/ims-service-routing-service-profile.html

Nosql database sizing

http://datascale.io/sizing-cassandra-data/

https://www.mongodb.com/blog/post/capacity-planning-and-hardware-provisioning-mongodb-ten-minutes

Traffic Analysis

http://www.cisco.com/c/en/us/td/docs/ios/solutions_docs/voip_solutions/TA_ISD.html#wp1015327

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

JPA 2.1 Features

http://www.thoughts-on-java.org/jpa-21-overview/

Spring Boot and JPA 2.0 in servlet 2.5 AP server

http://stackoverflow.com/questions/27349972/spring-boot-and-jpa-2-0

https://github.com/spring-projects/spring-boot/issues/3397

http://blog.marcnuri.com/spring-data-jpa-eclipselink-configuring-spring-boot-to-use-eclipselink-as-the-jpa-provider/

http://docs.oracle.com/cd/E17904_01/web.1111/e13720/using_toplink.htm#EJBAD1311

http://stackoverflow.com/questions/35894459/weblogic-12c-jpa-2-1-spring-boot

http://stackoverflow.com/questions/37140437/hibernate-validator-uses-wrong-persistence-provider

http://buttso.blogspot.tw/2011/07/plugging-in-later-version-of.html

https://github.com/spring-projects/spring-boot/issues/1460

Spring MVC @PathVariable with dot (.) is getting truncated

http://stackoverflow.com/questions/16332092/spring-mvc-pathvariable-with-dot-is-getting-truncated

http://www.projectclearwater.org/about-clearwater/

SIP Number Portability Parameters

http://www.voip-info.org/wiki/view/SIP+Number+Portability+Parameters

http://www.dialogic.com/webhelp/img1010/10.3.3er2/webhelp/Description/Interworking/SIP_Carrier_Identification_Code.htm

http://www.voip-info.org/wiki/view/SIP+URI

Spring boot on Servlet 2.5 container

https://github.com/dsyer/spring-boot-legacy

http://stackoverflow.com/questions/22974475/does-spring-boot-support-servlet-2-5-auto-configuration

https://groups.google.com/forum/#!topic/google-appengine-stackoverflow/AQH-1fl3Oc4

http://docs.spring.io/spring-boot/docs/current/reference/html/howto-traditional-deployment.html

http://stackoverflow.com/questions/24435718/how-to-deploy-spring-boot-app-to-tomcat-6-servlet-2-5

Enum - JPA Enumerated

http://tomee.apache.org/examples-trunk/jpa-enumerated/README.html

lazy loading is a code smell?

https://dzone.com/articles/lazy-loading-is-a-code-smell?edition=262787&utm_source=Daily%20Digest&utm_medium=email&utm_campaign=dd%202017-01-11

Security Issues In Restful

http://insights.thoughtworkers.org/security-issues-in-restful/