Database¶

pre-configured databases¶

• PostgreSQL
• H2 for an embedded database (http://www.h2database.com/html/main.html)

LinShare is integrated natively with PostgreSQL (this is the default configuration). To switch to another database, you will need to change the jdbc driver and to update the sql scripts. Follow the step below.

Change the database.¶

Create the new schema.¶

add a new file /src/main/resources/reference-database.properties and set the new dialect of your database

# used by maven to generate sql scripts
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

then generate the schema:

 mvn hibernate3:hbm2ddl 

the ouput will be in /target/hibernate3/sql/createSchema.sql

Import manually the initial data.¶

Configure linShare with the new database.¶

Troubles.¶