Subject: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 ??
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.