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 >> > >
