You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Jim Collins <ja...@blueyonder.co.uk> on 2002/11/15 00:59:30 UTC
Domain.xml configuration for MySQL
Hi,
Does anyone have a configuration file for MySQL.
Thanks
Jim
----- Original Message -----
From: "Michael Wang" <mw...@mindspring.com>
To: <sl...@jakarta.apache.org>
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:
<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>
Re: Domain.xml configuration for MySQL
Posted by Martin Holz <ho...@fiz-chemie.de>.
Hi,
On Friday 15 November 2002 07:36, Jim Collins wrote:
> 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.
Just an idea. It's not alway clear to me, in which cases mysql clients try to
login as root@localhost and in which case it uses
root@mycomputer.mydomain.com. Its even worst, if your computer has more than
one name.
Martin
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Performance issue
Posted by Sean Qi <se...@showiz.com>.
I forgot to mention that I was trying to move the Slide source direcotry
which you get from Slide's CVS to slide. In other words, the 170MB consists
of hundreds of files.
When I put one SINGLE file of 44 MB, it only take 15 seconds.
Any input?
Sean Q
----- Original Message -----
From: "Sean Qi" <se...@showiz.com>
To: "Slide Developers Mailing List" <sl...@jakarta.apache.org>; "Slide
Users Mailing List" <sl...@jakarta.apache.org>
Sent: Friday, November 15, 2002 4:25 PM
Subject: Performance issue
> Hi, All,
>
> Has anyone tested Slide's performance or run into some issues in the
> performance area?
>
> I just did a test as follows:
>
> 1. Configure Slide to use JDBCDescriptorStore as nodestore and
> FileContentStore as the content store.
> 2. Start Tomcat (4.1) with Slide deployed in webapps on my local machine
> (W2K Professional).
> 3. Used Windows Explorer as the WebDav client to copy/paste 170M files
from
> my local drive to Slide.
> 4. It seemed that it took forever to finish the copy. I finally ran out
of
> patience and stopped the copying. It turned out that in approximately 40
> minutes, only 9.8 M files were copied over to slide.
> After some math, I realized the speed is only 4K/second. It is too slow.
>
> Is this an inherited "problem" with Slide or something could be done to
> improve it?
>
> Any input isappreciated.
>
> Sean Q.
>
>
>
> --
> 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>
Re: Performance issue
Posted by Sean Qi <se...@showiz.com>.
I forgot to mention that I was trying to move the Slide source direcotry
which you get from Slide's CVS to slide. In other words, the 170MB consists
of hundreds of files.
When I put one SINGLE file of 44 MB, it only take 15 seconds.
Any input?
Sean Q
----- Original Message -----
From: "Sean Qi" <se...@showiz.com>
To: "Slide Developers Mailing List" <sl...@jakarta.apache.org>; "Slide
Users Mailing List" <sl...@jakarta.apache.org>
Sent: Friday, November 15, 2002 4:25 PM
Subject: Performance issue
> Hi, All,
>
> Has anyone tested Slide's performance or run into some issues in the
> performance area?
>
> I just did a test as follows:
>
> 1. Configure Slide to use JDBCDescriptorStore as nodestore and
> FileContentStore as the content store.
> 2. Start Tomcat (4.1) with Slide deployed in webapps on my local machine
> (W2K Professional).
> 3. Used Windows Explorer as the WebDav client to copy/paste 170M files
from
> my local drive to Slide.
> 4. It seemed that it took forever to finish the copy. I finally ran out
of
> patience and stopped the copying. It turned out that in approximately 40
> minutes, only 9.8 M files were copied over to slide.
> After some math, I realized the speed is only 4K/second. It is too slow.
>
> Is this an inherited "problem" with Slide or something could be done to
> improve it?
>
> Any input isappreciated.
>
> Sean Q.
>
>
>
> --
> 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>
Performance issue
Posted by Sean Qi <se...@showiz.com>.
Hi, All,
Has anyone tested Slide's performance or run into some issues in the
performance area?
I just did a test as follows:
1. Configure Slide to use JDBCDescriptorStore as nodestore and
FileContentStore as the content store.
2. Start Tomcat (4.1) with Slide deployed in webapps on my local machine
(W2K Professional).
3. Used Windows Explorer as the WebDav client to copy/paste 170M files from
my local drive to Slide.
4. It seemed that it took forever to finish the copy. I finally ran out of
patience and stopped the copying. It turned out that in approximately 40
minutes, only 9.8 M files were copied over to slide.
After some math, I realized the speed is only 4K/second. It is too slow.
Is this an inherited "problem" with Slide or something could be done to
improve it?
Any input isappreciated.
Sean Q.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Error creating a collection.
Posted by Jim Collins <ja...@blueyonder.co.uk>.
I found the problem. In my Domain.xml file I was using a JDBC store instead
of a MySQL strore.
Regards
Jim.
----- Original Message -----
From: "Jim Collins" <ja...@blueyonder.co.uk>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Sunday, November 17, 2002 10:06 PM
Subject: Re: Error creating a collection.
> I have been trawling through the mail archives and noted that Chris
Stevens
> had the same problem in the posting:
> "can connect to but not use MySQL collections..."
> I could not find any reply however explaining how to fix the problem.
>
> Thanks
>
> Jim.
>
> ----- Original Message -----
> From: "Jim Collins" <ja...@blueyonder.co.uk>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Sunday, November 17, 2002 9:09 PM
> Subject: Error creating a collection.
>
>
> > Hi,
> >
> > I have now sorted out the MySQL problems I had (thanks Rahul) and I can
> now
> > get Slide to start. When I try and create a collection I get the
following
> > error:
> >
> > 17 Nov 2002 17:30:39 - org.apache.slide.common.Domain - WARNING -
Service
> > jdbc(org.apache.slide.store.StandardStore) access error : Failed to
enlist
> > service slidestore.reference.JDBCDescriptorsStore@1c293f8 in active
> > transaction
> > 17 Nov 2002 17:30:39 -
> > org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
> > Transaction 28 xid HttpProcessor[8080][1]-1037554234610-28- in thread
> > HttpProcessor[8080][1]
> > 17 Nov 2002 17:30:39 - org.apache.slide.webdav.WebdavServlet - INFO -
> MKCOL
> > = 500 Internal Server Error (time: 4927 ms) URI = /Jess
> > 17 Nov 2002 20:54:07 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> > WARNING - Enlist failure: Resource manager
> > slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code
XAER_OUTSIDE
> in
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:12 - org.apache.slide.common.Domain - WARNING -
Service
> > jdbc(org.apache.slide.store.StandardStore) access error : Failed to
enlist
> > service slidestore.reference.JDBCDescriptorsStore@1c293f8 in active
> > transaction
> > 17 Nov 2002 20:54:12 -
> > org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
> > Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> > HttpProcessor[8080][4]
> > 17 Nov 2002 20:54:12 - org.apache.slide.webdav.WebdavServlet - INFO -
> MKCOL
> > = 500 Internal Server Error (time: 8482 ms) URI = /Jess
> >
> > If anyone has and idea what I am doing wrong it would be appreciated.
> >
> > Thanks
> >
> > Jim.
> >
> >
> > --
> > 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>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Error creating a collection.
Posted by Jim Collins <ja...@blueyonder.co.uk>.
I have been trawling through the mail archives and noted that Chris Stevens
had the same problem in the posting:
"can connect to but not use MySQL collections..."
I could not find any reply however explaining how to fix the problem.
Thanks
Jim.
----- Original Message -----
From: "Jim Collins" <ja...@blueyonder.co.uk>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Sunday, November 17, 2002 9:09 PM
Subject: Error creating a collection.
> Hi,
>
> I have now sorted out the MySQL problems I had (thanks Rahul) and I can
now
> get Slide to start. When I try and create a collection I get the following
> error:
>
> 17 Nov 2002 17:30:39 - org.apache.slide.common.Domain - WARNING - Service
> jdbc(org.apache.slide.store.StandardStore) access error : Failed to enlist
> service slidestore.reference.JDBCDescriptorsStore@1c293f8 in active
> transaction
> 17 Nov 2002 17:30:39 -
> org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
> Transaction 28 xid HttpProcessor[8080][1]-1037554234610-28- in thread
> HttpProcessor[8080][1]
> 17 Nov 2002 17:30:39 - org.apache.slide.webdav.WebdavServlet - INFO -
MKCOL
> = 500 Internal Server Error (time: 4927 ms) URI = /Jess
> 17 Nov 2002 20:54:07 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
> WARNING - Enlist failure: Resource manager
> slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE
in
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:12 - org.apache.slide.common.Domain - WARNING - Service
> jdbc(org.apache.slide.store.StandardStore) access error : Failed to enlist
> service slidestore.reference.JDBCDescriptorsStore@1c293f8 in active
> transaction
> 17 Nov 2002 20:54:12 -
> org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
> Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
> HttpProcessor[8080][4]
> 17 Nov 2002 20:54:12 - org.apache.slide.webdav.WebdavServlet - INFO -
MKCOL
> = 500 Internal Server Error (time: 8482 ms) URI = /Jess
>
> If anyone has and idea what I am doing wrong it would be appreciated.
>
> Thanks
>
> Jim.
>
>
> --
> 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>
Error creating a collection.
Posted by Jim Collins <ja...@blueyonder.co.uk>.
Hi,
I have now sorted out the MySQL problems I had (thanks Rahul) and I can now
get Slide to start. When I try and create a collection I get the following
error:
17 Nov 2002 17:30:39 - org.apache.slide.common.Domain - WARNING - Service
jdbc(org.apache.slide.store.StandardStore) access error : Failed to enlist
service slidestore.reference.JDBCDescriptorsStore@1c293f8 in active
transaction
17 Nov 2002 17:30:39 -
org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
Transaction 28 xid HttpProcessor[8080][1]-1037554234610-28- in thread
HttpProcessor[8080][1]
17 Nov 2002 17:30:39 - org.apache.slide.webdav.WebdavServlet - INFO - MKCOL
= 500 Internal Server Error (time: 4927 ms) URI = /Jess
17 Nov 2002 20:54:07 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:08 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:09 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:10 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:11 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
slidestore.reference.JDBCDescriptorsStore@1c293f8 Error code XAER_OUTSIDE in
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:12 - org.apache.slide.common.Domain - WARNING - Service
jdbc(org.apache.slide.store.StandardStore) access error : Failed to enlist
service slidestore.reference.JDBCDescriptorsStore@1c293f8 in active
transaction
17 Nov 2002 20:54:12 -
org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
Transaction 29 xid HttpProcessor[8080][4]-1037566444237-29- in thread
HttpProcessor[8080][4]
17 Nov 2002 20:54:12 - org.apache.slide.webdav.WebdavServlet - INFO - MKCOL
= 500 Internal Server Error (time: 8482 ms) URI = /Jess
If anyone has and idea what I am doing wrong it would be appreciated.
Thanks
Jim.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Domain.xml configuration for MySQL
Posted by Jim Collins <ja...@blueyonder.co.uk>.
Hi Rahul,
Thanks again for the tip. I am new to MySQL and thought it had something to
do with the MySQL and not slide.
Regards
Jim.
PS Thanks also to the other people who replied.
----- Original Message -----
From: "Rahul" <ra...@excibir.co.nz>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Saturday, November 16, 2002 2:13 AM
Subject: Re: Domain.xml configuration for MySQL
> Hi Jim,
>
> The MySQL error there has to do with MySQL server configuration. you can
> refer to "GRANT PRIVILEGES ....." syntax to change privileges for
> <user_name>@<host_name> (Please refer MySQL documentation).
>
> That should resolve that :-)
>
> Cheers,
>
> Rahul
>
> ----- Original Message -----
> From: "Jim Collins" <ja...@blueyonder.co.uk>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Friday, November 15, 2002 7:36 PM
> Subject: Re: Domain.xml configuration for MySQL
>
>
> > 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" <ra...@excibir.co.nz>
> > To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > 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" <ja...@blueyonder.co.uk>
> > > To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > > 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" <mw...@mindspring.com>
> > > > To: <sl...@jakarta.apache.org>
> > > > 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:
> > > > <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>
> > > >
> > >
> > >
> > > --
> > > 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>
> >
>
>
> --
> 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>
Re: Domain.xml configuration for MySQL
Posted by Rahul <ra...@excibir.co.nz>.
Hi Jim,
The MySQL error there has to do with MySQL server configuration. you can
refer to "GRANT PRIVILEGES ....." syntax to change privileges for
<user_name>@<host_name> (Please refer MySQL documentation).
That should resolve that :-)
Cheers,
Rahul
----- Original Message -----
From: "Jim Collins" <ja...@blueyonder.co.uk>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Friday, November 15, 2002 7:36 PM
Subject: Re: Domain.xml configuration for MySQL
> 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" <ra...@excibir.co.nz>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> 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" <ja...@blueyonder.co.uk>
> > To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > 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" <mw...@mindspring.com>
> > > To: <sl...@jakarta.apache.org>
> > > 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:
> > > <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>
> > >
> >
> >
> > --
> > 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>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Performance issue
Posted by Sean Qi <se...@showiz.com>.
Hi, All,
Has anyone tested Slide's performance or run into some issues in the
performance area?
I just did a test as follows:
1. Configure Slide to use JDBCDescriptorStore as nodestore and
FileContentStore as the content store.
2. Start Tomcat (4.1) with Slide deployed in webapps on my local machine
(W2K Professional).
3. Used Windows Explorer as the WebDav client to copy/paste 170M files from
my local drive to Slide.
4. It seemed that it took forever to finish the copy. I finally ran out of
patience and stopped the copying. It turned out that in approximately 40
minutes, only 9.8 M files were copied over to slide.
After some math, I realized the speed is only 4K/second. It is too slow.
Is this an inherited "problem" with Slide or something could be done to
improve it?
Any input isappreciated.
Sean Q.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Domain.xml configuration for MySQL
Posted by Jim Collins <ja...@blueyonder.co.uk>.
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" <ra...@excibir.co.nz>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
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" <ja...@blueyonder.co.uk>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> 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" <mw...@mindspring.com>
> > To: <sl...@jakarta.apache.org>
> > 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:
> > <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>
> >
>
>
> --
> 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>
Re: Domain.xml configuration for MySQL
Posted by Rahul <ra...@excibir.co.nz>.
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" <ja...@blueyonder.co.uk>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
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" <mw...@mindspring.com>
> To: <sl...@jakarta.apache.org>
> 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:
> <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>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>