February 2007 - xwiki-users@xwiki.org

1.0beta2 cannot auto create some tables in Oracle 10
by feixingyu99＠hotmail.com 02 Feb '07

02 Feb '07

Hi everyone, Why can't I find the xwiki.hbm.xml file in 1.0B2 package? Am I required to create it by my self, or XWiki will provide one? Because once XWiki tried to recreate the tables, I got the error: [XWikiHibernateStore] Failed updating schema: ORA-01754: a table may contain only one column of type LONG It seems that we have to map some MySQL datatype to the proper Oracle type, in order to generate the proper DDL. Does anyone have a hbm.xml file that works with Oracle? Or what else need to be changed in the hibernate.cfg.xml? (I am using 10g JDBC driver) Best regards, Eric Sun -----Original Message----- From: Ludovic Dubost [mailto:ludovic@xwiki.org] Sent: Wed 1/18/2006 6:42 PM To: Eric Sun (Toronto) Subject: Re: Installation concerns for Oracle 10g Hi, You should post this to the users/dev lists. http://forge.objectweb.org/mail/?group_id=170 With XWiki 1.0B2 you should be able to run XWiki with an empty database (XWiki creates the tables automatically) and then try to import the ".xar" file available on xwiki.org into the XWiki running with the Oracle DB. Let us know how this works. Ludovic

3 8

Re: Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

Ok, the only problem I encountered while surfing the wiki is that it throws up exceptions while saving stuff. Maybe XWiki has a problem or maybe the problem I encountered while copying is the bugger. Anyway, I think we can use this way to help shape XWiki to use an old xwiki db in postgres directly as MySQL. What you do is you take your old xwiki postgres db, use the SQuirreL (or any DB copier) to copy over the tables from your postgres to MySQL. Move to the new xwiki while pointing at your MySQL db. Then move back to postgres and let the new XWiki point to Postgres again. MySQL and XWiki will "straighten" things out that will allow you to use the new Xwiki with Postgres. I hope this will work for everyone as it worked for me (well it almost worked 100% :-) ). Regards, Dandre

2 1

Re: Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

Ha ha! It worked! Well, it couldn't copy over something in 1 table, something about a duplicate reference or something but other than that, I could open up the new xwiki in postgres with an imported db from the old one! Ok, I'll post more info later. Regards, Dandre

1 0

Re: Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

Ok, so far so good. The plugin seems to work. Now I am really gonna put it through the test ;-) Wish me luck! :-D Regards, Dandre

1 0

Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

I have found a forum on the MySQL site (something like this on the net is as scarce as chicken teeth :-D ) that talks about converting a PostgreSQL db to a MySQL one (well I still need to try it out, will let everyone know): http://forums.mysql.com/read.php?83,34517,34517#msg-34517 Why? Well if you want the new XWiki to work and you don't mind the kind of DB to use, then this is a good solution. But I wanna try something. I want to copy my PSQL db to MySQL and get that to work on the new XWiki and hopefully I can convert it back to PSQL and it'll work on the new XWiki (HOPEFULLY)!!! On that forum thread, there is a plugin for SQuirreL SQL that basically allows you to copy between DBs! Now thats handy! I want to test that out and see if it will work! Oh how I hope it'll work!!! Regards, Dandre

1 0

Debugging XWiki
by Dandre 02 Feb '07

02 Feb '07

Hello Vincent and everyone at XWiki! I am going through the code but I need to view how XWiki is generating SQL queries that are sent to the JDBC driver in order to see if it's XWiki that has a problem or Hibernate or the JDBC driver. Yes, I am working with Fabian and them to try and figure out why Postgres gives a problem when porting from an old DB. Could you guys maybe give me instructions of how to turn on debug mode. Thanks alot. Regards, Dandre

3 3

Re: Re: [xwiki-users] Debugging XWiki
by Dandre 02 Feb '07

02 Feb '07

> Which IDE are you using? I've planned to write documentation on how to > debug XWiki from within IntelliJ IDEA. If you need it I can do it > sooner rather than later. Right now I am not using an IDE. Pure text viewers and editing ;-) If you can it would be great, but unfortunately I cannot spend too much time figuring out what is wrong, being at work they only give me a certain amount of time to get this thing moving and I've been working on this for almost 2 weeks now. I think I should try to find a way to extract the posts from the old xwiki DB and get it to insert into the new xwiki DB through an app or something. Maybe that is a good short-term solution. It should work, right? Unless there are too many dependencies to insert and keep track of. Thanks Regards, Dandre

1 0

Re: Re: [xwiki-users] upgrade from 0.984 to 1.0B3
by Dandre 02 Feb '07

02 Feb '07

> I just did that, running on Tomcat 5.5 against a MySQL 5.0.21 server. > I loaded the database dump from the old xwiki app. > Unfortunately, still the same error, see below. I use MySQL 5.0.22 and it works great. I think XWiki might have a problem with porting from the old xwiki with Postgres and not the JDBC driver or the Hibernate thing.

1 0

How to Create Menu in XWiki
by Sarmal 02 Feb '07

02 Feb '07

Hi , I am New to XWIki. I want to Create Menu for My XWiki Appalication , the Help DOc said I have to create a Page called Menu in a Space , then it will automatically DIsplay it in all the pages in that Space. I have create the Page called Menu In a Space , But the Menu is not at all Loaded in any page . If I open the3 Menu page I can See the Content Only Once But as per the Help Doc it should Show 2 time. I am using XWiki 1.0 Beta 2 Pl. let me know how to get the Menu is Left or in Right Side . -- View this message in context: http://www.nabble.com/How-to-Create-Menu-in-XWiki-tf3148965.html#a8729694 Sent from the XWiki- Users mailing list archive at Nabble.com.

3 3

[xwiki user] Exporting just a single space
by Dan Murphy 01 Feb '07

01 Feb '07

Hi, It's probably me, but I can't seem to find a way to export specific spaces. In earlier version of the import/export there was a drop down and you could select specific spaces & pages to export... now it seems to only export the entire wiki. I had a nasty problem with my wiki (some pages were "bad" and when I tried to delete them I got told they didn't exist) and thought... I know, I'll just export the good stuff and drop the db then import my good pages back in... I couldn't becuase export seems to be exporting the whole wiki (despite a space parameter in the url). So, question is can I export specific pages / spaces only & if so any hints :) Thanks, Dan

2 2