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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
(Deleted User) Subject: Oracle Connections in 9i and 10g
Author: (Deleted User)
Date: 03 May 2006 01:06 PM
I have read the forum messages for the search string "LDAP Oracle" and one of them hit the mark. Most of them refer to messages on [XML-DEV] list.

History: Prior to Oracle 9i TNSNAMES.ORA file was the method for connecting to an Oracle DB. The file contained the connection facts. JDBC as, used in SS, does not reference the TNSNAMES.ora file, but places the connection facts into the connection string.

Oracle 9i is the transition release. It offers both TNSNAMES access as well as an LDAP server that isolates the DB user connection facts. This adds security and maintainability. A user need only know the name of the resource. LDAP will look up the other facts and determine if connection is appropriate.

Problem: I cannot use SS to connect to our Oracle 9i databases because I do not have, and cannot get the DB connection facts. Oracle 10g uses LDAP as the preferred connection support path. More an more organizations will be needing the LDAP path for SS connection to Oracle DB.

How do I use rdbxml in an Oracle LDAP environment?


Ivan PedruzziSubject: Oracle Connections in 9i and 10g
Author: Ivan Pedruzzi
Date: 03 May 2006 04:53 PM

What do you mean by "DB user connection facts"?

Are you suggesting to have a LDAP resource browser to retrieve the user credentials and the database server address?

Thank You for you feedback
Ivan Pedruzzi
Stylus Studio Team

(Deleted User) Subject: Oracle Connections in 9i and 10g
Author: (Deleted User)
Date: 03 May 2006 05:49 PM
A TNSNAMES.ora file has these facts in it.
some.domain.name =
(ADDRESS = (PROTOCOL = TCP)(HOST = someMachineName)(PORT = 1521))
(SID = SomeSID)
some.domain.name -- provides a name for the resource
PROTOCOL -- identifies the protocol that the resource is expecting.
someMachineName -- provides a name defined in the physical box containing the resource.
PORT -- provides the port on the physical box that the resource will use to accept work.
SID -- a value

All or most of these facts as also provided in a JDBC connection string. Although there are Oracle drivers that will create thier JDBC connection string by referencing an entry in the TNSNAMES.ora file the SS built in Oracle Driver assembles the string from a dialog.

An example string needed for the oracle provided driver might be
<host> -- is the same fact that is kept in the TNSNAME.ora file as someMachineName.
<port> -- is the same fact as defined in the TNSNAMES.ora file as PORT=
<service> -- is the same fact as defined in the TNSNAME.ora file as SID =.

Obviously both the TNSNAME.ora file and the JDBC string expose too much information. Use of the LDAP service reduces the information needed fro a client to connect to a data resource. All the client needs is a name and set of credentials. No one needs to know anything about the internal network, machine names, open ports or anything.

Oracle says to use this kind of a JDBC string to connect through a LDAP server when using their driver.
cn and dc are fields in the LDAP data set.

This would probably work to supply credentials over a secure connection

My question is how do I use the dialogs of rdbxml to get a connection string formed that will use the LDAP protocol to establish a connection?

Ivan PedruzziSubject: Oracle Connections in 9i and 10g
Author: Ivan Pedruzzi
Date: 04 May 2006 01:22 PM
Hi Greg,

Unfortunately you can't. Even if you type the URL it will not work.

"DB to XML Data Source" is layered on top of the DataDirect JDBC drivers that don't support LDAP.

We understand that this feature has become increasingly important and I am sure we will come up with a good solution.

Ivan Pedruzzi
Stylus Studio Team

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!  

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.