JPA didn’t created any table for me. Here is startup log:
2015-09-07 09:48:42.047 DEBUG o.o.p.j.i.JpaPersistenceServiceActivator[:31]- JPA persistence bundle has been started.
2015-09-07 09:48:42.088 DEBUG o.o.p.j.i.JpaConfiguration[:41]- Update config...
2015-09-07 09:48:42.092 ERROR o.o.p.j.i.JpaConfiguration[:44]- Got a null properties object!
2015-09-07 09:49:02.141 DEBUG o.o.p.j.i.JpaConfiguration[:41]- Update config...
2015-09-07 09:49:02.146 DEBUG o.o.p.j.i.JpaConfiguration[:49]- url: jdbc:mysql://localhost:3306/openhab
2015-09-07 09:49:02.147 DEBUG o.o.p.j.i.JpaConfiguration[:61]- driver: com.mysql.jdbc.Driver
2015-09-07 09:49:02.149 DEBUG o.o.p.j.i.JpaConfiguration[:81]- Update config...done
2015-09-07 09:49:23.761 DEBUG o.o.p.j.i.JpaPersistenceService[:59]- Activating jpa binding...
2015-09-07 09:49:23.765 DEBUG o.o.p.j.i.JpaPersistenceService[:60]- Activating jpa binding...done
2015-09-07 09:50:53.998 DEBUG o.o.p.j.i.JpaPersistenceService[:92]- Storing item: ZaDomem_Ogrod1
2015-09-07 09:50:54.090 DEBUG o.o.p.j.i.JpaPersistenceService[:209]- Creating EntityManagerFactory...
2015-09-07 09:50:57.462 DEBUG o.o.p.j.i.JpaPersistenceService[:225]- Creating EntityManagerFactory...done
2015-09-07 09:51:03.720 DEBUG o.o.p.j.i.JpaPersistenceService[:92]- Storing item: ZaDomem_Ogrod2
2015-09-07 09:51:03.923 DEBUG o.o.p.j.i.JpaPersistenceService[:120]- Persisting item...
2015-09-07 09:51:04.573 ERROR o.o.p.j.i.JpaPersistenceService[:127]- Error on persisting item! Rolling back!
2015-09-07 09:51:04.635 ERROR o.o.p.j.i.JpaPersistenceService[:128]- The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:594)
at org.openhab.persistence.jpa.internal.JpaPersistenceService.store(JpaPersistenceService.java:124)
at org.openhab.core.persistence.internal.PersistenceServiceDelegate.store(PersistenceServiceDelegate.java:48)
at org.eclipse.smarthome.model.persistence.internal.PersistenceManager.handleStateEvent(PersistenceManager.java:227)
at org.eclipse.smarthome.model.persistence.internal.PersistenceManager.stateUpdated(PersistenceManager.java:209)
at org.eclipse.smarthome.core.items.GenericItem.notifyListeners(GenericItem.java:197)
Caused by: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2370)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2207)
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2105)
at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2023)
at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1528)
Caused by: org.apache.openjpa.persistence.PersistenceException: Table 'openhab.HISTORIC_ITEM' doesn't exist {prepstmnt 454115339 INSERT INTO HISTORIC_ITEM (id, name, realName, timestamp, value) VALUES (?, ?$
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4974)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4934)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:76)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'openhab.HISTORIC_ITEM' doesn't exist {prepstmnt 454115339 INSERT INTO HISTORIC_ITEM (id, name, realName, timestamp, value) VALUES (?, ?, $
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:59)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1134)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1792)
I’ve managed to create tables on my own based on error queries and it looks it works now.