kusuma guntupalli wrote:
> .Dear Sir,
>When Iam trying to connect remote mysql database Using
>JSP on LINUX Os (6.2/7.2)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));
>
>}
>%>
>
>
>__________________________________________________
>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
>
>
>
You're using a _very_ old version of MM.MySQL that is not compatible
with newer versions of MySQL.
Please upgrade to something newer, like MySQL Connector/J 2.0.14 from
http://www.mysql.com/products/connector-j/
You also might want to look into the search functionality at
lists.mysql.com (click on the mailing list name) before asking
questions, because most questions have already been answered in the
mailing lists many times.
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.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
