Where is that Oracle patch? There is a link on that JIRA bug report,
but it leads to a password protected page.
- Dave
On Sep 1, 2005, at 5:41 PM, Kolano, Kenneth M. wrote:
IMO getting Padraic's (or someone else's) Oracle patches in would be a
priority over Derby. There is already support for HSQL for folks
without a
DB install.
http://opensource2.atlassian.com/projects/roller/browse/ROL-453
Kenneth M. Kolano
Technology Architecture & Innovation
908-423-4241
WS1B-51B
-----Original Message-----
From: Dave Johnson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 5:18 PM
To: [email protected]
Subject: Re: more createdb-raw.sql observations
Thanks Elias.
I think this stuff should be addressed and I will attempt to do so in
the createdb script. IMO Derby is a key database for Apache, IBM and
Sun and we need to support it. I hope to get to it tomorrow, but
probably after I make the Roller 2.0 EA demo available.
- Dave
On Sep 1, 2005, at 4:36 PM, Elias Torres wrote:
Inspired by the message from Brent [1] and with the help of IBM
colleagues on the Derby end, we've seem to find some other things in
the script that could be improved so we can support Derby 10.1 as
well.
1. website table create an "extra" index on the primary key. This
gives a warning on both derby and db2, not sure what do the other
databases do in this case. Is it ok if we remove the extra index?
[[[
id varchar(48) not null primary key,
]]]
[[[
create index website_id_index on website(id);
]]]
2. I believe that the rag_group table adds a constraint the handle
column to be unique and also creates an index. Again, both derby and
db2 think it's redundant.
[[[
alter table rag_group add constraint rag_group_handle_uq unique (
[EMAIL PROTECTED]@ );
create index rag_group_handle on rag_group([EMAIL PROTECTED]@);
]]]
3. There's an inconsistency in a foreign key relationship and the
table definition of the webpage table. website.id is VARCHAR(48) and
webpage.websiteid is VARCHAR(255). Is this an oversight or can we
change websiteid in webpage to also be VARCHAR(48), this way Derby
won't give us an error.
from webpage table:
[[[
websiteid varchar(255) not null,
]]]
[[[
alter table webpage add constraint weblogpage_websiteid_fk
foreign key ( websiteid ) references website( id )
]]]
from website table:
[[[
id varchar(48) not null primary key,
]]]
Again, thanks for all your support and time with all these requests, I
know you are very busy doing the next release, especially Dave.
Elias
[1] http://tinyurl.com/doqut
-----------------------------------------------------------------------
-------
Notice: This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
New Jersey, USA 08889), and/or its affiliates (which may be known
outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD
and in Japan, as Banyu) that may be confidential, proprietary
copyrighted and/or legally privileged. It is intended solely for the
use of the individual or entity named on this message. If you are not
the intended recipient, and have received this message in error,
please notify us immediately by reply e-mail and then delete it from
your system.
-----------------------------------------------------------------------
-------
