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
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
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
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
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
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
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
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 (
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
Oops! Sorry
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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'
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
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
13 matches
Mail list logo