Unsupported upgrade Exception when running a test

[Suran Jayathilaka <su...@gmail.com>]

Hi,
I got an svn update and did "ant clobber", "ant" and tried to run a test class.
I get the following exception.

Exception in thread "main" java.sql.SQLException: Failed to start
database 'wombat', see the next exception for details.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
        at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:223)
        at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:2611)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:365)
        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
        at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:80)
        at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:238)
        at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at LengthLargeClob.main(LengthLargeClob.java:10)
Caused by: java.sql.SQLException: Unsupported upgrade from '10.4' to
'10.5 beta'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
        at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:2609)
        ... 8 more
Caused by: ERROR XCW00: Unsupported upgrade from '10.4' to '10.5 beta'.
        at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:303)
        at org.apache.derby.iapi.services.monitor.Monitor.isFullUpgrade(Monitor.java:725)
        at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(DD_Version.java:201)
        at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTables(DataDictionaryImpl.java:6931)
        at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(DataDictionaryImpl.java:740)
        at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:2000)
        at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:291)
        at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:554)
        at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:427)
        at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:214)
        at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:2000)
        at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:291)
        at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1837)
        at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1703)
        at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1583)
        at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:1002)
        at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:550)
        at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:2572)
        ... 8 more

Does anyone know what might be causing this and how I can rectify it?
Thanks.
Suran

Re: Unsupported upgrade Exception when running a test

[Bryan Pendleton <bp...@amberpoint.com>]

> Exception in thread "main" java.sql.SQLException: Failed to start
> database 'wombat', see the next exception for details.

> Caused by: java.sql.SQLException: Unsupported upgrade from '10.4' to
> '10.5 beta'.

> Caused by: ERROR XCW00: Unsupported upgrade from '10.4' to '10.5 beta'.

> Does anyone know what might be causing this and how I can rectify it?

Many of the tests tend to use the database 'wombat' as their test db.
It sounds like you were recently running some tests with Derby 10.4
and then switched to using the trunk code, but the old database
was still present.

The easiest thing to do is just remove the old database: 'rm -r wombat'
or on Windows 'rmdir /s wombat'.

thanks,

bryan

P.S. I am sort of in the habit of always going to a special
directory called 'tests' when I'm running various Derby tests.
Then I periodically do 'cd tests; rm -r *' to start fresh with
a new set of code.