Hello
I have setup for a few days a new Base2 installation, running with
postgresQL.
I know that the update process wan "not safe" with psql, due a bug in
hibernate. However, the updating process ran without problem from 2.0.2
to 2.0.3
So, trying to update to 2.1, here is the output of ./update.sh:
----------------------------------------------------------------------------------
[EMAIL PROTECTED] bin]$ sh ./updatedb.sh password
[0%] Building database.................
[30%] Database built successfully.
[70%] The adjustment of the existing items failed: could not execute
update query
net.sf.basedb.core.BaseException: could not execute update query
at
net.sf.basedb.core.HibernateUtil.executeUpdate(HibernateUtil.java:1140)
at net.sf.basedb.core.Update.adjustExistingItems(Update.java:877)
at net.sf.basedb.install.InitDB.main(InitDB.java:66)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute update query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:84)
at
org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)
at
org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)
at
org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at
net.sf.basedb.core.HibernateUtil.executeUpdate(HibernateUtil.java:1136)
... 2 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "trusted"
does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at
org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)
... 7 more
13:14:56,582 ERROR Application:386 - Schema version mismatch: database
schema version=12; expected=20; Please update the database with the
'updatedb.sh' script before starting BASE.
net.sf.basedb.core.BaseException: Schema version mismatch: database
schema version=12; expected=20; Please update the database with the
'updatedb.sh' script before starting BASE.
at net.sf.basedb.core.Application.start(Application.java:387)
at net.sf.basedb.core.Application.start(Application.java:302)
at net.sf.basedb.install.InitDB.main(InitDB.java:84)
-----------------------------------------------------------
Is this the symptom of the hibernate problem, or is there anything else
wrong ?
Is there anything I can do to upgrade anyway (is it required running
this script to upgrade to 2.1 ?)
Thanks in advance for your advices.
--
Emmanuel COURCELLE [EMAIL PROTECTED]
L.I.P.M. (UMR CNRS-INRA 2594/441) tel (33) 5-61-28-54-50
B.P.52627 - 31326 CASTANET TOLOSAN Cedex - FRANCE
------
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
The BASE general discussion mailing list
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
