autogenerated queries/finders
Why Orion generates a query for findByApplication, but not for findByUsername? It would be great if Orion can autogenerate queries for findByApplicationUsername, for example. What do you say? This is from orion-ejb-jar.xml: entity-deployment name=User location=User wrapper=UserHome_EntityHomeWrapper26 table=User data-source=jdbc/HypersonicDS primkey-mapping cmp-field-mapping name=id persistence-name=id / /primkey-mapping cmp-field-mapping name=application persistence-name=application / cmp-field-mapping name=username persistence-name=username / cmp-field-mapping name=password persistence-name=password / cmp-field-mapping name=timestamp persistence-name=timestamp / finder-method query= !-- Generated SQL: select User.id, User.application, User.username, User.password, User.timestamp from User -- method ejb-nameUser/ejb-name method-namefindAll/method-name method-params /method-params /method /finder-method finder-method query=$application = $1 !-- Generated SQL: select User.id, User.application, User.username, User.password, User.timestamp from User where User.application = ? -- method ejb-nameUser/ejb-name method-namefindByApplication/method-name method-params method-paramjava.lang.String/method-param /method-params /method /finder-method finder-method query= !-- Generated SQL: select User.id, User.application, User.username, User.password, User.timestamp from User -- method ejb-nameUser/ejb-name method-namefindByUsername/method-name method-params method-paramjava.lang.String/method-param /method-params /method /finder-method finder-method query= !-- Generated SQL: select User.id, User.application, User.username, User.password, User.timestamp from User -- method ejb-nameUser/ejb-name method-namefindByApplicationUsername/method-name method-params method-paramjava.lang.String/method-param method-paramjava.lang.String/method-param /method-params /method /finder-method ejb-ref-mapping name=ejb/UIDSession / /entity-deployment
Problems with cluster.
Hello, I have some applications running in two Orions servers with the cluster configured. My problem is that the cluster only works for the default application and not for the others. When I use the others applications I look that the server that recieve the request send the cluster message but the other server not recieve this, onlye recieve a message but not the cluster message for update. What is the problem? . Thanks.
Fw: [smq3beta] MDB
There is a thread going on the swiftmq 3 beta mailing list about MDBs and SwiftMQ. While the resource-provider technique works for MDBs (my MDB gets the message), other folks wonder about transactions when using the technique described on the orionserver site. Does anyone know about XA transaction support in this case ? - Renaud - Original Message - From: Andreas Mueller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 8:28 AM Subject: [smq3beta] MDB That's great! It seems Orion doesn't need ASF to drive the MDBs. For the other question: The usual way to drive MDBs is to use the JMS provider's application server facilities (ASF) in conjunction with distributed transactions (XA). These things are specified in chapter 8 of the JMS spec. It is optional for a JMS provider to implement it. SwiftMQ doesn't implement it to avoid to the effort to support the different plug- in interfaces of the various container provider, because the contract between container and JMS provider is unspecified (the JMS spec describes only behaviors). There is also a transaction flow problematic which has to be addressed.
Weird Transaction Problem
I have this EJB transaction related problem (Orion 1.5.2, DB2 V7.1) : I have 2 EJBs: 1) UserSession (Stateless session bean) trans-attribute: Required transaction-type : Container 2) User (BMP entity bean) trans-attribute: Mandatory My client makes a call to a method in UserSession which in turns call User. In User EJB, the method will get a connection: Connection cn = ds.getConnection(..); cn.setAutoCommit(false); After performing database operation, connection is closed: cn.close(); At this point an exception is raised: === exception == javax.transaction.TransactionRolledbackException: java.rmi.RemoteException: SQLException.; nested exception is: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000 CLI0116E Invalid transaction state. : exception== I looked up DB2 documentation and the following was the explanation: Explanation: There was a transaction in progress when SQLDisconnect was called. User Response: Call SQLTransact before calling SQLDisconnect. Has anyone encountered similar problems before? Thanks. ps. I attached my data-sources.xml just in case there was a misconfig of datasource. data-source class=com.evermind.sql.DriverManagerDataSource name=DB2 location=jdbc/DB2CoreDS xa-location=jdbc/DB2XADS ejb-location=jdbc/DB2DS connection-driver=COM.ibm.db2.jdbc.app.DB2Driver username=db2inst1 password=db2inst1 url=jdbc:db2:sbn schema=database-schemas/db2.xml inactivity-timeout=30 / __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
Auto-reply: Fw: [smq3beta] MDB
Please contact my manager Wendy Liau (650.506.8364) for any issues. Sam ---BeginMessage--- There is a thread going on the swiftmq 3 beta mailing list about MDBs and SwiftMQ. While the resource-provider technique works for MDBs (my MDB gets the message), other folks wonder about transactions when using the technique described on the orionserver site. Does anyone know about XA transaction support in this case ? - Renaud - Original Message - From: Andreas Mueller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 8:28 AM Subject: [smq3beta] MDB That's great! It seems Orion doesn't need ASF to drive the MDBs. For the other question: The usual way to drive MDBs is to use the JMS provider's application server facilities (ASF) in conjunction with distributed transactions (XA). These things are specified in chapter 8 of the JMS spec. It is optional for a JMS provider to implement it. SwiftMQ doesn't implement it to avoid to the effort to support the different plug- in interfaces of the various container provider, because the contract between container and JMS provider is unspecified (the JMS spec describes only behaviors). There is also a transaction flow problematic which has to be addressed. ---End Message---
Re: redirecting console output to log file
Nimmons, Buster wrote: Is there a setting anywhere to redirect the output from the console of the machine running orion to a log file. You have two possibilities: - Use the redirection: java -jar orion.jar logfile.log 21 - Check orion.jar options: java -jar orion.jar -? You can redirect stdout or stderr to any file, like this: java -jar orion.jar -out orion.out -err orion.err -- ·· Juan Fuentes Nieto Essi Projects [EMAIL PROTECTED]t +34 977 221 182 http://www.essiprojects.com f +34 977 230 170 ··
Re: Weird Transaction Problem
Herman Rashid wrote: I have this EJB transaction related problem (Orion 1.5.2, DB2 V7.1) : I have 2 EJBs: 1) UserSession (Stateless session bean) trans-attribute: Required transaction-type : Container 2) User (BMP entity bean) trans-attribute: Mandatory My client makes a call to a method in UserSession which in turns call User. In User EJB, the method will get a connection: Connection cn = ds.getConnection(..); cn.setAutoCommit(false); After performing database operation, connection is closed: cn.close(); At this point an exception is raised: === exception == javax.transaction.TransactionRolledbackException: java.rmi.RemoteException: SQLException.; nested exception is: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000 CLI0116E Invalid transaction state. : [snip] Hi Herman. The first (obvious) question is, before you did cn.close(), did you do cn.commit()? -Steve -- Stephen Davidson Java Consultant Delphi Consultants, LLC http://www.delphis.com Phone: 214-696-6224 x208
Re: OrionRemoteException: Error (de-)serializing object
Use a disconnected RowSet; that's what they were
designed for. You won't
have to modify your application because RowSet
extends ResultSet!!
- Original Message -
From:
Andres
Garcia Hourcade
To: Orion-Interest
Sent: Monday, November 26, 2001 10:41
AM
Subject: OrionRemoteException: Error
(de-)serializing object
Hi, i am new in J2EE technology and i'm big troubles.
I have an intranet application (jsp ejb) running fine with version
1.4.0,
i am trying to deploy the same EAR in 1.5.2 version, but i get this
error.
com.evermind.server.rmi.OrionRemoteException: Error (de-)serializing
object:
org.gjt.mm.mysql.jdbc2.ResultSet; nested exception is:
java.io.NotSerializableException: org.gjt.mm.mysql.jdbc2.ResultSet
This error occurs when i return a ResultSet from a method "executeQuery"
of
an EJB that manages de mysql db.
I have written many jsp, that are in production, and i woud not want to
modify them.
Is there any solution for this error ?
Can i solve this problem if i return a Vector, instead of a ResultSet ?
Many thanks in advance and best regards
Andres Garcia Hourcade
EJB
import java.rmi.*;
import java.util.*;
import javax.ejb.*;
import javax.naming.*;
import java.sql.*;
import javax.sql.*;
import javax.sql.DataSource;
// ejb que maneja archivos de log
import Log.*;
public class DbManagerBean implements SessionBean
{
transient SessionContext context;
transient Connection conn = null;
transient DataSource ds = null;
transient Statement st = null;
transient ResultSet rs = null;
public void getConnection(String datasource) throws RemoteException,
DbManagerException
{
try
{
InitialContext ictx = new InitialContext();
this.ds = (DataSource) ictx.lookup(datasource);
this.conn = this.ds.getConnection();
}
catch (Exception e)
{
throw new DbManagerException(e);
}
}
public void closeConnection() throws RemoteException,
DbManagerException
{
try
{
this.conn.close();
}
catch (Exception e)
{
throw new DbManagerException(e);
}
}
public ResultSet executeQuery(String strsql, String logonuser) throws
RemoteException, DbManagerException
{
st = null;
rs = null;
try
{
//ResultSet.TYPE_SCROLL_INSENSITIVE,
//ResultSet.CONCUR_READ_ONLY
this.st = this.conn.createStatement();
try{
// logeo la consulta
InitialContext context = new InitialContext();
LogHome logHome = (LogHome)
javax.rmi.PortableRemoteObject.narrow(context.lookup("Log"),
LogHome.class);
Log log = logHome.create();
log.writeDebug(strsql, logonuser);
log.remove();
}
catch (Exception e)
{
throw new DbManagerException(e);
}
rs = this.st.executeQuery(strsql);
// the closing of a statement also closes all
// the resultsets asociated with the statement
st.close();
}
catch (SQLException e)
{
throw new DbManagerException(e, this.conn);
}
return (rs);
}
public void ejbPassivate(){
context = null;
conn = null;
ds = null;
st = null;
rs = null;
}
public void ejbActivate()
{
}
public void ejbRemove()
{
}
public void ejbCreate()
{
}
public void setSessionContext(SessionContext context)
{
this.context = context;
}
}
Re: Weird Transaction Problem
Herman Rashid wrote: I have this EJB transaction related problem (Orion 1.5.2, DB2 V7.1) : I have 2 EJBs: 1) UserSession (Stateless session bean) trans-attribute: Required transaction-type : Container 2) User (BMP entity bean) trans-attribute: Mandatory My client makes a call to a method in UserSession which in turns call User. In User EJB, the method will get a connection: Connection cn = ds.getConnection(..); cn.setAutoCommit(false); You should not mess with the transaction when you are using CMT. Test what happens if you remove the line above. /Fredrik
User Threads
Anybody knows if user threaded application is portable to other application servers. Orion requires a specific parameter -userThreads to be passed in the command line. I know that weblogic could not handle user threads in its previous versions. I don't have any experience with other server. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
RE: redirecting console output to log file
java -jar orion.jar -? will give you the usage info. including writing output to log instead of console -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nimmons, Buster Sent: Tuesday, November 27, 2001 7:21 AM To: Orion-Interest Subject: redirecting console output to log file Is there a setting anywhere to redirect the output from the console of the machine running orion to a log file.
FW: [JBoss-user] Redux of Performance Issues
Wow. I know people have complained about this list being a little slow, but if this is what I get from the lead developer of JBoss on how to fix up JBoss performance to compare to Orion's, then ... well ... perhaps I should be spending more time on this list. I'm a little disappointed. I have some interest in both JBoss and Orion, and it's frustrating to get this kind of a response from a key player in the JBoss community. - Geoffrey : -Original Message- : From: marc fleury [mailto:[EMAIL PROTECTED]] : Sent: Tuesday, November 27, 2001 2:34 PM : To: [EMAIL PROTECTED]; [EMAIL PROTECTED] : Subject: RE: [JBoss-user] Redux of Performance Issues : : : look dude, : : get the integrated jboss-tomcat stack you are running : non-optimized out of : stack, period. : : come back when you have set it up, or don't we don't care, : : marcf : : |-Original Message- : |From: [EMAIL PROTECTED] : |[mailto:[EMAIL PROTECTED]]On Behalf Of : |[EMAIL PROTECTED] : |Sent: Tuesday, November 27, 2001 2:09 PM : |To: [EMAIL PROTECTED] : |Subject: [JBoss-user] Redux of Performance Issues : | : | : |For reasons unknown, this message hasn't been going out to the : |list. Trying : |again. : | : |-- : | : |Okay, I've clearly managed to piss off a few people by my : concerns about : |JBoss performance. : | : |Let me start out by saying that I'd be more than happy to get my : |application : |working speedily under JBoss. Orion's documentation is poor : at best, and : |JBoss is fully open-source. I have a great deal of respect : for some of : |JBoss's technology (the verifier and deployer are probably : the best I've : |seen), and where it's coming from. I chose JBoss for the initial : |development because of its reputation and my own interests. : | : |That said, if the performance I'm getting out of JBoss is : the best I can : |expect, or, at least, the best I can manage to get, then I : |absolutely cannot : |use it. Not because I think it 'sucks rocks', because it : doesn't, but : |simply because it will not support the user load I need it to in : |any sort of : |cost-effective manner. Some of you would probably be just : as happy to see : |me go somewhere else, from the tone of your emails, but I'd : personally : |rather find a way to get the performance out of JBoss, for : this or other : |projects. : | : |And, ultimately, it seems as if the performance I'm asking for is : |relatively : |reasonable. I expect a certain amount of overhead in EJB : performance, and : |I'm not asking to duplicate the speed of a bean-only : implementation. But : |supporting a maximum of 25 concurrent users on a decent (if : not maxed-out) : |server seems ... suspiciously slow. : | : |It may be that I've missed some settings to speed things up. It : |may be that : |our application's architecture is better suited to Orion : than to JBoss. : |Whatever it is, I'd like to find out. So I've joined the : JBoss list, and : |I'm here to ask some questions. I'm not trying to promote : Orion, or insult : |JBoss. I like bits of both of them, and the reasons for : that, I can get : |into another day. Ultimately, however, I'd rather support : JBoss as an : |open-source appserver, if I can. : | : |-- : | : |Now, on to the details. Some of you pointed out, and : rightly so, that I : |hadn't provided much in the way of details of what I've : tried, which is : |true. I wanted to start off by finding out if the kind of : numbers I was : |talking about seemed realistic or not, based on the : experience of people : |who'd spent more time with JBoss than I have, but it's : probably fair to say : |that you couldn't really say without knowing a lot more about my : |application. So let's get into a few details. : | : |Let's start with versions. I did some of my original EJB : |experimentation on : |JBoss-2.4.1. We started developing a project on : JBoss-2.4.1a w/ Embedded : |Tomcat, which was the latest JBoss/Tomcat grouping at the : time. We started : |noticing performance concerns then. When Tomcat 4 came out, : we moved to : |JBoss-2.4.3 w/ Embedded Catalina, so that we could try a few : things, and : |found it not to be slower, so we stayed with it. : | : |After we reached a point where we needed to see better : performance, we did : |some optimizing of our app with a profiler, and tried JBoss : 2.4.3 w/ Resin, : |which we already knew to be fast. That gave us a minor speed : |boost, but not : |very much, leading me to believe that JBoss might be the : cause of some of : |our performance. By comparison, Orion 1.5.2 seems to be : very much faster. : | : |All of this is running on Windows 2000. The versions of : Tomcat are 3.2.3 : |and 4.0, as far as I know. The version of Resin is the latest : |version as of : |a few weeks ago, I'd have to go check. If it's important, I will. : | : |Processor speed depended, but developers are working, largely, on : |PIII-700MHzs, and we did most of our
Re: FW: [JBoss-user] Redux of Performance Issues
I've been working with the swiftmq beta release (with Orion) and I have noticed that Marc Fleury has also spread his charm to the folks over on that list. The developers at Swiftmq have essentially been told to piss off by JBoss (I assume by Marc, since the tone is the same). --- [EMAIL PROTECTED] wrote: Wow. I know people have complained about this list being a little slow, but if this is what I get from the lead developer of JBoss on how to fix up JBoss performance to compare to Orion's, then ... well ... perhaps I should be spending more time on this list. I'm a little disappointed. I have some interest in both JBoss and Orion, and it's frustrating to get this kind of a response from a key player in the JBoss community. - Geoffrey : -Original Message- : From: marc fleury [mailto:[EMAIL PROTECTED]] : Sent: Tuesday, November 27, 2001 2:34 PM : To: [EMAIL PROTECTED]; [EMAIL PROTECTED] : Subject: RE: [JBoss-user] Redux of Performance Issues : : : look dude, : : get the integrated jboss-tomcat stack you are running : non-optimized out of : stack, period. : : come back when you have set it up, or don't we don't care, : : marcf : : |-Original Message- : |From: [EMAIL PROTECTED] : |[mailto:[EMAIL PROTECTED]]On Behalf Of : |[EMAIL PROTECTED] : |Sent: Tuesday, November 27, 2001 2:09 PM : |To: [EMAIL PROTECTED] : |Subject: [JBoss-user] Redux of Performance Issues : | : | : |For reasons unknown, this message hasn't been going out to the : |list. Trying : |again. : | : |-- : | : |Okay, I've clearly managed to piss off a few people by my : concerns about : |JBoss performance. : | : |Let me start out by saying that I'd be more than happy to get my : |application : |working speedily under JBoss. Orion's documentation is poor : at best, and : |JBoss is fully open-source. I have a great deal of respect : for some of : |JBoss's technology (the verifier and deployer are probably : the best I've : |seen), and where it's coming from. I chose JBoss for the initial : |development because of its reputation and my own interests. : | : |That said, if the performance I'm getting out of JBoss is : the best I can : |expect, or, at least, the best I can manage to get, then I : |absolutely cannot : |use it. Not because I think it 'sucks rocks', because it : doesn't, but : |simply because it will not support the user load I need it to in : |any sort of : |cost-effective manner. Some of you would probably be just : as happy to see : |me go somewhere else, from the tone of your emails, but I'd : personally : |rather find a way to get the performance out of JBoss, for : this or other : |projects. : | : |And, ultimately, it seems as if the performance I'm asking for is : |relatively : |reasonable. I expect a certain amount of overhead in EJB : performance, and : |I'm not asking to duplicate the speed of a bean-only : implementation. But : |supporting a maximum of 25 concurrent users on a decent (if : not maxed-out) : |server seems ... suspiciously slow. : | : |It may be that I've missed some settings to speed things up. It : |may be that : |our application's architecture is better suited to Orion : than to JBoss. : |Whatever it is, I'd like to find out. So I've joined the : JBoss list, and : |I'm here to ask some questions. I'm not trying to promote : Orion, or insult : |JBoss. I like bits of both of them, and the reasons for : that, I can get : |into another day. Ultimately, however, I'd rather support : JBoss as an : |open-source appserver, if I can. : | : |-- : | : |Now, on to the details. Some of you pointed out, and : rightly so, that I : |hadn't provided much in the way of details of what I've : tried, which is : |true. I wanted to start off by finding out if the kind of : numbers I was : |talking about seemed realistic or not, based on the : experience of people : |who'd spent more time with JBoss than I have, but it's : probably fair to say : |that you couldn't really say without knowing a lot more about my : |application. So let's get into a few details. : | : |Let's start with versions. I did some of my original EJB : |experimentation on : |JBoss-2.4.1. We started developing a project on : JBoss-2.4.1a w/ Embedded : |Tomcat, which was the latest JBoss/Tomcat grouping at the : time. We started : |noticing performance concerns then. When Tomcat 4 came out, : we moved to : |JBoss-2.4.3 w/ Embedded Catalina, so that we could try a few : things, and : |found it not to be slower, so we stayed with it. : | : |After we reached a point where we needed to see better : performance, we did : |some optimizing of our app with a profiler, and tried JBoss : 2.4.3 w/ Resin, : |which we already knew to be fast. That gave us a minor speed : |boost, but not : |very much, leading me to believe that JBoss might be the : cause of some
RE: FW: [JBoss-user] Redux of Performance Issues
Amazing! It would be one thing if this Geoffrey guy was being a jerk, but my reading of his message indicates that he approached the problem very sensitively. This coupled with Andreas' (from SwiftMQ) comment about his similar response from the JBoss folks make me think that maybe they've forgotten what made them successful in the first place...developers like you and I. -Original Message- From: Ray Harrison [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 2:54 PM To: Orion-Interest Subject: Re: FW: [JBoss-user] Redux of Performance Issues I've been working with the swiftmq beta release (with Orion) and I have noticed that Marc Fleury has also spread his charm to the folks over on that list. The developers at Swiftmq have essentially been told to piss off by JBoss (I assume by Marc, since the tone is the same). --- [EMAIL PROTECTED] wrote: Wow. I know people have complained about this list being a little slow, but if this is what I get from the lead developer of JBoss on how to fix up JBoss performance to compare to Orion's, then ... well ... perhaps I should be spending more time on this list. I'm a little disappointed. I have some interest in both JBoss and Orion, and it's frustrating to get this kind of a response from a key player in the JBoss community. - Geoffrey
Debugging JSP
Hi all, How do you debug jsp using Orion ? I have managed to get debugging going for servlets/ejb, but not JSP since I don't know the internal of Orion's JSP.. All help appreciated. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
Attaching a Web App to root context
Hi everyone, I am trying to attach my own web application to the root context, ie I want to access my web application like this: http://myserver/myindex.html instead of: http://myserver/myapp/myindex.html which has been shown in the examples. So far I have achieved this by changing this line in default-web-site.xml: default-web-app application=default name=defaultWebApp / To this line: default-web-app application=myapp name=myapp / Also I deployed my application as an ear file and put the following line in server.xml: application name=myapp path=../applications/myapp.ear / The web application seems to work as I can access html, jsp and servlets BUT I can't get servlet forwards to JSP working. It made me wonder if I've configured the whole thing wrongly. Thank you all __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
Re: FW: [JBoss-user] Redux of Performance Issues
Sounds to me like the lead developer of JBoss is a fifteen year old kid who is too busy watching MTV to bother with a serious reply to your posting. tim. Wow. I know people have complained about this list being a little slow, but if this is what I get from the lead developer of JBoss on how to fix up JBoss performance to compare to Orion's, then ... well ... perhaps I should be spending more time on this list. I'm a little disappointed. I have some interest in both JBoss and Orion, and it's frustrating to get this kind of a response from a key player in the JBoss community. - Geoffrey : -Original Message- : From: marc fleury [mailto:[EMAIL PROTECTED]] : Sent: Tuesday, November 27, 2001 2:34 PM : To: [EMAIL PROTECTED]; [EMAIL PROTECTED] : Subject: RE: [JBoss-user] Redux of Performance Issues : : : look dude, : : get the integrated jboss-tomcat stack you are running : non-optimized out of : stack, period. : : come back when you have set it up, or don't we don't care, : : marcf
