Vanilla PostgreSQL

8 posts / 0 new

Last post

Mon, 01/20/2014 - 15:36

come.moyne

Offline

Last seen: 10 years 2 months ago

Joined: 08/23/2013 - 16:08

Vanilla PostgreSQL

Language English

Vanilla can be run with both MySQL and PostgreSQL database.

Our server is pre-configured for MySQL. In order to use it with a PostgreSQL server, follow those steps :

Download and extract vanilla-tomcat-mysql-server : download server.
Download, extract and restore PostgreSQL backups : download PostgreSQL backup.
Rename propertie files in vanilla-conf/ in order to use the one for PostgreSQL

For any other questions, please refer to the prerequisites documentation.

Wed, 02/05/2014 - 16:00

scivray

Offline

Last seen: 10 years 10 months ago

Joined: 02/04/2014 - 15:15

In vanilla-tomcat-mysql-4.4.2_GA.zip, the file vanilla-conf/repositoryone.postgres.properties is configured for the database vanilla44 :

bpm.vanilla.repository.database.jdbcUrl=jdbc:postgresql://localhost:5432/vanilla44

But the Postgresql scripts create a database called repository44.

It should be :

bpm.vanilla.repository.database.jdbcUrl=jdbc:postgresql://localhost:5432/repository44

Wed, 02/12/2014 - 14:56

(Reply to #2) #3

come.moyne

Offline

Last seen: 10 years 2 months ago

Joined: 08/23/2013 - 16:08

Thank you for your update. This will be corrected in next Version of Vanilla.

Fri, 03/28/2014 - 04:47

villasanacarlos

Offline

Last seen: 10 years 9 months ago

Joined: 10/02/2013 - 03:51

I configured with Postgres as said in the Documentation and got the error

java.sql.SQLException: No suitable driver

Anyone knows what is the reason?

Thanks

Carlos Villasana
Cel. 58.412.4766393
skype: carlos.villasana
Pentaho BI Consultant
www.pentaho.com

Mon, 04/14/2014 - 02:14

(Reply to #4) #5

jimmcruz

Offline

Last seen: 10 years 8 months ago

Joined: 04/13/2014 - 23:13

copy the jdbc driver file from ´resources\jdbc' to 'lib'.

Mon, 04/14/2014 - 11:06

(Reply to #5) #6

come.moyne

Offline

Last seen: 10 years 2 months ago

Joined: 08/23/2013 - 16:08

Hi villasanacarlos,

Do you still have issues connecting to Vanilla using PostgreSQL database ? If not, could you provide more details : when / where the error occur, what is youf configuration file...

Normally it should work without any move of postgreSQL driver.

Regards

Thu, 09/25/2014 - 09:11

bhericher

Offline

Last seen: 10 years 1 month ago

Joined: 09/23/2014 - 10:41

Has someone been able to install Vanilla 4.4.2 on Windows with Postgresql 9.3?

Thank you

Tue, 05/31/2016 - 20:48

mgiammarco

Offline

Last seen: 8 years 6 months ago

Joined: 04/30/2016 - 20:29

I have downloaded vanilla 5.2 and I am trying to use postgresql. I cannot find sql script to prepare database.

Can you help me?

Thanks,

Mario

Search form