Galera estou tentando inserir dados no BD mais esta dando erro em um campo com data Error 500: java.sql.SQLException: ORA-00904: “DATACADASTRO”: invalid identifier abaixo esta minha action estou deduzindo que o erro e porque estou setando o valor da data sem validar mais tb não estou conseguindo acessar os método que valida que esta em um pacote e a classe que formata que esta em um outro pacote
aqui esta minha Action
public ActionForward cadastraFilme(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws Exception {
FilmesDAO filmesDAO = new FilmesDAO();
FilmesForm filmesForm = (FilmesForm) form;
FilmesTO filmesTO = filmesForm.getFilmesTO();
filmesTO.setAno(Util.stringToCalendar(filmesTO.getAnoString()));
filmesTO.setDataCadastro(Util.stringToCalendar(filmesTO.getDataCompraString()));
filmesTO.setDataCompra(Util.stringToCalendar(filmesTO.getDataCompraString()));
filmesDAO.cadastraFilmes(filmesTO);
return mapping.findForward("sucesso");
}
Método que valida esta em uma pacote na classe Validacao
public static boolean isValidDate(final String tempDate) {
boolean result = false;
if (!isNull(tempDate)) {
try {
DateFormat df = new SimpleDateFormat("dd/MM/yyyy");
df.setLenient(false);
java.util.Date d = df.parse(tempDate);
result = true;
} catch (ParseException e) {
System.out.println("isValidDate" + "ParseException=" + e.getMessage());
}
}
return result;
}
para formatar esta em outro pacote na classe Util
public static Calendar stringToCalendar(String str) {
Date dt = Util.stringToDate(str);
Calendar cal = new GregorianCalendar();
cal.setTime(dt);
return cal;
}
Minha JSP
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
<%@ page errorPage="erro.jsp"%>
<html>
<head>
<title>:: Cadastrar Filmes ::</title>
</head>
<body bgcolor="lightblue">
<h2 align="CENTER">Cadastrar Fimes</h2>
<br>
<br>
<html:form action="/cadastroFilmes" method="post">
<html:hidden property="operacao" value="cadastraFilme" />
<table border=1 align="center">
<tr>
<td>Titulo:</td>
<td colspan="5"><input type="text" name="filmesTO.titulo" size="60" /></td>
</tr>
<tr>
<td>Sub Titulo:</td>
<td colspan="5"><input type="text" name="filmesTO.subTitulo" size="60" /></td>
</tr>
<tr>
<td>Codigo:</td>
<td colspan="5"><input type="text" name="filmesTO.codigo" size="10" maxlength="2" /></td>
</tr>
<tr>
<td>Genero</td>
<TD>
<select name="filmesTO.genero" size="1">
<option value="Aventura">Aventura</option>
<option value="Ação">Ação</option>
<option value="Terror">Terror</option>
<option value="Suspense">Suspense</option>
</select>
</TD>
<td>Duração</td>
<td colspan="3"><input type="text" name="filmesTO.duracao" size="10" maxlength="10" /></td>
<tr>
<tr>
<TD>Produtora</TD>
<TD>
<select name="filmesTO.produtora" size="1">
<option value="Califórnia">Califórnia</option>
<option value="Universal Pictures">Universal Pictures</option>
<option value="Wall disney">Wall Disney</option>
</select>
</TD>
<TD>Pais</TD>
<TD>
<select name="filmesTO.pais" size="1">
<option value="Brasil ">Brasil</option>
<option value="EUA">EUA</option>
<option value="Alemanhã ">Alemanhã</option>
<option value="França">França</option>
</select>
</TD>
<TD>Midia</TD>
<TD>
<select name="filmesTO.midia" size="1">
<option value="DVD">DVD</option>
<option value="VHS">VHS</option>
</select>
</TD>
</tr>
<tr>
<td>Ano:</td>
<td><html:text property="filmesTO.anoString" size="10" maxlength="10" /></td>
<td>Condição</td>
<td>
<select name="filmesTO.condicao" size="1">
<option value="lancamento">Lançamento</option>
<option value="catalogo">Catalogo</option>
</select>
</td>
<td>Estado</td>
<td>
<select name="filmesTO.estado" size="1">
<option value="ativo">Ativo</option>
<option value="inativo">Inativo</option>
</select>
</td>
</tr>
<tr>
<td>Legenda</td>
<td>
<select name="filmesTO.legenda" size="1">
<option value="dublado">Dublado</option>
<option value="legendado ">Legendado</option>
</select>
</td>
<td>Idioma</td>
<td>
<select name="filmesTO.idioma" size="1">
<option value="portugues">Português</option>
<option value="ingles">Inglês</option>
<option value="alemanhao">Alemanhão</option>
<option value="frances">Francês</option>
</select>
<td>
</tr>
<tr>
<td>Distribuidora:</td>
<td><input type="text" name="filmesTO.distribuidora" size="30" maxlength="25" /></td>
<td>Data Compra:</td>
<td><input type="text" name="filmesTO.dataCompraString" size="10" maxlength="10" /></td>
<td>Data Cadastro:</td>
<td><input type="text" name="filmesTO.dataCadastroString" size="10" maxlength="10" /></td>
</tr>
</table>
<BR>
<BR>
<table align="CENTER">
<tr>
<td><input type="submit" value="Cadastrar"></td>
<td><INPUT TYPE="reset" NAME="limpar" VALUE="Limpar"></td>
<td><input type="button" value="voltar" onclick=javascript:window.history.back()></td>
</tr>
</table>
</html:form>
</body>
</html>
Provavelmente a aplicação está achando a classe de validação, senão apareceria algum erro como “ClassNotFoundException”. Então deve haver algum erro na hora de você formatar a data. Coloque um log para fazer debug da data para ver o que o método está fazendo (pode ser com Log4J).
tai o log
*** Starting the server ***
************ Start Display Current Environment ************
WebSphere Platform 5.1 [BASE 5.1.1 a0426.01] [JDK 1.4.2 cn1420-20040626] running with process name localhost\localhost\server1 and process id 3404
Host Operating System is Windows XP, version 5.1 build 2600 Service Pack 2
Java version = J2RE 1.4.2 IBM J9 build 20040610 (JIT enabled), Java Compiler = j9jit21, Java VM name = IBM J9SE VM
was.install.root = C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51
user.install.root = C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51
Java Home = C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v51\java\jre
ws.ext.dirs = C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/java/lib;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/classes;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/classes;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/lib;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/lib/ext;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/web/help;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime;C:/Program Files/IBM/Rational/SDP/6.0/rwd/eclipse/plugins/com.ibm.etools.webservice.consumption.soap_6.0.2/runtime/worf.jar
Classpath = C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/properties;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/properties;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/lib/bootstrap.jar;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/lib/j2ee.jar;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/lib/lmproxy.jar;C:/Program Files/IBM/Rational/SDP/6.0/runtimes/base_v51/lib/urlprotocols.jar;C:/Program Files/IBM/Rational/SDP/6.0/rwd/eclipse/plugins/com.ibm.etools.websphere.tools.common_6.0.2/wteServers.jar;C:/Program Files/IBM/Rational/SDP/6.0/rwd/eclipse/plugins/com.ibm.etools.websphere.tools.common_6.0.2/wasToolsCommon.jar
Java Library path = C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v51\bin;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v51\java/bin;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v51\java/jre/bin;C:\Program Files\IBM\Rational\SDP\6.0\eclipse\jre\bin;.;C:\Program Files\IBM\Rational\SDP\6.0\eclipse\jre\bin;E:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;c:\temp;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\DMIX;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Rational\common;C:\dev\fake\Password Manager\dll\SIT
************* End Display Current Environment *************
[8/11/08 16:52:36:748 BRT] 155f155f ManagerAdmin I TRAS0017I: The startup trace state is *=all=disabled.
[8/11/08 16:52:36:983 BRT] 155f155f AdminInitiali A ADMN0015I: AdminService initialized
[8/11/08 16:52:37:233 BRT] 155f155f ConfigInfoBui A NMSV0819I: No name server custom properties were found.
[8/11/08 16:52:37:295 BRT] 155f155f Configuration A SECJ0215I: Successfully set JAAS login provider configuration class to com.ibm.ws.security.auth.login.Configuration.
[8/11/08 16:52:37:326 BRT] 155f155f SecurityDM I SECJ0231I: The Security component's FFDC Diagnostic Module com.ibm.ws.security.core.SecurityDM registered successfully: true.
[8/11/08 16:52:37:405 BRT] 155f155f SecurityCompo I SECJ0309I: Java 2 Security is disabled.
[8/11/08 16:52:37:420 BRT] 155f155f SecurityCompo I SECJ0212I: WCCM JAAS configuration information successfully pushed to login provider class.
[8/11/08 16:52:37:420 BRT] 155f155f SecurityCompo I SECJ0240I: Security service initialization completed successfully
[8/11/08 16:52:37:420 BRT] 155f155f JMSRegistrati A MSGS0602I: WebSphere Embedded Messaging Client only has been installed
[8/11/08 16:52:39:139 BRT] 155f155f CacheServiceI I DYNA0048I: WebSphere Dynamic Cache initialized successfully.
[8/11/08 16:52:40:155 BRT] 155f155f JMXSoapAdapte A ADMC0013I: SOAP connector available at port 8880
[8/11/08 16:52:40:155 BRT] 155f155f SecurityCompo I SECJ0243I: Security service started successfully
[8/11/08 16:52:40:155 BRT] 155f155f SecurityCompo I SECJ0210I: Security enabled false
[8/11/08 16:52:40:545 BRT] 155f155f ApplicationMg A WSVR0200I: Starting application: IBMUTC
[8/11/08 16:52:40:701 BRT] 155f155f WebContainer A SRVE0161I: IBM WebSphere Application Server - Web Container. Copyright IBM Corp. 1998-2002
[8/11/08 16:52:40:701 BRT] 155f155f WebContainer A SRVE0162I: Servlet Specification Level: 2.3
[8/11/08 16:52:40:717 BRT] 155f155f WebContainer A SRVE0163I: Supported JSP Specification Level: 1.2
[8/11/08 16:52:40:748 BRT] 155f155f WebContainer A SRVE0169I: Loading Web Module: Universal Test Client.
[8/11/08 16:52:40:858 BRT] 155f155f WebGroup I SRVE0180I: [Universal Test Client] [/UTC] [Servlet.LOG]: JSP 1.2 Processor: init
[8/11/08 16:52:40:905 BRT] 155f155f WebGroup I SRVE0180I: [Universal Test Client] [/UTC] [Servlet.LOG]: SimpleFileServlet: init
[8/11/08 16:52:40:936 BRT] 155f155f ApplicationMg A WSVR0221I: Application started: IBMUTC
[8/11/08 16:52:40:936 BRT] 155f155f ApplicationMg A WSVR0200I: Starting application: Locadora1EAR
[8/11/08 16:52:41:045 BRT] 155f155f WebContainer A SRVE0169I: Loading Web Module: Locadora1.
[8/11/08 16:52:41:295 BRT] 155f155f WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: JSP 1.2 Processor: init
[8/11/08 16:52:41:592 BRT] 155f155f WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: SimpleFileServlet: init
[8/11/08 16:52:41:592 BRT] 155f155f WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: InvokerServlet: init
[8/11/08 16:52:41:686 BRT] 155f155f WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: action: init
[8/11/08 16:52:41:717 BRT] 155f155f PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
[8/11/08 16:52:41:733 BRT] 155f155f PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
[8/11/08 16:52:42:155 BRT] 155f155f PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='com.brq.locadora1.resources.ApplicationResources', returnNull=true
[8/11/08 16:52:42:155 BRT] 155f155f ApplicationMg A WSVR0221I: Application started: Locadora1EAR
[8/11/08 16:52:42:389 BRT] 155f155f HttpTransport A SRVE0171I: Transport http is listening on port 9,080.
[8/11/08 16:52:44:452 BRT] 155f155f HttpTransport A SRVE0171I: Transport https is listening on port 9,443.
[8/11/08 16:52:44:467 BRT] 155f155f RMIConnectorC A ADMC0026I: RMI Connector available at port 2809
[8/11/08 16:52:44:498 BRT] 155f155f WsServer A WSVR0001I: Server server1 open for e-business
[8/11/08 16:54:04:091 BRT] 208d208d SystemOut O FiltroAutenticador()
[8/11/08 16:54:04:091 BRT] 208d208d SystemOut O init(FilterConfig arg0)
[8/11/08 16:54:04:669 BRT] 208d208d WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: /index.jsp: init
[8/11/08 16:54:04:747 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
[8/11/08 16:54:04:747 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
[8/11/08 16:54:04:747 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
[8/11/08 16:54:05:950 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.actions.LocalStrings', returnNull=true
[8/11/08 16:54:06:372 BRT] 208d208d WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: /WEB-INF/jsp/Login/login.jsp: init
[8/11/08 16:54:06:435 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
[8/11/08 16:54:06:435 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
[8/11/08 16:54:07:857 BRT] 208d208d OSEListenerDi E PLGN0021E: Servlet Request Processor Exception: Virtual Host/WebGroup Not Found : The web group /favicon.ico has not been defined
[8/11/08 16:54:07:904 BRT] 208d208d OSEListenerDi E PLGN0021E: Servlet Request Processor Exception: Virtual Host/WebGroup Not Found : The web group /favicon.ico has not been defined
[8/11/08 16:54:11:700 BRT] 208d208d WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: /WEB-INF/jsp/menu.jsp: init
[8/11/08 16:54:11:763 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
[8/11/08 16:54:13:607 BRT] 208d208d WebGroup I SRVE0180I: [Locadora1] [/locadora1] [Servlet.LOG]: /WEB-INF/jsp/cadastro/cadastrarFilmes.jsp: init
[8/11/08 16:54:13:669 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
[8/11/08 16:54:24:450 BRT] 208d208d PropertyMessa I org.apache.struts.util.PropertyMessageResources Initializing, config='org.apache.struts.actions.LocalStrings', returnNull=true
[8/11/08 16:54:27:919 BRT] 208d208d SystemErr R java.sql.SQLException: ORA-00904: "DATACADASTRO": invalid identifier
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at java.lang.Throwable.<init>(Throwable.java)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at java.lang.Throwable.<init>(Throwable.java)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at java.sql.SQLException.<init>(SQLException.java:53)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1741)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1902)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at br.com.locadora.locadora1.DAO.FilmesDAO.cadastraFilmes(FilmesDAO.java)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at br.com.locadora.locadora1.action.FilmesAction.cadastraFilme(FilmesAction.java)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at java.lang.reflect.Method.invoke(Method.java:391)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at br.com.locadora.locadora1.arquitetura.autenticacao.FiltroAutenticador.doFilter(FiltroAutenticador.java:56)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1010)
[8/11/08 16:54:27:950 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:592)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:204)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:286)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:615)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[8/11/08 16:54:27:966 BRT] 208d208d SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)
[8/11/08 16:54:27:966 BRT] 208d208d SystemOut O Erro: java.sql.SQLException: ORA-00904: "DATACADASTRO": invalid identifier
[8/11/08 16:54:27:966 BRT] 208d208d RequestProces W org.apache.struts.action.RequestProcessor Unhandled Exception thrown: class java.lang.Exception
[8/11/08 16:54:28:716 BRT] 208d208d WebGroup E SRVE0026E: [Servlet Error]-[java.sql.SQLException: ORA-00904: "DATACADASTRO": invalid identifier
]: java.lang.Exception: java.sql.SQLException: ORA-00904: "DATACADASTRO": invalid identifier
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java:104)
at br.com.locadora.locadora1.DAO.FilmesDAO.cadastraFilmes(FilmesDAO.java)
at br.com.locadora.locadora1.action.FilmesAction.cadastraFilme(FilmesAction.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
at java.lang.reflect.Method.invoke(Method.java:391)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at br.com.locadora.locadora1.arquitetura.autenticacao.FiltroAutenticador.doFilter(FiltroAutenticador.java:56)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1010)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:592)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:204)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:286)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:615)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)
Caused by: java.sql.SQLException: ORA-00904: "DATACADASTRO": invalid identifier
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at java.sql.SQLException.<init>(SQLException.java:53)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1741)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1902)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
at br.com.locadora.locadora1.DAO.FilmesDAO.cadastraFilmes(FilmesDAO.java)
at br.com.locadora.locadora1.action.FilmesAction.cadastraFilme(FilmesAction.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
at java.lang.reflect.Method.invoke(Method.java:391)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at br.com.locadora.locadora1.arquitetura.autenticacao.FiltroAutenticador.doFilter(FiltroAutenticador.java:56)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1010)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:592)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:204)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:286)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:615)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)
Valeu broder consegui desenrolar o problema estava colocando o nome da tabela errado