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 | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Hibernate Community • View topic - Hibernate & WAS 6.0

    hibernate.org | 6 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