datasource problem

Hi :
I have a problem with the 6th version of intellij.
In the datasource definition wizard I have entered the correct jdbc driver of my database (MySQL) and the correct information for connection(including: username, password, driver class, database url) but when i want to connect to the db this exception occures :

Incorrect driver and/or connection setting specified

What's the problem ?

Regards

9 comments

Hello nima,

Have you specified JDBC driver libraries?


nima wrote:

Hi :
I have a problem with the 6th version of intellij.
In the datasource definition wizard I have entered the correct jdbc driver of my database (MySQL) and the correct information for connection(including: username, password, driver class, database url) but when i want to connect to the db this exception occures :

Incorrect driver and/or connection setting specified

What's the problem ?

Regards


Gregory Shrago
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0

Hello Dear :

I add the jdbc library to my project libraries and then select it from the project library while creating datasource.

I tried oracle database and the thin jdbc driver but I got the same error.

I dont know if I have to add my jdbc drivers to any other location/classpath ?

thanks

0

The attached file is the print screen of my datasource definition wizard.



Attachment(s):
ps.gif
0

Didn't you say in your first post that you're using MySQL?

nima wrote:

The attached file is the print screen of my datasource definition wizard.


------------------------------------------------------------------------


--
Martin Fuhrer
Fuhrer Engineering AG
http://www.fuhrer.com

0

Yes sir, I tried MySQL too but I got the same result.
and the configuration in the picture is for Oracle XE database.

0

It's just that with a configuration example for MySQL I could try to
help, whereas I don't know much about Oracle.

nima wrote:

Yes sir, I tried MySQL too but I got the same result.
and the configuration in the picture is for Oracle XE database.


--
Martin Fuhrer
Fuhrer Engineering AG
http://www.fuhrer.com

0

Hello Dear,

Would you please tell me how to configure a datasource for MySQL?

Thanks.

0

Hello nima,

Unforunately due to a minor bug that is fixed for 6.0.2 you don't get
the detailed error message.

The root cause of the error is either ClassNotFoundException or
SQLException.

You can check it by running the code like this (with JDBC driver of your
choice jars on the classpath):

Driver driver = new (); Properties connectionProperties = new Properties(); connectionProperties.setProperty("user", ); connectionProperties.setProperty("password", ); Connection connection = driver.connect(]]>, connectionProperties);

Gregory Shrago
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

nima wrote:

Hello Dear,

Would you please tell me how I can configure a dataource for MySQL?

Thanks.

0

It may be caused by:

http://www.jetbrains.net/jira/browse/IDEADEV-11931


nima wrote:

Hi :
I have a problem with the 6th version of intellij.
In the datasource definition wizard I have entered the correct jdbc driver of my database (MySQL) and the correct information for connection(including: username, password, driver class, database url) but when i want to connect to the db this exception occures :

Incorrect driver and/or connection setting specified

What's the problem ?

Regards


Gregory Shrago
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0

Please sign in to leave a comment.