TAILIEUCHUNG - Oracle XSQL- P25
Oracle XSQL- P25Welcome to the exciting world of eXtended Structured Query Language (XSQL) development! What’s so exciting? Efficiency and ease of use. XSQL isn’t some razzle-dazzle technology to wow your users. It also isn’t the latest X standard du jour that no one can stop talking about until you ask, “But what does it do for me today?” The problem with all of the great stuff out there is that no one technology does it all. | 460 Chapter 16 There is only one method left to document the writeError. This is a simple utility method for writing out any errors. Since it is the last method this code snippet also contains the closing brace for the class void writeError String mesg An error occurred mesg Now you can put this code to use. In Chapter 7 you used a table called newsletter to study the XML handling actions. In this example you use the command line tool to input some rows into the table. Here is the XSQL that will exist on the Web server side the filename is xml version page connection momnpup xmlns xsql urn oracle-xsql xsql insert-request table newsletter page As discussed in Chapter 7 the xsql insert-request action assumes that there is an XML document in the canonical rowset schema contained in the HTTP request. Our SimpleServicesApp will load a file and embed the XML in the request. Here is what the file looks like which we ll call xml version ROWSET ROW num 1 NAME test name2 NAME EMAIL test1@ EMAIL ROW ROW num 2 NAME test name2 NAME EMAIL test2@ EMAIL ROW ROWSET You invoke the SimpleServicesApp as follows prompt java SimpleServicesApp http localhost xsql momnpup When the request arrives at the HTTP server it looks like this POST xsql momnpup HTTP Content-Type text xml User-Agent Host localhost Accept text html image gif image jpeg q .2 q .2 Connection keep-alive Web Services with XSQL 461 Content-length 226 xml version ROWSET ROW num 1 NAME test name2 NAME EMAIL test1@ EMAIL ROW ROW num 2 NAME test name2 NAME EMAIL test2@ EMAIL ROW ROWSET There are two differences between this and a standard post. First the Content -Type is set to text xml. The second difference is more obvious. Instead of having a list of name-value pairs in the body of the request you have the XML .
đang nạp các trang xem trước