You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@isis.apache.org by keng <kr...@gmail.com> on 2016/05/14 18:33:06 UTC
Re: Running Isis on Jetty with PostgreSQL
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.
Re: Running Isis on Jetty with PostgreSQL
Posted by Dan Haywood <da...@haywood-associates.co.uk>.
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 <kr...@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.
>
>
>