[xwiki-users] Derby support working
Brian J. Sayatovic
trin-xwiki-users at trinition.org
Thu Jun 14 03:44:59 CEST 2007
I upgraded to Derby 10.2.2.0 and it worked (still with XWiki 1.1-M1... I
dare not rollback!)
Regards,
Brian.
Brian J. Sayatovic wrote:
> OK, I re-tried with XWiki 1.0 and got the same results. Frustrated,
> I've move to XWiki 1.1-M1. I downloaded the mapping file for 1.1M1
> from that same page and deployed it. I got the same type of exception:
>
> Error number 8002 in 8: Cannot create user XWiki.TestUser
> Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.TestUser
> Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDocument]
> com.xpn.xwiki.XWikiException: Error number 8002 in 8: Cannot create user XWiki.TestUser
> Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.TestUser
> Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDocument]
> at com.xpn.xwiki.XWiki.createUser(XWiki.java:2827)
> at com.xpn.xwiki.XWiki.createUser(XWiki.java:2601)
> at com.xpn.xwiki.XWiki.createUser(XWiki.java:2509)
> at com.xpn.xwiki.web.RegisterAction.action(RegisterAction.java:44)
> ... snip ...
> 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)
>
>
> I'm not giving up, but I'm at least convinced that its not specific to
> 1.0, but specific to something I'm doing.
>
> The exception would lead me to believe its still a CLOB/VARCHAR
> mismatch, but I even checked the mapping file myself and saw no
> VARCHARs left.
>
> Is there a specific version of Derby I need? I'm using 10.1.2.0.
>
> Regards,
> Brian.
>
> P.S. I just realized I never did the "load default XAR" step, will try
> that...
>
> Vincent Massol wrote:
>> 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
>>>>> <http://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
>>>>>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> --
>> You receive this message as a subscriber of the xwiki-users at objectweb.org mailing list.
>> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
>> For general help: mailto:sympa at objectweb.org?subject=help
>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the xwiki-users at objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xwiki.org/pipermail/users/attachments/20070613/1b76c2dd/attachment.htm
More information about the users
mailing list