SSDN - jdbc problems

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

Adriaan Vanderende

Subject: jdbc problems
Author: Adriaan Vanderende
Date: 29 Jun 2005 07:13 AM

Hi,
When using saxon8 with sql extensions executed within stylus studio it gives me errors like :
java.lang.RuntimeException: JDBC Connection Failure: oracle.jdbc.OracleDriver
TransformerException:
at: null 1048575
Connecting to jdbc:oracle:thin,.......

When executed outside stylus in saxon directoy ( with same classpath) it works fine.

Why?

Classpath in stylus :
${classpath};C:\oracle92\jdbc\classes12.zip

in dos box :
C:\saxon>java -classpath saxon8.jar;saxon8-sql.jar;C:\oracle92\jdbc\classes12.zi
p net.sf.saxon.Transform colors.xml "C:\Program Files\Apache Group\Tomcat 4.1\w
ebapps\hawkhttp\xsl\MsgMonitorReportsql.xsl"

jvm :

java version "1.5.0_03"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_03-b07)
Java HotSpot(TM) Client VM (build 1.5.0_03-b07, mixed mode, sharing)

samplesql.xsl
sample

Ivan Pedruzzi

Subject: jdbc problems
Author: Ivan Pedruzzi
Date: 29 Jun 2005 11:36 AM

Hi Adriaan,

I added saxon8-sql.jar and classes12.jar to the project CLASSAPTH (Project -> Set Classpath...) and seems to work fine with Stylus Studio 6.3 377K

Here my settings

<xsl:param name="driver" select="'oracle.jdbc.driver.OracleDriver'"/>
<xsl:param name="database" select="'jdbc:oracle:thin:@localhost:1521:ora92'"/>
<xsl:param name="user" select="'scott'"/>
<xsl:param name="password" select="'tiger'"/>

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Adriaan Vanderende

Subject: jdbc problems
Author: Adriaan Vanderende
Date: 29 Jun 2005 01:39 PM

Hi,

Have you set the classpath for the jvm and the external jvm ? or have you set the classpath outside stylus studio?

I have added saxon-sql.jar but no way.

Adriaan Vanderende

Subject: jdbc problems
Author: Adriaan Vanderende
Date: 29 Jun 2005 02:27 PM

hi,

wel mine does not have add to classpath for a project
using version 6 : 287h release 2

Adriaan Vanderende

Subject: jdbc problems
Author: Adriaan Vanderende
Date: 29 Jun 2005 02:32 PM

hi,

It is working in the DDQ beta version.

But not in the 6.2 version of mine.

Ivan Pedruzzi

Subject: jdbc problems
Author: Ivan Pedruzzi
Date: 29 Jun 2005 03:54 PM

If it is not feasible to update to 6.3 try to copy the classes from classes12.jar into saxon8.jar located in
"c:\Program Files\Stylus Studio 6 XML Enterprise Edition\bin"

Tha worked for me

Ivan

Adriaan Vanderende

Subject: jdbc problems
Author: Adriaan Vanderende
Date: 30 Jun 2005 04:31 AM

you are good, you are good. ( like in "analyze this" the movie).

Can't think of why I did not think of it myself.

Kind regards

Ivan Pedruzzi

Subject: jdbc problems
Author: Ivan Pedruzzi
Date: 01 Jul 2005 01:23 AM

<<"

... so the 25 tons fountanin made of Italian marble
sitting on my back yard comes from you

">>

:)

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.