1. Extracting more information from SQL Exception forum.hibernate.orgI am using Hibernate 3.0.5 and Hibernate Transaction manager to manage transaction. When flushing the objects, say Oracle DB didnt accept and JDBC driver throws the exception with message "cannot insert NULL into |
2. Strange SQL exception 32769 forum.hibernate.orgUsing Hibernate 3.2.5, DB2 ver. 9 on z/OS and IBM Websphere 6.0 we sometimes encounter the following log statements during application execution... [22-06-10 15:28:27:001 CEST] 000004df SystemOut O ** WARN (org.hibernate.util.JDBCExceptionReporter) - SQL Error: 0, SQLState: null [22-06-10 15:28:27:001 CEST] 000004df SystemOut O ** ERROR (org.hibernate.util.JDBCExceptionReporter) - 32769 When 'hit' the app server needs to be restarted and generally, this exception ... |
3. Exception not throw (java.sql.SQLException) forum.hibernate.orgThanks Brannor, I have mapped the constraints in map file ... at least I think ... look: -- |
4. |
5. SQL exception (invalid use of keyword USER) forum.hibernate.orgNewbie Joined: Thu Oct 21, 2004 5:43 am Posts: 2 Hi All, I have a somewhat annoying problem. In my database (MSSQL) I have a "users" table. The convention for hibernate seems to be to name the class as the singular so I have "data.User" as a classname. When I issue a query: String query = "select user from user " ... |
6. java.sql.savepoint exception forum.hibernate.org |
7. Hibernate / Derby - SQL Exception: Table 'HIBERNATE_UNIQUE_K forum.hibernate.orgAuthor Message timdyck Post subject: Hibernate / Derby - SQL Exception: Table 'HIBERNATE_UNIQUE_K Posted: Thu Dec 22, 2005 3:50 pm Newbie Joined: Thu Dec 22, 2005 3:39 pm Posts: 1 Location: Bellingham, WA I am having troubles getting derby and hibernate to work together. I keep getting an exception saying that the Table 'HIBERNATE_UNIQUE_KEY' does not exist. Is this ... |
8. Exception while using native sql forum.hibernate.orgQuery: SQLQuery qry = HibernateUtil.currentSession().createSQLQuery(" select ordrPosType as ord from STOrderTO STO where " +"STO.ordrStat in ( 1,2,3,15,16,29,41) " +"and STO.instrumentId=4276"); qry.addScalar("ord",Hibernate.STRING); result = qry.list(); mapping file: |
9. how to disable exception throw by java.sql ? forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:3.2.2 Full stack trace of any exception that occurs: 18:34:06,828 WARN [JDBCExceptionReporter] SQL Error: 1062, SQLState: 23000 18:34:06,828 ERROR [JDBCExceptionReporter] Duplicate entry '2007-03-12 00:00:00-2908' for key 1 18:34:06,868 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249) ... |
10. Exception while executing native SQL forum.hibernate.orgHi, I am getting the following error while using native sql query, Quote: org.hibernate.QueryException: No column name found for property [user] for alias [pi] [Select pycis.INSTN_ID_N as {pi.instnIdN}, pycis.INSTN_NM_C as {pi.instnNmC}, pycis.CIBS_ACCT_NUM_N as {pi.cibsAcctNumN}, pycis.TMPL_TYPE_LVL_3_C as {pi.cibsStrucCodeC}, pycis.CIBS_DISC_NM_C as {pi.cibsDiscNmC}, pycis.CIBS_SUBDISC_NM_C as {pi.cibsSubdiscNmC}, smple.userr as {pi.user}, smple.datte as {pi.updDt} from pcr.v_pycis_dwh_acct pycis , (Select instAtt.INSTN_ID_N as instanceId,instAtt.UPD_USR_C as userr,instAtt.UPD_DT_D as datte ... |