Hi Brian,

On Jun 7, 2007, at 3:42 AM, Brian J. Sayatovic wrote:

Ah, that helped a bunch!  Now I can get in and start to do stuff.  But, creating a user failed.  I think I can follow the pattern of your fix and fix it locally...

I've just tried it here and it worked fine. Here's what I've done:

1) configure xwiki to use derby
2) start xwiki (thus with an empty Derby DB)
3) load the default xwiki XAR
4) go to the register page (http://localhost:8080/xwiki/bin/register/XWiki/Register) and create a user

Is that what you've done too?

Thanks
-Vincent


Wrapped Exception:

SQL Exception: An attempt was made to get a data value of type 'CLOB' from a data value of type 'VARCHAR'.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setNull(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:104)
	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:75)
	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:58)
	at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1826)
	at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1803)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2059)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:573)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:547)
	at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:309)
	at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:100)
	at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:94)
	at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:914)
	at com.xpn.xwiki.XWiki.createUser(XWiki.java:2762)
	...

Regards,
Brian.

Vincent Massol wrote:
Hi Brian, 

I know what's wrong. We've changed the database model a bit in 1.1 (we've added a comment field) so as you're using 1.0 the XWikiDocument class doesn't have the getter/setter for comments.

+        <property name="comment" type="string">
+            <column name="XWD_COMMENT" length="1023" not-null="true" />
+        </property>

I've uploaded a fixed HBM file on 
http://www.xwiki.org/xwiki/bin/view/AdminGuide/InstallationDerby

Sorry about that
-Vincent


On Jun 5, 2007, at 3:57 AM, Brian J. Sayatovic wrote:

I tried the XML file you provided in the linked page.  I got past where I was stuck before, but now got this:

org.hibernate.PropertyNotFoundException: Could not find a getter for comment in class com.xpn.xwiki.doc.XWikiDocument
    at org.hibernate.property.BasicPropertyAccessor.createGetter(BasicPropertyAccessor.java:282)
    at org.hibernate.property.BasicPropertyAccessor.getGetter(BasicPropertyAccessor.java:275)
    at org.hibernate.mapping.Property.getGetter(Property.java:251)
    at org.hibernate.tuple.PojoEntityTuplizer.buildPropertyGetter(PojoEntityTuplizer.java:255)
    at org.hibernate.tuple.AbstractEntityTuplizer.<init>(AbstractEntityTuplizer.java:121)
    at org.hibernate.tuple.PojoEntityTuplizer.<init>(PojoEntityTuplizer.java:55)
    at org.hibernate.tuple.TuplizerLookup.create(TuplizerLookup.java:64)
    at org.hibernate.tuple.EntityMetamodel.<init>(EntityMetamodel.java:257)
    at org.hibernate.persister.entity.AbstractEntityPersister.<init>(AbstractEntityPersister.java:412)
    at org.hibernate.persister.entity.SingleTableEntityPersister.<init>(SingleTableEntityPersister.java:108)
    at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:55)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:215)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
    at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:134)
    at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:389)
    at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:342)
    at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:160)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:936)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:970)
    at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:2179)
    at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:675)
    at com.xpn.xwiki.XWiki.<init>(XWiki.java:567)
    at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:282)
    at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:383)
    at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
    at ...
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Unknown Source)

This is using XWiki 1.0.

Did you encounter this along the way?

Regards,
Brian.

Vincent Massol wrote:
FWIW I've succeeded in running XWiki on Derby and I have created this page to document it:
http://www.xwiki.org/xwiki/bin/view/AdminGuide/InstallationDerby

-Vincent