Re: [xwiki-users] SQL files
Hi David, All tables are created automatically, you just need to create the correct empty shema/database (by default xwiki). 2007/11/9, david bessire [EMAIL PROTECTED]: A second question: according to hibernate.cfg.xml, database objects (tables) will be created automatically, at least for some databases. Is this database-dependent; that is, do some databases require the tables to be manually created? If so, where can i obtain the .sql files which define the xwiki data model? i was quite surprised to find no .sql files in the .jar i downloaded. Thanks, david bessire Peek-a-boo FREE Tricks Treats for You! Get 'em! ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Thomas Mortagne ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] SQL files
Hi David, All tables are created automatically, you just need to create the correct empty shema/database (by default xwiki). For MSSQL to work I had to create my own xwiki.hbm.xml, the default one didn't work. Cheers, Tobias ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] SQL files
On Nov 9, 2007, at 5:56 PM, [EMAIL PROTECTED] wrote: Hi David, All tables are created automatically, you just need to create the correct empty shema/database (by default xwiki). For MSSQL to work I had to create my own xwiki.hbm.xml, the default one didn't work. would be nice if you could contribute it. Thanks -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] SQL files
On Nov 9, 2007, at 5:56 PM, [EMAIL PROTECTED] wrote: Hi David, All tables are created automatically, you just need to create the correct empty shema/database (by default xwiki). For MSSQL to work I had to create my own xwiki.hbm.xml, the default one didn't work. would be nice if you could contribute it. Of course, here it is. I actually wanted to provide a complete patch, but I couldn't yet figure out how put the changes to hibernate.cfg.xml into the source. Here's what I added manually: !-- MSSQL configuration -- property name=connection.urljdbc:jtds:sqlserver://some.sql-swerver.com:1433/XWiki;tds=8.0;lastupdatecount=true/property property name=connection.usernamexwikiuser/property property name=connection.passwordxwikipassword/property property name=connection.driver_classnet.sourceforge.jtds.jdbc.Driver/property property name=dialectorg.hibernate.dialect.SQLServerDialect/property mapping resource=xwiki.mssql.hbm.xml/ mapping resource=feeds.hbm.xml/ If you commit this, please send me note with the revision number. Thanks, Tobias?xml version=1.0? !DOCTYPE hibernate-mapping PUBLIC -//Hibernate/Hibernate Mapping DTD//EN http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd; hibernate-mapping auto-import=true !-- com.xpn.xwiki.doc.XWikiDocument root -- class name=com.xpn.xwiki.doc.XWikiDocument table=xwikidoc id name=id type=long unsaved-value=undefined column name=XWD_ID not-null=true/ generator class=assigned / /id property name=fullName type=string column name=XWD_FULLNAME length=255 not-null=true/ /property property name=name type=string column name=XWD_NAME length=255 not-null=true/ /property property name=title type=string column name=XWD_TITLE length=255 not-null=true/ /property property name=language type=string column name=XWD_LANGUAGE length=5 / /property property name=defaultLanguage type=string column name=XWD_DEFAULT_LANGUAGE length=5 / /property property name=translation type=integer column name=XWD_TRANSLATION not-null=true / /property property name=date type=timestamp column name=XWD_DATE not-null=true/ /property property name=contentUpdateDate type=timestamp column name=XWD_CONTENT_UPDATE_DATE not-null=true / /property property name=creationDate type=timestamp column name=XWD_CREATION_DATE not-null=true / /property property name=author type=string column name=XWD_AUTHOR length=255 not-null=true/ /property property name=contentAuthor type=string column name=XWD_CONTENT_AUTHOR length=255 not-null=true/ /property property name=creator type=string column name=XWD_CREATOR length=255 not-null=true / /property property name=web type=string column name=XWD_WEB length=255 not-null=true/ /property property name=content type=text column name=XWD_CONTENT length=20 not-null=true/ /property property name=version type=string column name=XWD_VERSION length=255 not-null=true/ /property property name=customClass type=string column name=XWD_CUSTOM_CLASS length=255 not-null=true/ /property property name=parent type=string column name=XWD_PARENT length=511 not-null=true/ /property property name=xWikiClassXML type=text column name=XWD_CLASS_XML length=4 not-null=false/ /property property name=elements type=integer not-null=true column name=XWD_ELEMENTS / /property property name=defaultTemplate type=string column name=XWD_DEFAULT_TEMPLATE not-null=true/ /property property name=validationScript type=string column name=XWD_VALIDATION_SCRIPT not-null=true / /property property name=comment type=string column name=XWD_COMMENT length=1023 not-null=true / /property /class class name=com.xpn.xwiki.doc.XWikiDocumentArchive table=xwikidoc id name=id type=long unsaved-value=undefined column name=XWD_ID not-null=true/ generator class=assigned / /id property name=archive type=text column name=XWD_ARCHIVE length=20 not-null=false / /property /class class name=com.xpn.xwiki.doc.XWikiLock table=xwikilock id name=docId type=long unsaved-value=undefined column name=XWL_DOC_ID not-null=true/ generator class=assigned / /id property name=userName type=string column name=XWL_AUTHOR length=255/ /property property name=date type=timestamp
Re: [xwiki-users] SQL files
On Nov 9, 2007, at 6:09 PM, [EMAIL PROTECTED] wrote: On Nov 9, 2007, at 5:56 PM, [EMAIL PROTECTED] wrote: Hi David, All tables are created automatically, you just need to create the correct empty shema/database (by default xwiki). For MSSQL to work I had to create my own xwiki.hbm.xml, the default one didn't work. would be nice if you could contribute it. Of course, here it is. I actually wanted to provide a complete patch, but I couldn't yet figure out how put the changes to hibernate.cfg.xml into the source. Here's what I added manually: !-- MSSQL configuration -- property name=connection.urljdbc:jtds:sqlserver://some.sql-swerver.com: 1433/XWiki;tds=8.0;lastupdatecount=true/property property name=connection.usernamexwikiuser/property property name=connection.passwordxwikipassword/property property name=connection.driver_classnet.sourceforge.jtds.jdbc.Driver/ property property name=dialectorg.hibernate.dialect.SQLServerDialect/ property mapping resource=xwiki.mssql.hbm.xml/ mapping resource=feeds.hbm.xml/ If you commit this, please send me note with the revision number. What would be nice is if you could edit the installation page and add instructions to set up MSSQL (same as what exists for other DBs). You could attach you hibernate file to the page (as it's done for some DBs too). Later on we could commit in xwiki when others have tested it works fine for them. Thanks a lot! -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] SQL files
What would be nice is if you could edit the installation page and add instructions to set up MSSQL (same as what exists for other DBs). You could attach you hibernate file to the page (as it's done for some DBs too). Later on we could commit in xwiki when others have tested it works fine for them. OK, I'll do so on on Monday. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
