[EJB 3.0] - Re: ORA-00904
by Ceene
| 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 getNutzer() {return nutzer;}
| public void setNutzer(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;}
| }
|
|
I changed my EntityBean and now i have no user-variable.
But i get the same Error-Code as i descriped in the first posting.
| 12:21:34,453 WARN [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000
| 12:21:34,453 ERROR [JDBCExceptionReporter] ORA-00904: Ungültiger Spaltenname
|
Where is the problem? The column name in the "@Column(name="LOV_USR_USER")" ist correct.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135252#4135252
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4135252
18 years, 1 month
[JBoss Messaging] - clustered messages stuck on queues
by dave_lund
There's a good chance that this could be related to:
http://jira.jboss.org/jira/browse/JBMESSAGING-1245
Messages are getting 'stuck' in the database and I have to restart a single app server before these messages are delivered
However, this problem only seems to happen very sporadically (around every 10-14 days) on our production environment and hence im hesitent of changing the prefetchSize before asking the forum.
We are using Jboss AS 4.2.2.GA and JBM 1.4.0.SP3 backed by a mysql 5 database and JRE 6 on a debian OS. The queues are clustered over 3 servers. We are using the MessageConsumer.receive(1000) method to receive messages that runs every 1-5 seconds depending on the queue. I know this is happening as some newer messages are being delivered correctly. The queues all have the following properties set: Clustered=true and MaxDeliveryAttempts=1
Below are the queue message counts - 99% of these are messages that are stuck on the queues.
server 1: queueA=357,queueB=0,queueC=51,queueD=8
server 2: queueA=353,queueB=3,queueC=941,queueD=1
server 3: queueA=9,queueC=5,queueC=37,queueD=2
After restarting server 1 using the jboss shutdown.sh script all messages on servers2 and 3 were sent and then after starting server 1 all messages on its queues were then delivered. I would doubt our code doing the batching effect if it wasn't for this re-starting behaviour.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135251#4135251
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4135251
18 years, 1 month