Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use of scope resolution operator in PHP development example

1030334Aug 2 2013 — edited Aug 8 2013

I am relatively new to OOP in general so this question may sound dumb but

In this documentation:  Query Performance and Prefetching

To quote that text, "

The $db->setPrefetch() call is used to set the prefetch value. The microtime() calls are used to show how long the report took to generate.

A new Db::fetchRow() method is used to get one row at a time. It is called in a loop after the query has been run"

Why the does it use the scope resolution operator? Isn't it used for just static methods and overridden methods.

I do not see any static declaration when this method is entered into class.

To quote the method declaration:

  /** * Fetch a row of data. Call this in a loop after calling Db::execute() * * @return array An array of data for one row of the query */

public function fetchRow() {

$row = oci_fetch_array($this->stid, OCI_ASSOC + OCI_RETURN_NULLS);

return($row);

}

Am I missing something really trivial thing about this concept?

Thank you.

Comments

Jani Rautiainen-Oracle

I think the main issue you have is the SFTP connection. AFAIK only HTTPS connections are allowed. The documentation states:

Remote invocations with a transport protocol other than HTTPS (including plain text HTTP).

Not applicable.

does the 3rd party provide a web service to obtain the data ?

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Hi ,

3rd party doesn't have any web-service in place.

I heard ICS supports most of the 3rd party integration. But looks like they are not yet released. Hence trying to find some feasible options through JCS.

Since JCS (SAAS Extension) supports java based applications, can we use some 3rd party libraries in JCS to connect with SFTP through Java application ?

Appreciate your help.

Thanks,

Vasanth

Jani Rautiainen-Oracle

I am not sure; the documentation is fairly clear that only HTTPS is allowed. That said the JCS console does have some SFTP configurations listed so maybe there is some functionality, unfortunately I have no knowledge of this and have to leave it up to guys from JCS to confirm. AFAIK the SFTP details on the console are used for JDeveloper DB Cart functionality to move DM & data between systems..

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Hi Jani ,

Thanks for your reply.

Instead of JCS SAAS, can i use plain JCS to connect the third party system through SFTP. If so , is there any documentation or examples available on the available approached for using SFTP in JCS ? 

And also need your help to know , if not here, which is the right forum to ask our technical queries on JCS? 

Appreciate your help!

Thanks,

Vasanth

Unfortunately I am also only developer using JCS-SaaS so I cannot give definite answers on "plain JCS" as I do not have an instance to test with so I am limited to the documentation. This is the right forum to ask questions on JCS, I think there was a public holiday in US yesterday so hopefully the JCS guys will give definitive answers soon. I did forward the thread to the JCS product manager.

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Any updates or inputs on the JCS part. Appreciate your help.

Thanks,

Vasanth

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 5 2013
Added on Aug 2 2013
1 comment
1,370 views