Thread: [Php-java-bridge-users] Code takes a long time

Is there any reason why the following code would take 13 seconds to load?

I'm using the java.so extension.

Code:
<?php
include_once('java/Java.inc');

$class = Java("java.lang.Class");
$sequelink =
$class->forName("com.ddtek.jdbc.sequelink.SequeLinkDriver")->newInstance();
$dm = Java("java.sql.DriverManager");

$con =
$dm->getConnection("jdbc:sequelink://FMServer:2399;serverDataSource=Clients",
$username, $password);

$stmt = $con->createStatement();

$results = $stmt->executeQuery($query);

$metaData = $results->getMetaData();

$numCols = $metaData->getColumnCount();

?>

-- 


Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com

Try the same algorithm directly on Java code, maybe the delay could be on
the SQL queries.


On Wed, Aug 20, 2008 at 2:06 PM, <
php...@li...> wrote:

> Is there any reason why the following code would take 13 seconds to load?
>
> I'm using the java.so extension.
>
> Code:
> <?php
> include_once('java/Java.inc');
>
> $class = Java("java.lang.Class");
> $sequelink =
> $class->forName("com.ddtek.jdbc.sequelink.SequeLinkDriver")->newInstance();
> $dm = Java("java.sql.DriverManager");
>
> $con =
>
> $dm->getConnection("jdbc:sequelink://FMServer:2399;serverDataSource=Clients",
> $username, $password);
>
> $stmt = $con->createStatement();
>
> $results = $stmt->executeQuery($query);
>
> $metaData = $results->getMetaData();
>
> $numCols = $metaData->getColumnCount();
>
> ?>
>
> --
>
>
> Thank you,
> Micah Gersten
> onShore Networks
> Internal Developer
> http://www.onshore.com
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> php-java-bridge-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>



-- 
Roger José Padilla Camacho

Problem appears to either be with my JDBC driver or Filemaker, not the
bridge.  I tested with a Java DB test app Filemaker gives out.
Thanks for all your help.

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



php...@li... wrote:
> Try the same algorithm directly on Java code, maybe the delay could be on
> the SQL queries.
>
>
> On Wed, Aug 20, 2008 at 2:06 PM, <
> php...@li...> wrote:
>
>   
>> Is there any reason why the following code would take 13 seconds to load?
>>
>> I'm using the java.so extension.
>>
>> Code:
>> <?php
>> include_once('java/Java.inc');
>>
>> $class = Java("java.lang.Class");
>> $sequelink =
>> $class->forName("com.ddtek.jdbc.sequelink.SequeLinkDriver")->newInstance();
>> $dm = Java("java.sql.DriverManager");
>>
>> $con =
>>
>> $dm->getConnection("jdbc:sequelink://FMServer:2399;serverDataSource=Clients",
>> $username, $password);
>>
>> $stmt = $con->createStatement();
>>
>> $results = $stmt->executeQuery($query);
>>
>> $metaData = $results->getMetaData();
>>
>> $numCols = $metaData->getColumnCount();
>>
>> ?>
>>
>> --
>>
>>
>> Thank you,
>> Micah Gersten
>> onShore Networks
>> Internal Developer
>> http://www.onshore.com
>>
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> php-java-bridge-users mailing list
>> php...@li...
>> https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users
>>
>>     
>
>
>
>