Dear Sir,
When Iam trying to connect remote mysql database Using JSP on LINUX Os it is
giving an error...
Remote system is Windows NT.
java.sql.SQLException: Communication link failure: Bad handshake
I loaded
1).MySQL-3.23.40-1.i386.rpm
2).MySQL-client-3.23.40-1.i386.rpm
files in to my system. Is any other files required to install?
How i will overcome this problem . My OS is LINUX Red Hat.
My JSP source code is like this:
<%@ page language="java" import="java.sql.*" %>
<%
Connection Conn = null;
ResultSet RS = null;
Statement Stmt = null;
String DBUrl = "jdbc:mysql://IPaddress:3306/db
name?user=username&password=pass";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Conn = DriverManager.getConnection(DBUrl);
Stmt = Conn.createStatement();
RS=Stmt.executeQuery("select * from HITS");
while(RS.next())
{
%>
<br>
<%
out.println(RS.getString(1));
}
%>
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
