Would this allow JBossQL be used in an ad-hoc manner? So you could use
it in a very similar way to JDBC, but in the EJB domain rather than the
database domain?
A simple solution might be to have a JBossQL - Native SQL convertor, so
you can use the standard JDBC functionality provided by your
What you have described is almost all available now. You can execute
any JBossQL at runtime using DynamicQL. To make it available to any
code, just add a home method to some bean the calls an internal
ejbSelect method that is mapped to DynamicQL.
What this doesn't get you is the ability to
Michael Bartmann wrote:
Dain,
I could help defining the grammar; unfortunately I'm
quite busy this week and on a long sought vacation
next week, so you'll have to be patient with me.
No rush; I won't be able to get to it for a while anyway.
The current grammar for JBossQL is not exactly
That shouldn't be to hard once we add support for sub queries, but
unless it is supported by most of the major vendors (postgres, oracle,
ms, ibm), it wouldn't be worth the work.
-dain
[EMAIL PROTECTED] wrote:
On Tue, Nov 12, 2002 at 04:53:28PM -0600, Dain Sundstrom wrote:
What is an
Don't know who supports it, but it is standard sql-92 (intermed level, not
entry)
david jencks
On 2002.11.13 10:12:35 -0500 Dain Sundstrom wrote:
That shouldn't be to hard once we add support for sub queries, but
unless it is supported by most of the major vendors (postgres, oracle,
ms,
Even better would be if Sun added something to the spec.
It seems to me that this is a fundamental limitation of CMP 2. No
matter how fast the container, it is difficult to see how it would ever
be able to do complex reports using CMP without such a feature.
Some reports may only return a few
Pete,
To better support complex reporting we just need to add more features to
JBossQL select statements (e.g., group by, having, sub queries, and
multiple fields in the select clause). I plan on adding most of these
features. It would be cool if sun added this stuff, but I find it
What about adding INTERSECTION-queries (whis is possible in postgresql)?
Or is it possible by some easy workaround now?
On tir, 2002-11-12 at 20:10, Dain Sundstrom wrote:
Pete,
To better support complex reporting we just need to add more features to
JBossQL select statements (e.g., group
What is an INTERSECTION query? Is it widely supported?
-dain
Marius Kotsbak wrote:
What about adding INTERSECTION-queries (whis is possible in postgresql)?
Or is it possible by some easy workaround now?
On tir, 2002-11-12 at 20:10, Dain Sundstrom wrote:
Pete,
To better support complex
Dain,
I could help defining the grammar; unfortunately I'm
quite busy this week and on a long sought vacation
next week, so you'll have to be patient with me.
The current grammar for JBossQL is not exactly tiny,
at least the JavaCC representation is a bit difficult
to read due to the way JavaCC
: Wednesday, November 06, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Absolutely!
I don't have to add much to this, but I think that this request
(non-container ejb-ql) is so important (and a good workaround,
too), that I simply couldn't resist
: Wednesday, November 06, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Absolutely!
I don't have to add much to this, but I think that this request
(non-container ejb-ql) is so important (and a good workaround,
too), that I simply couldn't resist
On Tue, 2002-10-29 at 17:28, Bill Burke wrote:
JBoss is being used in production everywhere. I've been at 6 sites myself
over the past year. IMHO and experience, entity beans are not the right
choice if you're doing complex reporting. A handmade query cache with
direct JDBC will always be
Absolutely!
I don't have to add much to this, but I think that this request
(non-container ejb-ql) is so important (and a good workaround,
too), that I simply couldn't resist to reply.
Anyway, would this be difficult to achieve?
Regards,
Michael Bartmann
Pete Beck wrote:
On Tue, 2002-10-29
Of Michael
Bartmann
Sent: Wednesday, November 06, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Absolutely!
I don't have to add much to this, but I think that this request
(non-container ejb-ql) is so important (and a good workaround,
too), that I simply
, November 06, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Absolutely!
I don't have to add much to this, but I think that this request
(non-container ejb-ql) is so important (and a good workaround,
too), that I simply couldn't resist to reply
onsdagen den 6 november 2002 kl 13.51 skrev saroj kumar:
1) If there is no container then how do we parse the XML?
2) If there are no Entity beans then how do you query?
3) If Above points are sorted out then how do we achieve complex
joins/unions?
How would Hibernate stand up ? ...
As a
, November 06, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Absolutely!
I don't have to add much to this, but I think that this request
(non-container ejb-ql) is so important (and a good workaround,
too), that I simply couldn't resist to reply.
Anyway
-admin;lists.sourceforge.net] On Behalf Of Michael
Bartmann
Sent: Wednesday, November 06, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Absolutely!
I don't have to add much to this, but I think that this request
(non-container ejb-ql) is so
crucial if the changes to DB are quite frequent.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:jboss-user-admin;lists.sourceforge.net] On Behalf Of Michael
Bartmann
Sent: Wednesday, November 06, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning
:29 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Hi,
Have you tried your tests out on 3.0.4 yet?
Some CMR performance optimisations made it into 3.0.4, because we
desperately needed them for our own application.
Steve Coy
On Wednesday, November 6, 2002
]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Luttrell, Peter wrote:
It is faster. I tried it in response to danch's message early in the
thread.
Thus I have the same question (which no one commented on): Time
~1200ms
is
a lot better then the original 2200, but can this still
have time this week for a quick sample. Last week was
deployment week.
.peter
-Original Message-
From: Sacha Labourey [mailto:Sacha.Labourey;ml.cogito-info.ch]
Sent: Wednesday, October 30, 2002 3:14 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
I was using read-ahead, as it's on by default.
See original posting.
-Original Message-
From: Emerson Cargnin - SICREDI Serviços
[mailto:emersonc;sicredi.com.br]
Sent: Tuesday, October 29, 2002 1:35 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Thanks for the advice.
I'll checkout SwiftMQ.
.peter
-Original Message-
From: Georg Schmid [mailto:georg-schmid;ti.com]
Sent: Tuesday, October 29, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
Peter,
it's a great relief to see
Luttrell, Peter wrote:
Bill also suggested that it was my code, which i don't think is the case. I
could be wrong ~ can anyone suggest how i can optimize this constructor:
public MyValueObject(SomeLocalInterface ejb){
name = ejb.getName();
id = ejb.getId();
someOtherField =
just a note : extends EJBObject - extends EntityBean
Dain Sundstrom wrote:
Luttrell, Peter wrote:
Bill also suggested that it was my code, which i don't think is the
case. I
could be wrong ~ can anyone suggest how i can optimize this constructor:
public MyValueObject(SomeLocalInterface ejb){
...course a bit of this is creating db pool
connections.
.peter
-Original Message-
From: Dain Sundstrom [mailto:dain;daingroup.com]
Sent: Monday, November 04, 2002 5:10 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Luttrell, Peter wrote:
Bill also
Luttrell, Peter wrote:
It is faster. I tried it in response to danch's message early in the thread.
Thus I have the same question (which no one commented on): Time ~1200ms is
a lot better then the original 2200, but can this still be acceptable for
reading ~10 fields from 750ejbs that are 100%
--__--__--
Message: 1
Date: Wed, 30 Oct 2002 14:14:06 -0600
From: Dain Sundstrom [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Reply-To: [EMAIL PROTECTED]
Georg Schmid wrote:
It seems that my (and, at least to some degree, Peter's) specific
Darren Hartford wrote:
Have been having similar issues, and my 'psuedo-hack' tests show similar
results to Georg, so thank you Georg for pointing out that the database
lookups are not the problem, but the object conversion piece.
I don't wish to sell other products, but for a reference, has
Hello,
Yes, in 4.0 there will be an abstraction layer between the cmp view of
the world and the physical storage. This means that it will be possible
to map several cmp beans in different applications to the same store.
The real trick is keeping the caches in sync and this is where the new
: [EMAIL PROTECTED]
[mailto:jboss-user-admin;lists.sourceforge.net] On Behalf Of Dain
Sundstrom
Sent: Wednesday, October 30, 2002 01:07
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Emerson Cargnin - SICREDI Serviços wrote:
Dain Sundstrom wrote:
Emerson
: Georg Schmid [mailto:georg-schmid;ti.com]
Sent: Wednesday, 30 October 2002 4:34 PM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
It seems that my (and, at least to some degree, Peter's) specific
problem is misunderstood.
In my case: the problem
Georg,
It seems that my (and, at least to some degree, Peter's) specific
problem is misunderstood.
...
into a collection of value objects. None of the previous posts (except
Peter's) touches upon this subject.
That's wrong: Bill suggested something wrt to your value object and I
suggested
Georg Schmid wrote:
It seems that my (and, at least to some degree, Peter's) specific
problem is misunderstood.
Sorry, that happens all the time on the lists
In my case: the problem is NOT getting the data from the database fast
(the finders execute fast enough).
I think Jboss does not
] On Behalf Of Bill Burke
Sent: Tuesday, October 29, 2002 07:24
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
Georg stop spewing nonsenseNever ever take out the synchronization
interceptor! It registers synchronzations with the TM so that the
entity bean
Hello Georg,
Do you mean that your slowness problem occurs when accessing the collection
*even* in mono-threaded behaviour? If I understand your scenario, you have
something like this:
- a web page that display the content of 4000 entity beans (either directly
or using a SLSB)
- the entity
Message-
From: Georg Schmid [mailto:georg-schmid;ti.com]
Sent: Tuesday, October 29, 2002 2:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
First of all:
This was only an experiment to check the impact of the
EntitySynchronizationInterceptor
-
From: Georg Schmid [mailto:georg-schmid;ti.com]
Sent: Tuesday, October 29, 2002 2:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
First of all:
This was only an experiment to check the impact of the
EntitySynchronizationInterceptor on performance
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
Georg,
I used 2 other non-ejb solutions to get what I needed done.
Cache the dataobjects in the webtier. It will only work in certain
cases, 2/3 in my case. I know it's duplicating work that the ejb
container
-Original Message-
From: Georg Schmid [mailto:georg-schmid;ti.com]
Sent: Tuesday, October 29, 2002 2:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
First of all:
This was only an experiment to check the impact
-
From: [EMAIL PROTECTED]
[mailto:jboss-user-admin;lists.sourceforge.net] On Behalf Of Bill Burke
Sent: Tuesday, October 29, 2002 07:24
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
Georg stop spewing nonsenseNever ever take out the synchronization
-admin;lists.sourceforge.net]On Behalf Of Bill Burke
Sent: Tuesday, October 29, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
JBoss is being used in production everywhere. I've been at 6 sites myself
over the past year. IMHO and experience
Jason Westra wrote:
Hi JBoss friends,
I tend to agree with Bill and Dain's last posting here. There are certain
things that CMP is not designed to do *well* and large, heavy reads is one
of them.
I disagree with you here. It depends on the type of reads you are
doing. A lot of applications
;lists.sourceforge.net]On Behalf Of Dain
Sundstrom
Sent: Tuesday, October 29, 2002 11:43 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Jason Westra wrote:
Hi JBoss friends,
I tend to agree with Bill and Dain's last posting here. There are certain
things
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Jason Westra wrote:
Hi JBoss friends,
I tend to agree with Bill and Dain's last posting here. There are certain
things that CMP is not designed to do *well* and large, heavy reads is one
of them.
I disagree
section able solve ALL data query
problems.
J
-Original Message-
From: [EMAIL PROTECTED]
[mailto:jboss-user-admin;lists.sourceforge.net]On Behalf Of Dain
Sundstrom
Sent: Tuesday, October 29, 2002 11:43 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
.
.peter
-Original Message-
From: Georg Schmid [mailto:georg-schmid;ti.com]
Sent: Tuesday, October 29, 2002 2:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
First of all:
This was only an experiment to check the impact
;lists.sourceforge.net]On Behalf Of Dain
Sundstrom
Sent: Tuesday, October 29, 2002 11:43 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Jason Westra wrote:
Hi JBoss friends,
I tend to agree with Bill and Dain's last posting here. There are
certain
things that CMP
Emerson Cargnin - SICREDI Serviços wrote:
Dain Sundstrom wrote:
Emerson,
I disagree with you classification that cmp is not usable. There are
many people that find the performance completely with in their
expectations. It is only when you have a high expectation and a very
complex
pool
connections.
.peter
-Original Message-
From: Dan Christopherson [mailto:danch;nvisia.com]
Sent: Monday, October 21, 2002 12:45 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help
Luttrell, Peter wrote:
basically pass in a reference to the ejb
;lists.sourceforge.net]On Behalf Of Georg Schmid
Sent: Monday, October 21, 2002 4:32 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Entity Bean Performance Tuning Help
Peter,
I have a similar problem and tried to dig into it.
You may have a look at the thread
http://www.jboss.org/forums
53 matches
Mail list logo