| haspath, inpath für xml data in blob column [message #91957] |
Tue, 09 December 2003 14:35 |
rabbit
Messages: 6
Registered: October 2003
|
Junior Member |
|
|
Hi all,
i have tried to insert my 10 xml data in the blob column. It's successful (After the inserting
i have checked it additionally). Now i want to use INPATH and HASPATH to search attribut and
element's value in the xml data. The Index with preference path_section_group is created. But
i get no result for the searching. My programmcode are shown following:
CREATE TABLE xmlblob_table(id int CONSTRAINT xmlblob_index PRIMARY KEY not null, xml_dok
BLOB)
cstmt = conn.prepareCall("{call Ctx_Ddl.create_section_group(?, ?)}");
cstmt.setString(1, "xmlpathgroup");
cstmt.setString(2, "PATH_SECTION_GROUP");
cstmt.execute();
CREATE INDEX xml_index ON xmlblob_table(xml_dok) INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('SECTION GROUP xmlpathgroup')
SELECT id FROM xmlblob_table
WHERE CONTAINS(xml_dok, '"Billy Tilla" INPATH(//author)')>0";
//WHERE CONTAINS(xml_dok, 'HASPATH(document1/title1)')>0";
I am sure, "Billy Tilla" is stored inside more author tags and document1 is the direct
parentage for the title1 tag in a xml data.
I think, it is possible the index is not correctly erzeugt. But i can not find any probleme.
Please help?
thank you very much and greeting from germany!
rabbit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
