[JBoss-user] [EJB/JBoss] - Re: How to deploy hibernate.har (4.0.0) into 4.0.2

2005-05-28 Thread amit10may
Hi, I am using JBoss 4.0.2 and I am able to deploy the Hibernate HAR files properly. The only issue which is seen in this version of JBoss is , the HAR can not be used as exploded directory .It does not work simply. So work around is to use the archive instead. If you are facing problems with eve

[JBoss-user] [Installation & Configuration] - Re: jboss 4.0.2 not deploying hibernate-service in exploded

2005-05-15 Thread amit10may
Hi, I am also experiencing same issues!!! What's wrong with 4.0.2? Or is anything extra needs to be done with the HAR ? Please help . Regards, Amit View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3877797#3877797 Reply to the post : http://www.jboss.org/index.h

[JBoss-user] [Beginners Corner] - Re: Can I use nested query in ejb finders?

2005-05-13 Thread amit10may
Yes it works. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3877622#3877622 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3877622 --- This SF.Net email is sponsored

[JBoss-user] [Beginners Corner] - Re: Can I use nested query in ejb finders?

2005-05-02 Thread amit10may
Thanks a lot. Its working fine. Regards Amit View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3876099#3876099 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3876099 ---

[JBoss-user] [Beginners Corner] - Re: Can I use nested query in ejb finders?

2005-05-01 Thread amit10may
That was so nice of you! I will try it out. Well, I need to use the subquery since the logic demands it. If this declared-sql does not work I will move to jdbc and fire plain sql to get the pk of the record and then move on with rest of the code after the finder. Thanks a lot again. View the o

[JBoss-user] [Beginners Corner] - Re: Can I use nested query in ejb finders?

2005-04-30 Thread amit10may
Not yet. I could not figure out how to construct the declare-sql clauses. Can you help me out? The query is not trivial . SELECT OBJECT(o) FROM CPRecoverLog o WHERE o.status = ?1 AND o.CPTransactionId = ( SELECT MIN(o1.CPTransactionId) FROM CPRecoverLog o1 WHERE o1.status = ?1) View the origina

[JBoss-user] [Beginners Corner] - Re: Can I use nested query in ejb finders?

2005-04-29 Thread amit10may
Hi, Actually I had tried with JBoss-QL also. But its giving same problem. Do you know how to use subqueries as mentioned in my original post ? Regards Amit View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3875868#3875868 Reply to the post : http://www.jboss.or

[JBoss-user] [Beginners Corner] - Re: Auto primary key generation with CMP and MySQL

2005-04-27 Thread amit10may
Hi guys, I think my problem is similar to yours. But I am using CMR in addition. The primary key generation works fine when I done use relationships. Can you help me out by viewing the post which describes the issue. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3875593#3875593 Regards

[JBoss-user] [Beginners Corner] - Re: Can I use nested query in ejb finders?

2005-04-27 Thread amit10may
Note that the same query was working in Weblogc 8.1 The exception I get in JBoss 4.0.1 SP1 is - 2005-04-27 17:34:25,170 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCSybaseCreateCommand.CPRecoverLog] Insert Entity SQL: INSERT INTO CPRecoverLog (cp_transaction_id, attemptCount, status, type,

[JBoss-user] [EJB/JBoss] - Re: Can I use nested query in ejb finders?

2005-04-27 Thread amit10may
Note that the same query was working in Weblogc 8.1 The exception I get in JBoss 4.0.1 SP1 is - 2005-04-27 17:34:25,170 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCSybaseCreateCommand.CPRecoverLog] Insert Entity SQL: INSERT INTO CPRecoverLog (cp_transaction_id, attemptCount, status, type

[JBoss-user] [Beginners Corner] - Can I use nested query in ejb finders?

2005-04-27 Thread amit10may
We need to use following query in CMP entity bean: SELECT OBJECT(o) FROM CPRecoverLog o WHERE o.status = ?1 AND o.CPTransactionId = ( SELECT MIN(o1.CPTransactionId) FROM CPRecoverLog o1 WHERE o1.status = ?1) The bean tags are as follows: * @ejb.bean description = "CPRecoverLog" *

[JBoss-user] [EJB/JBoss] - Can I use nested query in ejb finders?

2005-04-27 Thread amit10may
We need to use following query in CMP entity bean: SELECT OBJECT(o) FROM CPRecoverLog o WHERE o.status = ?1 AND o.CPTransactionId = ( SELECT MIN(o1.CPTransactionId) FROM CPRecoverLog o1 WHERE o1.status = ?1) The bean tags are as follows: * @ejb.bean description = "CPRecoverLog" *