Roster demo is producing some SQLGrammarException. First time I ever saw this.

I thought someone might know of quick resolve for the release 1.1.

Checked in code is producing the following:

1. create League, then SAVE
2. EDIT League

editor quits on SQLGrammarException

Here is the pojo layout... why are these not working anymore?

League.JAVA
@OneToMany(cascade = CascadeType.ALL)
@JoinColumn(name = "officer_league_fk", insertable = true, updatable = true, nullable = true)
@Collection(child = true, inverse = "league")
@PropertyDescriptor(readOnly = false, searchable = true)
@OrderBy("lastName")
public Set<Officer> getOfficers()
{
return officers;
}

Officer.JAVA
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "officer_league_fk", insertable = false, updatable = true, nullable = true)
public League getLeague()
{
return league;
}

-----> STACK TRACE FOLLOWS:
You may continue by restarting the session.
[ +/- ] Exception: could not initialize a collection: org.trails.demo.League.officers#1
org.apache.hivemind.ApplicationRuntimeException
could not initialize a collection: org.trails.demo.League.officers#1
component: $HibernateEditPage_40@3c1[DefaultEdit] location: context:/WEB-INF/DefaultEdit.page, line 2, column 63
1 <!DOCTYPE page-specification PUBLIC "-//Apache Software Foundation//Tapestry Specification 4.0//EN" "http://jakarta.apache.org/tapestry/dtd/Tapestry_4_0.dtd">
2 <page-specification class="org.trails.page.HibernateEditPage">
3 <property name="model" persist="session"/>
4 <property name="nextPage"/>
5
6 <property name="delegator"/>
7

[ +/- ] Exception: could not initialize a collection: org.trails.demo.League.officers#1
org.hibernate.exception.SQLGrammarException
could not initialize a collection: org.trails.demo.League.officers#1
SQL: select officers0_.officer_league_fk as officer30_1_, officers0_.id as id1_, officers0_.id as id3_0_, officers0_.EApplicationRole as EApplica3_3_0_, officers0_.ERole as ERole3_0_, officers0_.accessed as accessed3_0_, officers0_.accountNonExpired as accountN6_3_0_, officers0_.accountNonLocked as accountN7_3_0_, officers0_.created as created3_0_, officers0_.credentialsNonExpired as credenti9_3_0_, officers0_.address as address3_0_, officers0_.cellPhone as cellPhone3_0_, officers0_.city as city3_0_, officers0_.country as country3_0_, officers0_.dayPhone as dayPhone3_0_, officers0_.state as state3_0_, officers0_.website as website3_0_, officers0_.zip as zip3_0_, officers0_.dob as dob3_0_, officers0_.emailAddress as emailAd19_3_0_, officers0_.enabled as enabled3_0_, officers0_.firstName as firstName3_0_, officers0_.lastName as lastName3_0_, officers0_.password as password3_0_, officers0_.photo_id as photo34_3_0_, officers0_.username as username3_0_, officers0_.EOfficerRole as EOffice26_3_0_, officers0_.officer_league_fk as officer30_3_0_ from Person officers0_ where officers0_.officer_league_fk=? order by Person.lastName asc SQLState: 42S22 errorCode: 1054 messages:

• could not initialize a collection: org.trails.demo.League.officers#1
• Unknown column 'Person.lastName' in 'order clause'

throwableCount: 2 throwables:

• org.hibernate.exception.SQLGrammarException: could not initialize a collection: org.trails.demo.League.officers#1
• com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'Person.lastName' in 'order clause'

[ +/- ] Exception: Unknown column 'Person.lastName' in 'order clause'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
Unknown column 'Person.lastName' in 'order clause'
SQLState: 42S22 errorCode: 1054
Stack Trace:

com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) com.mysql.jdbc.Connection.execSQL(Connection.java:3256) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313) com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) org.hibernate.loader.Loader.getResultSet(Loader.java:1787) org.hibernate.loader.Loader.doQuery(Loader.java:674) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) org.hibernate.loader.Loader.loadCollection(Loader.java:1994) org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36) org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565) org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60) org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716) org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344) org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86) org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:163) org.trails.component.EditCollection.buildSelectedList(EditCollection.java:139) org.trails.component.EditCollection.prepareForRender(EditCollection.java:131) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:723) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:539) org.apache.tapestry.components.Block.renderForComponent(Block.java:65) org.apache.tapestry.components.RenderBlock.renderComponent(RenderBlock.java:65) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:107) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:539) org.apache.tapestry.components.IfBean.renderComponent(IfBean.java:94) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:539) org.apache.tapestry.components.ForBean.renderComponent(ForBean.java:181) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:107) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:539) org.apache.tapestry.form.FormSupportImpl.render(FormSupportImpl.java:502) org.apache.tapestry.form.Form.renderComponent(Form.java:217) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:107) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:539) org.apache.tapestry.components.RenderBody.renderComponent(RenderBody.java:39) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:539) org.apache.tapestry.html.Body.renderComponent(Body.java:38) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:539) org.apache.tapestry.html.Shell.renderComponent(Shell.java:124) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:107) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:180) org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:107) org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:725) org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:178) org.apache.tapestry.AbstractPage.renderPage(AbstractPage.java:249) org.apache.tapestry.engine.RequestCycle.renderPage(RequestCycle.java:397) org.apache.tapestry.services.impl.DefaultResponseBuilder.renderResponse(DefaultResponseBuilder.java:152) org.apache.tapestry.services.impl.ResponseRendererImpl.renderResponse(ResponseRendererImpl.java:33) $ResponseRenderer_114f58441b7.renderResponse($ResponseRenderer_114f58441b7.java) org.apache.tapestry.engine.ExternalService.service(ExternalService.java:163) $IEngineService_114f5844236.service($IEngineService_114f5844236.java) org.apache.tapestry.services.impl.EngineServiceOuterProxy.service(EngineServiceOuterProxy.java:72) org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:237) org.apache.tapestry.services.impl.InvokeEngineTerminator.service(InvokeEngineTerminator.java:54) $WebRequestServicer_114f5844203.service($WebRequestServicer_114f5844203.java) org.trails.i18n.LocaleFilter.service(LocaleFilter.java:26) $WebRequestServicerFilter_114f5844201.service($WebRequestServicerFilter_114f5844201.java) $WebRequestServicer_114f5844205.service($WebRequestServicer_114f5844205.java) $WebRequestServicer_114f58441fd.service($WebRequestServicer_114f58441fd.java) org.apache.tapestry.services.impl.WebRequestServicerPipelineBridge.service(WebRequestServicerPipelineBridge.java:61) $ServletRequestServicer_114f58441e3.service($ServletRequestServicer_114f58441e3.java) org.apache.tapestry.request.DecodedRequestInjector.service(DecodedRequestInjector.java:55) $ServletRequestServicerFilter_114f58441df.service($ServletRequestServicerFilter_114f58441df.java) $ServletRequestServicer_114f58441e5.service($ServletRequestServicer_114f58441e5.java) org.apache.tapestry.multipart.MultipartDecoderFilter.service(MultipartDecoderFilter.java:52) $ServletRequestServicerFilter_114f58441dd.service($ServletRequestServicerFilter_114f58441dd.java) $ServletRequestServicer_114f58441e5.service($ServletRequestServicer_114f58441e5.java) org.apache.tapestry.services.impl.SetupRequestEncoding.service(SetupRequestEncoding.java:53) $ServletRequestServicerFilter_114f58441e1.service($ServletRequestServicerFilter_114f58441e1.java) $ServletRequestServicer_114f58441e5.service($ServletRequestServicer_114f58441e5.java) $ServletRequestServicer_114f58441d7.service($ServletRequestServicer_114f58441d7.java) org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:126) org.apache.tapestry.ApplicationServlet.doGet(ApplicationServlet.java:103) javax.servlet.http.HttpServlet.service(HttpServlet.java:740) javax.servlet.http.HttpServlet.service(HttpServlet.java:853) org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:491) org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1074) org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1065) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) org.trails.security.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:152) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:229) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:286) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1065) org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:365) org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:185) org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:689) org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:391) org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:146) org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139) org.mortbay.jetty.Server.handle(Server.java:285) org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:457) org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:751) org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:500) org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209) org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:357) org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:329) org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)