从java应用程序运行oracle命令脚本文件 [英] Running oracle commands script file from java application

问题描述

我有一个具有oracle数据库的应用程序，因此安装应用程序需要运行一些oracle命令脚本文件来创建数据库并执行一些DDL操作。这些操作包括一些表空间创建，模式定义等。



我试图使用java应用程序准备安装向导。该向导需要运行这些命令。我的具体问题是：如何从我的java应用程序中运行oracle命令脚本文件？我确实需要一个java函数，它将sql命令文件路径作为输入参数，并从java执行脚本文件中的命令，考虑到必须将一些参数（例如一些用户选择的名称）传递给脚本文件哪个要执行



我曾经使用PL / SQL命令行功能以特权用户身份执行sql命令。



以下是该文件的一部分作为示例



ACCEPT TS_NAME CHAR PROMPT'输入表空间名称：'

ACCEPT DB_DATAFILE CHAR PROMPT'输入数据库文件完整路径：'

接受DB_SIZE NUMBER PROMPT'输入数据库文件大小（MB）：'

接受DB_USER CHAR PROMPT'输入用户姓名：'

接受DB_PASS CHAR PROMPT'输入表密码名称：'隐藏

接受DB_TNSNAME CHAR PROMPT'输入DATABASE TNSNAME：'

ACCEPT DB_LOG_PATH CHAR PROMPT'输入日志文件Pa th：'

PROMPT创建表空间

暂停按Return键继续...

CREATE TABLESPACE& TS_NAME DATAFILE'& DB_DATAFILE'SIZE & DB_SIZE M

AUTOEXTEND ON NEXT 1M MAXSIZE无限制记录永久

EXTENT管理本地自动安装块大小8K段空间管理手册;

PROMPT创建用户

暂停按返回继续...

创建用户和DB_USER由& DB_PASS DEFAULT TABLESPACE& TS_NAME PROFILE DEFA>识别

QUOTA无限用户;

COMMIT;

GRANT CONNECT TO& DB_USER;

GRANT RESOURCE TO& DB_USER;

COMMIT;

I have an application which has an oracle database, so the installation of the application needs running some oracle commands script files to create the database and perform some DDL operations. Those operations include some table space creation, schema definition etc.

I was trying to prepare an installation wizard using java application. This wizard needs to run these commands. My specific question is: How to run oracle commands script files from inside my java application? I exactly need a java function that takes the sql commands file path as input parameter and executes the commands within the script files from java taking into the eye of consideration that some parameters (e.g. some user-selected names)must be passed to the script file which to be executed

I used to use PL/SQL command line functionality to execute the sql commands as a privileged user.

Here is a section of the file as an example

ACCEPT TS_NAME CHAR PROMPT 'Enter Table Space Name : '
ACCEPT DB_DATAFILE CHAR PROMPT 'Enter DataBase File full path : '
ACCEPT DB_SIZE NUMBER PROMPT 'Enter DataBase File Size (MB) : '
ACCEPT DB_USER CHAR PROMPT 'Enter User Name : '
ACCEPT DB_PASS CHAR PROMPT 'Enter Table Password Name: ' HIDE
ACCEPT DB_TNSNAME CHAR PROMPT 'Enter DATABASE TNSNAME:'
ACCEPT DB_LOG_PATH CHAR PROMPT 'Enter Log File Path : '
PROMPT Create Tablespace
pause Press Return to continue ...
CREATE TABLESPACE &TS_NAME DATAFILE '&DB_DATAFILE' SIZE &DB_SIZE M
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL;
PROMPT Create User
pause Press Return to continue ...
CREATE USER &DB_USER IDENTIFIED BY &DB_PASS DEFAULT TABLESPACE &TS_NAME PROFILE DEFAULT
QUOTA UNLIMITED ON USERS;
COMMIT;
GRANT CONNECT TO &DB_USER;
GRANT RESOURCE TO &DB_USER;
COMMIT;

推荐答案

这篇关于从java应用程序运行oracle命令脚本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！