• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Tomcat Server StartUp Failed

 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Tomcat Server Log Details :


I have started a simple Struts Project . It has a login form and registerform on the first page. However When I tried to start the Tomcat server , the server doesn't start.
It throws a SQLIntegrityConstraintViolationException even when the underlying table has no data yet.
The bold line in the code belongs to the following java class.


Tomcat Server Output is as following :


Any suggestions will be appreciated ... thanks
 
Sheriff
Posts: 22650
126
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Parminder Ghai wrote:java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RAMAN.SYS_C004350) violated


You have a unique constraint on that table, and you're trying to insert a value in a column that already has that value in another record. You'll have to check your database schema to find out which column that is.
 
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
as Previous poster said, you need to find the index that is being violated, then find out what inserts into that table, as it appears to be trying to insert the same row twice.

trying to remember I think all_indexes is the table to select upon.

and i wrapped some long lines in your code sections, as they don't get wrapped automatically.
 
Raman Ghai
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I guess that column is emailId
By the way , I truncated the table and redeployed the project on Glassfish as Tomcat didn't allow me to redeploy the project .
Now it's working .

Thanks for replying
 
I can't take it! You are too smart for me! Here is the tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic