help - connection database

help find error that connection database and jsp..

<%
String connectionURL = "jdbc:mysql://localhost:3306/webaudio?user=root";
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").newInstance ();
connection = DriverManager.getConnection(connectionURL, "root", "123");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT name FROM audio");

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

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

rs.close();
%>
</td>></tr>
</table>
</body>
<html>

Mar 23 '07 #1

Subscribe Post Reply

1498

r035198x

13,262

8TB

help find error that connection database and jsp..

<%
String connectionURL = "jdbc:mysql://localhost:3306/webaudio?user=root";
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").newInstance ();
connection = DriverManager.getConnection(connectionURL, "root", "123");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT name FROM audio");

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

while (rs.next())
{
out.println("<tr><td>");
String file = rs.getString("name");
if((file!=null))
{
out.println("<a href=rtsp://554@localhost/test/" + file + ">");
out.println(file + "<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?

Mar 23 '07 #2

bylum

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.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

** BEGIN NESTED EXCEPTION **

java.io.IOException
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:109 6)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:62 6)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:4 91)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:346)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.jsp.audio_jsp._jspService(audio_jsp.jav a:108)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:390)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:212)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run( JIoEndpoint.java:445)
at java.lang.Thread.run(Unknown Source)

** END NESTED EXCEPTION **

org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:565)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:414)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)

Mar 23 '07 #3

Similar topics

Need help with ASP script.

by: Bobby | last post by:

Hello everyone I have a question. The school I am working for is in the beginning process of having a webpage that will direct students to download there homework and be able to view there info...

ASP / Active Server Pages

Run-time error 80004005 - HELP!

by: MyndPhlyp | last post by:

I am about to completely lose what is left of my poor mynd! The historical dissertation gets rather verbose, so I hope you can wade through it all. I really need some help on this one or I'm...

Microsoft Access / VBA

Help creating connection function

by: Jozef | last post by:

Hello, I'm trying to create a central function that runs a connection to an SQL Server database. The connection etc works, but when I try to call it, I get an error saying "Runtime-Error 91:...

Microsoft Access / VBA

sqlserver connection - need help desperately!

by: peshekeedweller | last post by:

Using asp.net 1.1. vb.net 2003. I am trying to connect to a remote sql server 2000 on a virtual machine running windows 2000 server. I can connect through the server explorer in visual studio,...

ASP.NET

How to have multiple worker threads submit to one final processing queue? - HELP

by: James Radke | last post by:

Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...

Visual Basic .NET

Problem with "locked" SQL Server Express database files - Please help!

by: Glen Buell | last post by:

Hi all, I have a major problem with my ASP.NET website and it's SQL Server 2005 Express database, and I'm wondering if anyone could help me out with it. This site is on a webhost...

ASP.NET

Need Help with Select @@ Identity

by: PinkBishop | last post by:

I am using VS 2005 with a formview control trying to insert a record to my access db. The data is submitted to the main table no problem, but I need to carry the catID to the bridge table...

ASP.NET

help with connection string

by: Jennifer.Berube | last post by:

well I'm not sure how to go about making my SQL connection string... The code below is what I need to replace with my SQL connection...I just don't know if that code is for DSN or access... I...

ASP / Active Server Pages

Java Servlet Problem. Help anyone?

by: dmstn | last post by:

Hey! I've got a little problem. I have to make a web site for a university essay. I curently have to create a search engine. Users can enter a hotel name in a search bar and results have to appear in...

Java

need help with my senior project

by: zaina | last post by:

hi everybody i am nwebie in this forum but i think it is useful for me and the member are helpful my project is about connecting client with the server to start exchanging messages between...

Java

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware