help - connection database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • bylum
    New Member
    • Mar 2007
    • 15
    #1

    help - connection database

    help find error that connection database and jsp..


    <%
    String connectionURL = "jdbc:mysql ://localhost:3306/webaudio?user=r oot";
    Connection connection = null;
    Statement statement = null;
    ResultSet rs = null;
    %>
    <html>
    <head></head>
    <body>
    <table>
    <tr align="center"> <td align="center">
    <%
    Class.forName(" com.mysql.jdbc. Driver").newIns tance();
    connection = DriverManager.g etConnection(co nnectionURL, "root", "123");
    statement = connection.crea teStatement();
    rs = statement.execu teQuery("SELECT name FROM audio");

    out.println("<t able border=1>");
    out.println("<t r><td>Audio In Database</td></tr>");

    while (rs.next())
    {
    out.println("<t r><td>");
    String file = rs.getString("n ame");
    if((file!=null) )
    {
    out.println("<a href=rtsp://554@localhost/test/" + file + ">");
    out.println(fil e + "<br>");
    out.println("</a></td></tr>");
    }
    }
    out.println("</table>");

    rs.close();
    %>
    </td>></tr>
    </table>
    </body>
    <html>
    Tags: None
    • r035198x
      MVP
      • Sep 2006
      • 13225
      #2
      Originally posted by bylum
      help find error that connection database and jsp..


      <%
      String connectionURL = "jdbc:mysql ://localhost:3306/webaudio?user=r oot";
      Connection connection = null;
      Statement statement = null;
      ResultSet rs = null;
      %>
      <html>
      <head></head>
      <body>
      <table>
      <tr align="center"> <td align="center">
      <%
      Class.forName(" com.mysql.jdbc. Driver").newIns tance();
      connection = DriverManager.g etConnection(co nnectionURL, "root", "123");
      statement = connection.crea teStatement();
      rs = statement.execu teQuery("SELECT name FROM audio");

      out.println("<t able border=1>");
      out.println("<t r><td>Audio In Database</td></tr>");

      while (rs.next())
      {
      out.println("<t r><td>");
      String file = rs.getString("n ame");
      if((file!=null) )
      {
      out.println("<a href=rtsp://554@localhost/test/" + file + ">");
      out.println(fil e + "<br>");
      out.println("</a></td></tr>");
      }
      }
      out.println("</table>");

      rs.close();
      %>
      </td>></tr>
      </table>
      </body>
      <html>
      1.)Use code tags when posting code
      2.)What is your problem? Are you getting an exception?

        Comment

        • bylum
          New Member
          • Mar 2007
          • 15
          #3
          Originally posted by r035198x
          1.)Use code tags when posting code
          2.)What is your problem? Are you getting an exception?
          i can't connect jsp and database(mysql) .
          This is the exception:


          exception
          org.apache.jasp er.JasperExcept ion: javax.servlet.S ervletException : java.sql.SQLExc eption: Communication link failure: java.io.IOExcep tion, underlying cause: Unexpected end of input stream

          ** BEGIN NESTED EXCEPTION **

          java.io.IOExcep tion
          MESSAGE: Unexpected end of input stream

          STACKTRACE:

          java.io.IOExcep tion: Unexpected end of input stream
          at com.mysql.jdbc. MysqlIO.readPac ket(MysqlIO.jav a:1096)
          at com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:626)
          at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:1562)
          at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:491)
          at com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:346)
          at java.sql.Driver Manager.getConn ection(Unknown Source)
          at java.sql.Driver Manager.getConn ection(Unknown Source)
          at org.apache.jsp. audio_jsp._jspS ervice(audio_js p.java:108)
          at org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:98)
          at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)
          at org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 390)
          at org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:320)
          at org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :266)
          at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)
          at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:290)
          at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:206)
          at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:228)
          at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:175)
          at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:12 8)
          at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:10 5)
          at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:109)
          at org.apache.cata lina.connector. CoyoteAdapter.s ervice(CoyoteAd apter.java:212)
          at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:844)
          at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.process(Htt p11Protocol.jav a:634)
          at org.apache.tomc at.util.net.JIo Endpoint$Worker .run(JIoEndpoin t.java:445)
          at java.lang.Threa d.run(Unknown Source)


          ** END NESTED EXCEPTION **


          org.apache.jasp er.servlet.JspS ervletWrapper.h andleJspExcepti on(JspServletWr apper.java:565)
          org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 414)
          org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:320)
          org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :266)
          javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)

            Comment

            Previous template Next
            Working...