Oracle




Common

Web site: http://www.oracle.com

Create a database

Creating a structure of database and populate init data:

 <Oracle>/BIN/sqlplus plazma/tiger @ñ:\Plazma\db\script\createdb\oracle\en\create_plazma_db.sql  1>>message.txt 2>>error.txt
 




JDBC driver

You have to check the JDBC driver:


 <Plazma>/lib/jdbc/oracle/ojdbc14.jar
 

You have to verify CLASSPATH for the JDBC driver in the file:


 <Plazma>/plazma.classpath
 ------------------------------------------------------
 # Oracle 
 lib/jdbc/oracle/ojdbc14.jar

 


Connect to a database

To connect you have to change properties in file <Plazma>/conf/jdbc.properties.

For example:

 # Set connection properties
 jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
 jdbc.url=jdbc:oracle:thin:@localhost:1521:XE
 jdbc.username=plazma
 jdbc.password=tiger