Hi, i'm in trouble with a painful occurence ;0)
try to create a rowset with the OJBPersistenceBroker. There is char-field
named 'languageID', which is a foreign-key. OJB returns with the following
message:
ORA-01400: cannot insert NULL into ("GECO"."BRANCH"."LANGUAGE_ID")
java.sql.SQLException: ORA-01400: cannot insert NULL into
("GECO"."BRANCH"."LANGUAGE_ID")
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2709)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:589)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
It seems, that the char languageID is not setted in the PreparedStatement.
In the following i attache the copy of the user-repository. Can anyone help
me please? Got no more ideas. Thx in advance. Peter
<!-- user defined mappings -->
<class-descriptor
class="com.gecapital.geco.api.entity.table.BranchTable"
table="BRANCH">
<field-descriptor
name="branchId"
column="BRANCH_ID"
primarykey="true"
autoincrement="false"
jdbc-type="VARCHAR"
/>
......
<field-descriptor
name="languageID"
column="LANGUAGE_ID"
jdbc-type="CHAR"
/>
.......
<reference-descriptor
name="languageTable"
class-ref="com.gecapital.geco.api.entity.table.LanguageTable"
>
<foreignkey field-ref="languageID"/>
</reference-descriptor>
<reference-descriptor
name="regionCenterTable"
class-ref="com.gecapital.geco.api.entity.table.RegionCenterTable"
>
<foreignkey field-ref="regionCenterId"/>
</reference-descriptor>
</class-descriptor>
<class-descriptor
class="com.gecapital.geco.api.entity.table.LanguageTable"
table="LANGUAGE">
<field-descriptor
name="languageId"
column="LANGUAGE_ID"
primarykey="true"
autoincrement="false"
jdbc-type="CHAR"
/>
<field-descriptor
name="language"
column="LANGUAGE"
jdbc-type="VARCHAR"
/>
</class-descriptor>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
