XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Mikhail SSubject: Problem with oracle large tables
Author: Mikhail S
Date: 21 Apr 2006 05:53 AM
I try to define collection in xquery scenario properties - on oracle large table (~20000000 rows). After pressing OK in Scenario Properties window Stylus Studio freeze for a long time, on database I can see a sql-query from JDBC connecttion - select * from table.
I don't have problems with defining small tables as collections, but if I choose large one - Stylus Studio try to extract all rows from table, but in some cases it's impossible.

Is it possible - to make xqueries on large tables ??

Postnext
Mikhail SSubject: Problem with oracle large tables
Author: Mikhail S
Date: 21 Apr 2006 05:56 AM
I use Stylus StudioŽ 2006 Release 2 XML Enterprise Edition (build 591)
XQuery Processor - DataDirect
jvm - 1.5.0-rc-b63 Java HotSpot(TM) Client VM Sun Microsystems Inc.

Posttop
Minollo I.Subject: Problem with oracle large tables
Author: Minollo I.
Date: 21 Apr 2006 09:00 AM
The problem you are hitting is related to the way the current Stylus Studio version tries to infer the structure of the XML resulting from the Oracle database. The DataDirect XQuery processor itself would most likely be able to process your query without any problem.

We are addressing this issue in the coming 2006 Rel 3 update; in the meanwhile you will have unfortunately to work out of the Stylus Studio UI context to handle these kind of cases.

You may want to visit http://www.datadirect.com/xquery and subscribe for an evaluation of the DataDirect XQuery product; you will receive examples and documentations about how to use it.

Thanks,
Minollo

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.