Re: [Php-java-bridge-users] Database Connection Resources in Php-Java Bridge

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

Hi Tony,
Using the Java Bridge as a JDBC wrapper incurs a fair amount of
technical overhead to your project.  If at all possible, I would
encourage you to first look for a suitable ODBC driver so that way you
can natively access the driver within PHP.

But if JDBC is your only option, it can be done.  I've used the bridge
on a Linux host to connect to SQL Server by JDBC and everything seemed
to work OK.  I did not go much further than executing some queries and
iterating result sets, but it worked pretty quickly on an idle dev
server.

As far as your connection questions go:  You can explicitly shut down
any open database connections by calling the close() method on the
JDBC driver.  But I have no idea if you can keep a persistent
connection open across multiple PHP script executions.. Like I said, I
was mostly playing around just to see what could be done.  It was very
quick, but I don't know how well it performs under load.

Good luck!

Brandon Kirsch
bra...@gm...
http://perceptionilluminates.com


On Thu, Oct 13, 2011 at 10:27 AM,
<php...@li...> wrote:
> Hi...
>
> Can someone provide me some advise on best practices for the use of jdbc
> connection resources in the hosted JVM.
>
> I want to call java code that performs jdbc from a php-developed web
> application.  I am concerned about the JVM not
> releasing connections.  Also, is it practical (or possible) to keep jdbc
> connections open during php sessions?  Is this advised?
>
> Thanks,
> Tony
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
> _______________________________________________
> php-java-bridge-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>