TestConnection fails for db connector in Anypoint Studio 7.3
I have installed Anypoint Studio 7.3 and trying to connect to oracle database using DB Connector. I have added the below dependency ±
<groupId>com.oracle.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>12.2.0.1</version>
</dependency>
But I am still getting error±
org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source Caused by: org.mule.extension.db.api.exception.connection.ConnectionCreationException: Could not obtain connection from data source Caused by: org.mule.runtime.extension.api.exception.ModuleException: java.sql.SQLException: Error trying to load driver: oracle.jdbc.driver.OracleDriver : Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Cannot load class 'oracle.jdbc.driver.OracleDriver': [ Class 'oracle.jdbc.driver.OracleDriver' has no package mapping for region 'domain/default/app/tooling-application-8e2bb850-e8d8-11e8-bc79-fe8a20524153'., Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Class 'oracle.jdbc.driver.OracleDriver' not found in classloader for artifact 'container'.]]]
Can anyone suggest please . Thanks, Sanjukta
mule-studio anypoint-studio dbconnection
add a comment |
I have installed Anypoint Studio 7.3 and trying to connect to oracle database using DB Connector. I have added the below dependency ±
<groupId>com.oracle.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>12.2.0.1</version>
</dependency>
But I am still getting error±
org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source Caused by: org.mule.extension.db.api.exception.connection.ConnectionCreationException: Could not obtain connection from data source Caused by: org.mule.runtime.extension.api.exception.ModuleException: java.sql.SQLException: Error trying to load driver: oracle.jdbc.driver.OracleDriver : Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Cannot load class 'oracle.jdbc.driver.OracleDriver': [ Class 'oracle.jdbc.driver.OracleDriver' has no package mapping for region 'domain/default/app/tooling-application-8e2bb850-e8d8-11e8-bc79-fe8a20524153'., Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Class 'oracle.jdbc.driver.OracleDriver' not found in classloader for artifact 'container'.]]]
Can anyone suggest please . Thanks, Sanjukta
mule-studio anypoint-studio dbconnection
add a comment |
I have installed Anypoint Studio 7.3 and trying to connect to oracle database using DB Connector. I have added the below dependency ±
<groupId>com.oracle.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>12.2.0.1</version>
</dependency>
But I am still getting error±
org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source Caused by: org.mule.extension.db.api.exception.connection.ConnectionCreationException: Could not obtain connection from data source Caused by: org.mule.runtime.extension.api.exception.ModuleException: java.sql.SQLException: Error trying to load driver: oracle.jdbc.driver.OracleDriver : Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Cannot load class 'oracle.jdbc.driver.OracleDriver': [ Class 'oracle.jdbc.driver.OracleDriver' has no package mapping for region 'domain/default/app/tooling-application-8e2bb850-e8d8-11e8-bc79-fe8a20524153'., Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Class 'oracle.jdbc.driver.OracleDriver' not found in classloader for artifact 'container'.]]]
Can anyone suggest please . Thanks, Sanjukta
mule-studio anypoint-studio dbconnection
I have installed Anypoint Studio 7.3 and trying to connect to oracle database using DB Connector. I have added the below dependency ±
<groupId>com.oracle.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>12.2.0.1</version>
</dependency>
But I am still getting error±
org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source Caused by: org.mule.extension.db.api.exception.connection.ConnectionCreationException: Could not obtain connection from data source Caused by: org.mule.runtime.extension.api.exception.ModuleException: java.sql.SQLException: Error trying to load driver: oracle.jdbc.driver.OracleDriver : Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Cannot load class 'oracle.jdbc.driver.OracleDriver': [ Class 'oracle.jdbc.driver.OracleDriver' has no package mapping for region 'domain/default/app/tooling-application-8e2bb850-e8d8-11e8-bc79-fe8a20524153'., Cannot load class 'oracle.jdbc.driver.OracleDriver': [ oracle.jdbc.driver.OracleDriver, Class 'oracle.jdbc.driver.OracleDriver' not found in classloader for artifact 'container'.]]]
Can anyone suggest please . Thanks, Sanjukta
mule-studio anypoint-studio dbconnection
mule-studio anypoint-studio dbconnection
asked Nov 16 '18 at 1:57
user3052531user3052531
92
92
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
That error happens because Maven can not find the dependency you added. That is because the Oracle JDBC driver is not available in the Maven Central repository. You will need to download the jar from Oracle and install it manually in the local Maven repository of your computer. Note that you need to match the coordinates of the dependency to the ones used in the install command, otherwise Maven will not find it.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53330395%2ftestconnection-fails-for-db-connector-in-anypoint-studio-7-3%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
That error happens because Maven can not find the dependency you added. That is because the Oracle JDBC driver is not available in the Maven Central repository. You will need to download the jar from Oracle and install it manually in the local Maven repository of your computer. Note that you need to match the coordinates of the dependency to the ones used in the install command, otherwise Maven will not find it.
add a comment |
That error happens because Maven can not find the dependency you added. That is because the Oracle JDBC driver is not available in the Maven Central repository. You will need to download the jar from Oracle and install it manually in the local Maven repository of your computer. Note that you need to match the coordinates of the dependency to the ones used in the install command, otherwise Maven will not find it.
add a comment |
That error happens because Maven can not find the dependency you added. That is because the Oracle JDBC driver is not available in the Maven Central repository. You will need to download the jar from Oracle and install it manually in the local Maven repository of your computer. Note that you need to match the coordinates of the dependency to the ones used in the install command, otherwise Maven will not find it.
That error happens because Maven can not find the dependency you added. That is because the Oracle JDBC driver is not available in the Maven Central repository. You will need to download the jar from Oracle and install it manually in the local Maven repository of your computer. Note that you need to match the coordinates of the dependency to the ones used in the install command, otherwise Maven will not find it.
answered Nov 17 '18 at 2:06
Alejandro DobniewskiAlejandro Dobniewski
905713
905713
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53330395%2ftestconnection-fails-for-db-connector-in-anypoint-studio-7-3%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