• State Suggested Answer
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 8 subscribers
  • Views 4412 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Administration

Different Secondary data sources

chetany
A Score Level 1
Hi All,

I have MySQL as primary and secondary data source.
I am trying to add a new Oracle data-source as a secondary data source.
I am using the configure.bat script.

But I am getting an error, the error is "com.appiancorp.suiteapi.common.exceptions.AppianException: com.appiancorp.rdbms.datasource.DataSourceException: javax.naming.NameNotFoundException: Error looking up jdbc/OracleDataSource, service service jboss.naming.context.java.jdbc.OracleDataSource is not started"

One thing that I am not clear is:
should the Oracle datasource be mentioned in apian-ds.xml or in a new *-ds.xml file?

Please let me know if someone has faced this issue, and how it can be resolved.

OriginalPostID-243107

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1
    @Eduardo, this is late reply, thanks anyway..
    I had given up configuring the extra Oracle Data source. But, today I tried it again systematically, also went through the Appian installation guide once again, and realized the mistake I was doing. I had not added the JDBC driver for Oracle in the correct location, also in standalone.xml.dev, I had not added the security-domain. Now, its working, both MySQL and Oracle data sources are working with the Appian environment.
Reply
  • 0
    A Score Level 1
    @Eduardo, this is late reply, thanks anyway..
    I had given up configuring the extra Oracle Data source. But, today I tried it again systematically, also went through the Appian installation guide once again, and realized the mistake I was doing. I had not added the JDBC driver for Oracle in the correct location, also in standalone.xml.dev, I had not added the security-domain. Now, its working, both MySQL and Oracle data sources are working with the Appian environment.
Children
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.