[xwiki-users] Anyone is successful when he install xwiki on Oracle 9i?

[Vincent Massol]

AFAIK we don't support Oracle 9i out of the box, only 10g. It doesn't  
mean it's not possible to find a good HBM config for it, just that we  
haven't done it as part of the XWiki project (if you check xwiki.org  
you'll see a  config for 10g only).

-Vincent

On Feb 21, 2008, at 3:27 PM, Sergiu Dumitriu wrote:

> Hi,
>
> Did you properly configure the hibernate configuration file?
> hibernate.cfg.xml
> The distributed file uses the hibernate 10g Dialect.
>
> Liu Aijun wrote:
>> Anyone is successful when install on Oracle 9i?
>>
>> I searched this maillist,and tryed several solution, but I failed  
>> runing
>> xwiki with Oracle 9i.
>>
>> Are there any new solutions? =========================
>> I have tryed two version:
>> xwiki 1.2.2    and   xwiki 1.3m2.
>> Oracle 9.2.x.x , Oracle JDBC driver version:Oracle 10.0.1.0
>>
>> Error Message:
>> Error number 3201 in 3: Exception while saving document Main.WebHome
>> Wrapped Exception: could not update:
>> [com 
>> .xpn 
>> .xwiki 
>> .doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2] 
>> {docId=-114121954,
>> version2=1, version1=1}]
>> com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
>> saving document Main.WebHome
>> Wrapped Exception: could not update:
>> [com 
>> .xpn 
>> .xwiki 
>> .doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2] 
>> {docId=-114121954,
>> version2=1, version1=1}]
>>    at
>> com 
>> .xpn 
>> .xwiki 
>> .store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:455)
>>
>>
>>    at
>> com 
>> .xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java: 
>> 97)
>>    at
>> com 
>> .xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java: 
>> 91)
>>    at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1077)
>>    at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:120)
>>    at
>> com 
>> .xpn 
>> .xwiki.web.SaveAndContinueAction.action(SaveAndContinueAction.java: 
>> 64)
>>
>>
>>    at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:187)
>>    at
>> org 
>> .apache 
>> .struts 
>> .action.RequestProcessor.processActionPerform(RequestProcessor.java: 
>> 431)
>>
>>
>>    at
>> org 
>> .apache 
>> .struts.action.RequestProcessor.process(RequestProcessor.java:236)
>>
>>
>>    at
>> org.apache.struts.action.ActionServlet.process(ActionServlet.java: 
>> 1196)
>>    at
>> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
>>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>>    at
>> org 
>> .apache 
>> .catalina 
>> .core 
>> .ApplicationFilterChain 
>> .internalDoFilter(ApplicationFilterChain.java:290)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina 
>> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
>> 206)
>>
>>
>>    at
>> com 
>> .xpn 
>> .xwiki 
>> .web 
>> .SetCharacterEncodingFilter 
>> .doFilter(SetCharacterEncodingFilter.java:117)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina 
>> .core 
>> .ApplicationFilterChain 
>> .internalDoFilter(ApplicationFilterChain.java:235)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina 
>> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
>> 206)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina 
>> .core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina 
>> .core.StandardContextValve.invoke(StandardContextValve.java:175)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>>
>>
>>    at
>> org 
>> .apache 
>> .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
>> 109)
>>
>>
>>    at
>> org 
>> .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
>> 263)
>>    at
>> org 
>> .apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
>> 844)
>>    at
>> org.apache.coyote.http11.Http11Protocol 
>> $Http11ConnectionHandler.process(Http11Protocol.java:584)
>>
>>
>>    at
>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 
>> 447)
>>    at java.lang.Thread.run(Thread.java:619)
>>
>>
>> Wrapped Exception:
>>
>> java.sql.SQLException: ORA-01483: DATE »ò NUMBER ¸³Öµ±äÁ¿µÄ³¤¶ÈÎÞЧ
>>
>>    at
>> oracle 
>> .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
>>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>>    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
>>    at
>> oracle 
>> .jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java: 
>> 213)
>>
>>
>>    at
>> oracle 
>> .jdbc 
>> .driver 
>> .T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1117)
>>
>>
>>    at
>> oracle 
>> .jdbc 
>> .driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java: 
>> 1270)
>>
>>
>>    at
>> oracle 
>> .jdbc 
>> .driver 
>> .OraclePreparedStatement 
>> .executeInternal(OraclePreparedStatement.java:3415)
>>
>>
>>    at
>> oracle 
>> .jdbc 
>> .driver 
>> .OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java: 
>> 3498)
>>
>>
>>    at
>> org 
>> .apache 
>> .commons 
>> .dbcp 
>> .DelegatingPreparedStatement 
>> .executeUpdate(DelegatingPreparedStatement.java:101)
>>
>>
>
> -- 
> Sergiu Dumitriu
> http://purl.org/net/sergiu/
> _______________________________________________
> users mailing list
> users at xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users