> Hello,
>
> I am trying to use Oracle for storing properties.
> I have modified Domain.xml for Oracle Database.
> It is giving Initilization error. It is working fine with hSQL
> Driver gets loaded in a simple Java program ,Slide clsses are unable to
load
> the Oracle Driver.
> Is there anything that i am missing?
>
> Error is
> Tue, 06 Feb 2001 14:46:06 EST - default - WARNING - Service
> slidestore.reference.JDBCDescriptorsStore@742b49 initialization failed :
> oracle.jdbc.driver.OracleDriver
> Service slidestore.reference.JDBCDescriptorsStore@742b49 initialization
> failed : oracle.jdbc.driver.OracleDriver
Apparently, the driver class was not found.
If you're running Slide under TC 4.0b1, you should know that TC4 ignores
your classpath. You should put the driver JAR in the "lib" folder.
Also, you should create the tables yourself (since some types I've used are
not compatible with Oracle). Here is the hSQL code :
String s = "create table objects(uri varchar(65536) "
+ " primary key, classname varchar(4096))";
statement.execute(s);
s = "create table children(uri varchar(65536), childuri "
+ "varchar(65536))";
statement.execute(s);
s = "create table links(link varchar(65536), linkto "
+ "varchar(65536))";
statement.execute(s);
s = "create table permissions(object varchar(65536),"
+ " subject varchar(65536), action varchar(65536), "
+ "inheritable int, negative int)";
statement.execute(s);
s = "create table locks(id varchar(65536), object
varchar(4096),"
+ " subject varchar(4096), type varchar(4096), "
+ "expirationdate varchar(15), inheritable int, "
+ "exclusive int)";
statement.execute(s);
s = "create table revisions(uri varchar(65536) primary key, "
+ "isversioned int, initialrevision varchar(10))";
statement.execute(s);
s = "create table workingrevision(uri varchar(65536), "
+ "baserevision varchar(20), number varchar(20))";
statement.execute(s);
s = "create table latestrevisions(uri varchar(65536), "
+ "branchname varchar(4096), number varchar(20))";
statement.execute(s);
s = "create table branches(uri varchar(65536), number "
+ "varchar(20), childnumber varchar(20))";
statement.execute(s);
s = "create table revision(uri varchar(65536), number "
+ "varchar(20), branchname varchar(4096))";
statement.execute(s);
s = "create table label(uri varchar(65536), number varchar(20),"
+ " label varchar(4096))";
statement.execute(s);
s = "create table property(uri varchar(65536), number"
+ " varchar(20), name varchar(4096), value varchar(65536), "
+ "namespace varchar(4096), type varchar(100), protected
int)";
statement.execute(s);
You should create the same tables, but with different types (varchar is
apparently limited to around 4000 characters in Oracle).
Remy
