I am working with jboss 2.4.1 server and Oracle8 database .I had a CMP bean named Customer with following CMP fields
public Integer customerId;
public Date since;
public double balance;
public String credit;
public double creditLimit;
public double ytdPayment;
The database table descriptin for this CMP bean is
c_id integer not null,
c_first char(16),
c_last char(16),
c_street1 char(20),
c_street2 char(20),
c_city char(20),
c_state char(2),
c_country char(10),
c_zip char(9),
c_phone char(16),
c_contact char(25),
c_since date,
c_balance numeric(9,2),
c_credit char(2),
c_credit_limit numeric(9,2),
c_ytd_payment numeric(9,2)
I had jaws.xml file in the following format
java:/ECperfDS
<type-mapping>Oracle8</type-mapping>
<default-entity>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>false</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
</default-entity>
<enterprise-beans>
<ejb-name>CustomerEnt</ejb-name>
<table-name>CustomerEnt</table-name>
<cmp-field>
<field-name>customerId</field-name>
<column-name>customerId</column-name>
</cmp-field>
<cmp-field>
<field-name>since</field-name>
<column-name>since</column-name>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</cmp-field>
<cmp-field>
<field-name>balance</field-name>
<column-name>balance</column-name>
</cmp-field>
<cmp-field>
<field-name>credit</field-name>
<column-name>credit</column-name>
</cmp-field>
<cmp-field>
<field-name>creditLimit</field-name>
<column-name>creditLimit</column-name>
</cmp-field>
<cmp-field>
<field-name>ytdPayment</field-name>
<column-name>ytdPayment</column-name>
</cmp-field>
</enterprise-beans>
while running the client on this application I am getting the following exception.
[Customer] TRANSACTION ROLLBACK EXCEPTION:null
Embedded Exception
javax.ejb.EJBException: null
what might be the problem.Here the CMP fields are not
equal to table columns will this give any problem.
I will be very thankful if any one help me regarding
this problem
Maybe you could try making the column-name elements match your column names.
Field name <=> ejb
column name <=> db table