[Php-java-bridge-users] help with php-java-bridge and mysql

[<php...@li...>]

Hello, I’m trying to use php-java bridge, but I find it impossible!

 

Basic examples work without problem, now, I want to connect php with mysql
using java.

 

This is my code:

 

Java :

 

public class pruebaLog {

      

    public static String connectDB(){

      Connection conn = null;

      String returned;

      try {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

            conn = DriverManager.getConnection("jdbc:mysql://localhost/spb",
"root", "Administrad0r");

            returned= “open”;

        } catch (Exception e){

            returned = "no";

        } 

        return returned;

       

    }

}

 

And the php:

 

<?php

 

     require_once('./JavaBridge/java/Java.inc');

 

     java_require('/var/www/bridge/java/pruebaLog.jar');

 

     try{

         $prueba = new Java('pruebaLog');

         echo $prueba -> connectDB();

     } catch (JavaException $e){

         echo "ERROR". "<br>". $e;

     }

 

?>

 

It shows “no”,  I can’t understand why!

 

Thank you so much!!

 

 

Saludos

Rocío Gómez Escribano