You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@isis.apache.org by "Dan Haywood (JIRA)" <ji...@apache.org> on 2012/12/17 00:26:12 UTC
[jira] [Updated] (ISIS-223) Additional Configuration Documentation
for using SQL ObjectStore and usage for Quick Start Archetype.
[ https://issues.apache.org/jira/browse/ISIS-223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dan Haywood updated ISIS-223:
-----------------------------
Component/s: (was: Examples)
> 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