Thanks Rahul, It is pretty much how I have got mine setup. I am getting the following error though when I startup Tomcat:
15 Nov 2002 00:32:36 - slidestore.reference.JDBCDescriptorsStore - INFO - Connecting to "jdbc:mysql://localhost:3306/myDB" as user "root" 15 Nov 2002 00:32:41 - slidestore.reference.JDBCDescriptorsStore - ERROR - Connecting to "jdbc:mysql://localhost:3306/myDB" as user "root" failed 15 Nov 2002 00:32:41 - slidestore.reference.JDBCDescriptorsStore - ERROR - java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@localhost' (Using password: YES) 15 Nov 2002 00:32:41 - org.apache.slide.common.Domain - WARNING - Service slidestore.reference.JDBCDescriptorsStore@a36b53 connection failed : Invalid authorization specification: Access denied for user: 'root@localhost' (Using password: YES) 15 Nov 2002 00:32:41 - org.apache.slide.common.Domain - WARNING - Service is missing on root node 15 Nov 2002 00:32:41 - org.apache.slide.common.Namespace - ERROR - Unable to read Namespace base configuration file : 15 Nov 2002 00:32:41 - org.apache.slide.common.Namespace - ERROR - org.apache.slide.common.ServiceMissingOnRootNodeException: Service is missing on root node org.apache.slide.common.ServiceMissingOnRootNodeException: Service is missing on root node I can access the database from mysql using the user name and password that I set in Domain.xml but it does not seem to work from slide. Thanks for you help anyway. Jim. ----- Original Message ----- From: "Rahul" <[EMAIL PROTECTED]> To: "Slide Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, November 15, 2002 1:58 AM Subject: Re: Domain.xml configuration for MySQL > > 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> > -- To unsubscribe, e-mail: <mailto:slide-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:slide-user-help@;jakarta.apache.org>
