[JBoss-user] [EJB/JBoss] - EJBQL and EJB 2.0 and Order By

2004-07-23 Thread hmae
To all, I'm using JBoss 3.2.4 and EJB 2.0. I have a EJBQL statement: "select distinct object(usr) from DWMUsrAdminSchema as usr, in (usr.userComp) as uComp where uComp.componentKey =?1 order by ?2 ". I read in another thread that JBoss extends EJBQL so that "order by ?2" would be legal even tho

[JBoss-user] [Persistence & CMP/JBoss] - transaction does not commit after server shutsdown

2004-11-04 Thread hmae
To all: I use: JBoss 3.2.4, Lomboz 2.1.3, Oracle 9i, WinXP I have web page project that adds data to a database table and show the contents of the table in the web page. I used CMP beans and I used CMT for my transactions. I tried to test what would happen if I shutdown JBoss. I did the follow

[JBoss-user] [EJB/JBoss] - Transaction XAOracleDS vs OracleDS

2004-11-09 Thread hmae
To all: Before I posted a topic: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=53288 where I was having a problem where transactions did not update the database instantaneously. I solved the problem by using OracleDS (the usual Oracle driver) instead of the recommended XAOracleDS (the

[JBoss-user] [Installation & Configuration] - Upgraded from JBoss3.2.4 to JBoss4.0

2004-11-29 Thread hmae
To all, System: JBoss 4.0, Lomboz 2.1.3, Eclipse 2.1.3, WinXP Pro I was using JBoss3.2.4 and upgraded to JBoss4.0. When I tried to rebuild/deploy with the new JBoss I was able to deploy without any errors. When I try to run my web application thru the run.bat the application does run correctly

[JBoss-user] [EJB/JBoss] - EJB QL and time comparison

2005-02-03 Thread hmae
To all: I am trying to do a comparison for a date field. My EJB QL is: select object(c) from tableschema as c where start_date between ?1 and ?2 The dates are: 01/05/2005 00:00AM and 01/05/2005 11:59 PM. I am trying to find all data that have a start_date of 1/05/2005. My program is using a dyna

[JBoss-user] [EJB/JBoss] - Re: EJB QL and time comparison

2005-02-03 Thread hmae
The EJB QL I posted was incorrect. It should have read: select object(c) from tableschema as c where c.start_date between ?1 and ?2 This is what I have, and I still need a way to pass hours and minute information. Thanks for any help you can give me. View the original post : http://www.jboss.

[JBoss-user] [EJB/JBoss] - Re: EJB QL and time comparison

2005-02-10 Thread hmae
Thank you for the replies. The application that I am working on tries to do a search by the name of the table fieldname and the value. I discovered that when I try to do a search on a date (ex. 01/27/2005), I will get data for 01/27/2005 00:00:00AM. And it did not get data for other times (e

[JBoss-user] [EJB/JBoss] - JBossQL, XDocletTags, and Date fields

2005-02-14 Thread hmae
To all: System: JBoss-3.2.4, Eclipse 2.1.3, Lomboz 2.1.3 I was trying to create a finder method for a date field using JBoss-QL, since EJB-QL's support for date is restricted (problems with time information). I thought I could create the finder method using Xdoclet's @jboss.query tag but the c

[JBoss-user] [EJB/JBoss] - Re: JBossQL, XDocletTags, and Date fields

2005-02-15 Thread hmae
Thank you for replying. I'm using Oracle9i. My problem is that whenever we tried to do a search based on a date field (ex. 1/27/2005). It works if the time was 00:00AM but it will not work if the time was 03:59AM. For testing purposes, we set up a dummy database table with a bunch of date fie

[JBoss-user] [EJB/JBoss] - accessing different instances of a database

2005-03-29 Thread hmae
To all: System information: JBoss-4.0.0, Windows XP Pro, Database: Oracle 9i I apologize in advance if I posted this in the wrong forum. I?m trying to solve a problem where I have a web application that needs to access two different instances of a database (ex. we call the instances dwm1 and dw

[JBoss-user] [EJB/JBoss] - Re: accessing different instances of a database

2005-04-08 Thread hmae
Thank you for your replies. I tried deploying two different EAR files with two different datasources. The two EAR file has one bean that have the same name. When I tried to deploy it on the same machine, it returned an error javax.management.InstanceAlreadyExistsException For my problem, since

[JBoss-user] [Persistence & CMP/JBoss] - Re: Why the multiple sql select for findByPrimaryKey JBoss

2005-04-20 Thread hmae
By setting read-ahead strategy to none you default it to the lazy-loading and it will do the multiple select statements. Try checking Chapter 11 "Optimized Loading" of the Administration document. This chapter explains the loading optimization. View the original post : http://www.jboss.org

[JBoss-user] [Persistence & CMP/JBoss] - Optimizaed loading question

2005-04-20 Thread hmae
To all: System: JBoss 4.0, EJB 2.0 On a customer's database I was testing out an EJB bean for a view. I noticed that the transaction was timing out because it took too long to get the data (there is about 4,000 records for the table). On the test servers where the data is smaller the beans wor

[JBoss-user] [EJB/JBoss] - JBossQL and DynamicQL

2004-08-02 Thread hmae
To all, I was trying to implement a generic finder method that I found in : http://www.mailarchive.com/[EMAIL PROTECTED]/msg05474.html The goal was to pass select statements that you define yourself. (My code is at the bottom.) When I deploy it, I get the error: 11:04:49,055 WARN [verifier] EJ

[JBoss-user] [EJB/JBoss] - Re: JBossQL and DynamicQL

2004-08-03 Thread hmae
Thank you for your replies. I tried both suggestions and it works now. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843979#3843979 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843979 -

[JBoss-user] [EJB/JBoss] - Forcing a commit for a Container Managed Transaction

2004-08-20 Thread hmae
Is there a way to force an CMT entity bean to commit to a database without caching? Is there some setting that I need to edit? Thanks in advance. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845780#3845780 Reply to the post : http://www.jboss.org/index.h

[JBoss-user] [EJB/JBoss] - concurrency issue NoSuchEntityException

2004-10-12 Thread hmae
To all, I created a web application where I add a new data using CMT. The web page has a table where I can click on a link so I can edit the data. (I'm sure alot of people have done something similar). I have Servlet->Facade->CMP. My web page has a table with a link which contains the primary

[JBoss-user] [EJB/JBoss] - Re: concurrency issue NoSuchEntityException

2004-10-13 Thread hmae
To all, I might have fixed the problem. However, I don't know why it worked. For my facade I put a xdoclet tag: "transaction-type=Container" This was something I found in a book "Enterprise JavaBeans" by Richard Monson-Haefel. Also, instead of using findByPrimaryKey() I created another finder me

[JBoss-user] [Installation & Configuration] - finding the number of active users

2005-06-27 Thread hmae
To all: Is there a way to find out how many active users are currently logged into an application using jmx-console? Or do you need to create a program that will keep track of the number of users? Thanks. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=388289