isis-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Haywood <...@haywood-associates.co.uk>
Subject Re: Running Isis on Jetty with PostgreSQL
Date Mon, 16 May 2016 06:01:56 GMT
Um, thanks, but this is a rather old thread, and those instructions are
also very out of date.

The simpleapp archetype is shipped with the Postgres JDBC driver in the
pom.xml (but commented out) [1]; the only other change is to update
persistor.properties [2]

Cheers
Dan


[1]
https://github.com/apache/isis/blob/rel/simpleapp-archetype-1.12.1/example/application/simpleapp/webapp/pom.xml#L157
[2]
https://github.com/apache/isis/blob/rel/simpleapp-archetype-1.12.1/example/application/simpleapp/webapp/src/main/webapp/WEB-INF/persistor.properties#L90


On 14 May 2016 at 19:33, keng <kruger.engelbrecht@gmail.com> wrote:

> See : https://issues.apache.org/jira/browse/ISIS-223, the content copied
> here.
>
> 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.
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message