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)
-> + 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)
-- Previous [1201-1220] [1221-1240] [1241-1260] 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.