XSQLServlet - simple question

From: <herve_at_improsteurs.ch>
Date: 29 May 2006 08:26:40 -0700
Message-ID: <1148916400.698006.223850@i39g2000cwa.googlegroups.com>

Hi all,

I would like to select a row in a single table using the XSQLServlet from Oracle (verison 10.1.0.2)
My table is :
CREATE TABLE MAPPING (

	context VARCHAR2(255) NOT NULL,
	key VARCHAR2(255) NOT NULL,
	value VARCHAR2(255),

  description VARCHAR2(255)
);

ALTER TABLE MAPPING ADD CONSTRAINT PK_mapping

        PRIMARY KEY (context, key);

I just would like to execute this query : SELECT VALUE AS VALUE FROM MAPPING WHERE CONTEXT = ? and KEY = ?

If I pass the parameters in the url (GET method) it works fine. But I need to use the POST method.
I post an XML like that :
<?xml version="1.0" encoding="ISO-8859-1"?> <request>
  <parameters>
<context>TEST_CONTEXT</context>
<key>TEXT_KEY</key>

  </parameters>
</request>

How can I retreive both CONTEXT and KEY parameters from the posted XML ?

Thanks in advance for your help. Received on Mon May 29 2006 - 10:26:40 CDT