Re: XML:DB over JDBC (was: XPath Queries: Resources without ID)

[Kimbro Staken]

Ok, interesting. Since there aren't any scripts I take it the tables are 
constructed dynamically, correct? Did you happen to look at using a more 
structured mapping along the lines of what DB-DOM uses?

On Thursday, August 2, 2001, at 08:18 AM, Jeremias Maerki wrote:

What does the database schema look like for this?
Basically this is:
ID VARCHAR(20) PRIMARY KEY for the resource ID
DOCUMENT MEDIUMBLOB for the resource (text)
Then for each XPath statement in the configuration XML file you specify
an alias which is used as column name in the database. The datatype is
determined in the configuration file.
That means using SQLSelectQueryService you can only search using the
predefined values which are evaluated each time a resource is
manipulated.
Pretty simplicistic, but it has worked for me until now.

Jeremias Märki

mailto:[EMAIL PROTECTED]

OUTLINE AG
Postfach 3954 - Rhynauerstr. 15 - CH-6002 Luzern
Fon +41 (41) 317 2020 - Fax +41 (41) 317 2029
Internet http://www.outline.ch
----------------------------------------------------------------------
Post a message:         mailto:[EMAIL PROTECTED]
Unsubscribe:            mailto:[EMAIL PROTECTED]
Contact administrator:  mailto:[EMAIL PROTECTED]
Read archived messages: http://archive.xmldb.org/
----------------------------------------------------------------------
Kimbro Staken
The dbXML Project
htttp://www.dbxml.org
----------------------------------------------------------------------
Post a message:         mailto:[EMAIL PROTECTED]
Unsubscribe:            mailto:[EMAIL PROTECTED]
Contact administrator:  mailto:[EMAIL PROTECTED]
Read archived messages: http://archive.xmldb.org/
----------------------------------------------------------------------