postgresql - playframework-1.x heroku postgres -


i tried deployed play 1.2.4 app heroku. app works great locally, on heroku got strange errors, try save data.

2012-07-02t21:26:04+00:00 app[web.1]: internal server error (500) request post /players/save 2012-07-02t21:26:04+00:00 app[web.1]:  2012-07-02t21:26:04+00:00 app[web.1]: oops: unexpectedexception 2012-07-02t21:26:04+00:00 app[web.1]: unexpected error occured caused exception unexpectedexception: unexpected error 2012-07-02t21:26:04+00:00 app[web.1]:  2012-07-02t21:26:04+00:00 app[web.1]: play.exceptions.unexpectedexception: unexpected error 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.data.validation.validationplugin.beforeactioninvocation(validationplugin.java:59) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.plugins.plugincollection.beforeactioninvocation(plugincollection.java:594) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.mvc.actioninvoker.invoke(actioninvoker.java:134) 2012-07-02t21:26:04+00:00 app[web.1]:   @ invocation.http request(play!) 2012-07-02t21:26:04+00:00 app[web.1]: caused by: play.exceptions.unexpectedexception: unexpected error 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.db.jpa.jpaplugin.bind(jpaplugin.java:84) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.plugins.plugincollection.bind(plugincollection.java:534) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.data.binding.binder.bind(binder.java:111) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.mvc.actioninvoker.getactionmethodargs(actioninvoker.java:642) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.data.validation.validationplugin$validator.validateaction(validationplugin.java:96) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.data.validation.validationplugin.beforeactioninvocation(validationplugin.java:51) 2012-07-02t21:26:04+00:00 app[web.1]:   ... 3 more 2012-07-02t21:26:04+00:00 app[web.1]: caused by: javax.persistence.persistenceexception: org.hibernate.exception.sqlgrammarexception: not execute query 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1214) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1147) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:307) 2012-07-02t21:26:04+00:00 app[web.1]:   @ play.db.jpa.jpaplugin.bind(jpaplugin.java:79) 2012-07-02t21:26:04+00:00 app[web.1]:   ... 8 more 2012-07-02t21:26:04+00:00 app[web.1]: caused by: org.hibernate.exception.sqlgrammarexception: not execute query 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.exception.sqlstateconverter.convert(sqlstateconverter.java:92) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.exception.jdbcexceptionhelper.convert(jdbcexceptionhelper.java:66) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.loader.dolist(loader.java:2536) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.loader.listignorequerycache(loader.java:2276) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.loader.list(loader.java:2271) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.hql.queryloader.list(queryloader.java:452) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.hql.ast.querytranslatorimpl.list(querytranslatorimpl.java:363) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.engine.query.hqlqueryplan.performlist(hqlqueryplan.java:196) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.impl.sessionimpl.list(sessionimpl.java:1268) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.impl.queryimpl.list(queryimpl.java:102) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:274) 2012-07-02t21:26:04+00:00 app[web.1]:   ... 9 more 2012-07-02t21:26:04+00:00 app[web.1]: caused by: org.postgresql.util.psqlexception: error: operator not exist: bigint = bytea 2012-07-02t21:26:04+00:00 app[web.1]:   hint: no operator matches given name , argument type(s). might need add explicit type casts. 2012-07-02t21:26:04+00:00 app[web.1]:   position: 130 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.postgresql.core.v3.queryexecutorimpl.receiveerrorresponse(queryexecutorimpl.java:2102) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.postgresql.core.v3.queryexecutorimpl.processresults(queryexecutorimpl.java:1835) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.postgresql.core.v3.queryexecutorimpl.execute(queryexecutorimpl.java:257) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.postgresql.jdbc2.abstractjdbc2statement.execute(abstractjdbc2statement.java:500) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.postgresql.jdbc2.abstractjdbc2statement.executewithflags(abstractjdbc2statement.java:388) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.postgresql.jdbc2.abstractjdbc2statement.executequery(abstractjdbc2statement.java:273) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.jdbc.abstractbatcher.getresultset(abstractbatcher.java:208) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.loader.getresultset(loader.java:1953) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.loader.doquery(loader.java:802) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:274) 2012-07-02t21:26:04+00:00 app[web.1]:   @ org.hibernate.loader.loader.dolist(loader.java:2533) 2012-07-02t21:26:04+00:00 app[web.1]:   ... 17 more 

the app public accessable here: https://github.com/phaus/kickster

i tried use db evolutions first. did not work neither. found several pages

caused by: org.postgresql.util.psqlexception: error: operator not exist: bigint = bytea

but looks, problem within play framework?

this play framework bug has been fixed in play 1.2.5.


Comments

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

c# - Copy ObservableCollection to another ObservableCollection -

All overlapping substrings matching a java regex -