Hello,
I have some problems with db.update since I upgraded from castor 0.9.6 to 0.9.9.
In the Javacode below you can see, that I don't set the field "endtime". That's
why I get
the following Exception:
07.11.2005 09:05:57 org.exolab.castor.jdo.engine.SQLEngine create
INFO: A fatal error occurred while creating/updating
oms.db.castor.entities.FiletransferexecutionImpl using SQL:
{call INSERT INTO "FILETRANSFEREXECUTION"
("STARTTIME","ENDTIME","FILETRANSFERINSTANCE","STATE") VALUES (?,?,?,?)
RETURNING "ID" INTO ?}
java.sql.SQLException: ORA-01008: Nicht allen Variablen ist ein Wert zugeordnet
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
. . .
Do you have any idea why I get this exception, because in Oracle "endtime" is a
nullable column and in the mapping file the field has required="false"?
//*********** Javacode **************************************
ftExecution =
(Filetransferexecution)BOManager.getInstance(Filetransferexecution.class);
ftExecution.setStarttime(new Timestamp(today.getTime()));
ftExecution.setFiletransferinstance(filetransferinstance);
ftExecution.setState(ftState);
db.update(ftExecution);
//********* Table in Oracle *********************************
SQL> desc filetransferexecution;
Name Null? Typ
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(18)
FILETRANSFERINSTANCE NOT NULL NUMBER(18)
STATE NOT NULL NUMBER(18)
STARTTIME DATE
ENDTIME DATE
//********* mapping.xml **************************************
<!-- Mapping for Filetransferexecution -->
<class name="oms.db.castor.entities.FiletransferexecutionImpl" identity="id"
key-generator="RETURNING">
<cache-type type="unlimited"/>
<map-to table="FILETRANSFEREXECUTION"/>
<field name="id" type="long">
<sql name="id" type="numeric"/>
</field>
<field name="starttime" type="timestamp" required="false">
<sql name="starttime" type="timestamp"/>
</field>
<field name="endtime" type="timestamp" required="false">
<sql name="endtime" type="timestamp"/>
</field>
<field name="filetransferinstance"
type="oms.db.castor.entities.FiletransferinstanceImpl">
<sql name="filetransferinstance"/>
</field>
<field name="state" type="oms.db.castor.entities.FiletransferstateImpl">
<sql name="state"/>
</field>
</class>
Thanks,
Helene
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
