Discussoes de Programacao e Tecnologia

Inserir dados no BD

3 respostas
R
robsonsan

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>
Alura Desenvolvimento Front-End React Do primeiro componente à liderança técnica! HTML/CSS/JavaScript fundamental, React com hooks e...

3 Respostas

Roger75
Roger75

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).

R
robsonsan

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)
R
robsonsan

Valeu broder consegui desenrolar o problema estava colocando o nome da tabela errado

Criado 11 de agosto de 2008
Ultima resposta 12 de ago. de 2008
Respostas 3
Participantes 2

Topicos relacionados

Compilar e executar uma classe java pelo prompt do windows 13 respostas [RESOLVIDO] Como executar função JavaScript após página carregada 13 respostas Java.lang.OutOfMemoryError: Java heap space - Como resolver? 11 respostas Como consultar CPF na Receita Federal usando Web Service? 22 respostas Como acessar localhost de forma externa? [RESOLVIDO] 13 respostas
Alura O que é Python? — um guia completo para iniciar nessa linguagem de programação Acesse agora o guia sobre Python e inicie sua jornada nessa linguagem de programação: o que é e para que serve, sua sintaxe e como iniciar nela!
Casa do Codigo Guia pratico de TypeScript: Melhore suas aplicacoes... Por Thiago da Silva Adriano — Casa do Codigo