Micha Bayer wrote: > 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?
I don't think so. I don't know what is happening. The message "Database built successfully" is probably not correct, because if it was, the 'Platforms' table would exists. The problem is that the part of the Hibernate code we are using to update the database never reports any problems. What you can try is to enable logging. Find the log4j.properties file in /www/WEB-INF/classes. Find the line '#log4j.logger.org.hibernate.tool.hbm2ddl=debug' and remove the '#' in front of it. Then try the update again and see what it prints out. /Nicklas > > 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] ------------------------------------------------------------------------- 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]
