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)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ 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.