• Post Reply Bookmark Topic Watch Topic
  • New Topic

Unable to delete  RSS feed

 
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,
I have a table named Contact in mysql running on localhost. The columns in the table are ID,FIRSTNAME, LASTNAME and EMAIL.
There's only one row in the table. The values in the row are ID = 6, FIRSTNAME = Subhash, LASTNAME = Medhi and EMAIL = subhash.chandra.medhi@xyz.com .

I am using the following code to delete this row:



if i execute this code, the row doesn't get deleted and i get the following output:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
null


if use try-catch statement around "row = query.executeUpate();" in the following way:



the row doesn't get deleted, and i get the following output:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
null
Couldn't delete any row!

Kindly do let me know where i might have gone wrong.

[ Edited to use code tags - Paul Sturrock ]
[ September 11, 2008: Message edited by: Paul Sturrock ]
 
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
null


This output is log4j telling you you have not configured your loggers correctly. Nothing to do with Hibenrtae itself. I'd double check what you've got in log4j.properties and where it is.

Your code is assuming Hibernate is working "non-transationally" i.e. there either are no transactions involved, or if there are they are auto-commiting. Auto-commit is disabled by default in Hibernate, so unless you have configured it otherwise you'll need to wrap your operation in a transaction and commit it at the end. See this.
[ September 11, 2008: Message edited by: Paul Sturrock ]
 
Author
Ranch Hand
Posts: 3417
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Throw this in your log4j.properties file, and you should get rid of the warnings:

http://ideoplex.com/id/386/controlling-hibernate-output-with-log4j



-Cameron McKenzie
[ September 11, 2008: Message edited by: Cameron Wallace McKenzie ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!