[JBoss-user] [EJB/JBoss] - Cannot create EntityBean /JB3.2.5

2004-07-06 Thread konstantinidis
ful"); But only the first statement is logged, then nothing else happens. Does anyone know if there have been made some changes concerning ejbCreate-methods between 3.2.3 and 3.2.5? Also if you have an idea where I could look for a missing configuration feel free to tell me. Thx a lot in

[JBoss-user] [Persistence & CMP/JBoss] - Re: How to use Subqueries in a finder-Method???

2004-05-12 Thread konstantinidis
Okay, I tried the DeclaredSQL and it seems that it might work. There was no exception at deployment, but I had no time to test it. The XDoclet tag is @jboss.declared-sql (look at http://xdoclet.sourceforge.net/xdoclet/index.html for further details) But now I have a new problem: with DeclaredS

[JBoss-user] [Persistence & CMP/JBoss] - Re: How to JOIN several Tables in Finder-Methods

2004-05-12 Thread konstantinidis
Hello, Pascal, thx for your answer! Perhaps I didnt ask well. The problem is that I have a hierarchy like A M <--> 1 B M< --> 1 C M <--> 1 D (where A, B, C, D are the table names and M = many) and I want to get some Entities from C, but I have to make a JOIN on all tables A, B, C, D because de

[JBoss-user] [Persistence & CMP/JBoss] - Re: How to use Subqueries in a finder-Method???

2004-05-11 Thread konstantinidis
Hello, and thx again for your fast answer! :-) Yes, getting an ordered collection and taking the last object is the way I go atm. But as I dont know exactly how many rows will be affected, I thought there might be a better solution. I also have never used DeclaredSQL. But perhaps I should t

[JBoss-user] [Persistence & CMP/JBoss] - Re: How to use Subqueries in a finder-Method???

2004-05-11 Thread konstantinidis
Hello, thx for your fast answer! :-) Well, I read the Specs. But "not specified" does not mean "not supported by JBoss". That's the reason for JBossQL. But I didnt find some good description and especially some good examples in the JBoss Docs. Do you know some? I know that the IN Operator wi

[JBoss-user] [Persistence & CMP/JBoss] - How to JOIN several Tables in Finder-Methods

2004-05-11 Thread konstantinidis
Hello, I would like to transform a SQL-Statement like the following to a finder- (or Selector-)Method: SELECT c.id FROM myC c JOIN myB b ON b.id_c = c.id JOIN myA a ON a.id_b= b.id JOIN myD d ON c.id_d = d.id WHERE a.myFieldFromA = 1 AND c.myFieldFromC = 2 AND d

[JBoss-user] [Persistence & CMP/JBoss] - How to use Subqueries in a finder-Method???

2004-05-11 Thread konstantinidis
Hello, I would like to create a finder-Method with a query like the following: SELECT Object(a) FROM myTable AS a WHERE a.date = (SELECT MAX(b.date) FROM myTable AS b) But when I make it this way I always get a ParseException. The two problems, in my opinion, are that the return value of the