search

sqlite-sync / SQLite-sync.com

AMPLI-SYNC is a framework for synchronizing data between a Sqlite database and an MS SQL/MySQL/Oracle/PostgreSQL database. With this framework your application can work completely offline (Airplane Mode), then perform an automated Bidirectional Synchronization when an internet connection becomes available.
https://ampliapps.com/sqlite-sync/
BSD 3-Clause "New" or "Revised" License
328 stars 82 forks source link

API[3.2.15] SQLite-Sync.COM is working correctly! Error creating database connection. #33

Closed luiza-avelino closed 4 years ago

luiza-avelino commented 4 years ago

I'm receiving this error when access: localhost:8080/sync/API3.

My web.xml:

working-dir java.lang.String C:\Users\Luiza\sync\

My sync.properties file(located at 'C:\Users\Luiza\sync\config\sync.properties') :

DB_ENGINE = postgres DBURL = jdbc:postgresql://localhost:56582/sync DBUSER = postgres DBPASS = postgres DBDRIVER = org.postgresql.Driver DATE_FORMAT = yyyy-MM-dd HH:mm:ss HISTORY_DAYS = 7 LOG_LEVEL = 4

IchoTolot commented 4 years ago

Hi, can you connect to the database with this credentials and pgAdmin?

luiza-avelino commented 4 years ago

Yes,

credentials is OK, dbname is OK. I really don't know what's the problem

IchoTolot commented 4 years ago

Please set DB_ENGINE to postgresql and add TIMESTAMP_FORMAT according to your local Datetime format. Same for DATE_FORMAT even this has nothing to do with the database error.