Hi,
I am trying to use XDoclet/EJBDoclet to create my beans.
In my bean I have
* @ejb:bean
* type="CMP"
* cmp-version="2.x"
* name="MarketingRequests"
* local-jndi-name="cmr.MarketingRequestsLocalHome"
* view-type="local"
* primkey-field="mrId"
*
* @weblogic:table-name MarketingRequests
* @weblogic:data-source-name EtsDataSource
* @jboss.persistence table-name="MarketingRequests"
* @jboss.persistence datasource="java:/EtsDataSource" datasource-mapping="MS SQLSERVER2000"
* @weblogic:persistence
* @weblogic:automatic-key-generation
* generator-type="SQL_SERVER"
* @ejb:pk class="java.lang.Integer"
* generate="false"
* @jboss.unknown-pk class="java.lang.Integer"
* auto-increment="true"
*
* @weblogic:cache concurrency-strategy="Optimistic"
* cache-between-transactions="True"
* @weblogic:verify-columns Timestamp
* @weblogic:optimistic-column updated_last
public abstract class MarketingRequestsBean implements EntityBean {
private javax.ejb.EntityContext _entityContext;
/**
* answers the getMrId
* @return the getMrId
* @ejb:primkey-field
* @ejb:persistent-field
* @ejb:interface-method view-type="local"
* @ejb:transaction type="Supports"
* @weblogic:dbms-column mr_id
* @jboss.column-name="mr_id"
* @jboss.persistence auto-increment="true"
*/
public abstract java.lang.Integer getMrId();
As you can see I am trying to set mrId(mr_id) as a primary key which is managed by my db.
My generated jbooscmp-jdbc.xml looks like
<ejb-name>MarketingRequests</ejb-name>
java:/EtsDataSource
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
<table-name>MarketingRequests</table-name>
<cmp-field>
<field-name>mrId</field-name>
</cmp-field>
The mapping and autoincrement is not showing here??
I am using xdoclet 1.2.3, java 1.4, ant 1.5.4
Because of this, when I try to create a row I get
17:58:37,172 INFO [STDOUT] Caused by: javax.ejb.CreateException: Error checking if entity exists:java.sql.SQLException:, [Microsoft][SQLServer JDBC Driver][SQLServer]Invalid column name 'mrId'.
Can anyone tell me where I am goign wrong.
Regards
Rajesh J
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3885811#3885811
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3885811
|
