Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » OM2M » Usage of Postgre DB (SQL Syntax exception in Postgre)
Usage of Postgre DB [message #1765574] Mon, 12 June 2017 14:13
Alpay Ozturk is currently offline Alpay OzturkFriend
Messages: 1
Registered: June 2017
Junior Member
Hi,
I've configured OM2M to use postgre DB instead of H2. But it gives below error while trying to run CREATE command in startup.

Has anyone managed to use postgre?
Thanks,
Alpay

Create AccessControlPolicy resource
Exception in thread "pool-1-thread-1" javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near "CREATE"
Position: 26
Error Code: 0
Call: INSERT INTO ACR (ACR_ID, CREATE, DELETE, DISCOVERY, NOTIFY, RETRIEVE, UPDATE) VALUES (?, ?, ?, ?, ?, ?, ?)
bind => [7 parameters bound]
Query: InsertObjectQuery(org.eclipse.om2m.commons.entities.AccessControlRuleEntity@28217bdb)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:157)
at org.eclipse.om2m.persistence.eclipselink.internal.DBTransactionJPAImpl.commit(DBTransactionJPAImpl.java:44)
at org.eclipse.om2m.core.CSEInitializer.initACP(CSEInitializer.java:309)
at org.eclipse.om2m.core.CSEInitializer.init(CSEInitializer.java:83)
at org.eclipse.om2m.core.Activator$2$1.run(Activator.java:98)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near "CREATE"
Previous Topic:om2m
Next Topic:OM2M performance for thousands of resources
Goto Forum:
  


Current Time: Sun Nov 18 11:04:09 GMT 2018

Powered by FUDForum. Page generated in 0.01656 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top