解決Oracle expdp問題

ORA-39213: Metadata processing is not available

1.登入sqlplus
sqlplus / as sysdba

2.執行
SQL> execute dbms_metadata_util.load_stylesheets


ORA-39087:directory name DATA_PUMP_DIR is invalid

1.登入sqlplus
sqlplus / as sysdba

2.
SQL> GRANT read, write ON DIRECTORY data_pump_dir TO 帳號;

JDBC使用混合模式(Windows)驗證

1.下載驅動程式
Microsoft JDBC Drivers 4.1 and 4.0 for SQL Server
JDK版本對應

2.解壓縮放入lib

3.指向sqljdbc_auth.dll放置目錄
-Djava.library.path=%JBOSS_HOME%\standalone\lib\ext

4.連接程式碼

String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

    String dbUrl = "jdbc:sqlserver://localhost:1433;integratedSecurity=true;DatabaseName=db";




    try {

        Class.forName(dbDriver);

    } catch (ClassNotFoundException e) {

        e.printStackTrace();

        out.print("載入數據庫引擎失敗<br/>");

    }

    out.print("數據庫驅動成功<br/>");




    try {

        Connection conn = DriverManager.getConnection(dbUrl);

        out.print("連接數據庫成功<br/>");




        conn.close();

    } catch (SQLException e) {

        e.printStackTrace();

        out.print("連接數據庫錯誤<br/>");

    }

JBoss 7.1.1註冊成Windows服務

1.下載connector
http://jbossweb.jboss.org/downloads/jboss-native-2-0-9

2.將jbosssvc.exe和service.bat放入jboss-as-7.1.1.Final\bin

3.修改service.bat內容

4.註冊服務
service install

openssl產生自我憑證

1.產生私鑰
openssl genrsa -out ca.key 2048

2.產生 CSR
openssl req -new -key ca.key -out ca.csr

3.產生自我簽署的金鑰
openssl x509 -req -days 365 -in ca.csr -signkey ca.key -out ca.crt

解決WebService連接https錯誤

參考http://lab.howie.tw/2012/12/howto-resolve-self-sign-certificate-https-connection.html

1.

CentOS 7安裝Apache編譯mod_jk

1.安裝httpd,httpd-devel
yum install -y httpd httpd-devel

2.安裝編譯工具
yum install -y gcc*

3.下載tomcat-connector
http://tomcat.apache.org/download-connectors.cgi

CentOS 7安裝Tomcat 7

1.解壓縮
tar xzf apache-tomcat-7.0.59.tar.gz

2.移動到想放置的目錄
mv apache-tomcat-7.0.59 /usr/local/