In my case I have two CMP entity beans (Books and Music) . This
message error also appears when i executed the
EJB Test Client
in Visual Age 3.5. For other side, the CMP entity beans doesn't
need the SQL sentences to create instances of entity beans.
I relationed the entity beans with Oracle 7.2.3. tables . Anybody knows if this Oracle version have troubles with
EJBs ?
This is Database schema that was generated by Visual Age 3.5.
Connected to:
Oracle7 Server Release 7.2.3.0.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.2.3.0.0 - Production
SQL> desc books
Name Null? Type
------------------------------- -------- ----
DISCOUNT NUMBER(10)
CODE NOT NULL NUMBER(10)
PRICE FLOAT(126)
TITLE VARCHAR2(30)
AUTHORS VARCHAR2(30)
Message Error :
java.rmi.ServerException: Remote Exception occurred in server thread; nested exception is :
com.ibm.ejs.persistence.EJSPersistenceException: getPStmt failed; nested exception is:
java.sql.SQLException:ORA-00922: missing or invalid option
CMP Entity Bean :
public class BooksBean implements EntityBean {
public
String authors;
public int code;
public int discount;
private javax.ejb.EntityContext entityContext = null;
public double price;
final static long serialVersionUID = 3206093459760846163L;
public String title;
}
Thanks for yours help.
Jorge