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 Dirk Verbeeck <di...@pandora.be> on 2001/12/02 16:49:31 UTC
Re: Sybase again
Hi
Can you test if the insert statement in the reference implementation
works with sybase ?
Just make a simple test program with the code from
JDBCContentStore::storeContent.
PreparedStatement insertStatement = connection.prepareStatement
("insert into revisioncontent values(?, ?, ?)");
insertStatement.setString(1, revisionUri);
insertStatement.setString(2, revisionNumber);
InputStream is = ...
int contentLength = ...
insertStatement.setBinaryStream(3, is, contentLength);
insertStatement.executeUpdate();
Maybe you can find an sybase example that works.
Dirk
Tina Yang wrote:
>
> 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: <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>