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

Hi,

java_session()->put("key", $jVal)
>
where $jVal is a java object implementing java.io.Serializable.
>

Looks like PGConnection and its derivatives cannot be serialized (without
changing the API). The only serializable interface is
PGConnectionPoolDataSource.

Unless there are any other ways to persist the JDBC connection, it looks
like I'm going to have to abandon this optimization for now.

Of course not. Your other PHP script might be running on a different
> server. Even if there's only one server, you may have more than one
> java back end (see option <distributable/> in your web.xml.
>

One web server running Apache2 -- no web.xml files, no j2ee.

Thank you for your suggestions.

Dave

Hi Dave,

> How would you persist an open JDBC connection across invocations of the same

PHP is essentially a "shared nothing" architecture. However, you can
store Java objects into the Java session using

   java_session()->put("key", $jVal)

where $jVal is a java object implementing java.io.Serializable.


> For example the following does not work:

Of course not. Your other PHP script might be running on a different
server. Even if there's only one server, you may have more than one
java back end (see option <distributable/> in your web.xml.

You must guarantee that $jVal is available to all PHP instances.
Either use a 3 tier architecture, or make your java session
distributable or use only one java back end and store your value
there.

I don't know if your $jVal is distributable. If it's not, use a
standard 3 tier architecture.

Since we are talking about jdbc drivers; jee uses its own connection
pool. So the only thing you'll have to do is to fetch a connection
from the pool, for example by using standard JNDI lookups.


Regards,
Jost Boekemeier

Hi,

How would you persist an open JDBC connection across invocations of the same
PHP script but at different times, from different computers?

For example the following does not work:

    // Load the PostgreSQL database driver.
    //
    java( 'java.lang.Class' )->forName( 'org.postgresql.Driver' );

    $conn = apc_fetch( $PERSIST );

    if( $conn === false || $conn->isClosed() ) {
      echo "Reloading JDBC connection: $conn\n";
      exit;

      // Attempt a database connection.
      //
      $conn = java( 'java.sql.DriverManager' )->getConnection(
        "jdbc:postgresql://$dbhost/$dbname?user=$dbuser&password=$dbpass" );

      // Failure to add is fine; it means the above fetch will fail, and
      // thus recreate the JDBC connection each time. Not ideal; might have
      // a performance impact.
      //
      apc_delete( $PERSIST );
      apc_store( $PERSIST, $conn );
    }

The $conn is always closed after the script ends.

The only other way I can think of to prevent this from happening is to
implement my own PostgreSQL Connection subclass, and override "close()" to
do nothing.

The problem I'm trying to solve is that the PG database reloads PL/R modules
for each new database connection.

What I need is some sort of persistent JDBC connection pool for the PHP-Java
bridge.

Any ideas?

Thank you!
Dave