Darian,
There isn't a command-line parameter you can pass to Orion to get it to do this, but
as was shared with me on this list there's a really nice _free_ utility that does
this. It's called p6spy and is located at http://www.provision6.com/
I don't know about your second question, we've nev
Is there a directive to add on the command line to make Orion log all
generated SQL statements?
Also, if I have a EJB CMP and I am writing a finder method and I want to
pass a JavaBean as a parameter, how do I tell the finder which method or
variable to use in the where clause? Is it possible to
Neither is LIMIT supported by standard SQL, so it would reduce portability
to use it in the generated SQL as well.
/Fredrik
> You could either edit the orion-ejb-jar.xml. And change the generated
> SQL, but this will be overwritten next time orion is started. Another
> way is to specify a f
You could either edit the orion-ejb-jar.xml. And change the generated
SQL, but this will be overwritten next time orion is started. Another
way is to specify a finder query in your EJBHome inteface like this:
String findByRecipient_query = "Message.recipient = $1";
Collection findByRecipient(S
Hi all,
Is there possibility to set a maximum row count for a resultset ?
Something general for the SQL Attribure "LIMIT" ?!
Thanks in advance, Toni
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] Im Auftrag von prasanth sb
Gesendet: Sonntag, 10. Februar 2002
Title: Errors on EJB Finder Methods
If you are doing a find ... and lets say it cant find anything.
IT seems to throw an exception ... is there anway to make it just null ... so i can do something else instead?
Joseph Faisal Nusairat, Sr. Applications Developer
WorldCom
tel: 614-723-4232
hi,
i've an entity bean named Test, in which i've put a cmp field named
difficulty of a class tpye DifficultyLevel.
I've definded difficulty in orion-ejb-jar.xml as
everything is fine when i create, remove, load, store, etc. to Test.
BUT, when i try to use findByDifficulty(DifficultyLevel d) w
. ). The problem here is that it
is necessary
- not all queries can be coded
with CMP finder methods ( consider example: I need to extract 20 records,
starting with 500 out of 3000 records in a table. Using Collection would be
extremely expensive ).
2.BMPs
Benefits:
- full control over data
The orion finders are wonderfully straightforward in this regard (joins
across entities), but you have to be a bit careful. Here's a quick example.
An Employee bean has a reference to Office. The Office bean has an int
numStaff attribute. I want to define a finder method that shows me all
e
Hello,
Does anyone on this list know if an EB using an Entity Reference as an
attribute, can have a finder method
search on that attribute? If so can you search on attributes of the
afore mentioned entity reference?
--
Adam Cassar
Technical Development Manager
__
= $name"
you should allways set the field name first ie. "$name = $1" because of the
database optimizer.
2) when using like keyword the best way to use it is to inform the users
that % is the wildchar and then you will soon see some extremely cool usage
of your finder methods :) ive seen
Hi Sven,
The field names should be the "name", not the "persistence-name". So you
should use "$1 = $_fantasia". You can check this by viewing the generated
SQL after deployment.
I'm not sure about the LIKE construction - but it sounds reasonable.
Nick
At 10:23 AM 9/19/00 -0300, you wrote:
>I
I have a couple of doubts concerning the tag.
specifically, I would like to implement a query like "select * from
table where field LIKE '%value'"
Considering I have:
in my orion-ejb-jar.xml.
and the docs tell me:
I suppose (not really clear in the docs) that $1 is th
f
> different combinations can make this a bit of a headache.
>
> If you have name, age and score, you may end up with finder methods like:
>
> findByName(String name)
> findByAge(int age)
> findByScore(int score)
> findByNameAndAge(String name,
-
From: Joe Walnes [mailto:[EMAIL PROTECTED]]
Sent: 13. september 2000 16:01
To: Orion-Interest
Subject: RE: Specifying finder-methods (full query)
Ok, here's some methods to allow slightly more flexible queries.
There is rarely more than a few fields to query, but the permutations of
diff
Ok, here's some methods to allow slightly more flexible queries.
There is rarely more than a few fields to query, but the permutations of
different combinations can make this a bit of a headache.
If you have name, age and score, you may end up with finder methods like:
findB
The normal way of doing this is by implementing several finder methods, and
let a session bean do the entity querying..
For searching on names with wildchars just do:
query = "$name like $1"
this will actually serve as several finder methods (see examples under).
findByName(&qu
At 08:57 PM 9/12/00 +0200, you wrote:
>Thanks for the reaction (also Nick). I realize now the potential security
>problems by allowing full
>specification of SQL on the client.
>
>Unfortunately the "Bob" example does not solve my problem. I managed to
>implement that example.
>That is where I c
advance. Allowing this would impact performance, breach security and allow
> all havoc to break out.
>
> -Joe Walnes
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Frank Eggink
> > Sent: 12 Septemb
ECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Frank Eggink
> Sent: 12 September 2000 16:06
> To: Orion-Interest
> Subject: Specifying finder-methods (full query)
>
>
> I'm running into trouble specifying finder queries in
> orion-ejb-jar. As far
> as I can make sense o
I'm running into trouble specifying finder queries in orion-ejb-jar. As far
as I can make sense of it the cause is in the quotes. Is that correct and
does anyone know how the get around that?
I've changed the default finder method to:
you put these in the orion-ejb-jar.xml file using EJB2.0 types QL.
Tom Klaasen <[EMAIL PROTECTED]> wrote:
Hi all,In SilverStream 3.x (another EJB server), the finder methods are describedas follows in a deployment descriptor:findByShopIdjava.lang.StringExpressionitem2.shopi
Hi all,
In SilverStream 3.x (another EJB server), the finder methods are described
as follows in a deployment descriptor:
findByShopId
java.lang.String
Expression
item2.shopid like
age-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jeremy Cowgar
> Sent: Tuesday, 29 August 2000 11:56
> To: Orion-Interest
> Subject: RE: EJB finder methods.
>
>
> In a finder method, how do you automatically have a custom SQL
> statement...For in
> I would like to set an ORDER BY lname in my finder method...I
> know it can be
> done in the application deployment, but what about if I ship my
> EJB to other
> companies, do I have to have them edit all the application deployment .xml
> files to add custom finders?
2 choices.
1) Read http://
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Roman Kagan
Sent: Tuesday, August 29, 2000 8:22 AM
To: Orion-Interest
Subject: RE: EJB finder methods.
Importance: High
First of all implement the Entity Bean with Container Managed Persistence.
In that case you'll need to have f
(248) 227-1220
[EMAIL PROTECTED] fax (810) 958-5148
-
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of James Ho
Sent: Tuesday, August 29, 2000 12:18 PM
To: Orion-Interest
Subject: Re: EJB finder met
> Sent: August 29, 2000 12:18 PM
> To: Orion-Interest
> Subject: Re: EJB finder methods.
>
> Hi Paul
>
> I am a newbie in EJB...so don't know if this will really helps..
>
> I guess u implement the finder methods in the bean class? and also modify
> the
Hi Paul
I am a newbie in EJB...so don't know if this will really helps..
I guess u implement the finder methods in the bean class? and also modify
the Home interface file to add that method in.
Regards, James
> Where do I specify my own finder methods in my ent
Where do I specify my own finder methods in my entity bean.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http
automatically generated. For example findByName(String name)
will automatically generate a finder looking up on the field name.
Regards,
Karl Avedal
Enrique Wallace wrote:
> where/how are CMP finder methods (other than primary key) mapped to the
> database?
>
> t
where/how are CMP finder methods (other than primary key) mapped to the
database?
thanks,
ekw
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
rand type clash: IMAGE is incompatible with INT
This suggests that orion is simply passing across the serialized Collection
as a blob of data. (IMAGE is Sybase's equivalent of BLOB).
Does anyone know if it's possible to pass across Collections or arrays to
finder methods, and if so w
:) When i remapped those to Strings all finder
methods worked just fine.
Symptome:
All finder methods returning Collections fail until you reget the
result as many times as there are rows in your search criteria. When you get
the data all primary key fields will report null.
Sof
Congratulations on releasing v1.0.
It is a nice feature that orion writes the custom finders for CMP in some
cases. For those cases where it cannot, would it be possible to permit the
user to give it a hint? For example:
public interface FooHome extends EJBHome {
..
public F
Hello Jonas,
Jonas Larsson wrote:
> How do I create a custom finder method in a CPM EJB with Orionserver? Is
> that possible yet?
> Example:
> Collection findByName( String Name ) /* Returns all ejb:s where NAME=Name */
Yes, it is possible. This is how you do it:
1. Define the finder in the Ho
How do I create a custom finder method in a CPM EJB with Orionserver? Is
that possible yet?
Example:
Collection findByName( String Name ) /* Returns all ejb:s where NAME=Name */
/Jonas
37 matches
Mail list logo