SSDN - connection to oracle 10g

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

chong zhang

Subject: connection to oracle 10g
Author: chong zhang
Date: 25 Sep 2007 01:06 PM

Hi,

I am using Stylus Studio 2007 Ent Suite trying to connect to a system running oracle 10g.
I used File Explorer based the following connection string but got error:

SAMPRD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = samprd)
)
)

java.sql.SQLException: [XQuery][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (samprd) was not recognized by the Oracle server.
at com.ddtek.xquery.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.xquery.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.xquery.jdbc.oracle.OracleImplConnection.makeConnectionHelper(Unknown Source)
at com.ddtek.xquery.jdbc.oracle.OracleImplConnection.makeConnection(Unknown Source)
at com.ddtek.xquery.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
at com.ddtek.xquery.jdbc.oracle.OracleImplConnection.open(Unknown Source)
at com.ddtek.xquery.jdbc.base.BaseConnection.connect(Unknown Source)
at com.ddtek.xquery.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.ddtek.xquery.jdbc.base.BaseConnection.open(Unknown Source)
at com.ddtek.xquery.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.stylusstudio.DataDirectDDXQStub.connect(DataDirectDDXQStub.java:74)
at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:108)

The older system is running on an older version of Oracle. And I can connect to it from Stylus Studio, also the generated java code (on Solaris) from a simple xquery wrapper using doc("db:///file://./s.rdbxml")

So I copied .rdbxml file and used the new host/service_name. The SQL statement is the same and the java code is able to connect to the server and get the sql result back.

Am I using the File Explorer correct? Is there something related to the SERVICE_NAME vs. SID?

Thanks,
Chong

Ivan Pedruzzi

Subject: connection to oracle 10g
Author: Ivan Pedruzzi
Date: 25 Sep 2007 05:52 PM

Hi Chong,

Could you please post the connection settings you are using in the File Explorer "Connection Settings" dialog?

Thanks
Ivan Pedruzzi
Stylus Studio Team

chong zhang

Subject: connection to oracle 10g
Author: chong zhang
Date: 25 Sep 2007 10:29 PM

Database Type: Oracle
Server URL: //10.10.10.10:1521;SID=samprd
Username: user
Password: ******

Sorry I need to correct one statement on the first post: the updated java code for the new system is NOT working, which actually returns the same error code ORA-12505.

Thanks,
Chong

Ivan Pedruzzi

Subject: connection to oracle 10g
Author: Ivan Pedruzzi
Date: 26 Sep 2007 08:40 AM

Please run the following command on the machine where the oracle server is running just verify host-name, port and SID

lsnrctl services samprd

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

chong zhang

Subject: connection to oracle 10g
Author: chong zhang
Date: 26 Sep 2007 10:31 AM

Thanks Ivan. The SID is the issue, which is a different name samprd2.

Now I can connect to the DB using File Explorer
with both jdbc:xquery:oracle://10.10.10.10:1521:SID=samprd2
and jdbc:xquery:oracle://10.10.10.10:1521:ServiceName=samprd

Another question coming out: I tried to create a .rdbxml file using "DB to XML Data Source" but only the SID=samprd2 works, and the ServiceName=samprd failed on "ORA-12505 Connection refused, the specified SID (ORCL) was not recognized by the Oracle server."

Thanks,
Chong

Ivan Pedruzzi

Subject: connection to oracle 10g
Author: Ivan Pedruzzi
Date: 26 Sep 2007 05:13 PM

Chong,

One thing to keep in mind: SQL/XML (DB to XML DataSource) has been discontinued starting from Stylus Studio 2007 R2 in favor of XQuery.

I suggest to concentrate your efforts on DataDirect XQuery.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

chong zhang

Subject: connection to oracle 10g
Author: chong zhang
Date: 27 Sep 2007 10:58 AM

I assume I need to call collection to get data from db/table, right?
Can I use that for both DataDirect and Saxon?

Ivan Pedruzzi

Subject: connection to oracle 10g
Author: Ivan Pedruzzi
Date: 27 Sep 2007 12:22 PM

Yes.

XQuery over relational data is a DataDirect XQuery specific feature.

Have a look at http://www.xquery.com/tutorials/ for more information

Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.