Jhiptser 使用 SQL Server Tips (Liquibase Mavenplugin)

可考官網說明

https://jhipster.github.io/tips/004_tip_using_ms_sql_server.html

由於MSSQL Driver 無法直接由 Maven repository取得

若需使用Maven Liquibase plugin 來 針對MS SQL Server 操作, 須依下列步驟執行

1. 安裝 MS SQL Server JDBC Driver 於本地端Maven local repository

mvn install:install-file -Dfile=D:\dev\java\jars\sqljdbc4.jar -DgroupId=sqljdbc4 -DartifactId=sqljdbc4 -Dversion=4 -Dpackaging=jar -DgeneratePom=true


2. 將 MS SQL Server JDBC dependency 加到 Maven  pom.xml

3. 執行以下指令確認 Maven 可正常執行

     mvn -P dev liquibase:generateChangeLog

LiquiBase: Inserting data from a CSV file

How to resolve issue importing Date field

https://lizdouglass.wordpress.com/2009/02/01/liquibase-inserting-data-from-a-csv-file/

RTP over Websocket

http://stackoverflow.com/questions/18844534/rtp-over-websocket

WebRtc sample application

https://quickblox.github.io/quickblox-javascript-sdk/samples/webrtc/

JHipster Liquibase 指令範例 - Maven

JHipster 已經在POM.XML 做好 Liquibase的基本設定, 因此在JHipster Code Generate 出的專案中, 可以直接利用 Maven指令, 在Project 目錄下利用 mvn 的 command line 指令, 即可Reverse database schema 以及Diff出schema與 data 的修改.

1. 設定說明



2. 利用 Reverse 產出全部資料的 XML

         mvn -P dev liquibase:generateChangeLog

         -P :  指定Spring boot 在 Maven 定義的Profile
          generateChangeLog: reverse 全部資料


         mvn -P dev liquibase:generateChangeLog  -Dliquibase.outputChangeLogFile=./test.xml

         -Dliquibase.outputChangeLogFile: 自指定產出的XML檔案, 未指定則輸出到console


3. 利用 Diff 產出資料修改的 XML

    mvn liquibase:diff

       Spring boot預設的Profile與在pom.xml 設定在 ＜referenceUrl＞ 的料庫比對

    mvn -P prod liquibase:diff
        
     -P :  指定Spring boot 在 Maven 定義的Profile, 與在pom.xml 設定在 ＜referenceUrl＞ 的料庫比對
   

4. 利用updateSQL產出SQL指令( 不直接對資料庫下指令)

       mvn liquibase:updateSQL

5. 利用dropAll指令清除所有table

       mvn -P prod liquibase:dropAll

5. 利用clearCheckSums指令清除所有CheckSums以避免checkSum Error

        mvn -P prod liquibase:clearCheckSums

5. 利用Batch 指令執行Liquibase的Sample

// 從資料庫Reverse為Liquibase XML檔, 將changeLogFile附檔名改為.json即可改JSON格式

liquibase --driver=com.mysql.jdbc.Driver --classpath=.\mysql-connector-java-5.1.38.jar   --changeLogFile=db.changelog.xml  --url="jdbc:mysql://localhost:3306/dev?useUnicode=true&characterEncoding=UTF-8" --username=pollex --password=pollex123 generateChangeLog

// 連同 Data 一起 Reverse

liquibase --driver=com.mysql.jdbc.Driver --classpath=.\mysql-connector-java-5.1.38.jar   --changeLogFile=db.changelog.xml  --url="jdbc:mysql://localhost:3306/dev?useUnicode=true&characterEncoding=UTF-8"  --diffTypes=data --username=pollex --password=pollex generateChangeLog

//產出對資料庫建資料的SQL SCRIPT

liquibase --driver=com.mysql.jdbc.Driver --classpath=.\mysql-connector-java-5.1.38.jar   --changeLogFile=db.changelog.json  --url="jdbc:mysql://localhost:3306/dev?useUnicode=true&characterEncoding=UTF-8"  --username=pollex --password=pollex updateSQL > dbscript.sql

--diffTypes=data,tables,columns,views,primaryKeys,uniqueConstraints,indexes,foreignKeys,sequences







       

IMs

https://theimsjungle.wordpress.com/tag/i-cscf/

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

Marketing plan

http://www.entrepreneur.com/article/43018

SIP programming for the Java developer

https://telestax.com/mobicents-sip-servlets-sip-programming-in-java-tutorial/

http://www.javaworld.com/article/2071781/java-web-development/sip-programming-for-the-java-developer.html

http://alex.bikfalvi.com/teaching/upf/2013/architecture_and_signaling/lab/sip/

http://stackoverflow.com/questions/13033116/jain-sip-authentication

https://andrewjprokop.wordpress.com/2015/03/17/a-deep-dive-into-the-sip-publish-method/

http://www.oracle.com/technetwork/java/sip-and-java-137921.html

http://stackoverflow.com/questions/26551606/difference-between-jain-api-and-jain-slee-api

http://www.phitech.com.tw/news/?news_id=709

https://sourceforge.net/projects/mcumediaserver/?source=recommended

Open source SIP product

http://peers.sourceforge.net/

https://code.google.com/archive/p/sip2peer/wikis/sip2peerTutorial.wiki

https://maven.reucon.com/projects/public/asterisk-java/1.0.0/tutorial.html

http://www.asteriskguru.com/tutorials/basic_installation_information_asterisk_from_source.html

http://www.mobicents.org/index.html

https://developer.jboss.org/wiki/HelloSLEEWorldServiceJAINSLEETutorial


WebRTC media server

http://doc-kurento.readthedocs.org/en/stable/what_is_kurento.html

http://www.html5rocks.com/en/tutorials/webrtc/infrastructure/


HTML5  SIP client

https://www.doubango.org/sipml5/


Audio Library

http://stackoverflow.com/questions/8999629/open-source-audio-library-in-java

Asterisk V.S. Kamailio

http://www.dslreports.com/forum/r29128751-Kamailio-vs-Asterisk

http://kb.asipto.com/kamailio:presence:k31-made-simple

Xcap
http://nil.uniza.sk/instant-messaging/simple/configuring-xcap-support-im-and-presence-over-kamailio-31-debian-lenny

http://openxcap.org/

Presence Server
http://www.opensips.org/Documentation/Tutorials-Presence-PresenceServer

Back-to-back-user-agent (b2bua)
https://andrewjprokop.wordpress.com/2013/12/27/the-back-to-back-user-agent-b2bua/
https://andrewjprokop.wordpress.com/2013/06/21/sip-servers-and-services/

SIPS & SRTP

http://wiki.linuxwall.info/doku.php/en:ressources:dossiers:voip:tls_sips_rtps