Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
jar
JDBCProviderSybase.jar 45.5 kB 1 10-Feb-2006 16:31 sbglasius
zip
JDBCProviderSybase_src.zip 26.4 kB 1 10-Feb-2006 16:30 sbglasius

This page (revision-5) was last changed on 21-Jan-2008 08:31 by MiltonTaylor  

This page was created on 10-Feb-2006 16:23 by sbglasius

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 1 changed 61 lines
!!SyBase Compliant version of the JDBCProvider
This provider is based almost entirely on the "JSPWiki 2.3.72" version of the [JDBCProviders] except, that this works with SyBase (and probably not the others).
The changes are:
* Attachments table has an extra column with info about the attachment size, as SyBase does not support LENGTH on a binary field.
* Migrating now sets the original document date on the migrated versions.
Here are the table creation code:
{{{
CREATE TABLE WIKI_PAGE
(
PAGE_NAME nvarchar(100) NOT NULL,
PAGE_VERSION int DEFAULT 0 NOT NULL,
PAGE_MODIFIED datetime NULL,
PAGE_MODIFIED_BY nvarchar(50) NULL,
PAGE_TEXT text NULL,
CONSTRAINT PK_WIKI_PAGE
PRIMARY KEY CLUSTERED (PAGE_NAME)
) LOCK DATAROWS
CREATE INDEX IX_PAGE_MODIFIED ON WIKI_PAGE (PAGE_MODIFIED)
CREATE TABLE WIKI_PAGE_VERSIONS (
VERSION_NAME nvarchar(100) NOT NULL ,
VERSION_NUM int DEFAULT 0 NOT NULL ,
VERSION_MODIFIED datetime NULL ,
VERSION_MODIFIED_BY nvarchar(50) NULL ,
VERSION_TEXT text NULL ,
CONSTRAINT PK_WIKI_PAGE_VERSIONS
PRIMARY KEY CLUSTERED (VERSION_NAME, VERSION_NUM) ,
CONSTRAINT FK_WIKI_VERSIONS_WIKI_PAGE
FOREIGN KEY(VERSION_NAME) REFERENCES WIKI_PAGE(PAGE_NAME)
)LOCK DATAROWS
CREATE TABLE WIKI_ATT
(
ATT_PAGENAME nvarchar(100) NOT NULL,
ATT_FILENAME nvarchar(100) NOT NULL,
ATT_VERSION int DEFAULT 0 NOT NULL ,
ATT_MODIFIED datetime NULL,
ATT_MODIFIED_BY nvarchar(50) NULL,
ATT_DATA image NULL,
ATT_LENGTH int NULL,
CONSTRAINT PK_ATT_PAGE
PRIMARY KEY CLUSTERED (ATT_PAGENAME, ATT_FILENAME, ATT_VERSION),
)LOCK DATAROWS
CREATE INDEX WIKI_ATT_MODIFIED_IX ON WIKI_ATT (ATT_MODIFIED)
}}}
I'm thinking about joining the [Author|Daggerbox] of [JDBCProviders] to make this provider as generic as possible, but havn't contacted him yet.
Comments are welcome.
Best regards,
Søren
soeren at glasius dot dk
----
See [https://developer.berlios.de/projects/jdbcprovider/]
Version Date Modified Size Author Changes ... Change note
5 21-Jan-2008 08:31 0.059 kB MiltonTaylor to previous
4 23-Aug-2006 15:24 2.297 kB 80.254.166.97 to previous | to last
3 23-Aug-2006 13:56 2.866 kB Nhdkgf to previous | to last
2 10-Feb-2006 16:34 2.287 kB sbglasius to previous | to last
1 10-Feb-2006 16:23 2.06 kB sbglasius to last
« This page (revision-5) was last changed on 21-Jan-2008 08:31 by MiltonTaylor