Re: [DataVision-users] Error on connecting to mysql database

[Jim M. <ji...@ji...>]

In the driver class name, "org" needs to be lower case. In the
connection string I think the "jdbc" needs to be all lower-case, too.

Jim

On Tue, Jun 25, 2013 at 5:30 PM, Marty McGlensey <mmc...@fr...> wrote:
> Hello,
>
>
>
> I have just installed Datavision on Ubuntu 12.04 LTS. I can run the program
> using the shell script but I cannot connect to the database.
>
>
>
> I have installed MySQL J driver version mm.mysql-2.0.14. I’ve edited the
> classpath to show the directory that contains the java connector.
>
>
>
> When I enter the following:
>
>
>
> Org.gjt.mm.mysql.Driver
>
> Jdbc:mysql://localhost//HOA_Data
>
> HOA_Data
>
> root
>
> password
>
>
>
> Then click OK the error message is ”Java exception communication failure
> during handshake. Is there a server running on port 3306?”.
>
> I’ve checked MySql setup and the default port in /etc/my.cfg is 3306.
> Netstat –tln tells me that 127.0.0.1 is listening on multiple ports, one is
> 3306. The server is running.
>
>
>
> So what am I doing wrong?  It looks like a connection should be made.
>
>
>
> Thanks,
>
> Marty
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> DataVision-users mailing list
> Dat...@li...
> https://lists.sourceforge.net/lists/listinfo/datavision-users
>



-- 
Jim Menard, http://www.jimmenard.com/