CMR Error

drear friend i need help for container manage relationship in java studio enterprise edition 8.0

i have following table on mssql server 2000

customers(table) {

-> customerid columns (primary key),

-> firstname,

-> lastname,

-> address

}

orders(table) {

->orderid columns (primary key),

->date,

->remark,

->discount,

->paymenttype

->customerid (foreign key -> customers.customerid)

}

then i created two container manage entity beans for this two table,

added cmp fields, add relationship to them.

then after i add findAll finder method into the both entity bean.

when i use this entity bean via session bean in jsp page create intance of that entity and call findAll method of the order bean.

it throws SQLException say that can't find CUSTOMERS_CUSTOMERID

in order.

[933 byte] By [arunmoyala] at [2007-11-26 23:35:49]
# 1

Can you post the complete error message and stacktrace?

You may also want to take a look at:

http://developers.sun.com/appserver/reference/techart/ejbql.html#8

which provides a couple of example select statements that will not work.

Is it possible that the fields in 'order by' are not part of the fields in the 'select' clause? Or it could be that the 'order by' field is not an orderable type.

KarthikRa at 2007-7-11 14:57:49 > top of Java-index,Development Tools,Java Tools...
# 2
thanks for your respone. but i solve the problem by modifying project.property file. in project.property file i just remove exclude-cmp file.
arunmoyala at 2007-7-11 14:57:49 > top of Java-index,Development Tools,Java Tools...