Slide JDBC store schema questions

["GARTRELL,MIKE (HP-Corvallis,ex1)" <mi...@hp.com>]

	I have a few questions about the schema used for the JDBC store:
	1.) Some tables, like the "objects" table, have a varchar(3200) as a
primary key.  Oracle 8i is unable to index tables having a primary key type
where the length of varchar is greater than 1080.
	2.) Why do some tables, such as "latestrevisions", lack a primary
key?

---> Mike Gartrell <---     ---> mike_gartrell@hp.com <---
                            ---> phone: (541) 715-0008 <---


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Slide JDBC store schema questions

[Dirk Verbeeck <di...@pandora.be>]

Are you sure about that length limit? I remember something that the
limit is that your index columns have to fit into one oracle database
block and that block in defined by DB_BLOCK_SIZE (you have to define it
before you create your database).

But if there is a limit then you can reduce the column size.
I didn't tune the database scheme yet, we should look at the sql
statements and define primary keys & indices where needed.
latestrevisions should have a primary key of (uri,branchname) I think.


Dirk


"GARTRELL,MIKE (HP-Corvallis,ex1)" wrote:
> 
>         I have a few questions about the schema used for the JDBC store:
>         1.) Some tables, like the "objects" table, have a varchar(3200) as a
> primary key.  Oracle 8i is unable to index tables having a primary key type
> where the length of varchar is greater than 1080.
>         2.) Why do some tables, such as "latestrevisions", lack a primary
> key?
> 
> ---> Mike Gartrell <---     ---> mike_gartrell@hp.com <---
>                             ---> phone: (541) 715-0008 <---
> 
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>