Hi
I have changed a couple of column names and table names and I am getting
hte following error from a hibernate SQL query. Grepped all over but cannot
find the query which is using this "name" - possibly happening due to
role.name being changed to role.role_name. Thanks for your help! I am
running mvn -e jetty:run-war
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHan
dleFailures(DefaultLifecycleExecutor.java:311)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegmen
ts(DefaultLifecycleExecutor.java:278)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLi
fecycleExecutor.java:143)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:272)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
[testacegi] WARN [main] JDBCExceptionReporter.logExceptions(77) | SQL Error:
105
4, SQLState: 42S22
[testacegi] ERROR [main] JDBCExceptionReporter.logExceptions(78) | Unknown
colum
n 'name' in 'order clause'
[testacegi] DEBUG [main] JDBCTransaction.rollback(152) | rollback
[testacegi] DEBUG [main] JDBCTransaction.toggleAutoCommit(193) | re-enabling
aut
ocommit
[testacegi] DEBUG [main] JDBCTransaction.rollback(163) | rolled back JDBC
Connec
tion
[testacegi] DEBUG [main] ConnectionManager.afterTransaction(296) |
transaction c
ompleted on session with on_close connection release mode; be sure to close
the
session to release JDBC resources!
[testacegi] DEBUG [main] ConnectionManager.closeConnection(435) | releasing
JDBC
connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0,
glo
bally: 0)]
[testacegi] DEBUG [main] ConnectionManager.afterTransaction(296) |
transaction c
ompleted on session with on_close connection release mode; be sure to close
the
session to release JDBC resources!
2007-04-18 01:50:53.359::WARN: failed
[EMAIL PROTECTED]/,file:/C:/work/te
stacegi/target/work/webapp/}
2007-04-18 01:50:53.359::WARN: failed [EMAIL PROTECTED]
2007-04-18 01:50:53.359::WARN: failed [EMAIL PROTECTED]
2007-04-18 01:50:53.406::INFO: Started SelectChannelConnector @
0.0.0.0:8080
2007-04-18 01:50:53.406::WARN: failed [EMAIL PROTECTED]
[INFO] Jetty server exiting.
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Failure
Embedded error: could not execute query; nested exception is
org.hibernate.excep
tion.SQLGrammarException: could not execute query
Unknown column 'name' in 'order clause'
[INFO]
------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Failure
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa
ultLifecycleExecutor.java:564)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandalone
Goal(DefaultLifecycleExecutor.java:493)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(Defau
ltLifecycleExecutor.java:463)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHan
dleFailures(DefaultLifecycleExecutor.java:311)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegmen
ts(DefaultLifecycleExecutor.java:278)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLi
fecycleExecutor.java:143)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:272)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: org.apache.maven.plugin.MojoExecutionException: Failure
at
org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMo
jo.java:340)
at
org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.
java:272)
at
org.mortbay.jetty.plugin.Jetty6RunWar.execute(Jetty6RunWar.java:67)
at
org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPlugi
nManager.java:443)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa
ultLifecycleExecutor.java:539)
... 16 more
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException:
coul
d not execute query; nested exception is
org.hibernate.exception.SQLGrammarExcep
tion: could not execute query
at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHiberna
teAccessException(SessionFactoryUtils.java:613)
at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernate
AccessException(HibernateAccessor.java:412)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:372)
at
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:835)
at
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:827)
at
org.appfuse.dao.hibernate.LookupDaoHibernate.getRoles(LookupDaoHibern
ate.java:21)
at
org.appfuse.service.impl.LookupManagerImpl.getAllRoles(LookupManagerI
mpl.java:29)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:299)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:139)
at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:107)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:161)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:202)
at $Proxy32.getAllRoles(Unknown Source)
at
org.appfuse.webapp.listener.StartupListener.setupContext(StartupListe
ner.java:102)
at
org.appfuse.webapp.listener.StartupListener.contextInitialized(Startu
pListener.java:90)
at
org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.
java:447)
at
org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.jav
a:1133)
at
org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:
420)
at
org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:461
)
at
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:
38)
at
org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection
.java:156)
at
org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHan
dlerCollection.java:120)
at
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:
38)
at
org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection
.java:156)
at
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:
38)
at
org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:
119)
at org.mortbay.jetty.Server.doStart(Server.java:210)
at
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:
38)
at
org.mortbay.jetty.plugin.Jetty6PluginServer.start(Jetty6PluginServer.
java:134)
at
org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMo
jo.java:327)
... 20 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2214)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at
org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate
(HibernateTemplate.java:844)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:367)
... 52 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown
column '
name' in 'order clause'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1268)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1403)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:92)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
... 61 more
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 52 seconds
[INFO] Finished at: Wed Apr 18 01:50:53 EDT 2007
[INFO] Final Memory: 24M/44M
[INFO]
------------------------------------------------------------------------
2007-04-18 01:50:53.734::INFO: Shutdown hook executing
2007-04-18 01:50:53.734::INFO: Shutdown hook complete
--
View this message in context:
http://www.nabble.com/hibernate-error-due-to-name-change-tf3599097s2369.html#a10052690
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
