HI:
Gridsphere-users:
Hi, when i install gridportlet 1.4, i met a problem .
my gridsphere version is 2.2.9. my oracle version is 9204.
the problem is as following:
[dbtask] < Unsuccessful: create table resource (gsoid varchar2(32) not
null,
subclass varchar2(255) not null, dn varchar2(255), label varchar2(255),
description varchar2(255),
available number(1,0), ParentResource varchar2(32), HostName
varchar2(255), InetAddress varchar2(255),
Name varchar2(255), Port varchar2(255), Protocol varchar2(255),
ServicePath varchar2(255), dcau number(1,0),
basedn varchar2(255), proxyfile varchar2(255), certfile varchar2(255),
keyfile varchar2(255),
portalcred number(1,0), delegation varchar2(255), gsauthorization
varchar2(255), servicedn varchar2(255),
timeout varchar2(255), Path varchar2(255), schedtype varchar2(255),
UserId varchar2(255), useroid varchar2(255),
delOnEnd number(1,0), TaskSpec varchar2(32), taskStatus
varchar2(255), taskStatusMsg varchar2(255),
timeSubmitted number(19,0), timeStarted number(19,0),
timeStatusChanged number(19,0), timeEnded number(19,0),
jobId varchar2(255), jobStatus varchar2(255), jobString clob,
SchedulerName varchar2(255),
QueueName varchar2(255), NumNodes number(10,0), SOUT_LOC
varchar2(255), SERR_LOC varchar2(255),
fileTaskId varchar2(255), PARENT_OID varchar2(32), CHILD_NUM
number(10,0), primary key (gsoid)) >
[dbtask]
[dbtask] 7852:ERROR:(SchemaExport.java:execute:155)
[dbtask] < ORA-00903: invalid table name
I know why it happens because the word 'resource' conflicts with the
ORACLE reserved key 'resource'.
but i want to knwo how i can fix this problem. i met the same problem
as in gridportlet 1.3.2. CANNOT THE PORTLET WORK FINE WITH ORACLE?
I have edited the hibernate.properties ,the content is :
hibernate.show_sql=ture
hibernate.connection.pool_size=40
hibernate.connection.autocommit=true
hibernate.connection.shutdown=true
hibernate.cache.provider_class=net.sf.hibernate.cache.EhCacheProvider
hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
#hibernate.dialect net.sf.hibernate.dialect.OracleDialect
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
hibernate.connection.username gridsphere
hibernate.connection.password gridsphere
hibernate.connection.url jdbc:oracle:thin:@localhost:1521:mydb
hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N'
