Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
How to use postgreSQL
-
hi mlohbihler
I don't want to convert derby to postgreSQL,because I want to use postgreSQL directly,I modify the code about database,now I run the program and find the following log(the tables in postgreSQL have been created Automatically):
org.springframework.dao.InvalidDataAccessApiUsageException: The getKey method should only be used when a single key is returned. The current key entry contains multiple keys: [{id=1, username=admin, password=0DPiKuNIrrVmD8IUCuw1hQxNqZc=, email=admin@yourMangoDomain.com, phone=, admin=Y, disabled=N, lastlogin=null, selectedwatchlist=null, homeurl=null, receivealarmemails=0, receiveownauditevents=N}]
at org.springframework.jdbc.support.GeneratedKeyHolder.getKey(GeneratedKeyHolder.java:65)
at com.serotonin.db.DaoUtils.doInsert(DaoUtils.java:151)
at com.serotonin.mango.db.dao.UserDao.insertUser(UserDao.java:134)
at com.serotonin.mango.db.dao.UserDao.access$000(UserDao.java:38)
at com.serotonin.mango.db.dao.UserDao$2.doInTransactionWithoutResult(UserDao.java:122)
at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at com.serotonin.mango.db.dao.UserDao.saveUser(UserDao.java:118)
at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:138)
at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:248)
at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:85)
best wishes
Susan