• 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:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

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: 22510
122
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
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic