[xwiki-users] ORA-01483: invalid length for DATE or NUMBER bind variable
We are using XE 1.3 from the war and have been building our XWiki
successfully until today. We are hooked up to Oracle 10g and have been able
to create content, add users, and get notices from watch jobs, so it seemed
to be working fine.
Today we started getting errors on adding content. First on trying to
upload the mindmap.xar and then on creating a blog entry and finally on
creating a new comment.
All threw different Exceptions, but all had one root cause.
ORA-01483: invalid length for DATE or NUMBER bind variable
Here is one stack trace...
Error number 3201 in 3: Exception while saving document SaaS Engine
Road Map.ODGB
Wrapped Exception: Error number 13012 in 3: Exception while saving links
Wrapped Exception: could not update:
[com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{version2=2,
docId=153092, version1=5}]
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving
document SaaS Engine Road Map.ODGB
Wrapped Exception: Error number 13012 in 3: Exception while saving links
Wrapped Exception: could not update:
[com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{version2=2,
docId=153092, version1=5}]
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:457)
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:1078)
at
com.xpn.xwiki.web.CommentAddAction.action(CommentAddAction.java:61)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
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:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
com.xpn.xwiki.XWikiException: Error number 13012 in 3: Exception while
saving links
Wrapped Exception: could not update:
[com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{version2=2,
docId=153092, version1=5}]
at
com.xpn.xwiki.store.XWikiHibernateStore.saveLinks(XWikiHibernateStore.java:1657)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:443)
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:1078)
at
com.xpn.xwiki.web.CommentAddAction.action(CommentAddAction.java:61)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
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
[xwiki-users] Attachment Store Location
Hi guys, As I understand from the archive, attachments are stored in the DB itself, is that correct? That's not very handy for my personal use. I have written an automated backup bash-script, which dumps all DB's from my MySQL-installation into a backup folder and store it there (a daily folder with the last 7 dumps, a weekly folder and a monthly) and pushes once a night the backup folder to a backup-server. Now if every attachment is stored into the DB, the DB will grow extensively (versioning?, picture album), while with an ordinary file-store system you just backup files, who have changed or are newin my use scenario, attachments are way more stable than the actual content in the XWiki... Out of curiosity, what's exactly the benefit to store files in a DB? For the XWiki, is that the way you go or are you planning to implement a choice? Thanks! ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Attachment Store Location
Hi Squirrel, Squirrel wrote: Hi guys, As I understand from the archive, attachments are stored in the DB itself, is that correct? Yeap. That's not very handy for my personal use. I have written an automated backup bash-script, which dumps all DB's from my MySQL-installation into a backup folder and store it there (a daily folder with the last 7 dumps, a weekly folder and a monthly) and pushes once a night the backup folder to a backup-server. Now if every attachment is stored into the DB, the DB will grow extensively (versioning?, picture album), while with an ordinary file-store system you just backup files, who have changed or are newin my use scenario, attachments are way more stable than the actual content in the XWiki... Out of curiosity, what's exactly the benefit to store files in a DB? For the XWiki, is that the way you go or are you planning to implement a choice? Well, obviously I am not a XWiki guru, but it seems to me that it was, and in fact it is, a good idea to have a single access control system. If you have the whole system in a database, you have not to be concerned about how to control access to other repositories. And at at the same time, to have the whole thing in a single database gives, at least to me, an feeling of full control about what is going on with the contents I've to manage. Other idea: you easy can index and search the whole content with a single search engine. And control access to the results! But, as you says, there are a number of problems with this approach. I am sure this thread will be useful for you... http://www.nabble.com/Xwiki-file-and-attachment-storage-td11991466.html#a11991466 And as a last minute entry, see this... http://dev.xwiki.org/xwiki/bin/view/GoogleSummerOfCode/WebDAVApi2008 Hope this helps, Ricardo -- Ricardo RodrÃguez Your EPEC Network ICT Team ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Privileges on Oracle database
In single wiki mode (XWiki Enterprise) it will need read, write to the minimum if you pre create the schema from an existing one. If not you you will need schema read and write. I don't know which oracle privileges that is. Run it once with all privileges to get the database created in one oracle instance. Import that DB in your corporate database. Deactivate updateschema in xwiki.cfg. Then give the oracle privileges one by one. In multiwiki (XEM) the xwiki user needs to be a DBA to be able to create new users. Ludovic Anders Andersson wrote: Hello! I have a question regarding the installation of XWiki. In the installation instructions it says I must type these commands: connect ... create user xwiki identified by xwiki; grant all privileges to xwiki; However this wiki will be installed on a corporate network on their database and application servers and therefor not possible to grant all privileges to xwiki. I wonder if it is possible to run the wiki with more restrictions on the user xwiki? Which privileges is enough for xwiki to operate on the database correctly? Thanks for your time and patients. I will be happy to hear from you again Anders Andersson ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Making the date property the current date as a default
In the field, check the box Empty is today and this should work Ludovic Hosam Hassan wrote: Hello all, I am doing something similar to the TODO application here http://www.theserverside.com/tt/articles/article.tss?l=XWiki What I want to do is to have a submission date of the TODO which will be the current date so the field is disabled for the user and once he add a TODO the date will be the submission date. I installed already the JodaTimePlugin just I don't know how to make that default field. Thanks in advance Cheers, Hosam ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Synchronize two instances of XWiki Enterprise
This is complex if the 2 wikis can be edited at the same time. This is what XWiki Concerto is about http://concerto.xwiki.com (see video here http://tinyurl.com/2b8bgv ) If only one wiki is edited then : - you should use XML-RPC to read/write from one to the other for simple wiki pages - you can use XAR import export for full wiki pages - you can copy the DB but have to flush the cache Ludovic uwesbr wrote: Hi, what is the best way to keep two instances (two different pc) synchronized. Will it be enough to copy only the database= Regards, Uwe -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Attachment Store Location
On Sat, Mar 29, 2008 at 4:48 PM, [Ricardo Rodriguez] Your EPEC Network ICT Team [EMAIL PROTECTED] wrote: Well, obviously I am not a XWiki guru, but it seems to me that it was, and in fact it is, a good idea to have a single access control system. If you have the whole system in a database, you have not to be concerned about how to control access to other repositories. And at at the same time, to have the whole thing in a single database gives, at least to me, an feeling of full control about what is going on with the contents I've to manage. Other idea: you easy can index and search the whole content with a single search engine. And control access to the results! But, as you says, there are a number of problems with this approach. I am sure this thread will be useful for you... http://www.nabble.com/Xwiki-file-and-attachment-storage-td11991466.html#a11991466 And as a last minute entry, see this... http://dev.xwiki.org/xwiki/bin/view/GoogleSummerOfCode/WebDAVApi2008 Hope this helps, Ricardo Thanks for that, Ricardo! ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
