ARIS User Group Meeting Wien (German)
Register
ARIS Process Mining in action - Live Demo
Register
ARIS Super User Group
Register

View all
Profile picture for user Jos Ross

Hi,.

We are in the middle of the migration Aris7.2 to Aris9.8.

In the ist situation we have MashZone 2.3 and this works perfect with Oracle11g (when finally the right JDBC-Driver was found).

The MashZone 9.8 is now installed and I'm trying to get a connection to an Oracle12c database....(under administration/database connection etc).

I put (manually) the file ojdbc14.jar in the map jdbcdrivers then I stop/start the mashzone services... but the new driver does not pop-up in the JDBC driver selection bar (only the 2 default drivers).

The test-connetion answers to me "Unable to find JDBC driver class "sun.jdbc.odbc.JdbcOdbcDriver" connecting to database "AIAS2"

So I have some questions:

1. the documentation says that you 'have' to use ACC to upload the JDBC drivers, so does this mean that it can not be done manually ?

2. where on the server are the 2 default drivers installed (I can't seen these files in the map jdbcdrivers) 

3. is the ojdbc14.jar the right driver for oracle12c



Kind regards,

Jos

by Jiri Mares
Posted on Thu, 09/01/2016 - 15:42

Hi, try to follow the documentation as you mentioned, because if you do it via ACC you are at least sure the file is copied to the right destination where the particular runnable needs it. And you will see also error message if something goes wrong. In some cases there are more than one destination and that is why you should use "enhance" command in ACC. It´s not that easy in 9.X as it was in AMZ 2.3, but now almost every configuration could be done from one place = ACC.

BR,

Jiri

0
by Bernd Ziegler
Posted on Fri, 11/18/2016 - 08:42

Hello,

in the online documentation http://documentation.softwareag.com/ibo_bigdata/aris/mashzone981e/MashZone_Online_Help.pdf you can find all information about upgrad vom Mashzone 2.3 to Mashzone 9.8. 

According your Oracle driver question, we used driver "ojdbc7.jar" with name "oracle.jdbc.OracleDriver" and URL "jdbc:oracle:thin:@..." to connect to a orcale database and it worked in our tests.

Maybe the issue based on the wrong driver you used.

BR,

Bernd

 

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock