PHP-Java Bridge: Connect PHP to MySQL using JNDI
| From: | jpmad4it | Date: | Tue, 20 Jan 2009 12:47:49 +0000 |
| Subject: | PHP-Java Bridge: Connect PHP to MySQL using JNDI | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-286843@lists.php.net to get a copy of this message | ||
Hi everyone!
This is driving me nuts!
I have setup a Linux webserver. Tomcat is running at the backend and is
connected to Apache at the frontend using mod_proxy. At the moment I have a
few test applications setup, which involves Apache sending JSP requests to
Tomcat via mod_proxy. They all work fine.
I also have some JSP code that uses a JNDI connection to the MySQL database
using MySQL Connector / J. All the configuration is done in Tomcat in the
XML files. This works fine too.
Now what I want to do is use PHP code to connect to MySQL using JNDI,
instead of using JSP code. This is where the sourceforge open-source
PHP-Java Bridge comes into it.
The php-java bridge is deployed in Tomcat's webapps folder (it came as a
*.war file). This is all thats necessary for it to work according to their
tech support.
Is there anyone around that knows how to code this using PHP?
I had a go at this, and my (most-likely awful) attempt is here:
<?php
require_once("java/Java.inc");
require_once("java/JavaBridge.inc");
try {
$dbh = new PDO("java:comp/env/jdbc/TestDB");
foreach ($dbh->query('SELECT * from testdata') as $row) {
echo "<pre>";
print_r($row);
echo "</pre>";
}
$dbh = null;
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
?>
Now I don't think that PDO will support what I have done, and that is to try
and call the JNDI connection. I get the error message "Error!: could not
find driver"
Another attempt was to use the following code:
<?php
require_once("java/Java.inc");
require_once("java/JavaBridge.inc");
$conn = mysql_connect("java:comp/env/jdbc/TestDB");
print $conn;
?>
But this gave the error:
Warning - mysql_connect() [ function.mysql-connect function.mysql-connect ]:
Unknown MySQL server host 'java' (1)
I guess this post could have gone in the Java forum too, but I thought it
was more of a PHP issue?
Any help would be great.
rgs J
--
View this message in context: http://www.nabble.com/PHP-Java-Bridge%3A-Connect-PHP-to-MySQL-using-JNDI-tp21562460p21562460.html
Sent from the PHP - General mailing list archive at Nabble.com.