Pessoal tenho um campo Data na minha tabela no Mysql quando esse campo contem algum valor ele retorna numa boa mas se ele estiver vazio ele dar erro, para chama ele eu usu o getDate, getString e dar a mesmo erro.
chamo assim:
System.out.println("" + con.getResultSet().getDate(“data”));
ou assim:
System.out.println(con.getResultSet().getString(“data”));
error:
java.sql.SQLException: Value ‘0000-00-00’ can not be represented as java.sql.Date
at com.mysql.jdbc.ResultSet.getDateFromString(ResultSet.java:5613)
at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:977)
at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:934)
at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:948)
at dados.mySql.Acompanhantes.proximo(Acompanhantes.java:507)
at regras.negocio.RItens.optionConvConf(RItens.java:31)
at org.apache.jsp.principal_jsp._jspService(org.apache.jsp.principal_jsp:6830)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)