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