Re: JDBC¿¡¼ Bad handshake Error Á¦¹ß ºÎŹµå¸³´Ï´Ù....
jdbc µå¶óÀ̹ö¸¦ ÃֽŹöÁ¯À¸·Î ¹Ù²ãº¸¼¼¿ä
¿¡·¯°¡ ¾ø½À´Ï´Ù.
> ¾È³çÇϼ¼¿ä..
>
> JDBC¿¡¼ ÀÌ·± ¿¡·¯°¡ ³ª´Â±º¿ä.
>
> java.sql.SQLException: Communication link failure: Bad handshake
> at org.gjt.mm.mysql.MysqlIO.init(Compiled Code)
> at org.gjt.mm.mysql.Connection.<init>(Compiled Code)
> at org.gjt.mm.mysql.Driver.connect(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at DBmanager.<init>(Compiled Code)
> at DBmanager.main(Compiled Code)
>
> óÀ½¿¡´Â JDBC Driver¸¦ mm.mysql.jdbc-1.2c.tar.gz ½á ºÃ½À´Ï´Ù.
>
> ¾î¶² ºÐÀº JDBC¸¦ mm.mysql.jdbc-2.0pre5.tar.gz·Î ¹Ù²ã¼ µÇ¾ú´Ù°í Çϴµ¥..
> Àú´Â ¾ÈµÇ´Â ±º¿ä..
>
> ÀÌ·¸°Ôµµ ÇØ º¸¾Ò½À´Ï´Ù.
>
> grant all privileges on *.* to User_ID@"%" identified by 'User_pass' with grant option;
>
> ¶Ç ÀÌ·¸°Ôµµ ÇØ º¸¾Ò½À´Ï´Ù.
>
> insert into user values 'localhost','User_ID','User_pass','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>
> .bash_profile ³»¿ë ÀÔ´Ï´Ù.
>
> PATH=$PATH:$HOME/bin:.:/usr/local/mysql/bin:/usr/local/jdk1.2/bin
> BASH_ENV=$HOME/.bashrc
> USERNAME="futures21"
> TMOUT=-1
> export USERNAME BASH_ENV PATH
> export JAVA_HOME=/usr/local/jdk1.2
> export JDBC_HOME=/home/futures21/jdbc
> CLASSPATH=$JDBC_HOME/mysql_comp.jar:$JDBC_HOME/mysql_uncomp.jar:$JDBC_HOME/mysql_both_comp.jar:$JDBC_HOME/mysql_both_uncomp.jar:$JAVA_HOME
>
> CLASSPATH´Â JDBC Driver Á¾·á¿¡ µû¶ó ¹Ù²Ù¾î º¸±âµµ Çß½À´Ï´Ù.
>
> JAVA·Î DB¸¦ ¿¬°áÇÏ´Â ¼Ò½º´Â ´ÙÀ½°ú °°½À´Ï´Ù.
>
> try{
>
> driverName = "org.gjt.mm.mysql.Driver";
> Class.forName(driverName);
> dbURL = "jdbc:mysql://localhost:3306/User_db";
> connection = DriverManager.getConnection(dbURL, "User_ID", "User_pass");
> statement = connection.createStatement();
>
> } catch(SQLException e){
>
> e.printStackTrace();
>
> } catch(Exception e){
>
> e.printStackTrace();
>
> }
>
> ÇØ°áÃ¥Á» Á¦½ÃÇØ ÁÖ¼¼¿ä... Á¤¸» Á×°Ú½À´Ï´Ù.
>
> Á¦¹ß ºÎŹÇÕ´Ï´Ù. ÇØ°á¾ÈÁ» ÁÖ¼¼¿ä....
>
>