При нажатии на касный кводрат появился список произошедших ошибок:
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363)
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:291)
at $Proxy103.getGuideRecords(Unknown Source)
at com.epam.sono.app.delegate.GuidesDelegateImpl.getGuideRecords(GuidesDelegateImpl.java:55)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoSearchOnServerPage.getTaxOrgs(FnoSearchOnServerPage.java:339)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoSearchOnServerPage.initCriteriaArea(FnoSearchOnServerPage.java:266)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoSearchOnServerPage.init(FnoSearchOnServerPage.java:134)
at com.epam.sono.desktop2.modules.fnocompletion.np.pages.MyFnoPage.init(MyFnoPage.java:44)
at com.epam.sono.desktop2.api.ZRootModulePage.showBtnStylePage(ZRootModulePage.java:301)
at com.epam.sono.desktop2.api.ZRootModulePage.init(ZRootModulePage.java:111)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPModule.init(FnoCompletionNPModule.java:135)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPModule.initStartPage(FnoCompletionNPModule.java:147)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPModule.activate(FnoCompletionNPModule.java:196)
at com.epam.sono.desktop2.shell.ModuleManager.activate(ModuleManager.java:127)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPModule.showPage(FnoCompletionNPModule.java:217)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPMenu$MyFnoActionListener.actionPerformed(FnoCompletionNPMenu.java:107)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
at com.epam.sono.desktop2.controls.zswingcontrols.JSafeMenuItem.doClick(JSafeMenuItem.java:84)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1000)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1041)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at com.epam.sono.desktop2.shell.health.EventQueueProxy.dispatchEvent(EventQueueProxy.java:30)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:637)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:74)
at com.epam.sono.business.server.impl.AbstractPersistingService.getNamedQueryResultList(AbstractPersistingService.java:258)
at com.epam.sono.business.server.impl.AbstractPersistingService.getNamedQueryResultList(AbstractPersistingService.java:239)
at com.epam.sono.business.server.impl.GuidesServiceImpl.getGuideRecords(GuidesServiceImpl.java:90)
at com.epam.sono.facade.ejb.impl.GuidesFacadeBean.getGuideRecords(GuidesFacadeBean.java:28)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at com.epam.sono.facade.ejb.util.AuditEjbInterceptor.intercept(AuditEjbInterceptor.java:75)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at com.epam.sono.facade.ejb.util.FacadeLogger.intercept(FacadeLogger.java:50)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at com.epam.sono.facade.ejb.util.SecurityIntercepter.intercept(SecurityIntercepter.java:92)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:67)
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:211)
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:169)
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:217)
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:77)
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:286)
... 42 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2216)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: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.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)
... 79 more
Caused by: java.sql.SQLException: Column not found: TAXORG0_.CERT_SERIES_ID in statement [/* named HQL query TaxOrg.findAll */ select taxorg0_.ID as ID57_, taxorg0_.CERT_SERIES_ID as CERT17_57_, taxorg0_.ALIAS_NK as ALIAS2_57_, taxorg0_.CODE_NK as CODE3_57_, taxorg0_.NAME_KAZ as NAME4_57_, taxorg0_.NAME_RUS as NAME5_57_, taxorg0_.PARENT_CODE_NK as PARENT6_57_, taxorg0_.ID_INIS as ID7_57_, taxorg0_.INACTIVE_FLAG as INACTIVE8_57_, taxorg0_.LEGAL_ADDRES as LEGAL9_57_, taxorg0_.LAST_UPDATE as LAST10_57_, taxorg0_.MNAME_MANAGER as MNAME11_57_, taxorg0_.FNAME_MANAGER as FNAME12_57_, taxorg0_.LNAME_MANAGER as LNAME13_57_, taxorg0_.IS_ACTIV as IS14_57_, taxorg0_.RNN_NK as RNN15_57_, taxorg0_.SONO_CHANGE_DT as SONO16_57_ from TAX_ORG taxorg0_]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:250)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:250)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
... 87 more
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363)
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:291)
at $Proxy103.getGuideRecords(Unknown Source)
at com.epam.sono.app.delegate.GuidesDelegateImpl.getGuideRecords(GuidesDelegateImpl.java:55)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoSearchOnServerPage.getTaxOrgs(FnoSearchOnServerPage.java:339)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoSearchOnServerPage.initCriteriaArea(FnoSearchOnServerPage.java:266)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoSearchOnServerPage.init(FnoSearchOnServerPage.java:134)
at com.epam.sono.desktop2.modules.fnocompletion.np.pages.MyFnoPage.init(MyFnoPage.java:44)
at com.epam.sono.desktop2.api.ZRootModulePage.showBtnStylePage(ZRootModulePage.java:301)
at com.epam.sono.desktop2.api.ZRootModulePage.init(ZRootModulePage.java:111)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPModule.init(FnoCompletionNPModule.java:135)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPModule.initStartPage(FnoCompletionNPModule.java:147)
at com.epam.sono.desktop2.modules.fnocompletion.np.FnoCompletionNPModule.activate(FnoCompletionNPModule.java:196)
at com.epam.sono.desktop2.shell.ModuleManager.activate(ModuleManager.java:125)
at com.epam.sono.desktop2.shell.np.SonoClientNP.tryFirstAuthentication(SonoClientNP.java:135)
at com.epam.sono.desktop2.shell.np.SonoClientNP$5.run(SonoClientNP.java:117)
at java.lang.Thread.run(Thread.java:595)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at com.epam.sono.desktop2.shell.health.EventQueueProxy.dispatchEvent(EventQueueProxy.java:30)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:637)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:74)
at com.epam.sono.business.server.impl.AbstractPersistingService.getNamedQueryResultList(AbstractPersistingService.java:258)
at com.epam.sono.business.server.impl.AbstractPersistingService.getNamedQueryResultList(AbstractPersistingService.java:239)
at com.epam.sono.business.server.impl.GuidesServiceImpl.getGuideRecords(GuidesServiceImpl.java:90)
at com.epam.sono.facade.ejb.impl.GuidesFacadeBean.getGuideRecords(GuidesFacadeBean.java:28)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at com.epam.sono.facade.ejb.util.AuditEjbInterceptor.intercept(AuditEjbInterceptor.java:75)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at com.epam.sono.facade.ejb.util.FacadeLogger.intercept(FacadeLogger.java:50)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at com.epam.sono.facade.ejb.util.SecurityIntercepter.intercept(SecurityIntercepter.java:92)
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:585)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:67)
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:211)
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:169)
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:217)
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:77)
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:286)
... 23 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2216)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: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.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)
... 60 more
Caused by: java.sql.SQLException: Column not found: TAXORG0_.CERT_SERIES_ID in statement [/* named HQL query TaxOrg.findAll */ select taxorg0_.ID as ID57_, taxorg0_.CERT_SERIES_ID as CERT17_57_, taxorg0_.ALIAS_NK as ALIAS2_57_, taxorg0_.CODE_NK as CODE3_57_, taxorg0_.NAME_KAZ as NAME4_57_, taxorg0_.NAME_RUS as NAME5_57_, taxorg0_.PARENT_CODE_NK as PARENT6_57_, taxorg0_.ID_INIS as ID7_57_, taxorg0_.INACTIVE_FLAG as INACTIVE8_57_, taxorg0_.LEGAL_ADDRES as LEGAL9_57_, taxorg0_.LAST_UPDATE as LAST10_57_, taxorg0_.MNAME_MANAGER as MNAME11_57_, taxorg0_.FNAME_MANAGER as FNAME12_57_, taxorg0_.LNAME_MANAGER as LNAME13_57_, taxorg0_.IS_ACTIV as IS14_57_, taxorg0_.RNN_NK as RNN15_57_, taxorg0_.SONO_CHANGE_DT as SONO16_57_ from TAX_ORG taxorg0_]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:250)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:250)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
... 68 more
Кнопка отослать отчет не активна.
Может это поможет разобраться с програмными ошибками.
Если нашли решение подскажите пожалуйсто
.
Такая прошка (ее написание) занимает 2 минуты - минутка на саму прошку и минутка на кнопочку. Пользуюсь 9 месяцев и никогда не зависало на заставке и вообще никаких проблем. 
Кайрат-F2 » 02 апр 2010, 14:43
![[Новость]](http://bb.f2.kz/ru/styles/prosilver/imageset/icon_topic_reported.gif "[Новость]"){kind=icon}