Return-Path: 
 <dev-return-8862-apmail-jackrabbit-dev-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org
Received: (qmail 89623 invoked from network); 19 Sep 2006 12:55:23 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Sep 2006 12:55:23 -0000
Received: (qmail 46475 invoked by uid 500); 19 Sep 2006 12:55:21 -0000
Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org
Received: (qmail 46447 invoked by uid 500); 19 Sep 2006 12:55:21 -0000
Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:dev@jackrabbit.apache.org>
List-Id: <dev.jackrabbit.apache.org>
Reply-To: dev@jackrabbit.apache.org
Delivered-To: mailing list dev@jackrabbit.apache.org
Received: (qmail 46438 invoked by uid 99); 19 Sep 2006 12:55:21 -0000
Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org)
 (140.211.166.84)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Sep 2006 05:55:21 -0700
Authentication-Results: idunn.apache.osuosl.org
 header.from=stefan.guggisberg@gmail.com; domainkeys=good
X-ASF-Spam-Status: No,
 hits=0.4 required=5.0 tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP
DomainKey-Status: good
X-DomainKeys: Ecelerity dk_validate implementing
 draft-delany-domainkeys-base-01
Received: from ([64.233.162.198:49344] helo=nz-out-0102.google.com)
	by idunn.apache.osuosl.org (ecelerity 2.1 r(10620)) with ESMTP
	id 51/F0-27824-3B8EF054 for <dev@jackrabbit.apache.org>;
 Tue, 19 Sep 2006 05:55:16 -0700
Received: by nz-out-0102.google.com with SMTP id z3so1697473nzf
        for <dev@jackrabbit.apache.org>; Tue, 19 Sep 2006 05:55:13 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=JE/9rCuDyMvNAyTSOXf047W+PJBtSYqDbp0HwnOYOojOWh7W3EasqoFYWfWytcM4SQ9lWqlB7KSc1Z3X1EJwKG9gMH+ekftcToeU+N/vWoJvWA7OYnR9M5F8l7tLKpt7ZXICBjhOz7fhmRYjEFIi8hzg6eoTUEI6DfX7bdTp65I=
Received: by 10.64.209.6 with SMTP id h6mr14460173qbg;
        Tue, 19 Sep 2006 05:55:13 -0700 (PDT)
Received: by 10.64.48.4 with HTTP; Tue, 19 Sep 2006 05:55:12 -0700 (PDT)
Message-ID: <90a8d1c00609190555g6ad743fbx18d87e9d8705b89c@mail.gmail.com>
Date: Tue, 19 Sep 2006 14:55:12 +0200
From: "Stefan Guggisberg" <stefan.guggisberg@gmail.com>
To: dev@jackrabbit.apache.org
Subject: Re: Re : ERROR - failed to write node state
In-Reply-To: <20060918162451.35318.qmail@web54704.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20060918162451.35318.qmail@web54704.mail.yahoo.com>
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

could be a driver-related issue. did you also test with the
microsoft jdbc driver?

cheers
stefan

On 9/18/06, senthilkumar sivanandam <krsenthil@yahoo.com> wrote:
> Hi,
>
> I am using Microsoft SQL Server  2000 - 8.00.194
> Service Pack 2 and trying to setup repository. I am
> getting the below exception and not sure what is
> wrong.
>
>
> Here is the debug info.
>
> DEBUG - Initializing transient repository
> INFO - Starting repository...
> INFO - LocalFileSystem initialized at path
> c:\temp\myrepo\repository
> DEBUG - node type
> '{http://www.jcp.org/jcr/nt/1.0}base' is already
> contained.
> DEBUG - node type
> '{http://www.jcp.org/jcr/mix/1.0}referenceable' is
> already contained.
> DEBUG - node type
> '{http://www.jcp.org/jcr/nt/1.0}base' is already
> contained.
> DEBUG - node type
> '{http://www.jcp.org/jcr/nt/1.0}unstructured' is
> already contained.
> INFO - no custom node type definitions found
> INFO - LocalFileSystem initialized at path
> c:\temp\myrepo\version
> INFO - LocalFileSystem initialized at path
> c:\temp\myrepo\version\blobs
> ERROR - failed to write node state:
> deadbeef-face-babe-cafe-babecafebabe
> java.sql.DataTruncation: Data truncation
>         at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
>         at
> net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
>         at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
>         at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:471)
>         at
> org.apache.jackrabbit.core.state.AbstractPersistenceManager.store(AbstractPersistenceManager.java:67)
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:332)
>         at
> org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:154)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:306)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:245)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:498)
>         at
> org.apache.jackrabbit.core.TransientRepository$1.getRepository(TransientRepository.java:186)
>         at
> org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265)
>         at
> org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333)
>         at
> org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363)
>         at Secondhop.main(Secondhop.java:19)
> javax.jcr.RepositoryException: failed to write node
> state: deadbeef-face-babe-cafe-babecafebabe: failed to
> write node state: deadbeef-face-babe-cafe-babecafebabe
>         at
> org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:169)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:306)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:245)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:498)
>         at
> org.apache.jackrabbit.core.TransientRepository$1.getRepository(TransientRepository.java:186)
>         at
> org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265)
>         at
> org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333)
>         at
> org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363)
>         at Secondhop.main(Secondhop.java:19)
> Caused by:
> org.apache.jackrabbit.core.state.ItemStateException:
> failed to write node state:
> deadbeef-face-babe-cafe-babecafebabe
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:478)
>         at
> org.apache.jackrabbit.core.state.AbstractPersistenceManager.store(AbstractPersistenceManager.java:67)
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:332)
>         at
> org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:154)
>         ... 8 more
> Caused by: java.sql.DataTruncation: Data truncation
>         at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
>         at
> net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
>         at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
>         at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:471)
>         ... 11 more
> org.apache.jackrabbit.core.state.ItemStateException:
> failed to write node state:
> deadbeef-face-babe-cafe-babecafebabe
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:478)
>         at
> org.apache.jackrabbit.core.state.AbstractPersistenceManager.store(AbstractPersistenceManager.java:67)
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:332)
>         at
> org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:154)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:306)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:245)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:498)
>         at
> org.apache.jackrabbit.core.TransientRepository$1.getRepository(TransientRepository.java:186)
>         at
> org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265)
>         at
> org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333)
>         at
> org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363)
>         at Secondhop.main(Secondhop.java:19)
> Caused by: java.sql.DataTruncation: Data truncation
>         at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
>         at
> net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
>         at
> net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
>         at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
>         at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
>         at
> org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:471)
>         ... 11 more
> Exception in thread "main"
>
>
>
> ****************************************************
>
> Here is my repository.xml
>
>
> <Repository>
>         <!--
>                 virtual file system where the repository stores
> global state
>                 (e.g. registered namespaces, custom node types,
> etc.)
>         -->
>         <FileSystem
>
> class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
>                 <param name="path" value="${rep.home}/repository" />
>         </FileSystem>
>
>         <!--
>                 security configuration
>         -->
>         <Security appName="Jackrabbit">
>                 <!--
>                         access manager:
>                         class: FQN of class implementing the AccessManager
> interface
>                 -->
>                 <AccessManager
>
> class="org.apache.jackrabbit.core.security.SimpleAccessManager">
>                         <!-- <param name="config"
> value="${rep.home}/access.xml"/> -->
>                 </AccessManager>
>
>                 <LoginModule
>
> class="org.apache.jackrabbit.core.security.SimpleLoginModule">
>                         <!-- anonymous user name ('anonymous' is the
> default value) -->
>                         <param name="anonymousId" value="anonymous" />
>                         <!--
>                                 default user name to be used instead of the
> anonymous user
>                                 when no login credentials are provided (unset by
> default)
>                         -->
>                         <!-- <param name="defaultUserId"
> value="superuser"/> -->
>                 </LoginModule>
>         </Security>
>
>         <!--
>                 location of workspaces root directory and name of
> default workspace
>         -->
>         <Workspaces rootPath="${rep.home}/workspaces"
>                 defaultWorkspace="default" />
>         <!--
>                 workspace configuration template:
>                 used to create the initial workspace if there's no
> workspace yet
>         -->
>         <Workspace name="${wsp.name}">
>                 <!--
>                         virtual file system of the workspace:
>                         class: FQN of class implementing the FileSystem
> interface
>                 -->
>                 <FileSystem
>
> class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
>                         <param name="path" value="${wsp.home}" />
>                 </FileSystem>
>                 <!--
>                         persistence manager of the workspace:
>                         class: FQN of class implementing the
> PersistenceManager interface
>                 -->
>                 <PersistenceManager
>
> class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
>                         <param name="driver"
>                                 value="net.sourceforge.jtds.jdbc.Driver" />
>                         <param name="url"
>                                 value="jdbc:jtds:sqlserver://127.0.0.1:1433/jcr"
> />
>                         <param name="user" value="sa" />
>                         <param name="password" value="dragon" />
>                         <param name="externalBLOBs" value="true" />
>                 </PersistenceManager>
>                 <!--
>                         Search index and the file system it uses.
>                         class: FQN of class implementing the QueryHandler
> interface
>                 -->
>                 <SearchIndex
>
> class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
>                         <param name="path" value="${wsp.home}/index" />
>                 </SearchIndex>
>         </Workspace>
>
>         <!--
>                 Configures the versioning
>         -->
>         <Versioning rootPath="${rep.home}/version">
>                 <!--
>                         Configures the filesystem to use for versioning for
> the respective
>                         persistence manager
>                 -->
>                 <FileSystem
>
> class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
>                         <param name="path" value="${rep.home}/version" />
>                 </FileSystem>
>
>                 <!--
>                         Configures the persistence manager to be used for
> persisting version state.
>                         Please note that the current versioning
> implementation is based on
>                         a 'normal' persistence manager, but this could
> change in future
>                         implementations.
>                 -->
>                 <PersistenceManager
>
> class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
>                         <param name="driver"
>                                 value="net.sourceforge.jtds.jdbc.Driver" />
>                         <param name="url"
>                                 value="jdbc:jtds:sqlserver://127.0.0.1:1433/jcr"
> />
>                         <param name="externalBLOBs" value="true" />
>                 </PersistenceManager>
>
>         </Versioning>
>
>         <!--
>                 Search index for content that is shared repository
> wide
>                 (/jcr:system tree, contains mainly versions)
>         -->
>         <SearchIndex
>
> class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
>                 <param name="path"
> value="${rep.home}/repository/index" />
>         </SearchIndex>
> </Repository>
>
>
>
>
> ***************************************************
>
> Here is my code
>
>
> RepositoryConfig conf = RepositoryConfig
>                                 .create(
>                                                 "C:\\repository.xml",
>                                                 "c:\\temp\\myrepo");
>
>                 Repository repository = new
> TransientRepository(conf);
>
>                 Session session = repository.login(new
> SimpleCredentials("username",
>                                 "password".toCharArray()));
>
>                 try {
>                         Node root = session.getRootNode();
>
>                         // Store content
> /*                      Node hello = root.addNode("hello");
>                         Node world = hello.addNode("world");
>                         world.setProperty("message", "Hello, World!");
>                         session.save();
>
>                         // Retrieve content
>                         Node node = root.getNode("hello/world");
>                         System.out.println(node.getPath());
>
> System.out.println(node.getProperty("message").getString());*/
>
>                         // Remove content
>                         root.getNode("hello").remove();
>                         //root.getNode("1002-1151597096759").remove();
>                         session.save();
>                 } finally {
>                         session.logout();
>                 }
>
> Please help me!
>
> Thank you,
>
>
>
> Senthilkumar Sivanandam,
> 2540, Rosehall lane,
> Aurora, IL-60504
> Res  No : 630 851 8693
> Cell No : 847 722 4843
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>