Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Database installation guide

Open ?re Database Installation Guide http www igniterealtime org builds open ?re docs latest documentatio de Back to documentation index Open ?re stores all data in a back-end database If you choose to not use the embedded database you must setup and manage an external database for the application This document provides setup instructions for all of the currently supported databases JDBC drivers are required for Open ?re to communicate with your database Suggested drivers for particular databases are noted below where applicable Open ?re bundles JDBC drivers for MySQL Postgres Microsoft SQL Server and HSQLDB For a full list of available JDBC drivers please see http industry java sun com products jdbc drivers All database schemas can be found in the resources database directory of the Open ?re installation Note that additional databases besides the ones in this list may be supported Please check the distribution for a database schema for your database or consider creating a schema yourself if one isn't provided Choose your database from the list below for setup details MySQL Oracle Microsoft SQLServer PostgreSQL IBM DB HSQLDB MySQL JDBC Drivers The JDBC driver for MySQL is bundled with Open ?re so you do not need to download and install a separate driver In the Open ?re setup tool use the following values driver com mysql jdbc Driver server jdbc mysql YOURHOST DATABASENAME where YOURHOST and DATABASENAME are the actual values for you server In many cases localhost is a suitable value for YOUR HOST when your database is running on the same server as your webserver Setup Instructions Make sure that you are using MySQL or later x COpen ?re Database Installation Guide http www igniterealtime org builds open ?re docs latest documentatio recommended Create a database for the Open ?re tables mysqladmin create databaseName note databaseName can be something like 'open ?re' Import the schema ?le from the resources database directory of the installation folder Unix Linux cat open ?remysql sql mysql databaseName Windows type open ?remysql sql mysql databaseName Start the Open ?re setup tool and use the appropriate JDBC connection settings Character ?elds larger than are not supported by versions prior to MySQL If you cannot upgrade MySQL to the latest version you will then need to change the database scripts In particular replace VARCHAR with VARCHAR in the resources database open ?re mysql sql script Character Encoding Issues MySQL does not have proper Unicode support which makes supporting data in non-Western languages di ?cult However the MySQL JDBC driver has a workaround which can be enabled by adding useUnicode true characterEncoding UTF- characterSetResults UTF- to the URL of the JDBC driver You can edit the conf open ?re xml ?le to add this value Note If the mechanism you use to con ?gure a JDBC URL is XML-based you will need to use the XML character literal to separate con ?guration parameters as the ampersand is a reserved character for XML Further Help If you need help setting up MySQL refer