SSDN - mySQL DB Connection 2

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

daniel weberhofer

Subject: 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

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.

daniel weberhofer

Subject: 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 ...

Ivan Pedruzzi

Subject: 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

daniel weberhofer

Subject: 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

Ivan Pedruzzi

Subject: 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

daniel weberhofer

Subject: 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

daniel weberhofer

Subject: 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

Ivan Pedruzzi

Subject: 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

Frank Mainzer

Subject: 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

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.