12c中匯入java的jar檔案
1、建立表空間
[oracle@host01 /]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 21 15:29:33 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter session set container=xfpdb;
SQL> create tablespace xftbs datafile '/u01/app/oracle/oradata/PRODCDB/xfpdb/xftbs01.dbf' size 10m;
Tablespace created.
2、建立使用者並授權
SQL> create user xf identified by xf default tablespace xftbs quota unlimited on xftbs;
User created.
SQL> grant connect ,resource to xf;
Grant succeeded.
3、使用xf使用者連線資料庫執行jar包匯入
需要將commons-math3-3.0.jar檔案上傳至/home/oracle/files/下
使用dbms_java.loadjava匯入jar包
[oracle@host01 admin]$ sqlplus xf/xf@192.168.56.101:1521/xfpdb.example.com
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 19 13:58:13 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> call dbms_java.loadjava('-v -r PUBLIC -sysnonym /home/oracle/files/commons-math3-3.0.jar');
Call completed.
SQL> begin
dbms_java.loadjava('-v -r PUBLIC -sysnonym /home/oracle/files/commons-math3-3.0.jar');
end;
/
PL/SQL procedure successfully completed.
SQL> exec dbms_java.loadjava('-v -r PUBLIC -sysnonym /home/oracle/files/commons-math3-3.0.jar');
PL/SQL procedure successfully completed.
或者使用loadjava命令
[oracle@host01 admin]$ loadjava -force -thin -user xf/xf@192.168.56.101:1521/xfpdb.example.com -resolve /home/oracle/files/commons-math3-3.0.jar
4、在Oracle資料庫建立java程式碼
SQL> create or replace and compile java source named jar_norm as
2 import org.apache.commons.math3.distribution.NormalDistribution;
3 public class jar_norm {
4 public static double s_inv(double s){
5 NormalDistribution normalDistribution =new NormalDistribution(0,1);
6 double S1=normalDistribution.inverseCumulativeProbability(s);
7 return S1;
8 }
9 public static double s_dist_c(double s){
10 NormalDistribution normalDistribution =new NormalDistribution(0,1);
11 double S1=normalDistribution.cumulativeProbability(s);
12 return S1;
13 }
14 }
15 /
Java created.
-end-
[oracle@host01 /]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 21 15:29:33 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter session set container=xfpdb;
SQL> create tablespace xftbs datafile '/u01/app/oracle/oradata/PRODCDB/xfpdb/xftbs01.dbf' size 10m;
Tablespace created.
2、建立使用者並授權
SQL> create user xf identified by xf default tablespace xftbs quota unlimited on xftbs;
User created.
SQL> grant connect ,resource to xf;
Grant succeeded.
3、使用xf使用者連線資料庫執行jar包匯入
需要將commons-math3-3.0.jar檔案上傳至/home/oracle/files/下
使用dbms_java.loadjava匯入jar包
[oracle@host01 admin]$ sqlplus xf/xf@192.168.56.101:1521/xfpdb.example.com
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 19 13:58:13 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> call dbms_java.loadjava('-v -r PUBLIC -sysnonym /home/oracle/files/commons-math3-3.0.jar');
Call completed.
SQL> begin
dbms_java.loadjava('-v -r PUBLIC -sysnonym /home/oracle/files/commons-math3-3.0.jar');
end;
/
PL/SQL procedure successfully completed.
SQL> exec dbms_java.loadjava('-v -r PUBLIC -sysnonym /home/oracle/files/commons-math3-3.0.jar');
PL/SQL procedure successfully completed.
或者使用loadjava命令
[oracle@host01 admin]$ loadjava -force -thin -user xf/xf@192.168.56.101:1521/xfpdb.example.com -resolve /home/oracle/files/commons-math3-3.0.jar
4、在Oracle資料庫建立java程式碼
SQL> create or replace and compile java source named jar_norm as
2 import org.apache.commons.math3.distribution.NormalDistribution;
3 public class jar_norm {
4 public static double s_inv(double s){
5 NormalDistribution normalDistribution =new NormalDistribution(0,1);
6 double S1=normalDistribution.inverseCumulativeProbability(s);
7 return S1;
8 }
9 public static double s_dist_c(double s){
10 NormalDistribution normalDistribution =new NormalDistribution(0,1);
11 double S1=normalDistribution.cumulativeProbability(s);
12 return S1;
13 }
14 }
15 /
Java created.
-end-
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28373936/viewspace-2149028/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- java中的JAR檔案淺析JavaJAR
- jar包中匯入新的類JAR
- Java POI匯入Excel檔案JavaExcel
- 如何程式讀入jar包中的任何檔案。JAR
- MySQL匯入匯出檔案檔案MySql
- Java中getResourceAsStream的用法,讀取jar裡面的檔案JavaJAR
- 向mysql中匯入.sql檔案MySql
- 查詢jar中的pom檔案JAR
- k8s Java 專案替換 jar 中的 class 檔案K8SJavaJAR
- shell 啟動 java jar 檔案JavaJAR
- .sql檔案匯入到sql server中SQLServer
- svn匯入檔案
- 將eclipse中的檔案匯出成為*.JAR時遇見的問題!EclipseJAR
- NC65如何匯出補丁(jar檔案)JAR
- EasyExcel完成excel檔案的匯入匯出Excel
- maven工程載入外部jar檔案的方法MavenJAR
- Android專案中使用Eclipse匯出jar檔案AndroidEclipseJAR
- IDEA 匯入 ***.jar包IdeaJAR
- IDEA匯入jar包IdeaJAR
- maven 工程匯入jar包MavenJAR
- 使用dubbo需要匯入的jar包JAR
- (十一)Electron 匯入匯出檔案
- mysql 匯入匯出 sql檔案MySql
- MySQL匯入匯出平面檔案MySql
- sqlserver匯入匯出文字檔案SQLServer
- Java中獲取JAR檔案中資源路徑的三種方法JavaJAR
- Mysql匯入csv檔案MySql
- Mysql匯入本地檔案MySql
- vfp匯入文字檔案
- oracle匯入dmp檔案Oracle
- easyExcel分批匯入檔案Excel
- Python-檔案的匯入Python
- java匯出Excel檔案JavaExcel
- java匯出CSV檔案Java
- java怎麼匯入專案?java已有專案如何匯入eclipse?JavaEclipse
- Eclipse在已建立的project中匯入其他檔案EclipseProject
- 華表Cell檔案匯入匯出
- 匯入jar包,main函式JARAI函式