topic Re: How to connect postresql database in allinone projects in Alfresco Forum

How to connect postresql database in allinone projects

noohulalthaf — Wed, 06 Dec 2017 06:48:45 GMT

HiI have configured 'allinone' projects in my system but i don't have alfresco community installed in my system.I believe the project will get connect to tomcat runner internally and by default it will be connected to H2 database.but if i want to connect to other databases such as postresql,mysql et

Re: How to connect postresql database in allinone projects

krutik_jayswal — Wed, 06 Dec 2017 08:31:10 GMT

It depends on which alfresco SDK you are using.

If your SDK is below 3.0.0 than

You need to make changes in alfresco-gloabl.properties to change the db confiuration like db.port,dbusername etc.
You need to grabe driver as well from maven central repository and include it in pom file.

If your SDK is above 3.0.0 than

You can simply change configuration in alfresco-global-postgresql.properties with the db configuration which i mentioned above.
You need to change properties in POM file. like making maven.alfresco.enableH2 as false and making maven.alfresco.enablePostgres as true

Re: How to connect postresql database in allinone projects

noohulalthaf — Wed, 06 Dec 2017 10:36:03 GMT

Hi Krutik,

I am using SDK 2.2.0 Allinone alfresco project,as per your point, where i can find the alfresco global properties file ? if i am correct, this is the path where alfresco-global.proprties file located

C:\alfresco\alfresco\alfresco-repo-amp\target\amp\config\alfresco\module\alfresco-repo-amp\alfresco-global

and how to grab driver and include it in pom?can you guide me on that?

Re: How to connect postresql database in allinone projects

krutik_jayswal — Wed, 06 Dec 2017 11:16:08 GMT

You should not update anything inside target folder.I think below should be location of the file

src\main\amp\config\alfresco\module\${module.id}\alfresco-global.properties

Re: How to connect postresql database in allinone projects

noohulalthaf — Thu, 07 Dec 2017 12:19:35 GMT

I updated the alfresco-global.properties file with postgres db connection properties, but still getting error and while compiling it shows db connected to H2 database.

if i am correct,normally the file located in tomcat/shared/classes folder, which will overrides the properties given in project and execute it, but in my case alfresco community is not running, so where i can define the database connection properties?Any suggestion would be appreciated.