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
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);
}
}
}
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> 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)
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:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
