[rules-users] Persistence issue using Oracle

[ramram]

Hi All,

   I changed the datasource that was pointing to the in memory database to
oracle. But I am having the following exceptions. Can anyone help in this
issue.

15:28:10,926 INFO  [SchemaExport] exporting generated schema to database
15:28:11,348 ERROR [SchemaExport] Unsuccessful: create table
ProcessInstanceInfo (processInstanceId bigint generated by default as
identity, OPTLOCK integer, processId va
rchar(255), startDate timestamp, lastReadDate timestamp,
lastModificationDate timestamp, state integer not null,
processInstanceByteArray blob, externalVariables bit not
null, primary key (processInstanceId))
15:28:11,349 ERROR [SchemaExport] ORA-00907: missing right parenthesis

15:28:11,398 ERROR [SchemaExport] Unsuccessful: create table
ProcessInstanceInfo_eventTypes (ProcessInstanceInfo_processInstanceId bigint
not null, element varchar(255))
15:28:11,399 ERROR [SchemaExport] ORA-00972: identifier is too long

15:28:11,428 ERROR [SchemaExport] Unsuccessful: create table SessionInfo (id
integer generated by default as identity, startDate timestamp,
lastModificationDate timestamp
, dirty bit not null, rulesByteArray blob, primary key (id))
15:28:11,429 ERROR [SchemaExport] ORA-00907: missing right parenthesis

15:28:11,468 ERROR [SchemaExport] Unsuccessful: create table
VariableInstanceInfo (TYPE varchar(50) not null, id bigint generated by
default as identity, name varchar(255
), persister varchar(255), entityClass varchar(255), entityId bigint,
content blob, processId bigint, primary key (id))
15:28:11,469 ERROR [SchemaExport] ORA-00907: missing right parenthesis

15:28:11,509 ERROR [SchemaExport] Unsuccessful: create table WorkItemInfo
(workItemId bigint generated by default as identity, OPTLOCK integer, name
varchar(255), creatio
nDate timestamp, processInstanceId bigint not null, state bigint not null,
workItemByteArray blob, primary key (workItemId))
15:28:11,510 ERROR [SchemaExport] ORA-00907: missing right parenthesis

15:28:11,538 ERROR [SchemaExport] Unsuccessful: alter table
ProcessInstanceInfo_eventTypes add constraint FK2FD59D8CBEE4613C foreign key
(ProcessInstanceInfo_processInsta
nceId) references ProcessInstanceInfo
15:28:11,538 ERROR [SchemaExport] ORA-00972: identifier is too long

15:28:11,588 ERROR [SchemaExport] Unsuccessful: alter table
VariableInstanceInfo add constraint FK7BE49B9F9123C534 foreign key
(processId) references ProcessInstanceInfo
15:28:11,589 ERROR [SchemaExport] ORA-00942: table or view does not exist

15:28:11,590 INFO  [SchemaExport] schema export complete
15:28:11,596 INFO  [NamingHelper] JNDI InitialContext properties:{}
15:28:12,019 INFO  [STDOUT] Hibernate: select sessioninf0_.id as id0_0_,
sessioninf0_.startDate as startDate0_0_, sessioninf0_.lastModificationDate
as lastModi3_0_0_, ses
sioninf0_.dirty as dirty0_0_, sessioninf0_.rulesByteArray as rulesByt5_0_0_
from SessionInfo sessioninf0_ where sessioninf0_.id=?
15:28:12,350 WARN  [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
15:28:12,351 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not
exist

15:28:12,353 INFO  [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity:
[org.drools.persistence.session.SessionInfo#1]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
        at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
        at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
        at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
        at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
        at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)



Regards,
Ram
-- 
View this message in context: http://n3.nabble.com/Persistence-issue-using-Oracle-tp417257p439627.html
Sent from the Drools - User mailing list archive at Nabble.com.