Container Managed Bean serious problem

[Nam]

I run Oracle8i , Oracle driver classes.zip, Weblogic App Server 5.1 and
NT 4.0.
I declare a column VARCHAR2 , NOT NULL for my table.
I use container managed bean and insert a new row. I got exception.
But if I change the column to NULL then it is OK.
How can I fix this bug?

Here is the exception error:

ava.rmi.UnexpectedException: Unexpected exception in
com.titan.cabin.CabinBean.create():
java.sql.SQLException: ORA-01400: cannot insert NULL into
("EJB"."CABIN"."NAME")
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java, Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java, Compiled
Code)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java,
Compiled Code)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)

at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353)

at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)

at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:320)

at
weblogic.jdbc.pool.PreparedStatement.executeUpdate(PreparedStatement.java:65)

at
com.titan.cabin.CabinPSWebLogic_CMP_RDBMS.create(CabinPSWebLogic_CMP_RDBMS.java:170)

at
com.titan.cabin.CabinPSWebLogic_CMP_RDBMS.create(CabinPSWebLogic_CMP_RDBMS.java:128)

at
weblogic.ejb.internal.EntityEJBContext.create(EntityEJBContext.java:118)

at
weblogic.ejb.internal.StatefulEJBObject.postCreate(StatefulEJBObject.java:266)

at com.titan.cabin.CabinBeanEOImpl.create(CabinBeanEOImpl.java:62)
at com.titan.cabin.CabinBeanHomeImpl.create(CabinBeanHomeImpl.java:32)
at
com.titan.cabin.CabinBeanHomeImpl_WLSkel.invoke(CabinBeanHomeImpl_WLSkel.java:133)

at
weblogic.rmi.extensions.BasicServerObjectAdapter.invoke(BasicServerObjectAdapter.java,
Compiled Code)
at
weblogic.rmi.extensions.BasicRequestHandler.handleRequest(BasicRequestHandler.java,
Compiled Code)
at
weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java,
Compiled Code)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java, Compiled Code)

; nested exception is:
java.sql.SQLException: ORA-01400: cannot insert NULL into
("EJB"."CABIN"."NAME")
java.sql.SQLException: ORA-01400: cannot insert NULL into
("EJB"."CABIN"."NAME")
com.titan.cabin.Cabin
com.titan.cabin.CabinBeanHomeImpl_ServiceStub.create(int)
void com.titan.cabin.Client_1.main(java.lang.String[])

[Cameron Purdy]

You should post this question in the cmp newsgroup.

The answer is that the EJB must have a corresponding field for the database
column and ejbCreate() must set that field to a non-null value. For an
explanation of why, see the EJB 1.1 specification, available from
http://java.sun.com/j2ee.

Cameron Purdy, LiveWater

"Nam" <bv...@yahoo.com> wrote in message news:3947DF4D...@yahoo.com...