Aplicação para de funcionar após erro SQLServerException
17/08/2011
0
25877 ["http-bio-8080"-exec-7] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2601, SQLState: S0001 25877 ["http-bio-8080"-exec-7] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot insert duplicate key row in object 'dbo.SYS_SEG_USUARIO' with unique index 'IND_USUARIO_USER_NMAE_PASSWORD'. Aug 17, 2011 11:25:19 AM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [FacesServlet] in context with path [/prjGEO2] threw exception [org.hibernate.exception.SQLGrammarException: could not update: [gestaoobra.usuario.Usuario#118]] with root cause com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.SYS_SEG_USUARIO' with unique index 'IND_USUARIO_USER_NMAE_PASSWORD'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308) at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2590) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2494) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2821) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) at gestaoobra.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:250) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
public class ConexaoHibernateFilter implements Filter { private SessionFactory sf; @Override public void init(FilterConfig config ) throws ServletException { this.sf = HibernateUtil.getSeesioinFactory(); } @Override public void doFilter( ServletRequest servletRequest , ServletResponse serveletResponse , FilterChain chain ) throws ServletException { if ( validaAcessoAPagina((HttpServletRequest) servletRequest, (HttpServletResponse) serveletResponse) ) { try { this.sf.getCurrentSession().beginTransaction(); chain.doFilter(servletRequest, serveletResponse); this.sf.getCurrentSession().getTransaction().commit(); this.sf.getCurrentSession().close(); } catch (Throwable ex) { try { if ( this.sf.getCurrentSession().getTransaction().isActive()) { this.sf.getCurrentSession().getTransaction().rollback(); } } catch (Throwable t) { t.printStackTrace(); } throw new ServletException(ex); } finally{ if ( this.sf.getCurrentSession().isOpen() ) { this.sf.getCurrentSession().close(); } } } } @Override public void destroy() { } private boolean validaAcessoAPagina( HttpServletRequest req, HttpServletResponse resp ) { OpcoesMenuRN opMenuRN = new OpcoesMenuRN(); HttpSession session = req.getSession(); String page = req.getRequestURI(); UsuarioLogado usu = (UsuarioLogado) session.getAttribute("usuario"); boolean pgValida; String pg = page.replace("/prjGEO2/", "").replace("restrito/" ,"").replace("publico/","").replace(".jsf", "").replace(".xhtml", "").replace("/",""); System.out.println("pagina solicitada : " + page ); if ( ( ( page.indexOf("restrito") > - 1 ) || ( page.indexOf("privado") > -1 ) ) ) { if ( ! page.endsWith("login.jsf")) { if ( ( page.endsWith("mainpage.jsf") ) && ( session != null ) && ( usu != null ) && ( usu.isLogado() ) ) { return true; } else { this.sf.getCurrentSession().beginTransaction(); pgValida = opMenuRN.validaFormOpMenu(usu.getIdUsuario(), pg ); this.sf.getCurrentSession().getTransaction().commit(); this.sf.getCurrentSession().close(); if ( ! pgValida ) { try { session.invalidate(); resp.sendRedirect("/prjGEO2/"); return false; } catch (Throwable t) { t.printStackTrace(); } } } } } return true; } }
@ManagedBean(name="cadastroUsuario") @ViewScoped public class CadastroUsuario implements Serializable{ private static final long serialVersionUID = 1L; private List<Usuario> lista; private Usuario selectedUsuario = new Usuario(); private UIPanel panelForm; public UIPanel getPanelForm() { return panelForm; } public void setPanelForm(UIPanel panelForm) { this.panelForm = panelForm; } public void anulaSelcionar() { this.selectedUsuario = new Usuario(); this.cleanSubmittedValues(this.panelForm); } public Usuario getSelectedUsuario() { return this.selectedUsuario; } public void setSelectedUsuario(Usuario selectedUsuario) { this.selectedUsuario = selectedUsuario; } public void onRowSelected(SelectEvent event){ Usuario usu = (Usuario) event.getObject(); } public List<Usuario> getLista() { if ( this.lista == null ) { UsuarioRN usuarioRN = new UsuarioRN(); this.lista = usuarioRN.listar(); } return this.lista; } public void salvar() { try { UsuarioRN usuarioRN = new UsuarioRN(); usuarioRN.salvar(this.selectedUsuario); } catch (Exception e) { FacesContext fctx = FacesContext.getCurrentInstance(); FacesMessage msg = new FacesMessage("Falha durante atualização."); fctx.addMessage(null, msg); } } protected void cleanSubmittedValues(UIComponent component) { component.getChildren().clear(); } }
@Entity @Table(name="SYS_SEG_USUARIO") public class Usuario implements Serializable { private static final long serialVersionUID = 983778034503133406L; @Id @GeneratedValue @Column(name = "ID_USUARIO") private Integer idUsuario; @Column(name = "NOME_USUARIO", length = 140) private String nomeUsuario; @Column(name = "SIGLA_DPTO_USUARIO", length = 40) private String siglaDpto; @org.hibernate.annotations.NaturalId( mutable = true) @Column(name = "USER_NAME", length = 20) private String userName; @org.hibernate.annotations.NaturalId( mutable = true) @Column(name = "PASSWORD_USUARIO", length = 20) private String passWord; @Column(name = "EMAIL_USUARIO", length = 180) private String eMail; @Column(name = "DATA_CADASTRO",insertable=false, updatable=false) private Date dtaCadastro; @Column(name = "DATA_ALTERACAO",insertable=false, updatable=false) private Date dtaAlteracao; @ManyToOne @JoinColumn(name="ID_EMPRESA") private Empresa empresa; @OneToOne(mappedBy="usuariooo", cascade=CascadeType.ALL) @JoinColumn(name="ID_USUARIO", insertable = true, updatable = false) private UsuarioPerfil usuarioPerfil; public Empresa getEmpresa() { return empresa; } get e sets
Dalton Boer
Posts
17/08/2011
Robson Teixeira
17/08/2011
Davi Costa
@Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name = "ID_USUARIO") private Integer idUsuario;
Att Davi
17/08/2011
Dalton Boer
17/08/2011
Dyego Carmo
17/08/2011
Dalton Boer
Clique aqui para fazer login e interagir na Comunidade :)