[EJB 3.0] - Re: ORA-00904
by Ceene
I have renamed my user-variable but know i get a new error-code
| 11:29:59,093 ERROR [SessionFactoryImpl] Error in named query: LOV_USER.findByName
| org.hibernate.QueryException: could not resolve property: nutzer of: tcejb.LOV_User [SELECT l FROM tcejb.LOV_User l WHERE l.nutzer = ?1 ]
| at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(AbstractPropertyMapping.java:43)
| .......
|
My new EntityBean
| package tcejb;
|
| import javax.persistence.*;
|
| @Entity
| @NamedQueries({
| @NamedQuery(name="LOV_USER.findByName",
| query="SELECT l FROM LOV_User l WHERE l.nutzer = ?1 ")
| })
| @Table(name="LOV_USER")
| public class LOV_User implements java.io.Serializable {
|
| private static final long serialVersionUID = 1;
|
| private String nutzer;
| private String user_name;
| private String user_password;
| private int admin_sign;
| private String status_sign;
| private String new_date;
| private String update_date;
| private String last_user;
|
| @Id
| @Column(name="LOV_USR_USER")
| public String getUser() {return nutzer;}
| public void setUser(String benutzer) {this.nutzer = benutzer;}
|
| @Column(name="LOV_USR_USER_NAME")
| public String getUserName() {return user_name;}
| public void setUserName(String user_name) {this.user_name = user_name;}
|
| @Column(name="LOV_USR_USER_PASSWORD")
| public String getUserPassword() {return user_password;}
| public void setUserPassword(String user_password) {this.user_password = user_password;}
|
| @Column(name="LOV_USR_ADMIN_SIGN")
| public int getAdminSign() {return admin_sign;}
| public void setAdminSign(int admin_sign) {this.admin_sign = admin_sign;}
|
| @Column(name="LOV_USR_STAUS_SIGN")
| public String getStatusSign() {return status_sign;}
| public void setStatusSign(String status_sign) {this.status_sign = status_sign;}
|
| @Column(name="LOV_USR_NEW_DATE")
| public String getNewDate() {return new_date;}
| public void setNewDate(String new_date) {this.new_date = new_date;}
|
| @Column(name="LOV_USR_UPDATE_DATE")
| public String getUpdateDate() {return update_date;}
| public void setUpdateDate(String update_date) {this.update_date = update_date;}
|
| @Column(name="LOV_USR_LAST_USER")
| public String getLastUser() {return last_user;}
| public void setLastUser(String last_user) {this.last_user = last_user;}
| }
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135234#4135234
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4135234
18 years, 1 month
[EJB/JBoss] - transaction roll back and an error
by raj_kollasseril
I am using Hibernate 3, Jboss 3.2.3 and mysql 5 I got a
transaction roll back and an error which I donot really know what it is.
Any hint or help is appreciated.
Here is the error
null; nested exception is: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=localhost.localdomain//9823, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (java.lang.IllegalStateException: No security context set); - nested throwable: (org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=localhost.localdomain//9823, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (java.lang.IllegalStateException: No security context set))
org.jboss.tm.JBossTransactionRolledbackException: null; nested exception is: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=localhost.localdomain//9823, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (java.lang.IllegalStateException: No security context set); - nested throwable: (org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=localhost.localdomain//9823, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (java.lang.IllegalStateException: No security context set)) at org.jboss.ejb.plugins.TxInterceptorCMT.throwJBossException(TxInterceptorCMT.java:552) at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:463) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:326) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:150) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331) at org.jboss.ejb.Container.invoke(Container.java:709) at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:198) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97) at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:115) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:101) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55) at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86) at $Proxy217.addYearOfStudy(Unknown Source) at com.amritatech.aums.academics.controllers.YearOfStudyController.addYearOfStudy(YearOfStudyController.java:225) at com.amritatech.aums.academics.controllers.YearOfStudyController.doPageRequested(YearOfStudyController.java:172) at org.amma.aitf.hmoscore.ui.controller.BaseController.pageRequested(BaseController.java:439) at com.salmonllc.html.HtmlPage.notifyListeners(HtmlPage.java:1159) at com.salmonllc.jsp.JspController.notifyListeners(JspController.java:973) at com.salmonllc.jsp.JspController.doGet(JspController.java:589) at com.salmonllc.jsp.tags.PageTag.doStartTag(PageTag.java:215) at org.apache.jsp.Jsp.AcademicMaster.YearOfStudy_jsp._jspx_meth_jade_page_0(YearOfStudy_jsp.java:174) at org.apache.jsp.Jsp.AcademicMaster.YearOfStudy_jsp._jspService(YearOfStudy_jsp.java:126) at com.salmonllc.jsp.JspServlet.service(JspServlet.java:328) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Caused by: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=localhost.localdomain//9823, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (java.lang.IllegalStateException: No security context set) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:415) at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:458) ... 71 more Caused by: java.lang.IllegalStateException: No security context set at org.jboss.ejb.EnterpriseContext$EJBContextImpl.getCallerPrincipal(EnterpriseContext.java:276) at com.amritatech.common.util.AumsSessionBean.onFlushDirty(AumsSessionBean.java:127) at org.amma.aitf.hmoscore.services.HibernateInterceptor.onFlushDirty(HibernateInterceptor.java:171) at org.hibernate.event.def.DefaultFlushEntityEventListener.invokeInterceptor(DefaultFlushEntityEventListener.java:318) at org.hibernate.event.def.DefaultFlushEntityEventListener.handleInterception(DefaultFlushEntityEventListener.java:294) at org.hibernate.event.def.DefaultFlushEntityEventListener.scheduleUpdate(DefaultFlushEntityEventListener.java:234) at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:114) at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:195) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333) at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59) at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1362) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:347) ... 72 more
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135226#4135226
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4135226
18 years, 1 month
[EJB 3.0] - ORA-00904
by Ceene
Hi
I have a problem with my EntityBean but i don't know why. I hapoe somebody can help me.
Ouput in the JBoss-Console
| 10:43:14,296 WARN [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000
| 10:43:14,296 ERROR [JDBCExceptionReporter] ORA-00904: Ungültiger Spaltenname
|
My EntityBean "LOV_User.java"
| package tcejb;
|
| import javax.persistence.*;
|
| @Entity
| @NamedQueries({
| @NamedQuery(name="LOV_USER.findByName",
| query="SELECT l FROM LOV_User l WHERE l.user = ?1 ")
| })
| @Table(name="LOV_USER")
| public class LOV_User implements java.io.Serializable {
|
| private static final long serialVersionUID = 1;
|
| private String user;
| private String user_name;
| private String user_password;
| private int admin_sign;
| private String status_sign;
| private String new_date;
| private String update_date;
| private String last_user;
|
| @Id
| @Column(name="LOV_USR_USER")
| public String getUser() {return user;}
| public void setUser(String user) {this.user = user;}
|
| @Column(name="LOV_USR_USER_NAME")
| public String getUserName() {return user_name;}
| public void setUserName(String user_name) {this.user_name = user_name;}
|
| @Column(name="LOV_USR_USER_PASSWORD")
| public String getUserPassword() {return user_password;}
| public void setUserPassword(String user_password) {this.user_password = user_password;}
|
| @Column(name="LOV_USR_ADMIN_SIGN")
| public int getAdminSign() {return admin_sign;}
| public void setAdminSign(int admin_sign) {this.admin_sign = admin_sign;}
|
| @Column(name="LOV_USR_STAUS_SIGN")
| public String getStatusSign() {return status_sign;}
| public void setStatusSign(String status_sign) {this.status_sign = status_sign;}
|
| @Column(name="LOV_USR_NEW_DATE")
| public String getNewDate() {return new_date;}
| public void setNewDate(String new_date) {this.new_date = new_date;}
|
| @Column(name="LOV_USR_UPDATE_DATE")
| public String getUpdateDate() {return update_date;}
| public void setUpdateDate(String update_date) {this.update_date = update_date;}
|
| @Column(name="LOV_USR_LAST_USER")
| public String getLastUser() {return last_user;}
| public void setLastUser(String last_user) {this.last_user = last_user;}
| }
|
My StatefulBean
| package tcejb;
|
| import java.util.List;
| import java.util.Vector;
| import javax.ejb.*;
| import javax.persistence.*;
|
| @Stateful
| public class LoginBean implements LoginRemote {
| @PersistenceContext(unitName="tcdb")
| private EntityManager manager;
|
| private String user;
|
| @TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)
| public void initialisieren(String key) {
| Query query = manager.createNamedQuery("LOV_USER.findByName");
| query.setParameter(1, key);
| List liste = query.getResultList();
| Vector<LOV_User> erg = new Vector<LOV_User>();
| for(Object o : liste)
| {
| erg.add((LOV_User) o);
| }
| user = erg.toString();
| }
|
| @TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)
| public String getUser() {return user;}
|
| @Remove
| public void remove() {
|
| }
|
| }
|
Please somebody get me a solution. I have no idea why the Column name is not ok. If i write the column-name from the database-table the same message pop up.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135225#4135225
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4135225
18 years, 1 month