RE: CMP mapping question

1999-12-27 Thread Mike Cannon-Brookes 

This depends completely on your persistent store.

For example with MSSQL, you'd have to map fields of any length to TEXT
fields (which are very heavy on storage). If they're less than 255 map them
to a CHAR or VARCHAR field.

Look up in your DB to see what field types are available, Orion can map to
any of them.

Cheers,
Mike

 __
|  | Director - The BookmarkBox P/L
|  |  http://www.bookmarkbox.com 
|/\| Manage and share your bookmarks online!

Do you enjoy our service? Why not tell your friends about us?
http://www.bookmarkbox.com/email.cfm


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Frank Apap
> Sent: Tuesday, 28 December 1999 3:04
> To: Orion-Interest
> Subject: CMP mapping question
>
>
> Does anyone have a list of what maps to what?
>
> Also what kind of data type do I use if I need strings of any length (not
> just 255)?
>
> -Thanks
>
>
>
>

RE: cmp mapping of Integer, Float, Double etc.

1999-12-27 Thread Mike Cannon-Brookes 

By default Orion maps java.lang.Integer cmp fields to INTEGER db fields? (At
least that's the only thing that's ever happened to me). I sometimes change
this to map to LONGINTEGER or some other type that my DB supports.

You can alter what it maps to in the orion-ejb-jar.xml file (the deployment
descriptor).

Cheers,
Mike

 __
|  | Director - The BookmarkBox P/L
|  |  http://www.bookmarkbox.com 
|/\| Manage and share your bookmarks online!

Do you enjoy our service? Why not tell your friends about us?
http://www.bookmarkbox.com/email.cfm


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Krueger
> Sent: Tuesday, 28 December 1999 12:03
> To: Orion-Interest
> Subject: cmp mapping of Integer, Float, Double etc.
>
>
> Hi,
>
> it seems that orion maps java.lang.Integer cmp fields to LONGVARBINARY
> which makes it quite unusable if you generally don't work with basic
> data types as we do. Is there a way to change that behaviour? Are you
> working on that? Please don't tell me it's the way it's meant to be.
>
> Thanks,
>
> Robert
>
>
>
> --
> (-) Robert Krüger
> (-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
> (-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
> (-) Tel: 06151 665401, Fax: 06151 665373
> (-) [EMAIL PROTECTED], www.signal7.de
>
>
>
>
>

RE: Is there better control over the generated custom finder code in CMP?

1999-12-27 Thread Mike Cannon-Brookes 

This requires some sort of Object-Relational modelling tool (what you're
trying to do is make one EJB out of more than one table).

This is being added to Orion at the moment and will be a part of the feature
set in the future.

For now, the quickest way is to either create two CMP beans and join them
through methods, eg a.getB() and b.getA() or use BMP with some OR software.

Cheers,
Mike

 __
|  | Director - The BookmarkBox P/L
|  |  http://www.bookmarkbox.com 
|/\| Manage and share your bookmarks online!

Do you enjoy our service? Why not tell your friends about us?
http://www.bookmarkbox.com/email.cfm


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Paransky
> Sent: Tuesday, 28 December 1999 12:37
> To: Orion-Interest
> Subject: Is there better control over the generated custom finder code
> in CMP?
>
>
> By default you get: SELECT  FROM , you can also add a WHERE
> clause by playing with the .  I need to get the following
> format:
>
> SELECT  FROM ,  WHERE . =
> . and . like $1
>
> Is this possible?  In particular about the join from two tables?
> Are there
> any other tags I can add which will append something to the generated SQL
> but before the WHERE clause?
>
> Thanks.
> -AP_
>
>
>

Parameter parsing bug?

1999-12-27 Thread Brien Voorhees 

I ran into what might be a bug in OrionServer's parameter parsing.  I have a
JSP page that is called from a form submit and if one of the parameters is
empty but does not include an equal sign all of the parameters return null
(via getParameter()).  For example, the first URL works fine but the second
one results in all null-values.

blahjsp?one=1&two=&three=3

blahjsp?one=1&two&three=3


Thank you,
Brien Voorhees

CMP mapping question

1999-12-27 Thread Frank Apap 

Does anyone have a list of what maps to what?

Also what kind of data type do I use if I need strings of any length (not
just 255)?

-Thanks

Re: Orion-Interest subscription notification

1999-12-27 Thread saravanan thangaraju 

unsubscribe [EMAIL PROTECTED]


>From: Orion-Interest <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Orion-Interest subscription notification
>Date: Thu, 23 Dec 1999 17:54:23 -0500 (EST)
>
>[EMAIL PROTECTED] is now subscribed to Orion-Interest.
>
>

__
Get Your Private, Free Email at http://www.hotmail.com

Is there better control over the generated custom finder code in CMP?

1999-12-27 Thread Alex Paransky 

By default you get: SELECT  FROM , you can also add a WHERE
clause by playing with the .  I need to get the following
format:

SELECT  FROM ,  WHERE . =
. and . like $1

Is this possible?  In particular about the join from two tables?  Are there
any other tags I can add which will append something to the generated SQL
but before the WHERE clause?

Thanks.
-AP_

db mapping problem 2

1999-12-27 Thread Robert Krueger 


Just for completeness: if I specify the mapping explicitly, i.e. tell it
that the field of type java.lang.Integer maps to the database type
INTEGER it deploys but fails on the first create with the following
Oracle error:

 Log.error:0: java.rmi.RemoteException: error in createCompany ; nested
exception is:
java.lang.reflect.InvocationTargetException
java.lang.reflect.InvocationTargetException: java.rmi.RemoteException:
createCompany failed; nested exception is:
javax.ejb.CreateException: Error creating EntityBean: ORA-00932:
inconsistent datatypes

javax.ejb.CreateException: Error creating EntityBean: ORA-00932:
inconsistent datatypes

Is this Oracle specific or do generally not allow mapping of
java.lang.Integer to an INTEGER column?


--
(-) Robert Krüger
(-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
(-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de

cmp mapping of Integer, Float, Double etc.

1999-12-27 Thread Robert Krueger 

Hi,

it seems that orion maps java.lang.Integer cmp fields to LONGVARBINARY
which makes it quite unusable if you generally don't work with basic
data types as we do. Is there a way to change that behaviour? Are you
working on that? Please don't tell me it's the way it's meant to be.

Thanks,

Robert



--
(-) Robert Krüger
(-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
(-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de

session timeout on stateless session beans, why?

1999-12-27 Thread Robert Krueger 

Hi,

I'm getting session timeouts on stateless session beans. I thought that
timeouts only made sense on stateful session beans? Could someone please
clarify that? The state diagram of stateful session beans contains a
timeout but the one for stateless session beans doesn't. Am
I misinterpreting the spec here or is this left to the container
provider?

Thanks,

Robert

--
(-) Robert Krüger
(-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
(-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de