| Usage of Postgre DB [message #1765574] |
Mon, 12 June 2017 14:13 |
 Alpay Ozturk
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"
|
|
|
Powered by
FUDForum. Page generated in 0.02830 seconds
] 
Search
Help
Register
Login
Home
