[JBoss-user] [Persistence & CMP/JBoss] - Re: EJBQL Problem

2004-10-06 Thread timshaw
1) Remove the ORDER BY bits - check this works 2) Create identical entry in jbosscmp-jbbc.xml (with ORDER BY), replacing 'ejb-ql' tag with 'jboss-ql'. Empty the 'ejb-ql' tag in ejb-jar.xml Try again. G'luck tim View the original post : http://www.jboss.org/index.html?module=bb&op=viewto

[JBoss-user] [Persistence & CMP/JBoss] - Re: 'IN' in DynamicQL

2004-10-05 Thread timshaw
I tried to put the query into ejb-ql, to see if that worked (picks it up at deploy-time too, so it's quicker) ... MBeanException: org.jboss.deployment.DeploymentException: Error compiling JBossQL statement 'SELECT OBJECT(o) FROM CusOrderItemEJB o WHERE o.p

[JBoss-user] [Persistence & CMP/JBoss] - 'IN' in DynamicQL

2004-10-05 Thread timshaw
Hi, I've just started using DQL in order to execute something like the following statement : SELECT OBJECT(o) FROM CusOrderItemEJB o WHERE o.product = ?1 and o.cycle IN (?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18) This statement is generated (as per the DQL examp

[JBoss-user] [Persistence & CMP/JBoss] - Re: Does EJBQLToSQL92Compiler in 3.2.5 fully support EJB-QL

2004-09-29 Thread timshaw
Watch out for > and < ... make sure they're in CDATA sections (or use < and >) I couldn't get the CDATA to work in ejb-jar.xml, but it works fine in jboss-ql sections in jbosscmp-jdbc.xml. I also get compilation errors for the 'BETWEEN' keyword, but haven't followed that up. G'luck View the or

[JBoss-user] [Persistence & CMP/JBoss] - Re: ejb-ql jboss-ql integration problem?

2004-09-28 Thread timshaw
My understanding is that you cannot use 'IN' in this way. The below snippet works correctly (even with an empty ejb-ql) for me - the IN is used to say 'the given group is IN the set referenced by the object'. You appear to be using the SQL type-of IN. I don't think your approach works ... but i

[JBoss-user] [Persistence & CMP/JBoss] - Re: finder exception is not thrown

2004-08-25 Thread timshaw
I thought that this was correct. The Collection return will return the empty Collection if no matches are found. Just check for empty instead of a try/catch. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846128#3846128 Reply to the post : http://www.jboss.o

[JBoss-user] [Persistence & CMP/JBoss] - Re: CMP/Cacheing problems

2004-07-28 Thread timshaw
Thanks for the reply. I realise the error is due to a constraint violation - my problem is that this constraint violation should not occur! I have 2 - well, 350+ actually - datasets to load. If I load them one after the other, I get the error. If I stop JBoss after loading the first set and the

[JBoss-user] [Persistence & CMP/JBoss] - CMP/Cacheing problems

2004-07-27 Thread timshaw
Hi, I have an app which has infrequent (daily) updates of data, and requires high-speed read-only access by a small number of clients all the time. I'm not bothered (much) by the speed of loading, but retrieval needs to be as fast as possible. As all access is via my beans, I initially tried (

[JBoss-user] [Installation & Configuration] - Re: Log4J configuration (again!)

2004-07-21 Thread timshaw
Thanks, but that's just basic log4j stuff. Like a good person, I have a (fairly large) number of shared packages between my 2 web-apps - and I need the logging to be in the correct file depending one who's calling them (app1 or app2). When I had this problem with straight Tomcat, I had to creat

[JBoss-user] [Installation & Configuration] - Re: Log4J configuration (again!)

2004-07-21 Thread timshaw
Oops! Sorry | | | | | | | | | | | | | | | | | | | | | | | | | | |

[JBoss-user] [Installation & Configuration] - Re: Log4J configuration (again!)

2004-07-21 Thread timshaw
Tried the logging stuff on the Wiki (all of it!) before I posted. The below log4j.xml causes all 3 'custom' files to contain the same output. a) Perhaps the Filter doesn't work b) Perhaps I am using the wrong string for the DeployURL c) Perhaps this approach doesn't work with filtering 'contained'

[JBoss-user] [Installation & Configuration] - Re: JBoss not starting/booting in RHEL AS 3

2004-07-20 Thread timshaw
I've got the same system, and it ran out of the box. I would guess that it's your log4j stuff - a snippet from my output goes : 19:33:17,294 INFO [Server] Root Deployment Filename: jboss-service.xml 19:33:17,298 INFO [Server] Starting General Purpose Architecture (GPA)... 19:33:42,982 INFO [Se

[JBoss-user] [Installation & Configuration] - Log4J configuration (again!)

2004-07-20 Thread timshaw
Hi, I have checked (and tried various suggestions) for this - but I can't get the behaviour I want ... [JBoss 3.2.5, JDK 1.4.2_04] I have an .ear containing an EJB .jar and 2 .wars. I want the .wars to log into distinct files. I tried putting log4j.xml in each WEB-INF/classes of the .wars (wit