Forwarded to GS mailing list.
Regards, Wilfred From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of acesheath Sent: Sunday, September 09, 2007 12:26 AM To: [email protected] Subject: [gt-user] Can gridportlet1.4 work fine with Oracle 9204 ? 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'
