Hello Sliders,
I'm still stuck with my problem of using Sybase with Slide. When slide
is initialized everything works fine. Users and other nodes from
Domain.xml are stored in my database without problems. But when I want
to create new content (versioned) nothing is stored. When debugging the
app I can see that there seems to be a problem with transactions but I
don't know what is wrong.
The same app works fine with hSQL. What's the difference????
Thanx,
Tina.
PS: I'm using Tomcat4.0 and Slide 1.0.16
PPS: the SQL code for creating the tables in Sybase are included as well
as my Domain.xml
<?xml version="1.0"?>
<slide logger="org.apache.slide.util.logger.SimpleLogger" logger-level="7" default="slide">
<namespace name="slide">
<definition>
<store name="jdbc">
<nodestore classname="slidestore.reference.JDBCDescriptorsStore">
<parameter name="driver">com.sybase.jdbc2.jdbc.SybDriver</parameter>
<parameter name="url">jdbc:sybase:Tds:siegfried:4000</parameter>
<parameter name="user">wm_slide</parameter>
<parameter name="password">wm_slide</parameter>
<parameter name="jdbcversion">2</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.reference.JDBCContentStore">
<parameter name="driver">com.sybase.jdbc2.jdbc.SybDriver</parameter>
<parameter name="url">jdbc:sybase:Tds:siegfried:4000</parameter>
<parameter name="user">wm_slide</parameter>
<parameter name="password">wm_slide</parameter>
<parameter name="jdbcversion">2</parameter>
</contentstore>
</store>
<scope match="/" store="jdbc"/>
</definition>
<configuration>
<default-action>/actions</default-action>
<userspath>/users</userspath>
<parameter name="dav">true</parameter>
<parameter name="standalone">true</parameter>
</configuration>
<data>
<objectnode classname="org.apache.slide.structure.SubjectNode" uri="/">
<permission action="/actions" subject="/users/root"/>
<permission action="/actions" subject="/users/tina"/>
<!-- /users represents the unauthenticated user -->
<objectnode classname="org.apache.slide.structure.SubjectNode" uri="/users">
<!-- /users/root represents the administrator -->
<objectnode classname="org.apache.slide.structure.SubjectNode" uri="/users/root">
<revision>
<property name="password">root</property>
</revision>
</objectnode>
<!-- /users/tina represents a user -->
<objectnode classname="org.apache.slide.structure.SubjectNode" uri="/users/tina">
<revision>
<property name="password">tina</property>
</revision>
</objectnode>
</objectnode>
<objectnode classname="org.apache.slide.structure.ActionNode" uri="/actions">
<objectnode classname="org.apache.slide.structure.ActionNode" uri="/actions/read"/>
<objectnode classname="org.apache.slide.structure.ActionNode" uri="/actions/write"/>
<objectnode classname="org.apache.slide.structure.ActionNode" uri="/actions/manage"/>
</objectnode>
<objectnode classname="org.apache.slide.structure.SubjectNode" uri="/templates">
<permission action="/actions" subject="/users"/>
<permission action="/actions/read" subject="/users"/>
<permission action="/actions/manage" subject="/users"/>
<permission action="/actions/write" subject="/users"/>
</objectnode>
</objectnode>
</data>
</namespace>
</slide>
create table objects(uri varchar(255) not null primary key, classname text null)
create table children(uri varchar(255) not null, childuri varchar(255) not null)
create table links(link varchar(255) not null, linkto varchar(255) not null)
create table permissions(object varchar(255) not null, revisionnumber varchar(20)
null,
subject varchar(255) not null, action varchar(255) not null, inheritable int null,
negative int null)
create table locks(id varchar(255) not null, object varchar(255) not null, subject
varchar(255) not null, type varchar(255) not null,
expirationdate varchar(15) null, inheritable int null, xexclusive int null)
create table revisions(uri varchar(255) not null primary key, isversioned int null,
initialrevision varchar(10) null)
create table workingrevision(uri varchar(255) not null, baserevision varchar(20) null,
xnumber
varchar(20) null)
create table latestrevisions(uri varchar(255) not null, branchname text null, xnumber
varchar(20) null)
create table branches(uri varchar(255) not null, xnumber varchar(20) null, childnumber
varchar(20) null)
create table revision(uri varchar(255) not null, xnumber varchar(20) null, branchname
text null)
create table label(uri varchar(255) not null, xnumber varchar(20) null, label text
null)
create table property(uri varchar(255) not null, xnumber varchar(20) null, name text
null, value
text null, namespace text null, type varchar(100) null, protected int null)
create table revisioncontent(uri varchar(255) not null, xnumber varchar(20) null,
content image null)
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
