Hi,
I just tried to upgrade BASE on my (XP) development machine from version
2.4.6 to 2.6 and I get an error when I execute the updatedb script. It
looks like it builds the database ok but then it fails and complains
that it cannot find the table base2.platforms.
Is this the result of skipping releases between 2.4.6 and the current
one?
Here is the output from the updatedb.bat script -- any help much
appreciated.
Thanks
Micha
--System information-----------------------------
BASE : 2.6.0
Database :
jdbc:mysql://localhost/base2?useCursorFetch=true&defaultFetchSize=100
Dialect : org.hibernate.dialect.MySQLInnoDBDialect
JDBC : com.mysql.jdbc.Driver; version 5.0
Java : Java(TM) SE Runtime Environment; 1.6.0_01-b06; Sun
Microsystems Inc.
OS : Windows XP; x86; 5.1
-------------------------------------------------
Building database............
Database built successfully.11:43:04,125 ERROR Application:554 -
Exception when starting...
net.sf.basedb.core.BaseException: could not execute query
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1479)
at
net.sf.basedb.core.RawDataTypes.initPlatforms(RawDataTypes.java:117)
at net.sf.basedb.core.Application.start(Application.java:478)
at
net.sf.basedb.core.Update.adjustExistingItems(Update.java:2171)
at net.sf.basedb.install.InitDB.main(InitDB.java:75)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:
338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:17
2)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at
net.sf.basedb.core.hibernate.QueryWrapper.list(QueryWrapper.java:104)
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1475)
... 4 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'base2.platforms' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1293)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:142
8)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxy
PreparedStatement.java:76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186
)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade
r.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 13 more
The adjustment of the existing items failed: could not execute query
net.sf.basedb.core.BaseException: could not execute query
at net.sf.basedb.core.Application.start(Application.java:557)
at
net.sf.basedb.core.Update.adjustExistingItems(Update.java:2171)
at net.sf.basedb.install.InitDB.main(InitDB.java:75)
Caused by: net.sf.basedb.core.BaseException: could not execute query
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1479)
at
net.sf.basedb.core.RawDataTypes.initPlatforms(RawDataTypes.java:117)
at net.sf.basedb.core.Application.start(Application.java:478)
... 2 more
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:
338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:17
2)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at
net.sf.basedb.core.hibernate.QueryWrapper.list(QueryWrapper.java:104)
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1475)
... 4 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'base2.platforms' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1293)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:142
8)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxy
PreparedStatement.java:76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186
)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade
r.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 13 more
==================================
Dr Micha M Bayer
Bioinformatics Specialist
Genetics Programme
The Scottish Crop Research Institute
Invergowrie
Dundee
DD2 5DA
Scotland, UK
Telephone +44(0)1382 562731 ext. 2309
Fax +44(0)1382 562426
http://www.scri.ac.uk/staff/michabayer
==================================
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
SCRI, Invergowrie, Dundee, DD2 5DA.
The Scottish Crop Research Institute is a charitable company limited by
guarantee.
Registered in Scotland No: SC 29367.
Recognised by the Inland Revenue as a Scottish Charity No: SC 006662.
DISCLAIMER:
This email is from the Scottish Crop Research Institute, but the views
expressed by the sender are not necessarily the views of SCRI and its
subsidiaries. This email and any files transmitted with it are confidential
to the intended recipient at the e-mail address to which it has been
addressed. It may not be disclosed or used by any other than that addressee.
If you are not the intended recipient you are requested to preserve this
confidentiality and you must not use, disclose, copy, print or rely on this
e-mail in any way. Please notify [EMAIL PROTECTED] quoting the
name of the sender and delete the email from your system.
Although SCRI has taken reasonable precautions to ensure no viruses are
present in this email, neither the Institute nor the sender accepts any
responsibility for any viruses, and it is your responsibility to scan the email
and the attachments (if any).
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
The BASE general discussion mailing list
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
