Hi Folks, I have a similar Problem, I'm using Qooxdoo as Framework, MSSQL-Server 2K5 as Database and XML for Mapping.
I'll post my code, maybe someone can help me to find the error because when I first wrote the stuff with german naming for values etc. it works fine. Then my boss ordered me to change everything to english and now it won't work anymore. Here is the code of the form called pickUpContract.form.xml:
<?xml version="1.0" encoding="UTF-8"?>
<form xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/form.xsd">
<toolbar hasSaveButton="true" hasSaveAndExitButton="true" hasDeleteButton="true"/>
<headText>Abholauftrag</headText>
<backendKey>afbDaten</backendKey>
<dataHandler>afbDaten.logic.PickUpContract.PickUpContractLogic</dataHandler>
<conditions>
<condition id="0" setting="enabled" comparator="v" source="form">supplier</condition>
<condition id="1" setting="enabled" comparator="nv" source="form">supplier</condition>
</conditions>
<tabs>
<tab name="Abholauftrag">
<subForms>
<subForm type="single" mapping="afbDaten/dbm/PickUpContract.hbm.xml"
editable="true" javaClass="afbDaten.dbm.PickUpContract">
<hql keyField="id">from PickUpContract where id = :id</hql>
<formGrid>
<layout>
<columns>
<column pos="1">100</column>
<column pos="2">100</column>
<column pos="3">100</column>
<column pos="4">100</column>
<column pos="5">100</column>
</columns>
</layout>
<formFields>
<field><hidden binding="id" buffer="id"></hidden></field>
</formFields>
</formGrid>
</subForm>
</subForms>
</tab>
<tab name="AbholauftragDetails">
<subForms>
<subForm editable="true" type="endless" javaClass="afbDaten.dbm.PickUpContractDetails"
mapping="afbDaten/dbm/PickUpContractDetails.hbm.xml">
<hql keyField="id"> from PickUpContractDetails where pickUpContract=:id</hql>
<dataGrid pageSize="9" filter="true" deletable="true">
<headFields>
<field row="0" column="1"><label value="Menge" width="50"/></field>
<field row="0" column="5"><label value="Memo" width="240"/></field>
<field row="0" column="2"><label value="Typ" width="100"/></field>
<field row="0" column="3"><label value="Seriennummer" width="120"/></field>
<field row="0" column="4"><label value="Inventarnummer" width="120"/></field>
</headFields>
<formFields>
<field><hidden binding="client" buffer="client"></hidden></field>
<field row="0" column="1"><textField binding="quantity" width="50">
<validations>
<validation type="notNull">Das Feld darf nicht leer sein.</validation>
</validations>
</textField></field>
<field row="0" column="5"><textField binding="memo" width="240"></textField></field>
<field row="0" column="2">
<comboBoxPage binding="type" width="100" enabled="true">
<data>
<hql> from afbDaten.dbm.Category where client = :client</hql>
<boundField>type</boundField>
<shownFields>
<shownField text="GeräteTyp">type</shownField>
</shownFields>
</data>
</comboBoxPage>
</field>
<field row="0" column="3"><textField binding="serialNumber" width="120"/></field>
<field row="0" column="4"><textField binding="customerInventoryId" width="120"/></field>
<field> <!-- here starts the obvious wrong code -->
<hidden binding="pickUpContract">
<data>
<parameter>id</parameter>
<foreignClass>afbDaten.dbm.PickUpContract</foreignClass>
</data>
</hidden> <!-- here ends the code -->
</field>
</formFields>
</dataGrid>
</subForm>
</subForms>
</tab>
</tabs>
</form>
the next code is the code of the xml mapping class called PickUpContractDetails.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="afbDaten.dbm">
<class name="PickUpContractDetails" table="PickUpContractDetails" dynamic-update="true">
<id name="id" type="string">
<column name="id" />
<generator class="backend.NumberCircleGenerator" />
</id>
<property name="client" type="string">
<column name="client" not-null="false" length="20"></column>
</property>
<property name="quantity" type="string">
<column name="quantity" not-null="true" length="50"></column>
</property>
<property name="memo" type="string">
<column name="memo" not-null="false" length="500"></column>
</property>
<property name="serialNumber" type="string">
<column name="serialNumber" not-null="false" length="50"></column>
</property>
<property name="customerInventoryId" type="string">
<column name="customerInventoryId" not-null="false" length="50" /column>
</property>
<property name="saleStatus" type="string">
<column name="saleStatus" not-null="false" length="50"></column>
</property>
<!-- foreigen keys -->
<many-to-one name="pickUpContract" class="PickUpContract" fetch="select">
<column name="pickUpContract" not-null="true"></column>
</many-to-one>
<!-- the following foreign key is not hardwired so only combobox without mapping -->
<property name="type" type="string">
<column name="type" not-null="false" length="50"></column>
</property>
</class>
</hibernate-mapping>
the next code is the associated java file PickUpContractDetails.hbm.java:
package afbDaten.dbm;
public class PickUpContractDetails implements java.io.Serializable{
/**
*
*/
private static final long serialVersionUID = 3062108500774998374L;
private String quantity;
private String memo;
private String type;
private PickUpContract pickUpContract;
private String id;
private String serialNumber;
private String customerInventoryId;
private String client;
private String saleStatus;
public PickUpContractDetails(){
}
public PickUpContractDetails(String quantity, String memo, String type, PickUpContract pickUpContract, String id,
String saleStatus, String client, String customerInventoryId, String serialNumber){
this.quantity=quantity;
this.memo=memo;
this.type=type;
this.pickUpContract=pickUpContract;
this.id=id;
this.saleStatus=saleStatus;
this.client=client;
this.customerInventoryId=customerInventoryId;
this.serialNumber=serialNumber;
}
public PickUpContract getPickUpContract() {
return pickUpContract;
}
public void setPickUpContract(PickUpContract pickUpContract) {
this.pickUpContract = pickUpContract;
}
public String getMemo() {
return memo;
}
public void setMemo(String memo) {
this.memo = memo;
}
public String getQuantity() {
return quantity;
}
public void setQuantity(String quantity) {
this.quantity = quantity;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getCustomerInventoryId() {
return customerInventoryId;
}
public void setCustomerInventoryId(String customerInventoryId) {
this.customerInventoryId = customerInventoryId;
}
public String getSerialNumber() {
return serialNumber;
}
public void setSerialNumber(String serialNumber) {
this.serialNumber = serialNumber;
}
public String getClient() {
return client;
}
public void setClient(String client) {
this.client = client;
}
public String getSaleStatus() {
return saleStatus;
}
public void setSaleStatus(String saleStatus) {
this.saleStatus = saleStatus;
}
}
When I use it like this I always get the errormessage which named this topic.
thanx for help
Login
FAQ
Search
