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

Hello,

php-java-bridge is a great tool. But now I'm having a problem with 
accessing a MySQL-database using jdbc which I was not able to solve.

I always get the message "java.sql.SQLException: No suitable driver 
Responsible" or class not found errors.

The problem occurs when I try to convert the java code
   Class.forName("com.mysql.jdbc.Driver");
and the "getConnection" into corresponding php-code.

Please see the code snippets and the provided system information for 
details.

I have tried several ours to solve the problem. So any help would be 
desperately appreciated... Any ideas?


##################
Part of the php-Script with some comments:

<?php
   java_require('file:///usr/share/java/mysql.jar');
   // I also tried to put the jar into the same directory than the 
script without effect:
   // java_require('file:///var/www/mysql.jar');

   $conn = new Java('java.sql.Connection');

   // The following is working without errors. So the class must be 
there, I suppose...
   $mysql = new javaClass('com.mysql.jdbc.Driver');
   $mysqlinst = $mysql->newInstance();

   // The following two code lines yield:
   /* Uncaught [o(Exception):&quot;java.lang.Exception: Invoke failed: 
[c(Class)]-&gt;forName((String)o(String)). Cause: 
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver Responsible VM: 
1.5.0_08@http://java.sun.com/&quot; at:
#-18 java.net.URLClassLoader$1.run(URLClassLoader.java:200)
#-17 java.security.AccessController.doPrivileged(Native Method)
#-16 java.net.URLClassLoader.findClass(URLClassLoader.java:188)
#0 [internal function]: Java-&gt;__call('forName', Array)
#1 /var/www/java.php(33): Java-&gt;forName('com.mysql.jdbc....')
#2 {main}] thrown in <b>/var/www/java.php */
   // $javaclass = new Java('java.lang.Class');
   // $javaclass->forName('com.mysql.jdbc.Driver');

   // The following to lines also produce a ClassNotFoundExeption:
   //  $javaclass = new Java('php.java.bridge.SimpleJavaBridgeClassLoader');
   //  $javaclass->forName('com.mysql.jdbc.Driver');

   $drivermanager = new JavaClass('java.sql.DriverManager');
   $conn = 
$drivermanager->getConnection("jdbc:mysql://localhost/mv-hett", 'user', 
'pwd');
[...]

##################
Error message of the "getConnection" line in browser:

Fatal error</b>:  Uncaught [o(Exception):&quot;java.lang.Exception: 
Invoke failed: [c(DriverManager)]-&gt;getConnection((String)o(String), 
(String)o(String), (String)o(String)). Cause: java.sql.SQLException: No 
suitable driver Responsible VM: 1.5.0_08@http://java.sun.com/&quot; at:
#-11 java.sql.DriverManager.getConnection(DriverManager.java:545)
#-10 java.sql.DriverManager.getConnection(DriverManager.java:171)
#-9 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
#0 [internal function]: Java-&gt;__call('getConnection', Array)
#1 /var/www/java.php(42): 
JavaClass-&gt;getConnection('jdbc:mysql://lo...', 'user', 'pwd')
#2 {main}]
   thrown in <b>/var/www/java.php</b>


##################
Standalone Java-Code that does the same works without problems:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class mv {
   public static void main(String[] args) throws ClassNotFoundException, 
SQLException {
     Connection conn;

     Class.forName("com.mysql.jdbc.Driver");
     conn = 
DriverManager.getConnection("jdbc:mysql://localhost/mv-hett", "user", 
"pwd");
[...]

---

It is compiled using:
declare mysqllib=/usr/share/java/mysql.jar
javac -classpath $CLASSPATH:$mysqllib:. projects/test/mv.java


##################
test.php - Output:

java.runtime.name -> Java(TM) 2 Runtime Environment, Standard Edition
sun.boot.library.path -> /usr/lib/j2sdk1.5-sun/jre/lib/i386
java.vm.version -> 1.5.0_08-b03
java.vm.vendor -> Sun Microsystems Inc.
java.vendor.url -> http://java.sun.com/
path.separator -> :
java.vm.name -> Java HotSpot(TM) Client VM
file.encoding.pkg -> sun.io
user.country -> US
sun.os.patch.level -> unknown
java.vm.specification.name -> Java Virtual Machine Specification
user.dir -> /
java.runtime.version -> 1.5.0_08-b03
java.awt.graphicsenv -> sun.awt.X11GraphicsEnvironment
java.endorsed.dirs -> /usr/lib/j2sdk1.5-sun/jre/lib/endorsed
os.arch -> i386
java.io.tmpdir -> /tmp
line.separator ->
java.vm.specification.vendor -> Sun Microsystems Inc.
os.name -> Linux
sun.jnu.encoding -> ANSI_X3.4-1968
java.library.path -> 
/usr/lib/j2sdk1.5-sun/jre/lib/i386/client:/usr/lib/j2sdk1.5-sun/jre/lib/i386:/usr/lib/j2sdk1.5-sun/jre/../lib/i386
java.specification.name -> Java Platform API Specification
java.class.version -> 49.0
sun.management.compiler -> HotSpot Client Compiler
os.version -> 2.6.16-2-vserver-686
user.home -> /root
user.timezone -> Zulu
jdbc.drivers -> com.mysql.jdbc.Driver
java.awt.printerjob -> sun.print.PSPrinterJob
file.encoding -> ANSI_X3.4-1968
java.specification.version -> 1.5
java.class.path -> /usr/lib/php5/20051025/JavaBridge.jar
user.name -> root
java.vm.specification.version -> 1.0
java.home -> /usr/lib/j2sdk1.5-sun/jre
sun.arch.data.model -> 32
user.language -> en
java.specification.vendor -> Sun Microsystems Inc.
java.vm.info -> mixed mode, sharing
java.version -> 1.5.0_08
java.ext.dirs -> 
/usr/lib/j2sdk1.5-sun/jre/lib/ext:/usr/share/java/ext:/usr/java/packages/lib/ext
sun.boot.class.path -> 
/usr/lib/j2sdk1.5-sun/jre/lib/rt.jar:/usr/lib/j2sdk1.5-sun/jre/lib/i18n.jar:/usr/lib/j2sdk1.5-sun/jre/lib/sunrsasign.jar:/usr/lib/j2sdk1.5-sun/jre/lib/jsse.jar:/usr/lib/j2sdk1.5-sun/jre/lib/jce.jar:/usr/lib/j2sdk1.5-sun/jre/lib/charsets.jar:/usr/lib/j2sdk1.5-sun/jre/classes
java.vendor -> Sun Microsystems Inc.
file.separator -> /
java.vendor.url.bug -> http://java.sun.com/cgi-bin/bugreport.cgi
sun.io.unicode.encoding -> UnicodeLittle
sun.cpu.endian -> little
sun.cpu.isalist ->

JavaBridge back-end version: 3.1.7

##################
php.ini
Adding the mysql.jar to the classpath in php.ini did not help.

[java]
java.hosts = 127.0.0.1:9676
java.servlet = Off
java.classpath=/usr/lib/php5/20051025/JavaBridge.jar:/usr/share/java/mysql.jar

##################
The backend is running standalone, "ps aux" yields the line:

/usr/bin/java -classpath .:/usr/share/java/mysql.jar 
-Djdbc.drivers=com.mysql.jdbc.Driver -jar 
/usr/lib/php5/20051025/JavaBridge.jar INET_LOCAL:9676

After it did not work I added the classpath-info and the -Djdbc.drivers. 
It did not help either.

Am Mittwoch, den 20.09.2006, 05:08 -0700 schrieb
php...@li...:
> Hi,
> =20
> interestingly I've got similar problems while upgrading to bridge
> 3.1.8. The tomcat error log contained NoClassDefFound messages
> suggesting that some essential classes were missing.
> =20
> It turned out that tomcat kept old classes in its work and tmp
> directory and it was using these classes instead of the new versions
> from the JavaBridge.war.
> =20
> Cleaning these directories helped, but I now get
> java.lang.SecurityException messages when accessing the java session
> store from apache...The sessionSharing.php example works, but my
> classes don't. the only difference I see is that my classes call
> java_get_session more than once. Is there a bug in 3.1.8?
> =20
> =20
Look your errors like theese:
-------------
Fatal error: Uncaught [o(Exception):"java.lang.Exception: Invoke failed:
[o(PingActionsClient)]->authenticate((String)o(String),
(String)o(String)). Cause: org.chip.ping.PingException:
java.io.IOException: Server returned HTTP response code: 500 for URL:
http://192.168.2.51:8080/indivo-server-servlet-demo/PingServlet
Responsible VM: 1.5.0_08@http://java.sun.com/" at: #-13
org.chip.ping.client.PingTalkClient.sendRequest(PingTalkClient.java:480)
#-12
org.chip.ping.client.PingTalkClient.authenticate(PingTalkClient.java:352) #=
-11 org.chip.ping.client.PingTalkClient.authenticate(PingTalkClient.java:27=
9) #0 [internal function]: Java->__call('authenticate', Array) #1 /var/www/=
indivo-ui/config/setup.php(34): Java->authenticate('administrator@i...', 'a=
dmin') #2 {main}] thrown in /var/www/indivo-ui/config/setup.php on line 34
---------------

What version did you use before?

MQ

> Peter
> =20
>=20
> ______________________________________________________________________
> All-new Yahoo! Mail - Fire up a more powerful email and get things
> done faster.
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share y=
our
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________ php-java-bridge-users mai=
ling list php...@li... https://lists.sourcef=
orge.net/lists/listinfo/php-java-bridge-users

Hi,
   
  interestingly I've got similar problems while upgrading to bridge 3.1.8. The tomcat error log contained NoClassDefFound messages suggesting that some essential classes were missing.
   
  It turned out that tomcat kept old classes in its work and tmp directory and it was using these classes instead of the new versions from the JavaBridge.war.
   
  Cleaning these directories helped, but I now get java.lang.SecurityException messages when accessing the java session store from apache...The sessionSharing.php example works, but my classes don't. the only difference I see is that my classes call java_get_session more than once. Is there a bug in 3.1.8?
   
   
  Peter
   

 		
---------------------------------
 All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.

Hi,
if I try to reach the JavaBridge Directory I get this error:
HTTP Status 404 - Servlet PhpCGIServlet is not available

________________________________________________________________________

type Status report

message Servlet PhpCGIServlet is not available

description The requested resource (Servlet PhpCGIServlet is not
available) is not available.


________________________________________________________________________
Apache Tomcat/5.0

I Belive that's not good?


Also the access to the Javabridge throu tomcat does not work:
With=20

extension=3Djava.so

[java]
war-file first)
java.hosts     =3D "127.0.0.1:8080"
java.servlet   =3D On ;; Off, On or User
java.log_level =3D 2
java.log_file  =3D "/var/log/apache2/java-bridge.log"

;java.java_home =3D "/usr/lib/j2sdk1.5-sun"
;java.java      =3D "/usr/lib/j2sdk1.5-sun/bin/java"
;java.log_level =3D 2
;java.log_file  =3D "/var/log/apache2/java-bridge.log"

I get an error:
...blubb...
Fatal error: php_mod_java(88): Protocol violation at pos 182 while
trying to connect to
127.0.0.1:8080(/JavaBridge/JavaBridge.phpjavabridge). Please check that
the back-end (JavaBride.war) is deployed or please switch off the
java.servlet option. Received bytes: HTTP/1.1 500 Internal Server
Error??Content-Type: text/html;charset=3Dutf-8??Content-Length:
3310??Date: Wed, 20 Sep 2006 07:42:07 GMT??Server:
Apache-Coyote/1.1??Connection: close????<html><head><title>Apache
Tomcat/5.0 - Error report</title><style><!--H1
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;f=
ont-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;backgro=
und-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;=
color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tah=
oma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Ta=
homa,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family=
:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px; in /v=
ar/www/sessionSharing.php on line 5

With use of java.java, etc. it works.
But tomcat is faster, isn't it? That is the reason why i want to use it.


--=20
Mit freundlichen Gr=C3=BC=C3=9Fen / Best regards
  Matthias Quade

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Contact me =3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Matthias Quade                      eMail:  ma...@ma...
Brauweg 47                          web:    http://blog.matthias-qua.de
37073 G=C3=B6ttingen                     phone:  +49 551 3817880
Germany                             mobile: +49 171 6423616
Public Key: 0x4DA75E65              icq:    76375111
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Hi,

I'm attempting to convert the doubleclick.com DART Java API to a PEAR
class using the following command.

java -jar JavaBridge.jar
--convert /workspace/triad/lib/pear /workspace/triad/lib/java/dartapi/dartapi.jar

Here is the error.

java.lang.RuntimeException: java.lang.NoClassDefFoundError:
org/exolab/castor/xml/ValidationException
        at php.java.bridge.Standalone.init(Standalone.java:167)
        at php.java.bridge.Standalone.main(Standalone.java:194)
Caused by: java.lang.NoClassDefFoundError:
org/exolab/castor/xml/ValidationException
        at java.lang.Class.getDeclaredMethods0(Native Method)
        at java.lang.Class.privateGetDeclaredMethods(Class.java:2395)
        at java.lang.Class.privateGetPublicMethods(Class.java:2519)
        at java.lang.Class.getMethods(Class.java:1406)
        at php.java.bridge.Snarf.writeProcedures(Snarf.java:176)
        at php.java.bridge.Snarf.writeClass(Snarf.java:284)
        at php.java.bridge.Snarf.writeClass(Snarf.java:194)
        at php.java.bridge.Snarf.run(Snarf.java:142)
        at php.java.bridge.Snarf.main(Snarf.java:62)
        at php.java.bridge.Standalone.checkOption(Standalone.java:115)
        at php.java.bridge.Standalone.init(Standalone.java:142)
        ... 1 more

I chatted with the guys in #java on chat.freenode.net and they told me
the error was that I was missing the castor lib from (castor.org). I
downloaded this and placed it in /usr/share/java/ext as suggested by the
README. Restarted apache and I still receive this error. Does anyone
have any idea how to fix this?

Best Regards,
AJ Tarachanowicz II