AgendaWebJSTL

Front-end
#1

Olá,

eu desenvolvi uma Agenda Web usando o JSTL, só que quando meu form de cadastro dá um submit nos dados isneridos, ou seja, tenta cadastrar os dados no meu banco ele dá o seguitne erro quando coloco ele na Internet, e em localhost funciona direito e corretamente perfeito!

[b]
HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Unable to get connection, DataSource invalid: "com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.taglibs.standard.tag.common.sql.DataSourceWrapper.getConnection(DataSourceWrapper.java:69)
at org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.getConnection(UpdateTagSupport.java:233)
at org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.doStartTag(UpdateTagSupport.java:115)
at org.apache.jsp.recebeDados_jsp._jspx_meth_sql_update_0(recebeDados_jsp.java:375)
at org.apache.jsp.recebeDados_jsp._jspx_meth_c_if_0(recebeDados_jsp.java:349)
at org.apache.jsp.recebeDados_jsp._jspService(recebeDados_jsp.java:97)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
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.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago."
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.recebeDados_jsp._jspService(recebeDados_jsp.java:136)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.taglibs.standard.tag.common.sql.DataSourceWrapper.getConnection(DataSourceWrapper.java:69)
at org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.getConnection(UpdateTagSupport.java:233)
at org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.doStartTag(UpdateTagSupport.java:115)
at org.apache.jsp.recebeDados_jsp._jspx_meth_sql_update_0(recebeDados_jsp.java:375)
at org.apache.jsp.recebeDados_jsp._jspx_meth_c_if_0(recebeDados_jsp.java:349)
at org.apache.jsp.recebeDados_jsp._jspService(recebeDados_jsp.java:97)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
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.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago."
org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.getConnection(UpdateTagSupport.java:235)
org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.doStartTag(UpdateTagSupport.java:115)
org.apache.jsp.recebeDados_jsp._jspx_meth_sql_update_0(recebeDados_jsp.java:375)
org.apache.jsp.recebeDados_jsp._jspx_meth_c_if_0(recebeDados_jsp.java:349)
org.apache.jsp.recebeDados_jsp._jspService(recebeDados_jsp.java:97)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.27 logs.
Apache Tomcat/5.0.27
[/b]

Algum poderia me ajudar em relação à isso ??

Obs: Minha estrutura no tomcat é a seguinte:

webapps

  • agendaweb
    - WEB-INF
    web.xml
    - classes
    - jstl
    mensagens.properties
    mensagens_en_US.properties
    mensagens_pt_BR.properties
    - lib
    mysql-connector-java-5.0.4-bin.jar
    jstl.jar
    standard.jar
    • index.jsp
    • linguas.jsp
    • exibir.jsp
    • recebeDados.jsp
    • cadastro.jsp
    • atualizacao.jsp
    • alterar.jsp

Há algo de errado tbm nessa estrutura ?

Obrigado!!!

#2

Cara vamos ver se posso ajudar… pelo jeito seu driver jdbc não tá conseguindo criar uma conexão com o banco… como está criando essa conexão??? alguma api datasource, tomcat??? explica como estão as conexões e datasource para eu tentar te ajudar…

Abraços

#3

Está sendo feita assim:

Localhost:

<sql:setDataSource driver=“org.gjt.mm.mysql.Driver”
url=“jdbc:mysql://localhost:3306/meu_banco”
user=“meu_usuario”
password=“minha_senha”
var=“datasource” />

Internet (Servidor MySQL)

<sql:setDataSource driver=“org.gjt.mm.mysql.Driver”
url=“jdbc:mysql://mysql.uni5.net:3306/meu_banco”
user=“meu_usuario”
password=“minha_senha”
var=“datasource” />

Isso ajuda?

Abs.

#4

infelizmente isso não diz muita coisa… posta o código real onde você utiliza o datasource para pegar a criar a conexão com o banco…

outra coisa… tem certeza que precisa criar um datasource e fazer consultas direto no seu jsp???

#5

cara vc usa alguma ide,

#6

E ae peeterweb, blz?

Bem, tentando ajudar tb, creio que a conexão com o bd deva ser feita + ou - desse jeito(só pra dar um apoio aos outros amigos pra ver se algum entende bem o problema e te dá uma força…):

try
&#123;
   Class.forName&#40;&quot;Seu driver mysql&quot;&#41;;	
&#125;	
catch&#40;ClassNotFoundException e&#41;
&#123;
   System.out.println&#40;&quot;Não consigo carregar o driver...&quot; + e&#41;;
&#125;
		  	  
   Connection conn = DriverManager.getConnection&#40;&quot;Seu driver&quot;,&quot;seu usuario&quot;,&quot;sua senha&quot;&#41;;
   Statement stmt = conn.createStatement&#40;&#41;;
   String select = &quot;select * from funcionarios;&quot;;
   ResultSet rs = stmt.executeQuery&#40;select&#41;;
	       
   try
  &#123;	    	  
      while &#40;rs.next&#40;&#41;&#41;
     &#123;
	System.out.println&#40;rs.getString&#40;1&#41; + &quot;    &quot; + rs.getString&#40;2&#41; + &quot;\n&quot;&#41;;
      &#125;	          
  &#125;
  catch&#40; Exception e &#41;
  &#123;
     System.out.println&#40;e&#41;;
  &#125;	   
   stmt.close&#40;&#41;;
   conn.close&#40;&#41;;

Esse é um exemplo de consulta sem DataSource.

Vc fez algo assim?

#7

Bom,

primeiramente e estou usando a IDE NetBeans 5.5.

e finalizando:
eu nao fiz a classe desse tipo nao, eu isei as TagLibs mesmo do JSTL e hoje mesmo descobri meu erro:

  • eu nao coloquei o servidor do banco mysql na internet que obviamente eh diferente do meu localhot!!

Mas está resolvido, valeu mesmo pela ajuda!

Abs.

#8

O importante é resolver o problema…

Abs :yyeah:

#9

Com certeza,

está funcionando direitinho agora, valeu mesmo "!

só falta colocar um layout maneiro … p/ dar um “ar” !!! rsrs

dps te passo a URL !

Abs.

#10