You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by senthilkumar sivanandam <kr...@yahoo.com> on 2006/09/18 18:24:50 UTC

Re : ERROR - failed to write node state

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 

Re: Re : ERROR - failed to write node state

Posted by Stefan Guggisberg <st...@gmail.com>.
senthilkumar,

thomas is right, you forgot to specify the correct schema type in
your configuration. here's a sample configuration for mssql
(see http://jackrabbit.apache.org/api-1/org/apache/jackrabbit/core/state/db/SimpleDbPersistenceManager.html):

  <PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
       <param name="driver"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
       <param name="url"
value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=test;SelectMethod=Cursor;"/>
       <param name="schema" value="mssql"/>
       <param name="user" value="sa"/>
       <param name="password" value=""/>
       <param name="schemaObjectPrefix" value="${wsp.name}_"/>
       <param name="externalBLOBs" value="false"/>
   </PersistenceManager>

cheers
stefan

On 9/19/06, Thomas Mueller <th...@gmail.com> wrote:
> Hi,
>
> I had a similar problem with MS SQL Server a few weeks ago, the
> problem was that the tables where created with VARCHAR / VARBINARY
> length 1 (instead of 255 or whatever the correct length is). Could you
> check in the schema if the tables are created in this way. I think
> what happened in my case was that the schema for HSQLDB was used,
> where it says CREATE TABLE ... ( ... VARCHAR, ...). Just VARCHAR means
> VARCHAR(unlimited) for HSQLDB, but it means VARCHAR(1) for MS SQL
> Server. Anyway, what I did was, I created the tables manually. At that
> time I thought it was a configuration mistake on my side, and didn't
> really investigate any further... I used the 'official' MS SQL JDBC
> Driver by the way.
>
> Thomas
>
>
> > > I am using Microsoft SQL Server  2000 - 8.00.194
> > > ERROR - failed to write node state:
> > > deadbeef-face-babe-cafe-babecafebabe
> > > java.sql.DataTruncation: Data truncation
> > > net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
>

Re: Re : ERROR - failed to write node state

Posted by Thomas Mueller <th...@gmail.com>.
Hi,

I had a similar problem with MS SQL Server a few weeks ago, the
problem was that the tables where created with VARCHAR / VARBINARY
length 1 (instead of 255 or whatever the correct length is). Could you
check in the schema if the tables are created in this way. I think
what happened in my case was that the schema for HSQLDB was used,
where it says CREATE TABLE ... ( ... VARCHAR, ...). Just VARCHAR means
VARCHAR(unlimited) for HSQLDB, but it means VARCHAR(1) for MS SQL
Server. Anyway, what I did was, I created the tables manually. At that
time I thought it was a configuration mistake on my side, and didn't
really investigate any further... I used the 'official' MS SQL JDBC
Driver by the way.

Thomas


> > I am using Microsoft SQL Server  2000 - 8.00.194
> > ERROR - failed to write node state:
> > deadbeef-face-babe-cafe-babecafebabe
> > java.sql.DataTruncation: Data truncation
> > net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)

Re: Re : ERROR - failed to write node state

Posted by Stefan Guggisberg <st...@gmail.com>.
could be a driver-related issue. did you also test with the
microsoft jdbc driver?

cheers
stefan

On 9/18/06, senthilkumar sivanandam <kr...@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
>

Re: Re : ERROR - failed to write node state

Posted by Stefan Guggisberg <st...@gmail.com>.
fyi:  node_id char(36) is correct; your problem was that you didn't
specify the mssql schema in your configuration.

cheers
stefan

On 9/19/06, senthilkumar sivanandam <kr...@yahoo.com> wrote:
> Thank you all. It worked after changing the driver and
> modifying the ddl as below. Orignally node_id was char
> 36 and I changed to char(255)
>
> create table NODE (NODE_ID char(255) not null,
> NODE_DATA image not null)
> create unique index NODE_IDX on NODE (NODE_ID)
> create table PROP (PROP_ID varchar(1024) not null,
> PROP_DATA image not null)
> create unique index PROP_IDX on PROP (PROP_ID)
> create table REFS (NODE_ID char(255) not null,
> REFS_DATA image not null)
> create unique index REFS_IDX on REFS (NODE_ID)
> create table BINVAL (BINVAL_ID varchar(1024) not null,
> BINVAL_DATA image not null)
> create unique index BINVAL_IDX on BINVAL (BINVAL_ID)
>
>
> --- senthilkumar sivanandam <kr...@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
> >               -->
> >
> === message truncated ===
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

Re: Re : ERROR - failed to write node state

Posted by senthilkumar sivanandam <kr...@yahoo.com>.
Thank you all. It worked after changing the driver and
modifying the ddl as below. Orignally node_id was char
36 and I changed to char(255)

create table NODE (NODE_ID char(255) not null,
NODE_DATA image not null)
create unique index NODE_IDX on NODE (NODE_ID)
create table PROP (PROP_ID varchar(1024) not null,
PROP_DATA image not null)
create unique index PROP_IDX on PROP (PROP_ID)
create table REFS (NODE_ID char(255) not null,
REFS_DATA image not null)
create unique index REFS_IDX on REFS (NODE_ID)
create table BINVAL (BINVAL_ID varchar(1024) not null,
BINVAL_DATA image not null)
create unique index BINVAL_IDX on BINVAL (BINVAL_ID)


--- senthilkumar sivanandam <kr...@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
> 		-->
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com