Thank you very much for your advice.
I have two more question.
1. Do i need to put jdbc driver ( mm.mysql-2.0.4-bin.jar) somewhere in my
linux server?
2. I know the mysql server is running but how do i know it's accepting
TCP/IP connection?
Thanks again.
On Tue, 12 Mar 2002, Linux Rules wrote:
> On Tue, 12 Mar 2002, Jianping Zhu wrote:
>
> >
> >
> > I have this following code and mysql server running.
> >
> > //Connect to MySql Server
> > try {
> > Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> > }
> > catch(Exception e){
> > System.out.println("Can not get class Name");
> > }
> >
> > try {
> > c = DriverManager.getConnection //c is instance of Connection
> > ("jdbc:mysql://jianping.dhs.org/evote?user=username&password=mypasswd");
> > }
> > catch (SQLException se){System.out.println("trouble to
> > connect");}//
> >
> > When run this java code I get "Can not get class name" and"trouble to
> > connect".
> >
> > What is the potential reason for this. my os is redhat 7.2
> > Any suggetion appreciated.
> >
> >
> > --------------------------------
> > Jianping Zhu
> > Department of Computer Science
> > Univerity of Georgia
> > Athens, GA 30602
> > Tel 706 5423900
> > --------------------------------
> >
> >
> >
> > _______________________________________________
> > Redhat-list mailing list
> > [EMAIL PROTECTED]
> > https://listman.redhat.com/mailman/listinfo/redhat-list
> >
>
>
>
> Intenta esto :
>
> -------------------
> import java.sql.*;
>
> public class mysql{
>
> public static void main (String[] args){
> try{
> Class.forName("org.gjt.mm.mysql.Driver");
> Connection con = DriverManager.getConnection
> ("jdbc:mysql://server/database?user=user&password=pass");
> //Change server/database user and pass
>
> Statement St = con.createStatement();
> ResultSet Rs = St.executeQuery("select * from test");
> while ( Rs.next()){
> System.out.println ("Code: " + Rs.getString ("code"));
> System.out.println ("Descrip :" + Rs.getString ("descrip"));
> }
>
> con.close();
>
> }catch ( Exception E ){
> System.out.println(E.getMessage());
> }
> }
> }
>
> ------------------------
>
>
> Make sure the mysql server is running and it's accepting TCP/IP
> Connections and YOU have permisions to access
>
>
> Seguimos ....
>
>
> Leonel
>
>
>
>
> _______________________________________________
> Redhat-list mailing list
> [EMAIL PROTECTED]
> https://listman.redhat.com/mailman/listinfo/redhat-list
>
--------------------------------
Jianping Zhu
Department of Computer Science
Univerity of Georgia
Athens, GA 30602
Tel 706 5423900
--------------------------------
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
