So I should only modify the xo3adb.script to translate it into SQL 2000? This script is created by the database, or will I have to modify it every time I need to reload the webapp?
What are the .sql files for? (CreateAddressBook.sql & CreateAddressBookmysql.sql) Don't I have to modify the repository.xml files in the WEB-INF\classes directory? (I understood that it was the OJB config file for the connection with the database) If I have to modify it, where can I get ressources to help me deal with this problem? Thanks for the so much needed help, Romain --- Philippe Vollenweider <[EMAIL PROTECTED]> a �crit : > Hello, > > We have not tested this webapps with MS SQL 2000 but it should > normally run. > You will have to modify all scripts located in WEB-INF/db to be > compatible > with your database. > > Cheers, > > Philippe. > > At 15.07.2004 11:59, you wrote: > >Is it possible to have the AddressBook working with MS SQL 2000. If > so, > >what do I have to modify. > > > >If not, why not, and what part of the code would I have to modify to > >have it work with MS SQL 2000. > > > >Thanks for all your answers, you are being really helpful. > > > >Romain > > > >--- St�phane Croisier <[EMAIL PROTECTED]> a �crit : > Hello, > > > > > > New versions of the webapps provided with Jahia are now based on > > > Apache OJB > > > (JDO - http://db.apache.org/ojb/). They are by default embedded > with > > > Hypersonic for easu of use reasons. However a script for MySQL > should > > > be > > > provided in the directory mentionned by Philippe. You may also > add > > > new > > > scripts for other databases by modifing the existing ones. > > > > > > If you plan to use several web apps on several virtual sites, it > may > > > be a > > > good idea to: > > > 1) only load the used ones per virtual site (else it will use a > lot > > > of > > > memory for nothing) > > > 2) modify the DB settings in order to use one single centralized > > > database > > > (else you will have one instance of Hypersonic in memory per > webapp > > > per > > > site - not optimum from a memory usage point of view). > > > > > > Cheers > > > St�phane > > > > > > At 13:59 14/07/2004, you wrote: > > > >Hello, > > > > > > > >Your datas are stored into an hsql database. You will find the > sql > > > scripts > > > >here: > > > >tomcat\webapps\<your_webapp>\WEB-INF\db\ > > > > > > > >Cheers, > > > > > > > >Philippe > > > > > > > >At 14.07.2004 10:24, you wrote: > > > >>Hi all, > > > >> > > > >>I haven't been able to find where the portlet AddressBook was > > > saving > > > >>the contacts entered. > > > >> > > > >>Could someone tell me where the file(s) are to be found? > > > >> > > > >>Thanks for your help, > > > >> > > > >>Romain > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >>Cr�ez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! > > > >>Cr�ez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/ > > > >> > > > >>Dialoguez en direct avec vos amis gr�ce � Yahoo! Messenger > > > !T�l�chargez > > > >>Yahoo! Messenger sur http://fr.messenger.yahoo.com > > > > > > > >-------=[ pvollenweider at jahia dot com ]=--------- > > > >Jahia : A collaborative source CMS and Portal Server > > > >www.jahia.org Community and product web site > > > >www.jahia.com Commercial services company > > > > > > > > > > > > > > > > > > > > > > > > > > >Cr�ez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! > >Cr�ez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/ > > > >Dialoguez en direct avec vos amis gr�ce � Yahoo! Messenger > !T�l�chargez > >Yahoo! Messenger sur http://fr.messenger.yahoo.com > > -------=[ pvollenweider at jahia dot com ]=--------- > Jahia : A collaborative source CMS and Portal Server > www.jahia.org Community and product web site > www.jahia.com Commercial services company > > > Cr�ez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Cr�ez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/ Dialoguez en direct avec vos amis gr�ce � Yahoo! Messenger !T�l�chargez Yahoo! Messenger sur http://fr.messenger.yahoo.com
