[jira] [Created] (OPENJPA-2577) In what case [code=17041, state=99999] SQLException returns during lazy fetching?

["rashmi (JIRA)" <ji...@apache.org>]

rashmi created OPENJPA-2577:
-------------------------------

             Summary: In what case [code=17041, state=99999] SQLException returns during lazy fetching?
                 Key: OPENJPA-2577
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2577
             Project: OpenJPA
          Issue Type: Question
          Components: jpa
    Affects Versions: 2.1.2
         Environment: JSF application with EJB 3 and open JPA, running on websphere 8.5
            Reporter: rashmi
            Priority: Blocker


Hi,

In production environment once we got below exception. we are not able to reproduce the problem. That application is stopped using in production due to few issues, out of them one is this.

I tried to replicate this in many ways on production data dump. but i am not able to replicate.

To recreate data to replicate, i want to know when this exception is thrown by JPA framework?

Exception is:
[2014-10-28 13:04:15:209 CET] 0000003c BusinessExcep E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "calculateCompensations" on bean "BeanId(me-std-ear#me-std-web.war#MEFacadeBean, null)". Exception data: <openjpa-2.1.2-SNAPSHOT-r422266:1436521 nonfatal general error> org.apache.openjpa.util.GeneralException: org.apache.openjpa.lib.jdbc.ReportingSQLException: IN- eller OUT-parameter saknas i index:: 1 {prepstmnt 1296099302 SELECT t0.EXTERNAL_ID, t0.LAST_UPDATED, t0.NAME, t0.UOM FROM ITEM t0 WHERE t0.ITEM_ID = ? [params=?]} [code=17041, state=99999]
        at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1008)
        at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:907)
        at com.ibm.ws.persistence.kernel.WsJpaBrokerImpl.find(WsJpaBrokerImpl.java:199)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.find(JDBCStoreManager.java:1010)
        at org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy.load(RelationFieldStrategy.java:781)
        at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:934)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:702)
        at com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:130)
        at org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:117)
        at org.apache.openjpa.datacache.DataCacheStoreManager.load(DataCacheStoreManager.java:442)
        at org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:117)
        at org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)
        at org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:3061)
        at org.apache.openjpa.kernel.StateManagerImpl.loadField(StateManagerImpl.java:3136)
        at org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1606)
        at org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1591)
        at se.ica.me.entity.OfferPartItem.pcGetitem(OfferPartItem.java)
        at se.ica.me.entity.OfferPartItem.getItem(OfferPartItem.java:59)
        at se.ica.me.dao.SaleDAO.getItemsFrom(SaleDAO.java:100)
        at se.ica.me.dao.SaleDAO.getClusterTotalSaleForItem(SaleDAO.java:50)





SaleDao.java Code is as below:

private Set<Item> getItemsFrom(List<OfferPartItem> offerPartItems) {
		Set<Item> items = new HashSet<Item>();
		for(OfferPartItem offerPartItem : offerPartItems) {
			items.add(offerPartItem.getItem());
		}
		return items;
}


OfferPartItem.java entity code:

@Entity
@Table(name="OFFER_PART_ITEM")
public class OfferPartItem implements Serializable {
	private static final long serialVersionUID = 1L;
	
	@Id
	@GeneratedValue(strategy = SEQUENCE, generator = "OFFER_PART_ITEM_SEQ_GNR")
	@SequenceGenerator(name = "OFFER_PART_ITEM_SEQ_GNR", sequenceName = "OFFER_PART_ITEM_SEQ")
	@Column(name="OFFER_PART_ITEM_ID")
	private Long offerPartItemId;
	
	@Column(name="COST_PRICE")
	private BigDecimal costPrice;

    @ManyToOne(fetch=FetchType.LAZY)
	@JoinColumn(name="ITEM_ID")
	private Item item;

       public Item getItem() {
		return this.item;
	}






Item entity code:
@Entity
@Table(name="ITEM")
@NamedQueries({
		@NamedQuery(name = "Item.findByExternalId", query = "SELECT i FROM Item i where i.externalId = :externalId")

})
public class Item implements Serializable {
	private static final long serialVersionUID = 1L;

	public static final String NQ_FIND_BY_EXTERNAL_ID = "Item.findByExternalId";

	@Id
	@GeneratedValue(strategy=SEQUENCE, generator = "ITEM_SEQ_GNR")
	@SequenceGenerator(name = "ITEM_SEQ_GNR", sequenceName = "ITEM_SEQ")
	@Column(name="ITEM_ID")
	private Long itemId;

	/**
	 * ICA StoreItem-identifier
	 */
	@Column(name="EXTERNAL_ID", length=20)
	private String externalId;

	@Column(name="NAME", length=20)
	private String name;


      ...
      ...

}



Table structures
Offer_Part_Item
OFFER_PART_ITEM_ID N	NUMBER (Primary key)
ITEM_ID Y	NUMBER (Foreigh key of ITEM table)
OFFER_PART_ID Y	NUMBER
COST_PRICE Y	NUMBER
SALE_ID	Y	NUMBER

Your early help is very much appreciated.

Regards,
Rashmi



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)