Oracle Sql Error 1400 Sqlstate 23000
Contents |
Error: ora-01400 cannot insert null into oracle 1400, SQLState: 23000 Log In ora-01400 error in informatica ExportXMLWordPrintableDetails Type: Bug Status: Resolved Priority: High Resolution: ora-01400 cannot insert null into primary key Invalid Affects Version/s: None Fix Version/s: None Component/s: Database, Deployment Labels: blue Environment:
Ora 01400 Cannot Insert Null In Oracle Forms
Acceptance Last commented by user?: true Description 2015-02-04 09:50:07,573 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000 [main] 2015-02-04 09:50:07,573 ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01400: cannot insert ora 01400 exception NULL into ("CFREVGEAR"."SELECTED_CLM_FILE"."CLM_FILE_FLTR_CRITA_ID") [main] 2015-02-04 09:50:07,573 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000 [main] 2015-02-04 09:50:07,573 ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01400: cannot insert NULL into ("CFREVGEAR"."SELECTED_CLM_FILE"."CLM_FILE_FLTR_CRITA_ID") [main] 2015-02-04 09:50:07,574 ERROR org.hibernate.event.def.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:94) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.Ses
STERLINGNFX Technote (troubleshooting)
Ora 01400 Exception Name
Problem(Abstract) ORA-01400: cannot insert NULL into ACT_AUTHENTICATE Symptom Customer receives the ORA-01400 on ACT_AUTHENTICATE https://jira.atlassian.com/browse/CWD-4233 table error in the Visibiilty log. Tested and found issue is when the bp Connect Direct Server Begin Session service does not use the RemoteUserId and instead http://www.ibm.com/support/docview.wss?uid=swg21553095 uses proxy to set a userid. Error Message [2007-11-14 18:38:07.826] ERROR SQL Error Code: 1400 [2007-11-14 18:38:07.826] ERROR SQL State: 23000 java.sql.SQLException: ORA-01400: cannot insert NULL into ("GIS_USER"."ACT_AUTHENTICATE"."PRINCIPAL") at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3422) at sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.sterlingcommerce.woodstock.mailbox.db.SQLWrapper.forwardMethod(SQLWrapper.java:65) at com.sterlingcommerce.woodstock.mailbox.db.StatementWrapper.invoke(StatementWrapper.java:144) at $Proxy1.execute(Unknown Source) at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouse$1.body(DmiVisEventWarehouse.java:281) at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._runInTransaction(D
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript https://community.oracle.com/thread/806493 and much of it will not work http://forum.spring.io/forum/spring-projects/data/15715-pb-with-spring-hibernate-oracle-and-merge correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. cannot insert More discussions in weblogic.developer.interest.portal All PlacesOracle CommunityArchived ForumsArchived BEA Dev2Dev Forums (Read-only)WebLogic Portal Newsgroupsweblogic.developer.interest.portal This discussion is archived 1 Reply Latest reply on Apr 10, 2008 2:48 PM by 666705 SQL Error while trying to createMarkupDefinition 666705 Nov 9, cannot insert null 2007 9:53 PM We upgraded wls portal schem from 8.1 to 10 and when we tried to deploy the app we had issues inserting the MarkupDefinition. Attached is the error. The error also complains that there might be Possible markup duplication of [MrkupDefinition]
and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor. Announcement Announcement Module Collapse No announcement yet. Pb with Spring/Hibernate/Oracle and merge Page Title Module Move Remove Collapse X Conversation Detail Module Collapse Posts Latest Activity Search Forums Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only Videos only Links only Polls only Filtered by: Clear All new posts cbeuchot Junior Member Join Date: Feb 2006 Posts: 13 #1 Pb with Spring/Hibernate/Oracle and merge May 9th, 2006, 04:03 AM Hello, I have problems with transitive persistence with Spring, Hibernate and Oracle9i What I am trying to do is really simple : I want to persist am object (Owner) with its children (Pets) like this: Code: UserService userService = (UserService) factory.getBean("billing"); Owner owner = new Owner(); owner.setFirstName("Christophe"); owner.setLastName("Maurice"); owner.setCity("Zurich"); Pet fido = new Pet(); fido.setName("Fido"); owner.addPet(fido); Pet rex = new Pet(); rex.setName("Rex"); owner.addPet(rex); userService.CreateOwner(owner); The structure of classes Owner and Pet are really similar to those in petclinic. I have a business implementation of my UserService like this: Code: public class Billing implements UserService, CustomerService { .... public Long CreateOwner(Owner owner) { Long ownerId = userDao.CreateOwner(owner); return ownerId; } .... The implementation of userDao : Code: public class UserDaoHibernate extends HibernateDaoSupport implements UserDao { .... public Long CreateOwner(Owner owner) throws DataAccessException { getHibernateTemplate().merge(owner); return owner.getId(); } .... } The app ctx : Code: