java.sql.SQLException: ORA-00001: unique constraint (PROMOTIONS.SYS_C0054479 ) violated

Google Groups | Benjamin E.Ndugga | 4 months ago
  1. 0

    How to update or Delete Store entry upon Eviction and Value Update

    Google Groups | 4 months ago | Benjamin E.Ndugga
    java.sql.SQLException: ORA-00001: unique constraint (PROMOTIONS.SYS_C0054479 ) violated
  2. 0

    Oracle APPS (E-BUSINESS SUITE) 11i - R12: java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation

    blogspot.com | 2 years ago
    java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation
  3. 0

    Jboss 7.x - HA Web Sessions via Database Persis... | JBoss Developer

    jboss.org | 11 months ago
    java.sql.SQLException: ORA-00922: missing or invalid option
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I have installed Yaft, but at the database creation on tomcat startup appears this error when creating objects. 2009-03-10 13:55:52,112 INFO Thread-1 org.sakaiproject.yaft.impl.YaftForumServiceImpl - Registering Yaft functions ... 2009-03-10 13:55:52,175 ERROR Thread-1 org.sakaiproject.yaft.impl.YaftPersistenceManager - Caught exception whilst setting up tables. Rolling back ... java.sql.SQLException: ORA-00902: tipo de dato no válido 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.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.sakaiproject.yaft.impl.YaftPersistenceManager.setupTables(YaftPersistenceManager.java:94) at org.sakaiproject.yaft.impl.YaftForumServiceImpl.init(YaftForumServiceImpl.java:59) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1240) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1205) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248) at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160) at org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:74) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352) at org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:146) at org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:68) at org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:80) at org.sakaiproject.dav.DavServlet.init(DavServlet.java:488) at javax.servlet.GenericServlet.init(GenericServlet.java:212) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) I use oracle, it maybe the problem, datatypes error.

    Sakai JIRA | 3 years ago | zhou chumin
    java.sql.SQLException: ORA-00902: tipo de dato no válido
  6. 0

    Problem while changing DB from Pointbase to Oracle

    Oracle Community | 8 years ago | 661505
    java.sql.SQLException: ORA-00942: table or view does not exist [java]

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00001: unique constraint (PROMOTIONS.SYS_C0054479 ) violated

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeUpdate
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
      6. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
      8. oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
      9. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
      9 frames
    3. com.ibm.ug
      IMSIMapStore.store
      1. com.ibm.ug.hz.IMSIMapStore.store(IMSIMapStore.java:38)
      2. com.ibm.ug.hz.IMSIMapStore.store(IMSIMapStore.java:21)
      2 frames
    4. com.hazelcast.map
      MapStoreWrapper.store
      1. com.hazelcast.map.impl.MapStoreWrapper.store(MapStoreWrapper.java:93)
      1 frame