Profile picture for user ronak.gupta

Dear All,

After running the below mentioned query in ACC getting the error- no viable alternative at input.

update external service db0000000000 url="jdbc:oracle:thin:@<server>:<port>:<sid>" driverClassName="oracle.jdbc.OracleDriver" username="<user>" password="<password>" maxIdle=15 maxActive=100 maxWait=10000 removeAbandoned=false removeAbandonedTimeout=600 logAbandoned=true defaultAutoCommit=false rollbackOnReturn=true host=<server> port=<port> jmxEnabled=true validationQuery="select 1 from dual" testOnBorrow=true

Please help.

Thanks in Advance.

by Runé Becker
Badge for 'Mastermind' achievement
Posted on Thu, 09/28/2017 - 17:48

Have you replaced all parameters shown in < > before entering that command?

0
by Ronak Gupta Author
Posted on Fri, 09/29/2017 - 06:56

yes i have replaced with DB details but still getting this error. 

0

Featured achievement

Genius
You like to help others solve their problems by answering questions.
Recent Unlocks
  • KF
  • KH
  • RG
  • Profile picture for user Vee_ARIS
  • Profile picture for user smarty
  • 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