XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext 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

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.