Re: [Php-java-bridge-users] How to wrap two PHP objects asjavaclosures, and in Java call a method on the first closure with the secondclosureas parameter?

[<php-java-bridge-users@li...>]

Peter,

> Isn't it possible to simply use $this when a method is
> invoked from Java?!?

we were talking about an optimation which fetches the PHP object associated with a Java closure.  

Until now this was only possible by asking the PHP object for its ID (through a Java method) and then fetching the object from a global array using the obtained ID as a key.


Regards,
Jost Boekemeier



      

Re: [Php-java-bridge-users] How to wrap two PHP objects asjavaclosures, and in Java call a method on the first closure with the secondclosureas parameter?

[<php-java-bridge-users@li...>]

Hi,

> assume you want to unwrap the wrapped PHP object. It might
> be a good idea to extend java_values() this way.

the change is in the cvs head now. The current download version 5.4.3.1 also contains this feature. From the NEWS:

Version 5.4.3.1

* java_unwrap($closure) can now used to retrieve the PHP object
  associated with a java_closure(). Example:

    class f{function __toString(){return "p";}function toString(){return "j"}};
    $cl = java_closure(new f());
    echo $cl;
    => j
    $cl = java_unwrap($cl)
    echo $cl;
    => p


Regards,
Jost Boekemeier



      

Re: [Php-java-bridge-users] Starting the JavaBridge from PHP

[<php-java-bridge-users@li...>]

Hi,

> 1) Is it possible to test whether a Java bridge is running?

Yes. Please see the API documentation for details (http://php-java-bridge.sourceforge.net/pjb/docs/php-api/index.html)


> 2) If not 1), what happens if i try to start another bridge
> on the 9200 port? 

It will terminate immediately if port 9200 is already in use.


> 3) Is there an explicit way of shutting down the bridge?

Yes, see the posted example for details (http://php-java-bridge.sourceforge.net/pjb/examples/source.php?source=startJava.php).


Regards,
Jost Boekemeier



      

Re: [Php-java-bridge-users] connect PHP and MySQL using JNDI & PHP-Java Bridge

[<php-java-bridge-users@li...>]

Hi,

> How can I use the PHP-Java Bridge to connect PHP to MySQL
> using the JNDI connection?

Please see the MySQL API for details. An example is here:
http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-basic.html#connector-j-examples-connection-drivermanager


> $dbh = mysql_connect("java:comp/env/jdbc/TestDB")

Mamma mia... :)  If you want to access the driver from a EJB session bean, please see our EJB example (http://php-java-bridge.sourceforge.net/pjb/examples/source.php?source=documentClient.php) how to access a session bean.


Regards,
Jost Boekemeier



      

Re: [Php-java-bridge-users] connect PHP and MySQL using JNDI & PHP-Java Bridge

[<php-java-bridge-users@li...>]

As a follow up to "connect PHP and MySQL using JNDI & PHP-Java Bridge"

Thanks Dan,

I understand what you are saying. I have been thinking about trying that method too.

I made some progress with the JDBC/PHP using this code:

<?php
require_once ("java/Java.inc");
$drivermanager = new JavaClass('java.sql.DriverManager');
$conn1 = $drivermanager->getConnection("jdbc:mysql://localhost:3306/javatest?user=javauser&password=javadude";) or die("Unable to connect to MySQL");

print $conn1;
echo '<br /><br />';

mysql_select_db("javatest", $conn1) or die('Could not connect: ' . mysql_error());

$result = mysql_query("SELECT id, foo, bar FROM testdata");
while ($row = mysql_fetch_array($result)) {
  print "ID:".$row{'id'}." Name:".$row{'foo'}." 
  ".$row{'bar'}."<br>";
}
mysql_close($conn1);
?>


This code returns "com.mysql.jdbc.JDBC4Connection@...

Could not connect: "

However if I remove $conn1 from this line:

mysql_select_db("javatest", $conn1) or die('Could not connect: ' . mysql_error());

to get this line:

mysql_select_db("javatest") or die('Could not connect: ' . mysql_error());

I get the error:

com.mysql.jdbc.JDBC4Connection@...

Could not connect: Access denied for user 'root'@'localhost' (using password: NO)

I think this indicates that the problem is with the mysql_select_db() function. I don't know whether I've coded this correctly seeing as I am suing JDBC. Maybe someone knows?

Anyway, going down the Java route may be difficult as I know nothing about Java really.

Anyway, if I do ahead and write the Java code, would I compile it as a *.jar file? Or would I compile it as a *.class file and use it as a servlet??
I'm guessing as a *.jar file so then the data within it can be called in PHP?

I'm still wondering though, would the SQL queries have to be coded in Java? Or could they be coded in PHP once the connection is established - the only reason I ask is because i am kind of up to that point already with my code above....I have a connection but the database cannot be selected?

rgs J



 

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

Re: [Php-java-bridge-users] connect PHP and MySQL using JNDI & PHP-Java Bridge

[<php-java-bridge-users@li...>]

Hi,

If it were me, I would use some kind of data access layer written in 
java.  So the java data access layer would deal with the JNDI and 
database statements, and php would just call it.

$userdao = new Java("com.foo.dao.UserDAO");

$userdao->addUser("dan","moore");

The UserDAO class would have an addUser method that would do all the 
database manipulations.

I know that is not exactly what you are asking, but that is the way I'd 
do this.

You might be able to return a jdbc connection across the php java bridge 
as well.  Have a java class get the connection from JNDI, and then run 
normal JDBC commands against that connection.

$connmanager = new Java("com.foo.manager.ConnectionManager");

$stmt = $connmanager->createStatement("select * from users");
... more jdbc

I don't know if it is possible to get what is essentially a JDBC 
connection from JNDI and treat it as a php db connection (which is what 
the code you have below does).

Dan

On 1/20/2009 4:12 AM, php-java-bridge-users@... wrote:
> Hi there,
> 
> I have deployed the JavaBridge war file into my Tomcat backend.
> 
> I have successfully connected JSP to MySQL using MySQL Connector / J using JNDI (which is configured in the Tomcat server.xml and web.xml files).
> 
> How can I use the PHP-Java Bridge to connect PHP to MySQL using the JNDI connection?
> 
> I have tried this PHP code to call the JNDI connection jdbc/TestDB:
> <?php
> 
> require_once("java/Java.inc");
> 
> $dbh = mysql_connect("java:comp/env/jdbc/TestDB")
> 
> ?>
> 
> But i receive the error:
> 
> Warning - mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'java' (1)
> 
> Is what I am trying to achieve possible with the PHP-Java Bridge? Do I need to require more than the java/Java.inc file in my code?
> 
> If you could you supply me with or point me to the correct code to achieve this connection I would be most grateful.
> 
> Kind regards
> 
> 
> This message has been scanned for viruses by MailControl - http://www.mailcontrol.com
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> php-java-bridge-users mailing list
> php-java-bridge-users@...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users

[Php-java-bridge-users] connect PHP and MySQL using JNDI & PHP-Java Bridge

[<php-java-bridge-users@li...>]

Hi there,

I have deployed the JavaBridge war file into my Tomcat backend.

I have successfully connected JSP to MySQL using MySQL Connector / J using JNDI (which is configured in the Tomcat server.xml and web.xml files).

How can I use the PHP-Java Bridge to connect PHP to MySQL using the JNDI connection?

I have tried this PHP code to call the JNDI connection jdbc/TestDB:
<?php

require_once("java/Java.inc");

$dbh = mysql_connect("java:comp/env/jdbc/TestDB")

?>

But i receive the error:

Warning - mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'java' (1)

Is what I am trying to achieve possible with the PHP-Java Bridge? Do I need to require more than the java/Java.inc file in my code?

If you could you supply me with or point me to the correct code to achieve this connection I would be most grateful.

Kind regards


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