| Usage of Postgre DB [message #1765574] |
Mon, 12 June 2017 10:13 |
Eclipse User |
|
|
|
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"
|
|
|
Powered by
FUDForum. Page generated in 0.03934 seconds
Home