[
https://issues.apache.org/jira/browse/ISIS-223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dan Haywood closed ISIS-223.
----------------------------
> Additional Configuration Documentation for using SQL ObjectStore and usage
> for Quick Start Archetype.
> -----------------------------------------------------------------------------------------------------
>
> Key: ISIS-223
> URL: https://issues.apache.org/jira/browse/ISIS-223
> Project: Isis
> Issue Type: Wish
> Components: Objectstore: SQL
> Reporter: Jason Richardson
> Priority: Minor
> Labels: Newbie
>
> Please Add additional documentation to the ISIS website or ISIS guides that
> details what POM entries and isis.properties need to be updated to use the
> SQL Ojbjefrom the archetype quick start documentation
> I did this using the ISIS quickstart version: 0.2.0-incubating
> ** This is a PostgreSQL example
> ** In order to use the SQL ObjectStore the following things need to be done
> once the user has created their new ISIS Application.
> # comment postgresql url base example for
> (isis.persistor.sql.jdbc.connection): jdbc:postgresql://host:port/database
> =================================
> 1. Add the following entry in your projectname-objstore-dflt POM file
> <dependency>
>
> <groupId>org.apache.isis.runtimes.dflt.objectstores</groupId>
> <artifactId>sql-impl</artifactId>
> </dependency>
> =================================
> 2. Add the maven dependencies for your Database Drivers entry in your
> projectname-objstore-dflt POM file
> <dependency>
> <groupId>postgresql</groupId>
> <artifactId>postgresql</artifactId>
> <version>9.0-801.jdbc3</version>
> </dependency>
> =================================
> 2. In the projectname-webapp project in the isis.properties file change the
> isis.persistor property
> isis.persistor=sql
> =================================
> 3. In the projectname-webapp project add the following properties (suitable
> for your Database Platform)
> 3a. You will need to change the connection entry and driver entry to be
> specific for your database platform drivers and database server location and
> port.
> 3b. -if you want ISIS to create your DB tables you will need to use an
> ID/Password that has table creation rights.
> isis.persistor.sql.jdbc.driver=org.postgresql.Driver
> isis.persistor.sql.jdbc.connection=jdbc:postgresql://127.0.0.1:5432/assignments
>
> isis.persistor.sql.jdbc.user=postgres
> isis.persistor.sql.jdbc.password=TheDatabasePassword
> # PostgreSQL ISIS specific data type overides
> isis.persistor.sql.datatypes.timestamp=TIMESTAMP
> isis.persistor.sql.datatypes.datetime=TIMESTAMP
> isis.persistor.sql.datatypes.double=DOUBLE PRECISION
> =================================
> 4. Do a maven clean and install on your main project and run it.
> 4b. You should see new table(s) created in your database.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
