Re: trouble connecting to mysql

naveen wrote:
>>> though i have tried putting database as //localhostneo also
>>>  but this didnt work too
> 
> well i am soory ..my mistake i meant //localhost/neo

As a general rule: copy paste when you post to avoid typos.

> <%
> String varSql = request.getParameter("sql");
> if (varSql == null) {
>     varSql = "";
> }
> varSql = java.net.URLDecoder.decode(varSql).trim();
> %>
> ...
> <%
> String dbURL="jdbc:mysql://localhost/neo";
> String username="root";
> String passwd="abc";
> try{
>  Class.forName("com.mysql.jdbc.Driver");
>  Connection conn=DriverManager.getConnection(dbURL,username,passwd);
>  Statement stat=null;
>  try{
>   stat=conn.createStatement();

>  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:1096)
> 	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626)
> 	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
> 	at com.mysql.jdbc.Connection.(Connection.java:491)
> 	at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:
> 346)
> 	at java.sql.DriverManager.getConnection(Unknown Source)
> 	at java.sql.DriverManager.getConnection(Unknown Source)
> 	at org.apache.jsp.HelloMysql_jsp._jspService(HelloMysql_jsp.java:98)
> 	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

You have loaded the driver OK, you have established a TCP connection
to the server OK, but the JDBC driver and the MySQL server will not
talk to each other. It look like the MySQL server closes the connection.

Check that the JDBC driver you are using are newer than the MySQL
server version you are using.

Check in the MySQL side for errors.

Arne