r4 - 22 Sep 2006 - 20:29:31 - CarlosGamboaYou are here: TWiki >  AtlasSoftware Web > FrontierDatabaseTestBNL

Testing FrontierBNL database connectivity

Test 1 retreving a table data from an Oracle Data base:

The first test consists on retrieve a table stored on an Oracle 10g version data base. The aim of this test is to verify the connection parameters on the FrontierBNL.XML servlet stored on the Tomcat Server were FrontierBNL installation resides. Thus, the script fn-req is used to retrieve the following query file test_query.sql.

    [cgamboa@gridui01 bin]$ cat test_query.sql
    SELECT * FROM Emp
    

  • Results first test The script's results below presented can be devided into two parts -writting and connection request, retreiving data- as follows:

  • Request and connection part

   [cgamboa@gridui01 bin]$ ./fn-req -f test_query.sql
   Entered:
   SELECT * FROM Emp

   Param [eNoLdvVxdQ5R0FJwC-L3VXDNLeDiAgAxWwS1]
   debug [frontier_config.c:255]: Empty server url.
   debug [frontier_config.c:282]: Empty proxy url.
   debug [frontier_config.c:269]: Added server <http://gridui01.usatlas.bnl.gov:8080/FrontierBNL>
   debug [frontier_config.c:72]: Total 1 servers
   debug [frontier_config.c:296]: Added proxy <http://gridui01.usatlas.bnl.gov:3128>
   debug [frontier_config.c:79]: Total 1 proxies
   debug [frontier_config.c:81]: Retrieve zip level is 5
   debug [fn-htclient.c:232]: using proxy gridui01.usatlas.bnl.gov
   debug [fn-urlparse.c:159]: gridui01.usatlas.bnl.gov: found addr <130.199.185.10>
   debug [fn-socket.c:32]: new socket s=4
   debug [fn-socket.c:90]: connect s=4 in progress, preparing for select.
   debug [fn-socket.c:127]: connected, s=4 .
   debug [fn-htclient.c:316]: request <GET  http://gridui01.usatlas.bnl.gov:8080/FrontierBNL/Frontier?type=frontier_request:1: DEFAULT&encoding=BLOBzip5&p1=eNoLdvVxdQ5R0FJwC-L3VXDNLeDiAgAxWwS1 HTTP/1.0
   Host: gridui01.usatlas.bnl.gov
   X-Frontier-Id: GCC 2.4.7 20166 cgamboa(9102) Carlos Gamboa
   

Writting results and close connection

   debug [fn-socket.c:138]: write request 256 bytes
   debug [fn-htclient.c:337]: status line <HTTP/1.0 200 OK>
   debug [fn-htclient.c:348]: got line <Server: Apache-Coyote/1.1>
   debug [fn-htclient.c:348]: got line <Expires: Fri, 22 Sep 2006 21:10:55 GMT>
   debug [fn-htclient.c:348]: got line <Content-Type: text/xml;charset=US-ASCII>
   debug [fn-htclient.c:348]: got line <Content-Length: 581>
   debug [fn-htclient.c:348]: got line <Date: Fri, 15 Sep 2006 21:10:55 GMT>
   debug [fn-htclient.c:348]: got line <Age: 602069>
   

This part of the script shows that the request was satisfied by the Frontier proxy server which means that this request this table was previouly requested

   debug [fn-htclient.c:348]: got line <X-Cache: HIT from gridui01.usatlas.bnl.gov>
   debug [fn-htclient.c:348]: got line <Proxy-Connection: close>
   debug [fn-htclient.c:348]: got line <>
   debug [response.c:60]: frontier server version=3.1 xmlversion=1.0
   debug [payload.c:172]: uncompressing 138 byte (full size 168) payload
   debug [fn-socket.c:57]: socket s=4 closed
   debug [response.c:245]: Payload[1] error 0 error code 0

   Object fields:
   1 EMPID NUMBER(0)
   2 NAME VARCHAR2

   Result contains 5 objects.
   '1' 'Marcel Proust'
   '2' 'Peter Gabriel'
   '3' 'Stan Getz'
   '4' 'Emil Cioran'
   '5' 'Patrick Suskind'
   

Test 2 retreiving a updating a stale table data from an Oracle Data base*:

On this test the same data table is requested as in test 1. Here results shows a new version of the data so the request on test 1 was stale since the new results shows more fields on the data table resquested

  • Results first test
   [cgamboa@gridui01 bin]$ ./fn-req -f test_query.sql
   Entered:
   SELECT * FROM Emp

   Param [eNoLdvVxdQ5R0FJwC-L3VXDNLeDiAgAxWwS1]
   debug [frontier_config.c:255]: Empty server url.
   debug [frontier_config.c:282]: Empty proxy url.
   debug [frontier_config.c:269]: Added server <http://gridui01.usatlas.bnl.gov:8080/FrontierBNL>
   debug [frontier_config.c:72]: Total 1 servers
   debug [frontier_config.c:296]: Added proxy <http://gridui01.usatlas.bnl.gov:3128>
   debug [frontier_config.c:79]: Total 1 proxies
   debug [frontier_config.c:81]: Retrieve zip level is 5
   debug [fn-htclient.c:232]: using proxy gridui01.usatlas.bnl.gov
   debug [fn-urlparse.c:159]: gridui01.usatlas.bnl.gov: found addr <130.199.185.10>
   debug [fn-socket.c:32]: new socket s=4
   debug [fn-socket.c:90]: connect s=4 in progress, preparing for select.
   debug [fn-socket.c:127]: connected, s=4 .
   debug [fn-htclient.c:316]: request <GET   http://gridui01.usatlas.bnl.gov:8080/FrontierBNL/Frontier?type=frontier_request:1:
   DEFAULT&encoding=BLOBzip5&p1=eNoLdvVxdQ5R0FJwC-L3VXDNLeDiAgAxWwS1 HTTP/1.0
   Host: gridui01.usatlas.bnl.gov
   X-Frontier-Id: GCC 2.4.7 7757 cgamboa(9102) Carlos Gamboa

   >
   debug [fn-socket.c:138]: write request 255 bytes
   debug [fn-htclient.c:337]: status line <HTTP/1.0 200 OK>
   debug [fn-htclient.c:348]: got line <Server: Apache-Coyote/1.1>
   debug [fn-htclient.c:348]: got line <Expires: Fri, 29 Sep 2006 21:36:59 GMT>
   debug [fn-htclient.c:348]: got line <Content-Type: text/xml;charset=US-ASCII>
   debug [fn-htclient.c:348]: got line <Content-Length: 609>
   debug [fn-htclient.c:348]: got line <Date: Fri, 22 Sep 2006 21:37:01 GMT>
   

Notice that in here a "Miss" occurs due to the fact that this table was in cache but stale, so the Frontier server request the data directly to the Oracle database.

   debug [fn-htclient.c:348]: got line <X-Cache: MISS from gridui01.usatlas.bnl.gov>
   debug [fn-htclient.c:348]: got line <Proxy-Connection: close>
   debug [fn-htclient.c:348]: got line <>


   debug [response.c:60]: frontier server version=3.1 xmlversion=1.0
   debug [payload.c:172]: uncompressing 158 byte (full size 196) payload
   debug [fn-socket.c:57]: socket s=4 closed
   debug [response.c:245]: Payload[1] error 0 error code 0

   Object fields:
   1 EMPID NUMBER(0)
   2 NAME VARCHAR2

   Result contains 6 objects.
   '1' 'Marcel Proust'
   '2' 'Peter Gabriel'
   '3' 'Stan Getz'
   '4' 'Emil Cioran'
   '5' 'Patrick Suskind'
   '6' 'Charles Bukowski'

About This Site

Please note that this site is a content mirror of the BNL US ATLAS TWiki. To edit the content of this page, click the Edit this page button at the top of the page and log in with your US ATLAS computing account name and password.


Attachments

 
Powered by TWiki
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback