create-db.sql -- 创建表空间 CREATE TABLESPACE jbossportal LOGGING DATAFILE 'd:\oradata\dhtdba\jbossportal.dbf' SIZE 400M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; -- 创建用户 CREATE USER jbossportal IDENTIFIED BY jbossportal DEFAULT TABLESPACE jbossportal; -- 授予权限 GRANT DBA TO jbossportal; REVOKE UNLIMITED TABLESPACE FROM jbossportal; ALTER USER jbossportal QUOTA UNLIMITED ON jbossportal;
3. 配置JBOSS_HOME
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>PortalDS</jndi-name> <connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>jbossportal</user-name> <password>jbossportal</password> </local-tx-datasource> </datasources>