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.
Please post the contents of the dbconfig.xml.
Are you able to connect to Oracle using plsql? Also please try using a non oracle utility to connect to the database?
Renjith,
We have already established a direct connection to Oracle DB using a SID, however for our production setup we need to connect via a Datasource.
I am in the process of rebuilding my POC jira instance will repost:
dbconfig.xml
tnsnames
and any errors
Regards
Nakhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.