XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » mySQL DB Connection 2
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + element type must not contain ... (3)
-> + XML to .txt file (7)
-> + Modifying a XSL-FO report (5)
-> + Retrievning multiple values...... (2)
-> + does Stylus Enterprise work wi... (2)
-> + MSSQL to 837P conversion (4)
-> + Generating XML files accesing ... (6)
-> + How to bold text using XSL (6)
-> + Different heading based on pag... (3)
-> + Code folding (2)
-> + Bad param=value pair on comman... (2)
-> + Saving an XML file (2)
-> + stylus adding random non print... (2)
-> + Displaying Base64Binary as Ima... (6)
-> - probleme de representation d'i... (1)
-> + SS 2008 error message not disp... (8)
-> + XQuery external variable conve... (4)
-> + encodings available (3)
-> + stand-alone application file n... (4)
-> + Windows Installer Dialog Box a... (4)
-> + Block search and replace (2)
-> + Problem with validation (3)
-> + ISA12 vs GS08 (5)
-> + Web Service Call failure... an... (11)
-> + Quotes in xpath query (3)
-> + Java Built-in processor no lon... (6)
-> + Dynamic input and output names (8)
-> + Java built-in parser (3)
-> + Contains an invalid path (2)
-> + Wizard XML Schema to XML (2)
-> + XML to EDI (14)
-> + Computer with original install... (2)
-> + using Custom Tool - passing ar... (3)
-> + Non-printable special characte... (3)
-> + Transfer Options (Settings, Pr... (2)
-> + Enterprise Edition, Rel. 3, Bu... (9)
-> + Need help with xsl file and xm... (2)
-> + Upgrading and retaining settin... (4)
-> + saxon9.dll etc. missing (2)
-> - Error on using XQuery File in ... (1)
-> - Strange Dialog Box (1)
-> + Studio Crashes in schema edito... (3)
-> + Xml to XMl Conversion (2)
-> + Unable to create a complex typ... (2)
-> + Error message wen trying run j... (2)
-> - XSLT Mapper question... (1)
-> + Dcument Wizard XSLT Editor Tab... (2)
-> + Beginner Question - XPath with... (2)
-> + Trying to generate .net code w... (2)
-> + duplicate values in variable w... (5)
-> + Java Runtime Environment libra... (4)
-> + programmatically generate XML ... (4)
-> + Help Loading Oracle BI Publish... (4)
-> + [French] xsl <=> report (3)
-> + XML Diff (3)
-> + StylusStudio 2008, saxon saxon... (6)
-> + Msql Table err:FODC0004 Table ... (2)
-> + The evaluation period for Data... (2)
-> + Mysql to XML (2)
-> + Is there a Collapse All nodes ... (2)
-> + flat file conversion with CDAT... (4)
-> + Struzzo.exe eats up %40 CPU ba... (2)
-> + schematron support? (11)
-> + XML Generator did not generate... (2)
-> + Nesting XML files (2)
-> + Web Service Call fails - targe... (5)
-> + getting not valid for content ... (2)
-> - element modem was referenced i... (1)
-> + xerces-c++ xml parser (2)
-> + movie.dtd (2)
-> + HELP! Stylus Studio 2008 Enter... (3)
-> + Xalan problem with xsl:attribu... (2)
-> + Breakpoints being ignored (12)
-> + Need a new key for Stylus Stud... (2)
-> + Global parameters are not reco... (4)
-> - mySQL DB Connection 2 (10)
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> ->mySQL DB Connection 2
-> + Using Data Direct xQuery to ag... (4)
-> + stylusXslt command line -- XSL... (15)
-> + XSLT processor using EXSLT fun... (2)
-> + Integrating Omni Mark (2)
-> + EDI Standards to gXML (2)
-> + flat file conversion (3)
-> + EDI to XML: Invalid URI error (3)
-> + Validating and XML Schema (6)
-> + XSD to DDL (MS-SQL/2005) (6)
-> + xml converter cant encode 0x19 (4)
-> + XSD Help Needed (2)
-> + How do you delete a field in a... (2)
-> + Disable page breaks (3)
-> + XSD semantic structure compari... (3)
-> + Studio Crashes On File Open (7)
-> + Which parser is used by Stylus... (2)
-> + How to DIFF XML windows with d... (3)
-> + Automation using Visual Studio (7)
-> + CSV to XML conversion help (2)
-> + XML tree help (3)
-> + java.lang.NullPointerException... (2)
-> + Creating schema from xml - how... (3)
-> + Mismatch between intellisense ... (4)
-> + Using FOP 0.94 in XML Pipeline (2)
-- Previous [1081-1100] [1101-1120] [1121-1140] 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)
Topic  
Postnext
daniel weberhoferSubject: mySQL DB Connection 2
Author: daniel weberhofer
Date: 31 Mar 2008 04:28 PM
Hi,

I face the same problem as described in

Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » mySQL DB Connection

when I want to connect to MYSQL community edition on my Vista PC:

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test

at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.stylusstudio.DataDirectDDXQStub.connect(DataDirectDDXQStub.java:84)
at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:120)


In the project node I have added
C:\Program\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar saved the project and restart Stylus Studio.

But I still get java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test .

What to do next?

Daniel
Postnext
Minollo I.Subject: mySQL DB Connection 2
Author: Minollo I.
Date: 31 Mar 2008 04:38 PM
The driver .jar file doesn't need to be added to the project classpath, but to the connection you create. When adding a connection and selecting "MySQL Community Edition", enter/select the full driver's location in the "Driver Classpath" field.
Postnext
daniel weberhoferSubject: mySQL DB Connection 2
Author: daniel weberhofer
Date: 01 Apr 2008 02:54 AM
>The driver .jar file doesn't
>need to be added to the
>project classpath, but to the
>connection you create. When
>adding a connection and
>selecting "MySQL Community
>Edition", enter/select the
>full driver's location in the
>"Driver Classpath" field.


I tried this too - same result.

I also tried it on a XP machine - same error message.

Hmm - what's wrong ...

Postnext
Ivan PedruzziSubject: mySQL DB Connection 2
Author: Ivan Pedruzzi
Date: 01 Apr 2008 08:47 AM

Hi Daniel,

Could you try to re-start Stylus Studio?

Which Stylus Studio build are you running (Help->About->Framework version)?

Which Java Virtual Machine (Help-> About->Java Virtual Machine)?

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
daniel weberhoferSubject: mySQL DB Connection 2
Author: daniel weberhofer
Date: 01 Apr 2008 09:34 AM
Ivan,

I still need a bit of your help

>Could you try to re-start
>Stylus Studio?

I tried again to re-start my Stylus Studio - but I still get
"java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test"


>Which Stylus Studio build are
>you running
>(Help->About->Framework
>version)?

Build 1050g

>
>Which Java Virtual Machine
>(Help-> About->Java
>Virtual Machine)?

1.6.0_03-b05 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000

Daniel
Postnext
Ivan PedruzziSubject: mySQL DB Connection 2
Author: Ivan Pedruzzi
Date: 01 Apr 2008 02:42 PM
Originally Posted: 01 Apr 2008 02:39 PM
Daniel,

Could you please show us how the connection setting dialog is configured?


Ivan Pedruzzi
Stylus Studio Team

MySQL CE connection Settings

Postnext
daniel weberhoferSubject: mySQL DB Connection 2
Author: daniel weberhofer
Date: 01 Apr 2008 03:46 PM
Ivan,

It's similar as yours - but it still does not work.

The screenshot is attached.

Classpath is not fully visible therefore here full classpathstring "C:\Program\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6.bin.jar".

I double checked - the file is there.

Hmmm ....

Daniel

Postnext
daniel weberhoferSubject: mySQL DB Connection 2
Author: daniel weberhofer
Date: 02 Apr 2008 05:39 PM
Ivan,

Today I tried

- same jdbc driver version as you are using (C:\Program\mysql-connector-java-5.1.5\mysql-connector-java-5.1.5.bin.jar)
- disable windows vista UAC
- Capital letter path (C:\TEST\mysql-connector-java-5.1.6-bin.jar)

... of course always with restarting Stylus Studio 2008.

What could be the issue? What shall I do next?

Regards
Daniel
Postnext
Ivan PedruzziSubject: mySQL DB Connection 2
Author: Ivan Pedruzzi
Date: 02 Apr 2008 06:23 PM

Hi Daniel,

I sent you a private email, did it reach you?

Ivan Pedruzzi
Stylus Studio Team
Posttop
Frank MainzerSubject: mySQL DB Connection 2
Author: Frank Mainzer
Date: 29 Mar 2011 03:39 PM
Hi,

I have the same problem. What was the solution to it?

thx

frank
   
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!  
go

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.