php-java-bridge-users Mailing List for PHP/Java Bridge

G'day,

Thanks for the prompt reply, i did see that note in the readme of PJB

Ive just had another go (I think i was instantiating a class object for 
the forname call rather than using the java method) but i am still 
getting no love

require_once("./pjb/java/Java.inc");
java_require("mysql-connector-java-5.1.5-bin.jar");

$class = java("java.lang.Class");
$loader = 
java("java.lang.Thread")->currentThread()->getContextClassLoader();
$class->forName("com.mysql.jdbc.Driver",true,$loader);
$driverManager = new JavaClass("java.sql.DriverManager");
$thiscon = 
$driverManager->getConnection("jdbc:mysql://xxx/xxx?user=xxx&password=xxx");

Yields the error:

PHP Fatal error:  Uncaught [[o:Exception]:"java.lang.Exception: Invoke 
failed: [[c:DriverManager]]->getConnection((o:String)[o:String]). Cause: 
java.sql.SQLException: No suitable driver found for 
jdbc:mysql://xxx/xxx?user=xxx&password=xxx Responsible VM: 
1.6.0_03@http://java.sun.com/" at:
#-11 java.sql.DriverManager.getConnection(Unknown Source)
#-10 java.sql.DriverManager.getConnection(Unknown Source)
#-9 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
#0 C:\Inetpub\wwwroot\app\webroot\test\pjb\java\Java.inc(259): 
java_ThrowExceptionProxyFactory->getProxy(7, 'php.java.bridge...', true)
#1 C:\Inetpub\wwwroot\app\webroot\test\pjb\java\Java.inc(409): 
java_Arg->getResult(true)
#2 C:\Inetpub\wwwroot\app\webroot\test\pjb\java\Java.inc(415): 
java_Client->getWrappedResult(true)
#3 C:\Inetpub\wwwroot\app\webroot\test\pjb\java\Java.inc(619): 
java_Client->getResult()
#4 C:\Inetpub\wwwroot\app\webroot\test\pjb\java\Java.inc(1730): 
java_Client->invokeMethod(6, 'getConnection', Array)
#5 C:\Inetpub\wwwroot\app\webroot\test\ in C:\xxx\pjb\java\Java.inc on 
line 222

Im not sure what im doing wrong, it appears the java_require call is 
finding the file because if i change the path i get an error.

Regards,
Phillip Savage


php...@li... wrote:
> Hi,
>
>   
>> Forgive me if i am blind, but I can't find anything in the FAQ located 
>> at http://php-java-bridge.sourceforge.net/pjb/faq.php 
>>     
>
> the up-to-date FAQ is here: 
>
>   http://php-java-bridge.cvs.sourceforge.net/*checkout*/php-java-bridge/php-java-bridge/FAQ.html
>
> I think
>
>   java_require ("yourDriver.jar");
>   $Clazz = java("java.lang.Class");
>   $loader = java("java.lang.Thread")->currentThread()->getContextClassLoader();
>   $Clazz->forName("yourDriver", true, $loader);
>
> should do what you want.
>
>
> Regards,
> Jost Boekemeier
>
>
>
>
>       Machen Sie Yahoo! zu Ihrer Startseite. Los geht's: 
> http://de.yahoo.com/set
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> php-java-bridge-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>   

Hi,

> Forgive me if i am blind, but I can't find anything in the FAQ located 
> at http://php-java-bridge.sourceforge.net/pjb/faq.php 

the up-to-date FAQ is here: 

  http://php-java-bridge.cvs.sourceforge.net/*checkout*/php-java-bridge/php-java-bridge/FAQ.html

I think

  java_require ("yourDriver.jar");
  $Clazz = java("java.lang.Class");
  $loader = java("java.lang.Thread")->currentThread()->getContextClassLoader();
  $Clazz->forName("yourDriver", true, $loader);

should do what you want.


Regards,
Jost Boekemeier




      Machen Sie Yahoo! zu Ihrer Startseite. Los geht's: 
http://de.yahoo.com/set

With all my playing around/searching i gathered that it wouldn't work 
which is specifically why i tried the following which did not work:

$class->forName("com.mysql.jdbc.Driver",true,java("java.lang.Thread")->currentThread()->getContextClassLoader());

Forgive me if i am blind, but I can't find anything in the FAQ located 
at http://php-java-bridge.sourceforge.net/pjb/faq.php with regards to my 
problem

Regards,
Phillip Savage



php...@li... wrote:
> Hi,
>
>   
>> $class->forName("com.mysql.jdbc.Driver");
>>     
>
> won't work. Or better: will only work if the driver is available to the bootstrap loader. 
> Either use the current loader or add the driver to the global class loader.
>
> Please see the Java specification or our FAQ for details.
>
>
> Regards,
> Jost Boekemeier
>
>
>
>
>
>        __________________________________ Ihr erstes Fernweh? Wo gibt es den schönsten Strand? www.yahoo.de/clever
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> php-java-bridge-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>   

Hi,

> $class->forName("com.mysql.jdbc.Driver");

won't work. Or better: will only work if the driver is available to the bootstrap loader. 
Either use the current loader or add the driver to the global class loader.

Please see the Java specification or our FAQ for details.


Regards,
Jost Boekemeier





       __________________________________ Ihr erstes Fernweh? Wo gibt es den schönsten Strand? www.yahoo.de/clever

G'day,

Ive tried all sorts of things and im starting to pull my hair out.

Im trying to create a JDBC Connection with php-java-bridge which i can 
pass to BIRT to override the reports connection.

The code i started with is bellow:

$class = new JavaClass("java.lang.Class");
$class->forName("com.mysql.jdbc.Driver");
$driverManager = new JavaClass("java.sql.DriverManager");
$conn = 
$driverManager->getConnection("jdbc:mysql://xxxx/xxxx?user=xxx&password=xxxx");

Which gave me a class not found on the forName call. The wierd thing is 
i can instantiate a driver object manually by typing $driver = new 
Java("com.mysql.jdbc.Driver"); so obviously php-java-bridge can see the 
class file.

I'm at a loss as to what the problem is right now, here is a quick run 
down of the things I've tried so far:

    * Getting the current thread & using the context class loader
      $thread = java("java.lang.Thread")->currentThread();
      $class->forName("com.mysql.jdbc.Driver",true,$thread->getContextClassLoader());
    * Just instantiating the driver as normal (java.sql.SQLException: No
      suitable driver found thrown)
    * Creating an instance of the driver and calling
      $driverManager->registerDriver($driver) (java.sql.SQLException: No
      suitable driver found thrown)

Any help would be appreciated,

Regards,
Phillip Savage