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(a)xwiki.org
 
http://lists.xwiki.org/mailman/listinfo/users