And the final change to fix my issue: set databaseType="oracle" in my journal definition.
OraclePersistenceManager does this without me setting the parameter explicitly (~line 97). Should OracleDatabaseJournal assume the defaults that OraclePersistenceManager does? On Mon, Aug 16, 2010 at 11:25 AM, Carl Hall <[email protected]> wrote: > I started Sling and debugged into the JackRabbit code to see what SQL is > failing. This is what I've found. > > This SQL is run but fails with the 'invalid datatype' exception: > create table JOURNAL (REVISION_ID BIGINT NOT NULL, JOURNAL_ID varchar(255), > PRODUCER_ID varchar(255), REVISION_DATA varbinary) > > When I modify it in memory to this, it works: > create table JOURNAL (REVISION_ID number(20,0) NOT NULL, JOURNAL_ID > varchar(255), PRODUCER_ID varchar(255), REVISION_DATA blob) > > but then I find that this statement fails next: > create table LOCAL_REVISIONS (JOURNAL_ID varchar(255) NOT NULL, REVISION_ID > BIGINT NOT NULL) > > Same changes as above (BIGINT -> number(20,0)) and we're clear again. > > Should I file a JIRA for this? If someone can give me direction, I don't > mind making a patch or changing configuration where needed. > > > On Mon, Aug 16, 2010 at 9:20 AM, Carl Hall <[email protected]> wrote: > >> Aside from the first 3 drop statements failing (tables didn't exist), this >> ran correctly. I am changing my repository FS to be a DB FS and will try >> again. Maybe this will help in someway. >> >> >> On Mon, Aug 16, 2010 at 9:05 AM, Thomas Müller <[email protected]>wrote: >> >>> Hi, >>> >>> > Oracle 9. >>> >>> I'm not sure what the problem might be... Could you run the following >>> script to find out where exactly the problem is? >>> >>> drop table JOURNAL; >>> drop table GLOBAL_REVISION; >>> drop table LOCAL_REVISIONS; >>> create table JOURNAL (REVISION_ID number(20,0) NOT NULL, JOURNAL_ID >>> varchar(255), PRODUCER_ID varchar(255), REVISION_DATA blob); >>> create unique index JOURNAL_IDX on JOURNAL (REVISION_ID); >>> create table GLOBAL_REVISION (REVISION_ID number(20,0) NOT NULL); >>> create unique index GLOBAL_REVISION_IDX on GLOBAL_REVISION (REVISION_ID); >>> create table LOCAL_REVISIONS (JOURNAL_ID varchar(255) NOT NULL, >>> REVISION_ID number(20,0) NOT NULL); >>> insert into GLOBAL_REVISION VALUES(0); >>> drop table JOURNAL; >>> drop table GLOBAL_REVISION; >>> drop table LOCAL_REVISIONS; >>> >>> If this works, then I don't know where the problem might be. >>> >>> Regards, >>> Thomas >>> >> >> >
