php-java-bridge-users

Re: [Php-java-bridge-users] direct/native JDBC call using PHP

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

Brilliant,

I got it working with the above examples.

I have some questions regarding PDO. Would it be possible to use PDO with the Java Bridge? For example:
$pdo = new PDO("jdbc:mysql://localhost/test", "user", "pass");

I've tested this but I get the Tomcat error:

javax.servlet.ServletException: java.lang.RuntimeException: PHP Fatal error:  Uncaught exception 'PDOException' with message 'could not find driver' in /home/tomcat/webapps/JavaBridge/bridge_test2.php:9
Stack trace:
#0 /home/tomcat/webapps/JavaBridge/bridge_test2.php(9): PDO->__construct('jdbc:mysql://local...', 'test, 'test')
#1 {main}
  thrown in /home/tomcat/webapps/JavaBridge/bridge_test2.php on line 9

	php.java.servlet.PhpCGIServlet.handle(PhpCGIServlet.java:384)
	php.java.servlet.CGIServlet.doGet(CGIServlet.java:470)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
I am not sure if I require any different kind of java code / driver loading apart from:

# load driver from java.ext.dirs using Class.forName(...)

new java("com.mysql.jdbc.Driver");

Can PDO work in this way with the Bridge? Are there any examples available?

Also, is it possible to use the Bridge to call JNDI directly via PDO, such as (this works in Quercus):

$pdo = new PDO("java:comp/env/jdbc/TestDB");

Any help much appreciated.

kind regards

 

This message has been scanned for viruses by MailControl - www.mailcontrol.com

Re: [Php-java-bridge-users] direct/native JDBC call using PHP

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

Hi,


> I have some questions regarding PDO. Would it be possible
> to use PDO with the Java Bridge? 

You don't need the PHP/Java Bridge if all you want is to access databases through PHP PDO.

However, if you have a PDO library written in pure Java, you can access this library through the PHP/Java Bridge. 


> Also, is it possible to use the Bridge to call JNDI
> directly via PDO, such as (this works in Quercus):
> 
> $pdo = new PDO("java:comp/env/jdbc/TestDB");

Just copy the Java .jar file which exports the PDO API (quercus.jar probably) to your WEB-INF/lib and use the class as usual:

 $pdo = new java("com.caucho.xxx.pdo", "java:comp/env/jdbc/TestDB");

There's a test in the tests.php5 folder which accesses quercus from PHP through the PHP/Java Bridge, so this should work.


However, why do you want to use PHP PDO if you can use the pure Java JDBC API?


Regards,
Jost Boekemeier





      

Re: [Php-java-bridge-users] direct/native JDBC call using PHP

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

Hello!

I have some questions regarding PDO. Would it be possible to use PDO with the
Java Bridge? For example:
$pdo = new PDO("jdbc:mysql://localhost/test", "user",
"pass");

Do you want to use PDO or do you want to use a JDBC connection pool? Example above is not standard and doesn't work with PHP. See here: http://php.net/manual/en/book.pdo.php
But if you want to use pooled connections within tomcat, see here: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html


Peter