[prev in list] [next in list] [prev in thread] [next in thread]
List: slide-dev
Subject: Postgresql versus Mysql (was Problem with examples and transactions)
From: Leandro Rodrigo Saad Cruz <leandro () ibnetwork ! com ! br>
Date: 2001-12-21 19:41:09
[Download RAW message or body]
Hi all.
I set up a little test to show diferences between pgsql and mysql using
a simple test. This test should create some nodes, store content and
then create another revision of the same node.
Here is my test file.(attached TestFileStore.java)
should be run from build/examples and placed at build/examples/version.
a minor modification to build/examples/example.sh should do.
I run this example twice. using pgsql on a clean enviroment and using
mysql on free env too.
then I gor this results
Postgresql v.7.1.3-4:
pgsql log (attached pgsql.log)
process outout (attached test.pgsql.out)
pgsql queries (attached pgsql.client)
Mysql v 3.23.43-4
mysql log (attached mysql.log)
process output (attached test.mysql.out)
mysql queries (attached mysql.client)
If we compare the process output using mysql and pgsql we can find a
little diff found in test.pgsql.out
>org.apache.slide.store.StandardStore - INFO - Delisting service
>slidestore.reference.JDBCDescriptorsStore@2b34943 from active
>transaction with failure
>org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
>Transaction 1 xid main-1008960374578-1- in thread main
I think this is the cause that postgresql is not storing info in
property relation.
could somebody help me. I can increase the log level in Domain.java to
output more info if needed
--
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)
http://www.ibnetwork.com.br
["TestFileStore.java" (TestFileStore.java)]
package version;
import java.util.Enumeration;
import java.util.Vector;
import java.io.FileReader;
import java.io.FileWriter;
import java.util.Date;
import org.apache.slide.structure.*;
import org.apache.slide.content.*;
import org.apache.slide.common.*;
import org.apache.slide.lock.*;
import org.apache.slide.security.*;
import org.apache.slide.authenticate.CredentialsToken;
import org.apache.slide.authenticate.SecurityToken;
/**
* This is a test class soting files with versioning support.
*/
public class TestFileStore {
public static void main(String[] args) {
NamespaceAccessToken token = null;
try {
token = Domain.accessNamespace(new SecurityToken(new \
String()),"version");
Structure structure = token.getStructureHelper();
Content content = token.getContentHelper();
CredentialsToken credToken = new CredentialsToken(new String("root"));
SlideToken slideToken = new SlideTokenImpl(credToken);
String uri = "/test/file";
structure.create(slideToken, new SubjectNode(), uri);
content.create(slideToken,uri,true);
NodeRevisionDescriptor revision = null;
char[] buffer = \
{'t','h','i','s','.','i','s','.','a','.','t','e','s','t','\n'}; \
char[] new_buffer = \
{'t','h','i','s','.','i','s','.','a','.','n','e','w','.','t','e','s','t','\n'};
NodeRevisionContent nodeRevContent = new NodeRevisionContent();
//initial content
revision = new NodeRevisionDescriptor(buffer.length);
nodeRevContent.setContent(buffer);
content.create(slideToken, uri, revision, nodeRevContent);
//new revision
NodeRevisionDescriptors revisionDescriptors = \
content.retrieve(slideToken, uri);
revision = content.retrieve(slideToken ,revisionDescriptors);
revision.setContentLength(new_buffer.length);
nodeRevContent.setContent(new_buffer);
content.create(slideToken,uri,revision,nodeRevContent);
}
catch (Throwable e)
{
e.printStackTrace();
}
finally
{
System.out.println("Closing data sources");
Domain.closeNamespace(token);
}
}
}
["mysql.log" (mysql.log)]
011221 16:48:52 4 Connect stduser@localhost on
5 Connect slideuser@localhost on
4 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
4 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 4 Query show databases
5 Query SELECT VERSION() AS version
4 Quit
5 Quit
6 Connect stduser@localhost on
7 Connect stduser@localhost on
8 Connect slideuser@localhost on
6 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
6 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 6 Query show databases
8 Query SELECT VERSION() AS version
8 Init DB slide
8 Init DB slide
8 Query show tables
8 Query SHOW TABLE STATUS FROM `slide`
9 Connect slideuser@localhost on
7 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
7 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 7 Query show databases
9 Query SELECT VERSION() AS version
9 Query SELECT VERSION() as version, USER() as user
9 Query USE mysql
9 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql'
7 Query SELECT Create_priv, Process_priv, Reload_priv FROM mysql.user \
WHERE User = 'slideuser' OR User = '' 6 Quit
8 Quit
7 Query SELECT DISTINCT Db FROM mysql.db WHERE Create_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 7 Quit
9 Quit
011221 16:48:57 10 Connect stduser@localhost on
11 Connect slideuser@localhost on
10 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
10 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 10 Query show databases
11 Query SELECT VERSION() AS version
11 Init DB slide
11 Query SHOW TABLES LIKE 'branches'
11 Query SHOW TABLE STATUS LIKE 'branches'
11 Query SHOW KEYS FROM `branches`
11 Query SHOW FIELDS FROM `branches`
11 Query SELECT COUNT(*) AS num FROM `slide`.`branches`
11 Init DB slide
11 Query SHOW VARIABLES LIKE 'have_%'
10 Quit
11 Quit
011221 16:49:00 12 Connect stduser@localhost on
13 Connect slideuser@localhost on
12 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
12 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 12 Query show databases
13 Query SELECT VERSION() AS version
13 Init DB slide
13 Query SHOW TABLE STATUS FROM `slide`
13 Query USE mysql
13 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql' 12 Quit
13 Quit
011221 16:49:06 14 Connect stduser@localhost on
15 Connect slideuser@localhost on
14 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
14 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 14 Query show databases
15 Query SELECT VERSION() AS version
15 Init DB slide
15 Query SELECT COUNT(*) as count FROM `children`
15 Query DELETE FROM `children`
15 Init DB slide
15 Query SHOW TABLE STATUS FROM `slide`
15 Query USE mysql
15 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql' 14 Quit
15 Quit
011221 16:49:09 16 Connect stduser@localhost on
17 Connect slideuser@localhost on
16 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
16 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 16 Query show databases
17 Query SELECT VERSION() AS version
17 Init DB slide
17 Query SELECT COUNT(*) as count FROM `latestrevisions`
17 Query DELETE FROM `latestrevisions`
17 Init DB slide
17 Query SHOW TABLE STATUS FROM `slide`
17 Query USE mysql
17 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql' 16 Quit
17 Quit
011221 16:49:11 18 Connect stduser@localhost on
19 Connect slideuser@localhost on
18 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
18 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 18 Query show databases
19 Query SELECT VERSION() AS version
19 Init DB slide
19 Query SELECT COUNT(*) as count FROM `objects`
19 Query DELETE FROM `objects`
19 Init DB slide
011221 16:49:12 19 Query SHOW TABLE STATUS FROM `slide`
19 Query USE mysql
19 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql' 18 Quit
19 Quit
011221 16:49:14 20 Connect stduser@localhost on
21 Connect slideuser@localhost on
20 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
20 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 20 Query show databases
21 Query SELECT VERSION() AS version
21 Init DB slide
21 Query SELECT COUNT(*) as count FROM `property`
21 Query DELETE FROM `property`
21 Init DB slide
011221 16:49:15 21 Query SHOW TABLE STATUS FROM `slide`
21 Query USE mysql
21 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql' 20 Quit
21 Quit
011221 16:49:17 22 Connect stduser@localhost on
23 Connect slideuser@localhost on
22 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
22 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 22 Query show databases
23 Query SELECT VERSION() AS version
23 Init DB slide
23 Query SELECT COUNT(*) as count FROM `revision`
23 Query DELETE FROM `revision`
23 Init DB slide
23 Query SHOW TABLE STATUS FROM `slide`
23 Query USE mysql
23 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql' 22 Quit
23 Quit
011221 16:49:19 24 Connect stduser@localhost on
25 Connect slideuser@localhost on
24 Query SELECT User, Select_priv FROM mysql.user WHERE User = \
'slideuser'
24 Query SELECT DISTINCT Db FROM mysql.db WHERE Select_priv = 'Y' AND \
(User = 'slideuser' OR User = '') 24 Query show databases
25 Query SELECT VERSION() AS version
25 Init DB slide
25 Query SELECT COUNT(*) as count FROM `revisions`
25 Query DELETE FROM `revisions`
25 Init DB slide
25 Query SHOW TABLE STATUS FROM `slide`
25 Query USE mysql
25 Init DB Access denied for user: 'slideuser@localhost' to database \
'mysql' 24 Quit
25 Quit
011221 16:49:44 26 Connect slideuser@localhost on
26 Init DB slide
26 Query SHOW VARIABLES
26 Query SET autocommit=0
26 Query create table objects(uri varchar(65536) primary key, \
classname varchar(4096)) 011221 16:49:45 26 Query rollback
26 Query rollback
26 Query select * from objects where uri= '/'
26 Query insert into objects \
values('/','org.apache.slide.structure.SubjectNode') 26 Query SELECT 1
26 Query select * from objects where uri= '/tempaction'
26 Query insert into objects \
values('/tempaction','org.apache.slide.structure.ActionNode') 26 Query commit
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/test'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query rollback
26 Query select * from objects where uri= '/test'
26 Query insert into objects \
values('/test','org.apache.slide.structure.SubjectNode') 26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/'
26 Query delete from children where uri= '/'
26 Query insert into children values('/', '/test')
26 Query delete from links where link= '/'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users'
26 Query insert into objects \
values('/users','org.apache.slide.structure.SubjectNode') 26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/'
26 Query delete from children where uri= '/'
26 Query insert into children values('/', '/test')
26 Query insert into children values('/', '/users')
26 Query delete from links where link= '/'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users/root'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users/root'
26 Query insert into objects \
values('/users/root','org.apache.slide.structure.SubjectNode') 26 Query SELECT \
1 26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users'
26 Query delete from children where uri= '/users'
26 Query insert into children values('/users', '/users/root')
26 Query delete from links where link= '/users'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users/guest'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users/guest'
26 Query insert into objects \
values('/users/guest','org.apache.slide.structure.SubjectNode') 26 Query \
SELECT 1 26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/users'
26 Query delete from children where uri= '/users'
26 Query insert into children values('/users', '/users/root')
26 Query insert into children values('/users', '/users/guest')
26 Query delete from links where link= '/users'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/actions'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/actions'
26 Query insert into objects \
values('/actions','org.apache.slide.structure.ActionNode') 26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/'
26 Query delete from children where uri= '/'
26 Query insert into children values('/', '/test')
26 Query insert into children values('/', '/users')
26 Query insert into children values('/', '/actions')
26 Query delete from links where link= '/'
26 Query commit
26 Query rollback
26 Query delete from objects where uri= '/tempaction'
26 Query delete from children where uri='/tempaction'
26 Query delete from links where link= '/tempaction'
26 Query select * from objects where uri= '/'
26 Query delete from children where uri= '/'
26 Query insert into children values('/', '/test')
26 Query insert into children values('/', '/users')
26 Query insert into children values('/', '/actions')
26 Query delete from links where link= '/'
26 Query commit
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/test/file'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/test/file'
26 Query insert into objects \
values('/test/file','org.apache.slide.structure.SubjectNode') 26 Query SELECT \
1 26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query select * from objects where uri= '/test'
26 Query delete from children where uri= '/test'
26 Query insert into children values('/test', '/test/file')
26 Query delete from links where link= '/test'
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query insert into revisions values('/test/file',1,'1.0')
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query insert into revision values('/test/file', '1.0', 'main')
26 Query insert into property \
values('/test/file','1.0','resourcetype','<collection/>','DAV:','',1)
26 Query insert into property \
values('/test/file','1.0','source','','DAV:','',1)
26 Query insert into property \
values('/test/file','1.0','displayname','<![CDATA[file]]>','DAV:','',0)
26 Query insert into property \
values('/test/file','1.0','getlastmodified','Fri, 21 Dec 2001 18:49:45 \
GMT','DAV:','',1)
26 Query insert into property \
values('/test/file','1.0','getcontentlength','15','DAV:','',1)
26 Query insert into property \
values('/test/file','1.0','creationdate','2001-12-21T18:49:45Z','DAV:','',1) 26 \
Query delete from revisions where uri= '/test/file' 26 Query delete from \
workingrevision where uri= '/test/file' 26 Query delete from latestrevisions \
where uri= '/test/file' 26 Query delete from branches where uri= '/test/file'
26 Query insert into revisions values('/test/file',1,'1.0')
26 Query insert into latestrevisions values('/test/file','main','1.0')
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query SELECT 1
26 Query insert into revision values('/test/file', '1.1', 'main')
26 Query insert into property \
values('/test/file','1.1','resourcetype','<collection/>','DAV:','',1)
26 Query insert into property \
values('/test/file','1.1','source','','DAV:','',1)
26 Query insert into property \
values('/test/file','1.1','displayname','<![CDATA[file]]>','DAV:','',0)
26 Query insert into property \
values('/test/file','1.1','getlastmodified','Fri, 21 Dec 2001 18:49:45 \
GMT','DAV:','',1)
26 Query insert into property \
values('/test/file','1.1','getcontentlength','19','DAV:','',1)
26 Query insert into property \
values('/test/file','1.1','creationdate','2001-12-21T18:49:45Z','DAV:','',1) 26 \
Query delete from revisions where uri= '/test/file' 26 Query delete from \
workingrevision where uri= '/test/file' 26 Query delete from latestrevisions \
where uri= '/test/file' 26 Query delete from branches where uri= '/test/file'
26 Query insert into revisions values('/test/file',1,'1.0')
26 Query insert into latestrevisions values('/test/file','main','1.1')
26 Query SELECT 1
26 Quit
["mysql.client" (mysql.client)]
mysql> select * from objects;
+--------------+----------------------------------------+
> uri | classname |
+--------------+----------------------------------------+
> / | org.apache.slide.structure.SubjectNode |
> /test/file | org.apache.slide.structure.SubjectNode |
> /test | org.apache.slide.structure.SubjectNode |
> /users | org.apache.slide.structure.SubjectNode |
> /users/root | org.apache.slide.structure.SubjectNode |
> /users/guest | org.apache.slide.structure.SubjectNode |
> /actions | org.apache.slide.structure.ActionNode |
+--------------+----------------------------------------+
7 rows in set (0.00 sec)
mysql> select * from property ;
+------------+---------+------------------+-------------------------------+-----------+------+-----------+
| uri | xnumber | name | value |
namespace | type | protected |
+------------+---------+------------------+-------------------------------+-----------+------+-----------+
| /test/file | 1.0 | resourcetype | <collection/> |
DAV: | | 1 |
> /test/file | 1.0 | source | |
DAV: | | 1 |
> /test/file | 1.0 | displayname | <![CDATA[file]]> |
DAV: | | 0 |
> /test/file | 1.0 | getlastmodified | Fri, 21 Dec 2001 18:49:45 GMT |
DAV: | | 1 |
> /test/file | 1.0 | getcontentlength | 15 |
DAV: | | 1 |
> /test/file | 1.0 | creationdate | 2001-12-21T18:49:45Z |
DAV: | | 1 |
> /test/file | 1.1 | resourcetype | <collection/> |
DAV: | | 1 |
> /test/file | 1.1 | source | |
DAV: | | 1 |
> /test/file | 1.1 | displayname | <![CDATA[file]]> |
DAV: | | 0 |
> /test/file | 1.1 | getlastmodified | Fri, 21 Dec 2001 18:49:45 GMT |
DAV: | | 1 |
> /test/file | 1.1 | getcontentlength | 19 |
DAV: | | 1 |
> /test/file | 1.1 | creationdate | 2001-12-21T18:49:45Z |
DAV: | | 1 |
+------------+---------+------------------+-------------------------------+-----------+------+-----------+
mysql> select * from children ;
+--------+--------------+
> uri | childuri |
+--------+--------------+
> / | /actions |
> / | /users |
> /users | /users/root |
> /users | /users/guest |
> / | /test |
> /test | /test/file |
+--------+--------------+
mysql> select * from revisions;
+------------+-------------+-----------------+
> uri | isversioned | initialrevision |
+------------+-------------+-----------------+
> /test/file | 1 | 1.0 |
+------------+-------------+-----------------+
1 row in set (0.00 sec)
mysql> select * from latestrevisions;
+------------+------------+---------+
> uri | branchname | xnumber |
+------------+------------+---------+
> /test/file | main | 1.1 |
+------------+------------+---------+
1 row in set (0.00 sec)
["test.mysql.out" (test.mysql.out)]
21 Dec 2001 16:49:43 - org.apache.slide.common.Domain - INFO - Auto-Initializing \
Domain 21 Dec 2001 16:49:43 - org.apache.slide.common.Domain - INFO - Configuration \
resource : file:/home/leandro/cvs/jakarta-slide/build/classes/org/apache/slide/slide.properties
21 Dec 2001 16:49:44 - org.apache.slide.common.Domain - INFO - Configuration found \
in classpath 21 Dec 2001 16:49:44 - org.apache.slide.common.Domain - INFO - Domain \
configuration : {version=1.6, modified=no} 21 Dec 2001 16:49:44 - \
org.apache.slide.common.Domain - INFO - Domain configuration file : \
/home/leandro/cvs/jakarta-slide/build/examples/version/Domain.xml 21 Dec 2001 \
16:49:44 - org.apache.slide.common.Domain - INFO - Initializing Domain 21 Dec 2001 \
16:49:44 - org.apache.slide.common.Domain - INFO - Domain configuration : \
{version=1.6, modified=no} 21 Dec 2001 16:49:44 - org.apache.slide.common.Domain - \
INFO - Initializing namespace : version 21 Dec 2001 16:49:44 - \
org.apache.slide.common.Namespace - INFO - Loading namespace definition : version 21 \
Dec 2001 16:49:44 - org.apache.slide.common.Namespace - INFO - Loading store[memory] \
definition. storeClassName: org.apache.slide.store.StandardStore 21 Dec 2001 16:49:44 \
- org.apache.slide.common.Namespace - INFO - Node store: \
slidestore.reference.JDBCDescriptorsStore 21 Dec 2001 16:49:44 - \
org.apache.slide.common.Namespace - INFO - Revision descriptors store references \
nodestore 21 Dec 2001 16:49:44 - org.apache.slide.common.Namespace - INFO - Revision \
descriptor store references nodestore 21 Dec 2001 16:49:44 - \
org.apache.slide.common.Namespace - INFO - Content store: \
slidestore.reference.FileContentStore 21 Dec 2001 16:49:44 - \
org.apache.slide.common.Namespace - INFO - Registering Store memory of class class \
org.apache.slide.store.StandardStore with parameters {} on scope / 21 Dec 2001 \
16:49:44 - org.apache.slide.common.Namespace - INFO - Initializing Store \
memory(org.apache.slide.store.StandardStore) 21 Dec 2001 16:49:44 - \
slidestore.reference.JDBCDescriptorsStore - INFO - Loading and registering driver: \
org.gjt.mm.mysql.Driver 21 Dec 2001 16:49:44 - INFO - FileContentStore rootpath: \
/home/leandro/cvs/jakarta-slide/build/examples/version/. 21 Dec 2001 16:49:44 - INFO \
- FileContentStore rootpath: \
/home/leandro/cvs/jakarta-slide/build/examples/version/files 21 Dec 2001 16:49:44 - \
org.apache.slide.common.Namespace - INFO - Loading namespace version parameters 21 \
Dec 2001 16:49:44 - org.apache.slide.common.Namespace - INFO - Loading namespace \
version base data 21 Dec 2001 16:49:44 - slidestore.reference.JDBCDescriptorsStore - \
INFO - Connecting to "jdbc:mysql://localhost/slide" as user "slideuser" 21 Dec 2001 \
16:49:45 - org.apache.slide.common.Namespace - INFO - Init namespace version \
configuration 21 Dec 2001 16:49:45 - org.apache.slide.common.Namespace - INFO - \
Import data into namespace version 21 Dec 2001 16:49:45 - \
org.apache.slide.common.XMLUnmarshaller - INFO - Loading object / 21 Dec 2001 \
16:49:45 - org.apache.slide.common.XMLUnmarshaller - INFO - Loading object /test 21 \
Dec 2001 16:49:45 - org.apache.slide.common.XMLUnmarshaller - INFO - Loading object \
/users 21 Dec 2001 16:49:45 - org.apache.slide.common.XMLUnmarshaller - INFO - \
Loading object /users/root 21 Dec 2001 16:49:45 - \
org.apache.slide.common.XMLUnmarshaller - INFO - Loading object /users/guest 21 Dec \
2001 16:49:45 - org.apache.slide.common.XMLUnmarshaller - INFO - Loading object \
/actions 21 Dec 2001 16:49:45 - org.apache.slide.common.Namespace - INFO - Finish \
init namespace version configuration 21 Dec 2001 16:49:45 - \
org.apache.slide.common.Namespace - INFO - Loading namespace version configuration 21 \
Dec 2001 16:49:45 - org.apache.slide.common.Domain - INFO - Namespace configuration \
complete : version 21 Dec 2001 16:49:45 - org.apache.slide.common.Domain - INFO - \
Domain initialization complete 21 Dec 2001 16:49:45 - WARNING - WARNING: No active \
transaction 21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
21 Dec 2001 16:49:45 - WARNING - WARNING: No active transaction
Closing data sources
21 Dec 2001 16:49:45 - org.apache.slide.common.Namespace - INFO - Shutting down \
service memory(org.apache.slide.store.StandardStore) 21 Dec 2001 16:49:45 - \
slidestore.reference.JDBCDescriptorsStore - INFO - Disconnecting from \
"jdbc:mysql://localhost/slide" as user "slideuser" \
connection[org.gjt.mm.mysql.jdbc2.Connection@21409a9]
--
To unsubscribe, e-mail: <mailto:slide-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:slide-dev-help@jakarta.apache.org>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic