We are in the process of moving to Oracle as the Database for Jira.
I am trying to create a Datasource in Jira to estabish the connection.
have done the following
- created a tnsnames.ora file with the details of the Oracle servers ( have been able to connect using the .ora file from my local machine using Oracle SQL developer)
- updated the dbconfig.xml as per
https://confluence.atlassian.com/pages/viewpage.action?pageId=307038110
- updates the Setenv.bat file as per the above instruction
Looking for some pointers from anybody who has successfully implemented a connection to Oracle via a service name
getting the following error
type Exception report
message org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (IO Error: could not resolve the connect identifier "DATABASE.WORLD")
description The server encountered an internal error (org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (IO Error: could not resolve the connect identifier "DATABASE.WORLD")) that prevented it from fulfilling this request.
exception
com.atlassian.util.concurrent.LazyReference$InitializationException: org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (IO Error: could not resolve the connect identifier "DATABASE.WORLD")
com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)
com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:50)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:113)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:135)
com.atlassian.jira.web.filters.JiraEncodingFilter.getContentType(JiraEncodingFilter.java:59)
com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39)
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49)
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:78)
com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:57)
root cause
org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (IO Error: could not resolve the connect identifier "DATABASE.WORLD")
org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:409)
org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:962)
org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:630)
org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:804)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:789)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:766)
com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:82)
com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:318)
com.atlassian.jira.propertyset.JiraCachingPropertySet$12.run(JiraCachingPropertySet.java:785)
com.atlassian.jira.propertyset.JiraCachingPropertySet.doLocked(JiraCachingPropertySet.java:846)
com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:770)
com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:58)
com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:31)
com.atlassian.jira.config.properties.PropertySetUtils.createDatabaseBackedPropertySet(PropertySetUtils.java:34)
com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:26)
com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:22)
com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:140)
com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321)
com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143)
com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getString(ApplicationPropertiesStore.java:346)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:60)
com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$ApplicationPropertiesClassNameRetriever.get(UserNameTransformer.java:68)
com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$Factory.get(UserNameTransformer.java:99)
com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter$OSUserResolver.<init>(TrustedApplicationFilter.java:40)
com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter.<init>(TrustedApplicationFilter.java:25)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:525)
java.lang.Class.newInstance0(Class.java:374)
java.lang.Class.newInstance(Class.java:327)
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
java.util.concurrent.FutureTask.run(FutureTask.java:166)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.29 logs.
