SongKong Jaikoz

SongKong and Jaikoz Music Tagger Community Forum

'WIDTH' is not a column in table or VTI 'JAIKOZ.ARTWORK'

Seeing a lot of these in my log. Not sure if you’ve seen it before.

20/01/2011 21.50.12:com.jthink.jaikoz.data.ArtworkCache:writeToDatabase:WARNING: Failed to add Artwork because 'WIDTH' is not a column in table or VTI 'JAIKOZ.ARTWORK'.
java.sql.SQLSyntaxErrorException: 'WIDTH' is not a column in table or VTI 'JAIKOZ.ARTWORK'.
\tat org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
\tat org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
\tat org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
\tat org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
\tat org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
\tat org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
\tat org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
\tat org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
\tat org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
\tat org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
\tat org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
\tat org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
\tat org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
\tat java.lang.reflect.Method.invoke(Method.java:597)
\tat com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooStatementCache.java:525)
\tat com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.sql.SQLException: 'WIDTH' is not a column in table or VTI 'JAIKOZ.ARTWORK'.
\tat org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
\tat org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
\t... 19 more
Caused by: ERROR 42X14: 'WIDTH' is not a column in table or VTI 'JAIKOZ.ARTWORK'.
\tat org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
\tat org.apache.derby.impl.sql.compile.ResultColumn.bindResultColumnByName(Unknown Source)
\tat org.apache.derby.impl.sql.compile.ResultColumnList.bindResultColumnsByName(Unknown Source)
\tat org.apache.derby.impl.sql.compile.InsertNode.bindStatement(Unknown Source)
\tat org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
\tat org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
\tat org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
\t... 13 more

Jaikoz 3.8.3 using Java 1.6.0_20 16.3-b01-279 64bit on Mac OS X 10.5.8 x86_64

Yes, you need to delete your db as described in http://www.jthink.net/jaikozforum/posts/list/1246.page