This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tomcat Server StartUp Failed

 
Raman Ghai
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • 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
 
Rob Spoor
Sheriff
Pie
Posts: 20751
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • 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.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic