[OFBiz] Dev - from ERP-CRM team

[CRM-TEAM]

hi...
I've installed the PostgreSQl DBMS .
i connected it with OFBiz,but when i load the seed data a problem occures and here is a sample :
---- exception report ----------------------------------------------------------
An error occurred saving the data, rolling back transaction (true)
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while getting value : lastUpdatedStamp [LAST_UPDATED_STAMP] (2) (Bad Timestamp Format at 5 in 2005-
7 16:51:24.526+03)
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericDataSourceException: SQL Exception while getting value : lastUpdatedStamp [LAST_UPDATED_STAMP] (2)
d Timestamp Format at 5 in 2005-08-07 16:51:24.526+03)
org.ofbiz.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:661)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:502)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:464)
org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:90)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1099)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:245)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:227)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:184)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:223)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:250)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:89)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:413)
org.postgresql.util.PSQLException: Bad Timestamp Format at 5 in 2005-08-07 16:51:24.526+03
org.postgresql.jdbc1.AbstractJdbc1ResultSet.toTimestamp(AbstractJdbc1ResultSet.java:1000)
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getTimestamp(AbstractJdbc1ResultSet.java:273)
org.ofbiz.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:544)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:502)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:464)
org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:90)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1099)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:245)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:227)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:184)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:223)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:250)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:89)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:413)
Caused by: java.text.ParseException: Unparseable date: "2005-08-07 16:51:24 GMT+03:00"
java.text.DateFormat.parse(DateFormat.java:335)
org.postgresql.jdbc1.AbstractJdbc1ResultSet.toTimestamp(AbstractJdbc1ResultSet.java:996)
        ... 16 more
--------------------------------------------------------------------------------

14305 (main) [    TransactionUtil.java:248:ERROR]
---- exception report ----------------------------------------------------------
[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:247)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:229)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:234)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:184)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:223)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:250)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:89)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:413)
--------------------------------------------------------------------------------
and as you can see the main problem is the timestamp type.
so what can i do to avoid this problem.
bye for now...


 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev