db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramesh reddy Etta <etta.ram...@gmail.com>
Subject java.sql.SQLException: <column name> is not a column in table or VTI <app.table name>
Date Fri, 19 Mar 2010 05:41:49 GMT

We are connecting to embedded derby and trying to execute this test. It
intially used to pass, but after adding a column "LAST_UPLOAD_TIME" the
following is the error. Please help.

Failed
client.dao.ResourceUploadDaoTest.getResourcePartialUpload (from
ResourceUploadDaoTest) 

Failing for the past 6 builds (Since #540 ) 
Took 92 ms.
add description

Error Message
could not insert: [client.data.ResourceUpload]; nested exception is
org.hibernate.exception.SQLGrammarException: could not insert:
[client.data.ResourceUpload]
Stacktrace
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
insert: [client.data.ResourceUpload]; nested exception is
org.hibernate.exception.SQLGrammarException: could not insert:
[client.data.ResourceUpload]
	at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
	at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	at
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
	at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
	at
client.dao.impl.ResourceUploadDaoImpl.resourceUploadExists(ResourceUploadDaoImpl.java:50)
	at
client.dao.impl.ResourceUploadDaoImpl.create(ResourceUploadDaoImpl.java:38)
	at
client.dao.impl.ResourceUploadDaoImpl.create(ResourceUploadDaoImpl.java:29)
	at client.dao.ResourceUploadDaoTest.loadData(ResourceUploadDaoTest.java:65)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.runBefores(SpringMethodRoadie.java:273)
	at
org.springframework.test.context.junit4.SpringMethodRoadie$RunBeforesThenTestThenAfters.run(SpringMethodRoadie.java:332)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.runWithRepetitions(SpringMethodRoadie.java:217)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.runTest(SpringMethodRoadie.java:197)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.run(SpringMethodRoadie.java:143)
	at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:160)
	at
org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
	at
org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
	at
org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
	at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
	at
org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
	at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
	at
org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
	at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
	at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:165)
	at org.apache.maven.surefire.Surefire.run(Surefire.java:107)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:289)
	at
org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1005)
Caused by: org.hibernate.exception.SQLGrammarException: could not insert:
[client.data.ResourceUpload]
	at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
	at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285)
	at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)
	at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
	at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
	at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:997)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1590)
	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
	at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:328)
	at
client.dao.impl.ResourceUploadDaoImpl$1.doInHibernate(ResourceUploadDaoImpl.java:54)
	at
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
	... 31 more
Caused by: java.sql.SQLException: 'LAST_UPLOAD_TIME' is not a column in
table or VTI 'APP.RSRC_RESOURCE_UPLOAD'.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
	at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
	at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
	at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
	at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
	at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)
	at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
	at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
	at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)
	... 44 more

Standard Output
Hibernate: select count(*) as y0_ from rsrc_resource_upload this_ where
this_.uploadurl=?
Hibernate: insert into rsrc_resource_upload (created, deleted, uploadurl,
partial_uploadurl, uploaded, is_partial_upload, checksum, workspace, job,
bundle, workflow_instance, task, last_upload_time, resource_upload_id)
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

http://old.nabble.com/file/p27950901/ResourceUpload.hbm.xml
ResourceUpload.hbm.xml 
-- 
View this message in context: http://old.nabble.com/java.sql.SQLException%3A-%3Ccolumn-name%3E-is-not-a-column-in-table-or-VTI-%3Capp.table-name%3E-tp27950901p27950901.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message