Cannot connect to mySQL from web app in Eclipse
I'm following a course developing a simple web app in Eclipse. I'm now at the stage where the web app needs to connect to MySQL but throws a class not found: for the com MySQL connector.
The project is a Maven project and I have entered the dependency for MySQL connector-java which is 8.0.15 in the POM file. The connector has been downloaded and is in tomcat's lib folder and in the project's WEB-INFlib folder and it is even in a folder users….m2repositoryMySQLMySQL-connector-java (imported by Eclipse?).
In the Java Build Path at the top of the CLASSPATH lib there is a reference to the connector in the WEB-INFlib. There is also a reference to the same connector under Tomcat (pointing to the version in to Tomcat lib) and a further reference to the connector under the Maven dependencies where it points to the already mentioned users….m2repositoryMySQLMySQL-connector-java folder. That is 3 separate reference to the connector in 3 different folders. I've tried having only a single reference to the connector in the Java Build Path/CLASSPATH but all with the same result.
Incidentally I have a small standalone Java program that I start from the command line which does connect and read the database correctly although in this case when I run the program I also explicitly give the path to the MySQL connector.
All suggestions welcome.
mysql eclipse jdbc
edited Feb 14 at 0:14
MarianD
1,4911718
asked Feb 13 at 22:21
John SmithJohn Smith
11
add a comment |
I'm following a course developing a simple web app in Eclipse. I'm now at the stage where the web app needs to connect to MySQL but throws a class not found: for the com MySQL connector.
The project is a Maven project and I have entered the dependency for MySQL connector-java which is 8.0.15 in the POM file. The connector has been downloaded and is in tomcat's lib folder and in the project's WEB-INFlib folder and it is even in a folder users….m2repositoryMySQLMySQL-connector-java (imported by Eclipse?).
In the Java Build Path at the top of the CLASSPATH lib there is a reference to the connector in the WEB-INFlib. There is also a reference to the same connector under Tomcat (pointing to the version in to Tomcat lib) and a further reference to the connector under the Maven dependencies where it points to the already mentioned users….m2repositoryMySQLMySQL-connector-java folder. That is 3 separate reference to the connector in 3 different folders. I've tried having only a single reference to the connector in the Java Build Path/CLASSPATH but all with the same result.
Incidentally I have a small standalone Java program that I start from the command line which does connect and read the database correctly although in this case when I run the program I also explicitly give the path to the MySQL connector.
All suggestions welcome.
mysql eclipse jdbc
edited Feb 14 at 0:14
MarianD
1,4911718
asked Feb 13 at 22:21
John SmithJohn Smith
11
add a comment |
I'm following a course developing a simple web app in Eclipse. I'm now at the stage where the web app needs to connect to MySQL but throws a class not found: for the com MySQL connector.
The project is a Maven project and I have entered the dependency for MySQL connector-java which is 8.0.15 in the POM file. The connector has been downloaded and is in tomcat's lib folder and in the project's WEB-INFlib folder and it is even in a folder users….m2repositoryMySQLMySQL-connector-java (imported by Eclipse?).
In the Java Build Path at the top of the CLASSPATH lib there is a reference to the connector in the WEB-INFlib. There is also a reference to the same connector under Tomcat (pointing to the version in to Tomcat lib) and a further reference to the connector under the Maven dependencies where it points to the already mentioned users….m2repositoryMySQLMySQL-connector-java folder. That is 3 separate reference to the connector in 3 different folders. I've tried having only a single reference to the connector in the Java Build Path/CLASSPATH but all with the same result.
Incidentally I have a small standalone Java program that I start from the command line which does connect and read the database correctly although in this case when I run the program I also explicitly give the path to the MySQL connector.
All suggestions welcome.
mysql eclipse jdbc
edited Feb 14 at 0:14
MarianD
1,4911718
asked Feb 13 at 22:21
John SmithJohn Smith
11
I'm following a course developing a simple web app in Eclipse. I'm now at the stage where the web app needs to connect to MySQL but throws a class not found: for the com MySQL connector.
The project is a Maven project and I have entered the dependency for MySQL connector-java which is 8.0.15 in the POM file. The connector has been downloaded and is in tomcat's lib folder and in the project's WEB-INFlib folder and it is even in a folder users….m2repositoryMySQLMySQL-connector-java (imported by Eclipse?).
In the Java Build Path at the top of the CLASSPATH lib there is a reference to the connector in the WEB-INFlib. There is also a reference to the same connector under Tomcat (pointing to the version in to Tomcat lib) and a further reference to the connector under the Maven dependencies where it points to the already mentioned users….m2repositoryMySQLMySQL-connector-java folder. That is 3 separate reference to the connector in 3 different folders. I've tried having only a single reference to the connector in the Java Build Path/CLASSPATH but all with the same result.
Incidentally I have a small standalone Java program that I start from the command line which does connect and read the database correctly although in this case when I run the program I also explicitly give the path to the MySQL connector.
All suggestions welcome.
mysql eclipse jdbc
mysql eclipse jdbc
edited Feb 14 at 0:14
MarianD
1,4911718
asked Feb 13 at 22:21
John SmithJohn Smith
11
edited Feb 14 at 0:14
MarianD
1,4911718
asked Feb 13 at 22:21
John SmithJohn Smith
11
edited Feb 14 at 0:14
MarianD
1,4911718
edited Feb 14 at 0:14
MarianD
1,4911718
edited Feb 14 at 0:14
MarianD
1,4911718
1,4911718
asked Feb 13 at 22:21
John SmithJohn Smith
11
asked Feb 13 at 22:21
John SmithJohn Smith
11
asked Feb 13 at 22:21
John SmithJohn Smith
11
11
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405473%2fcannot-connect-to-mysql-from-web-app-in-eclipse%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405473%2fcannot-connect-to-mysql-from-web-app-in-eclipse%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
