Re: [xwiki-users] Derby support working

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...

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.performExecution s(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 >>>