1. Home
  2. Portal
  3. Configuring External Database

Configuring External Database

Darshan Patel, modified 5 Years ago.
Configuring External Database
New Member Posts: 8 Join Date: 8/12/19 Recent Posts
Hi guys,
I'm working on Liferay 6.2.
I came across the requirement in which I need to use external database which is postgres.

I configured it to my local system using below properties, I added these properties to portal-ext.properties file.

jdbc.ext.driverClassName=org.postgresql.Driver
jdbc.ext.url
jdbc.ext.username
jdbc.ext.password

 and it works fine.

But when I put above properties to the testing server's  portal-ext.properties file and restarted,

the system says that
 ERROR: relation "XYZ" does not exist_ org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into -------------------------------
nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

We also confirmed that after removing those properties from test server and error is gone, the test server works perfectly fine.

Any one knows how this happen and how to fix this problem ? It would be great if you help me, thanks in advance.
thumbnail
Christoph Rabel, modified 5 Years ago.
RE: Configuring External Database
Liferay Legend Posts: 1555 Join Date: 9/24/09 Recent Posts
Sorry, but your stacktrace is too incomplete. We can only guess here.
Who tries to insert what? Is it Liferay? Does it try to add a something to that ext database? Or is it one of your modules?
Maybe you are simply not allowed to execute insert into ..... (Whatever that does, since you snipped it away) When you authenticate with the ext user/password, can you execute the insert into ... statement manually?