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
3).mm.mysql.jdbc-12b.tar driver
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));
}
%>
__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
---------------------------------------------------------------------
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
