SSDN - Java code generated by Xquery & java.sql.connection

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Karlheinz Alber

Subject: Java code generated by Xquery & java.sql.connection
Author: Karlheinz Alber
Date: 07 Aug 2006 04:28 PM

I generated java cod with Xquery 'Generate Java Code' and
then brought this Java Code under our servlet environment.

Here, i can get a connection ( java.sql.connection).

How I can use this connection with the generated code.

thx
Karlheinz

Ivan Pedruzzi

Subject: Java code generated by Xquery & java.sql.connection
Author: Ivan Pedruzzi
Date: 07 Aug 2006 05:34 PM

Hi Karlheinz,

The DataDirect XQuery processor does not allow to use a generic SQL connection object. You will need to use the XQJ API to connect to the database, see the configuration file that Stylus Studio generates for you.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Karlheinz Alber

Subject: Java code generated by Xquery & java.sql.connection
Author: Karlheinz Alber
Date: 08 Aug 2006 04:11 AM

Hi Ivan,

is there an other possibility to export data from Oracle
using a java.sql.connection.

Is DB to XML Data source a way ?

It is important for us to have Java-code, which we could integrate into our application.

Karlheinz

Ivan Pedruzzi

Subject: Java code generated by Xquery & java.sql.connection
Author: Ivan Pedruzzi
Date: 08 Aug 2006 05:39 AM

Karlheinz,

Why are you force to use an existing java.sql.connection?

What prevents you to configure DataDirect XQuery to connect to the same Oracle database?

Thanks
Ivan Pedruzzi
Stylus Studio Team

Karlheinz Alber

Subject: Java code generated by Xquery & java.sql.connection
Author: Karlheinz Alber
Date: 08 Aug 2006 07:52 AM

1. We work in the finance sector and must serve security egulations.
I would not like to have any other configuration file with passwords for this reason on the servers our customers. I'm clear that i can save the
password encrypted, but I must leave certifcate this again.

2. Oracle licenses.
We have Oracel installation, with which we are at the border of the number of connections. This can mean for the user that he/it doesn't get any connection although he/it is in our application and the process cannot be executed.

Another question, can i install jar files of third-suppliers ( data direct ) and generated java code without further on customer server ?

thx
Karlheinz

Ivan Pedruzzi

Subject: Java code generated by Xquery & java.sql.connection
Author: Ivan Pedruzzi
Date: 08 Aug 2006 09:20 AM

You don't need to save the configuration file on disk, you can pass any kind of InputStream.

I am not sure what you mean by:
<<"can i install jar files of third-suppliers ( data direct ) and generated java code without further on customer server ?">>

To deploy DataDirect XQuery you will need to purchase license(s).
Please contact our Sales team for additional information
http://www.stylusstudio.com/xml_contact.html

Ivan Pedruzzi
Stylus Studio Team

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.