Hi Jim,
Below is a snippet of domain.xml for cofiguring slide with MySQL running on
localhost.
Hope it helps !!
Cheers :-)
Rahul
**************************************
<!-- ### JDBC Configuration ###
The following jdbc sample configuration uses the hsql Database Engine
a relational database engine written in Java, for more info:
http://hsqldb.sourceforge.net/
-->
<definition>
<store name="jdbc">
<nodestore classname="slidestore.mysql.MySQLDescriptorsStore">
<parameter name="driver">com.mysql.jdbc.Driver</parameter>
<parameter name="url">jdbc:mysql://localhost:3306/slide</parameter>
<parameter name="user">root</parameter>
<parameter name="password"></parameter>
</nodestore>
<securitystore>
<reference store="nodestore" />
</securitystore>
<lockstore>
<reference store="nodestore" />
</lockstore>
<revisiondescriptorsstore>
<reference store="nodestore" />
</revisiondescriptorsstore>
<revisiondescriptorstore>
<reference store="nodestore" />
</revisiondescriptorstore>
<contentstore classname="slidestore.mysql.MySQLContentStore">
<parameter name="driver">com.mysql.jdbc.Driver</parameter>
<parameter name="url">jdbc:mysql://localhost:3306/slide</parameter>
<parameter name="user">root</parameter>
<parameter name="password">somepassword</parameter>
</contentstore>
</store>
<scope match="/" store="jdbc" />
</definition>
******************************************
----- Original Message -----
From: "Jim Collins" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, November 15, 2002 12:59 PM
Subject: Domain.xml configuration for MySQL
> Hi,
>
> Does anyone have a configuration file for MySQL.
>
> Thanks
>
> Jim
> ----- Original Message -----
> From: "Michael Wang" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 14, 2002 11:22 PM
> Subject: URI limited to 255 in MySQL and DB2?
>
>
> > I found that URI column in OBJECTS and REVISIONS tables are limited
> > to 255 chars in MySQL and DB2, due to the primary key constraint.
> >
> > The purpose of this posting is to confirm this, and to seek opinions and
> > workaround.
> >
> > Thanks.
> >
> > (1) MySQL
> >
> > Copied from JDBC How To:
> >
> > "
> > create table objects(uri blob not null, primary key uriIndex (uri(255)),
> > classname blob);
> > "
> >
> > I believe PRIMARY KEY is used to enforce uniqueness as well as indexing.
> > If this is true, URI exceeds 255, and PRIMARY KEY is only done on the
> > first 255 chars, then the uniqueness is not enforced.
> >
> > The key is limited to 255 on a single column in MySQL (both MyISAM and
> > innoDB), having a larger URI column only create a hidden problem. It is
> > better to make the problem up front. For this reason, I would suggest
> > changing above to
> >
> > "
> > create table objects(uri varchar(255) not null, primary key uriIndex
> (uri(255)),
> > classname blob);
> > "
> >
> > How do you think? And anyone has an idea to make URI beyond 255 in
MySQL?
> >
> > (2) DB2
> >
> > The DB2 (version 7.1) has the same limitation on the length of
> > column with primary key, as shown below.
> >
> > "
> > db2 => create table obj(uri varchar(256) not null primary key,
> > db2 (cont.) => classname varchar(3200));
> >
> > SQL20075 The index or index extension "SQL021114150625950" cannot be
> created
> > or altered because the length of "URI" is more than 255 bytes.
> SQLSTATE=54008
> >
> > db2 => create table obj(uri blob(256) not null primary key,
> > db2 (cont.) => classname varchar(3200));
> >
> > SQL0350N LOB, DATALINK, or structured type column "URI" cannot be used
in
> an
> > index, a key, a unique constraint, a generated column, or a declared
> temporary
> > table. SQLSTATE=42962
> > "
> >
> > Is there a way to go beyond 255 in DB2?
> >
> > Anyone has encountered the limitation in these two databases, and
> > has found a workaround?
> >
> > --
> > Michael Wang
> > http://www.unixlabplus.com/
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:slide-user-unsubscribe@;jakarta.apache.org>
> > For additional commands, e-mail:
> <mailto:slide-user-help@;jakarta.apache.org>
> >
>
>
> --
> To unsubscribe, e-mail:
<mailto:slide-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail:
<mailto:slide-user-help@;jakarta.apache.org>
>
--
To unsubscribe, e-mail: <mailto:slide-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:slide-user-help@;jakarta.apache.org>
