javax.ejb.TransactionRolledbackLocalException: ; nested exception is: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select transactio0_.TXN_TYPE_ID as TXN1_1_, transactio0_.NAME as NAME1_, transactio0_.DESCRIPTION as DESCRIPT3_1_ from MMS_TXN_TYPE transactio0_ where transactio0_.NAME=?]; SQL state [null]; error code [0]; enlist: caught Exception; nested exception is java.sql.SQLException: enlist: caught Exception

hibernate.org | 5 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Hibernate Community • View topic - Hibernate & WAS 6.0

    hibernate.org | 5 months ago
    javax.ejb.TransactionRolledbackLocalException: ; nested exception is: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select transactio0_.TXN_TYPE_ID as TXN1_1_, transactio0_.NAME as NAME1_, transactio0_.DESCRIPTION as DESCRIPT3_1_ from MMS_TXN_TYPE transactio0_ where transactio0_.NAME=?]; SQL state [null]; error code [0]; enlist: caught Exception; nested exception is java.sql.SQLException: enlist: caught Exception

    Root Cause Analysis

    1. javax.ejb.TransactionRolledbackLocalException

      ; nested exception is: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select transactio0_.TXN_TYPE_ID as TXN1_1_, transactio0_.NAME as NAME1_, transactio0_.DESCRIPTION as DESCRIPT3_1_ from MMS_TXN_TYPE transactio0_ where transactio0_.NAME=?]; SQL state [null]; error code [0]; enlist: caught Exception; nested exception is java.sql.SQLException: enlist: caught Exception

      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate()
    2. Spring Framework
      SQLErrorCodeSQLExceptionTranslator.translate
      1. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:97)
      2. org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:268)
      2 frames
    3. Hibernate
      HibernateTemplate.findByNamedQueryAndNamedParam
      1. org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
      2. org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
      3. org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
      4. org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQueryAndNamedParam(HibernateTemplate.java:916)
      4 frames
    4. com.staples.mms
      AbstractTransactionConsumerBean.onMessage
      1. com.staples.mms.dao.AbstractHibernateDAO.findByNamedQuery(AbstractHibernateDAO.java:65)
      2. com.staples.mms.dao.AbstractHibernateDAO.findUnique(AbstractHibernateDAO.java:201)
      3. com.staples.mms.dao.txn.TransactionTypeDAO.findByTypeName(TransactionTypeDAO.java:43)
      4. com.staples.mms.service.txn.generic.TransactionTypeValidationRule.validate(TransactionTypeValidationRule.java:56)
      5. com.staples.mms.service.txn.generic.TransactionValidationServiceImpl.process(TransactionValidationServiceImpl.java:47)
      6. com.staples.mms.service.txn.generic.TransactionProcessorServiceImpl.process(TransactionProcessorServiceImpl.java:43)
      7. com.staples.mms.txn.ejb.MMSTransactionProcessorBean.process(Unknown Source)
      8. com.staples.mms.txn.ejb.EJSLocalStatelessMMSTransactionProcessor_83279595.process(Unknown Source)
      9. com.staples.mms.txn.ejb.AbstractTransactionConsumerBean.onMessage(Unknown Source)
      9 frames
    5. com.ibm.ejs
      MDBWrapper$PriviledgedOnMessage.run
      1. com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnMessage.run(MDBWrapper.java:316)
      1 frame