XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » Converting Oracle table to XML document
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Issue with Processing Instruct... (2)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Mark SlavutskySubject: Converting Oracle table to XML document
Author: Mark Slavutsky
Date: 30 Mar 2006 02:56 PM
Originally Posted: 30 Mar 2006 02:53 PM
I am trying to convert an Oracle table to XML document using URL Builder. I could not connect to database and noticed that Stylus use unreliable multithreaded server connecting to Oracle database. How can I configure the Server URL to use the dedicated server we support? The Server URL I am using is the following: //dwhv8pdb-srv-node:2602;SID=dwhv8p Also after connecting to the database using URL Builder, how can I cleanly disconnect from database? Thanks. Mark
Postnext
Ivan PedruzziSubject: Converting Oracle table to XML document
Author: Ivan Pedruzzi
Date: 30 Mar 2006 03:10 PM
Hi Mark

>I am trying to convert an
>Oracle table to XML document
>using URL Builder. I could not
>connect to database and

Is any error popping up?

>noticed that Stylus use
>unreliable multithreaded
>server connecting to Oracle
>database.
>How can I configure the Server
>URL to use the dedicated
>server we support?

The above doesn't parse :)
What do you mean by "unreliable multithreaded server"?

In the URL you can specify the server name, port number and database name. It is up to you choose to which server connect.

//dwhv8pdb-srv-node:2602;SID=dwhv8p


>The Server URL I am using is
>the following:
>//dwhv8pdb-srv-node:2602;SID=d
>whv8p
>Also after connecting to the
>database using URL Builder,
>how can I cleanly disconnect
>from database?

The connection life cycle terminate when you dismiss the dialog.

Another connection is open when fetching the query result and then closed.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Mark SlavutskySubject: Converting Oracle table to XML document
Author: Mark Slavutsky
Date: 30 Mar 2006 04:37 PM
The error is: Oracle JDBC Driver - Software caused connection abort:socket write error

We looked in DataDirect JDBC documentation and used their option to connect to a dedicated server:
//dwhv8pdb-srv-node:2602;SID=dwhv8p;ServerType=dedicated

It did not help either.

Also when I click on Cancel button, although the dialog closes, the connection is still open (we checked from database site).
Postnext
Ivan PedruzziSubject: Converting Oracle table to XML document
Author: Ivan Pedruzzi
Date: 30 Mar 2006 05:11 PM
Mark,

Could you please post the entire stack-trace from the error dialog?

Stylus Studio uses "DataDirect Connect For SQL/XML" and the embedded Oracle JDBC driver doesn't support the property "ServerType".

The JDBC User Guide can be found at http://www.stylusstudio.com/doc/jdbcug.pdf

Later version of driver (3.4) added this functionality
http://knowledgebase.datadirect.com/kbase.nsf/ce24d9443437511f85256e57006bfe2a/515B0549A8956EC385256EE700579C46/$file/Changes%20from%2033%20to%2034.pdf

If the connection is failing with "socket error" seems wierd that you still see it open.

Thank You for your feedback
Ivan Pedruzzi
Stylus Studio Team

Posttop
Mark SlavutskySubject: Converting Oracle table to XML document
Author: Mark Slavutsky
Date: 31 Mar 2006 09:41 AM
Connection looks like unstable: sometimes I can connect and see the tables, but when I select a table and click on Open button it gives me the error (in this case when I click on Cancel connection is still open)

Most of the time I can't connect to DB getting the following error:
The error:
[StylusStudio][Oracle JDBC Driver]Software caused connection abort: socket write error

The stack is:

java.sql.SQLException: [StylusStudio][Oracle JDBC Driver]Software caused connection abort: socket write error

at ZC.jdbc.jxtr.JXTRDriverConfig.translateSQLException(Unknown Source)

at ZC.jdbc.jxtr.JXTRDriverConfig.createSQLException(Unknown Source)

at ZC.jdbc.jxtr.JXTRDriverDatabaseMetaData.getTables(Unknown Source)

at com.stylusstudio.DataDirectStub.getTables(DataDirectStub.java:486)
   
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.