Re: CMP-findBy method

[Boris Gertsberg]

Your select statement in findBy method MUST include EVERY mapped property of your Entity Bean even if you use partial SQL statement. (i.e:"select T_Hotel.hotel_name,T_Hotel.trans_xid from T_Hotel where T_Hotel.trans_xid=$1") After findBy method found each of your entity beans application server loads the data into memory. That's why it MUST have EVERY field. Otherwise it would have to do n+1 SQL query to load your bean. 1 select statement is faster then n+1.   Actually you probably don't even need to use partial="false" here. The only good use for partial that I found is calling stored procedures and doing complex joins in findBy methods. Boris ----- Original Message ----- From: tasneem To: Orion-Interest Sent: Thursday, December 21, 2000 9:54 AM Subject: CMP-findBy method Hello everybody   I have a problem i hav a CMP bean in which i am doing doing a findBy method to get some info from my table. As per the normal way i have mentioned the query in my home class. After deploying have also found the same query in the orion.ejb.jar xml file but when i run my application the look up gets done findByPrimaryKey method is also working but the moment it reaches this findBy method it gives me the following error.   Note: My query looks like this in orion.ejb.jar xml file : <finder-method query="select T_Hotel.hotel_name from T_Hotel where T_Hotel.trans_xid=$1" partial="false">     <!-- Generated SQL: "select T_Hotel.hotel_name from T_Hotel where T_Hotel.trans_xid=?" --> where hotel_name , trans_xid are my columns and the table name is T_Hotel     java.sql.SQLException: Column not found  at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source)  at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)  at THotelHome_EntityHomeWrapper2.findByTrans_xid(THotelHome_EntityHomeWrapper2.java:959)  at CMP.HotelServlet.doGet(HotelServlet.java:61)  at javax.servlet.http.HttpServlet.service(HttpServlet.java)  at javax.servlet.http.HttpServlet.service(HttpServlet.java)  at javax.servlet.http.HttpServlet.service(HttpServlet.java)  at com.evermind.server.http.d1.si(JAX)  at com.evermind.server.http.d1.forward(JAX)  at com.evermind.server.http.ed.sp(JAX)  at com.evermind.server.http.ed.so(JAX)  at com.evermind.util.f.run(JAX)