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