com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column

Atlassian JIRA | Nick Minutello | 1 decade ago
  1. 0

    On starting Jira against an existing 2.5.3 database, I get this exception: 2005-05-14 16:15:07,446 ERROR [jira.issue.managers.DefaultCustomFieldManager] Exception thrown in DefaultCustomFieldManager.populateCache() 2005-05-14 16:15:07,462 ERROR [jira.issue.managers.DefaultCustomFieldManager] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:117) at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.getCustomFieldsFromDB(DefaultCustomFieldManager.java:270) at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.populateCache(DefaultCustomFieldManager.java:323) at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.<init>(DefaultCustomFieldManager.java:78) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.picocontainer.defaults.InstantiatingComponentAdapter.newInstance(InstantiatingComponentAdapter.java:100) at org.picocontainer.defaults.ConstructorInjectionComponentAdapter.instantiateComponent(ConstructorInjectionComponentAdapter.java:200) at org.picocontainer.defaults.InstantiatingComponentAdapter.getComponentInstance(InstantiatingComponentAdapter.java:48) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at org.picocontainer.defaults.SynchronizedComponentAdapter.getComponentInstance(SynchronizedComponentAdapter.java:35) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at com.atlassian.jira.config.component.ProfilingComponentAdapter.getComponentInstance(ProfilingComponentAdapter.java:27) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstanceOfType(DefaultPicoContainer.java:306) at com.atlassian.jira.ManagerFactory.getCustomFieldManager(ManagerFactory.java:194) at com.atlassian.jira.issue.fields.DefaultFieldManager.getCustomFieldManager(DefaultFieldManager.java:766) at com.atlassian.jira.issue.fields.DefaultFieldManager.isCustomField(DefaultFieldManager.java:564) at com.atlassian.jira.issue.fields.DefaultFieldManager.getOrderableField(DefaultFieldManager.java:654) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.<init>(DefaultFieldLayoutManager.java:50) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.picocontainer.defaults.InstantiatingComponentAdapter.newInstance(InstantiatingComponentAdapter.java:100) at org.picocontainer.defaults.ConstructorInjectionComponentAdapter.instantiateComponent(ConstructorInjectionComponentAdapter.java:200) at org.picocontainer.defaults.InstantiatingComponentAdapter.getComponentInstance(InstantiatingComponentAdapter.java:48) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at org.picocontainer.defaults.SynchronizedComponentAdapter.getComponentInstance(SynchronizedComponentAdapter.java:35) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at com.atlassian.jira.config.component.ProfilingComponentAdapter.getComponentInstance(ProfilingComponentAdapter.java:27) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstance(DefaultPicoContainer.java:298) at com.atlassian.jira.config.component.LicenseComponentAdaptor.loadComponent(LicenseComponentAdaptor.java:128) at com.atlassian.jira.config.component.LicenseComponentAdaptor.getComponentInstance(LicenseComponentAdaptor.java:105) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstancesOfType(DefaultPicoContainer.java:274) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstances(DefaultPicoContainer.java:266) at com.atlassian.jira.ComponentManager.eagerlyInstantiate(ComponentManager.java:296) at com.atlassian.jira.ComponentManager.start(ComponentManager.java:211) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:25) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3271) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardHost.start(StandardHost.java:754) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.Catalina.start(Catalina.java:512) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column name 'CUSTOMFIELDTYPEKEY'.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:336) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:113) ... 55 more

    Atlassian JIRA | 1 decade ago | Nick Minutello
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column
  2. 0

    On starting Jira against an existing 2.5.3 database, I get this exception: 2005-05-14 16:15:07,446 ERROR [jira.issue.managers.DefaultCustomFieldManager] Exception thrown in DefaultCustomFieldManager.populateCache() 2005-05-14 16:15:07,462 ERROR [jira.issue.managers.DefaultCustomFieldManager] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:117) at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.getCustomFieldsFromDB(DefaultCustomFieldManager.java:270) at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.populateCache(DefaultCustomFieldManager.java:323) at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.<init>(DefaultCustomFieldManager.java:78) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.picocontainer.defaults.InstantiatingComponentAdapter.newInstance(InstantiatingComponentAdapter.java:100) at org.picocontainer.defaults.ConstructorInjectionComponentAdapter.instantiateComponent(ConstructorInjectionComponentAdapter.java:200) at org.picocontainer.defaults.InstantiatingComponentAdapter.getComponentInstance(InstantiatingComponentAdapter.java:48) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at org.picocontainer.defaults.SynchronizedComponentAdapter.getComponentInstance(SynchronizedComponentAdapter.java:35) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at com.atlassian.jira.config.component.ProfilingComponentAdapter.getComponentInstance(ProfilingComponentAdapter.java:27) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstanceOfType(DefaultPicoContainer.java:306) at com.atlassian.jira.ManagerFactory.getCustomFieldManager(ManagerFactory.java:194) at com.atlassian.jira.issue.fields.DefaultFieldManager.getCustomFieldManager(DefaultFieldManager.java:766) at com.atlassian.jira.issue.fields.DefaultFieldManager.isCustomField(DefaultFieldManager.java:564) at com.atlassian.jira.issue.fields.DefaultFieldManager.getOrderableField(DefaultFieldManager.java:654) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.<init>(DefaultFieldLayoutManager.java:50) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.picocontainer.defaults.InstantiatingComponentAdapter.newInstance(InstantiatingComponentAdapter.java:100) at org.picocontainer.defaults.ConstructorInjectionComponentAdapter.instantiateComponent(ConstructorInjectionComponentAdapter.java:200) at org.picocontainer.defaults.InstantiatingComponentAdapter.getComponentInstance(InstantiatingComponentAdapter.java:48) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at org.picocontainer.defaults.SynchronizedComponentAdapter.getComponentInstance(SynchronizedComponentAdapter.java:35) at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42) at com.atlassian.jira.config.component.ProfilingComponentAdapter.getComponentInstance(ProfilingComponentAdapter.java:27) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstance(DefaultPicoContainer.java:298) at com.atlassian.jira.config.component.LicenseComponentAdaptor.loadComponent(LicenseComponentAdaptor.java:128) at com.atlassian.jira.config.component.LicenseComponentAdaptor.getComponentInstance(LicenseComponentAdaptor.java:105) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstancesOfType(DefaultPicoContainer.java:274) at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstances(DefaultPicoContainer.java:266) at com.atlassian.jira.ComponentManager.eagerlyInstantiate(ComponentManager.java:296) at com.atlassian.jira.ComponentManager.start(ComponentManager.java:211) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:25) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3271) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardHost.start(StandardHost.java:754) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.Catalina.start(Catalina.java:512) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column name 'CUSTOMFIELDTYPEKEY'.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:336) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:113) ... 55 more

    Atlassian JIRA | 1 decade ago | Nick Minutello
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column
  3. 0

    [JRA-8674] Tomcat & MySQL fail when using the -g driver - Atlassian JIRA

    atlassian.com | 11 months ago
    org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Cannot load JDBC driver class 'com.mysql.jdbc.Driver')
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The following was reported when using the *{{mysql-connector-java-3.1.10-bin-g.jar}}* driver. Removing the driver from the Classpath fixed the issue. Note. the *aspectj* error - this has affected quite a few tomcat/Mysql users - http://forums.mysql.com/read.php?39,22579,22579#msg-22579 {code} 2005-11-28 13:56:21,416 ERROR [atlassian.jira.service.DefaultServiceManager] Could not configure services: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Cannot load JDBC driver class 'com.mysql.jdbc.Driver') at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.service.DefaultServiceManager.loadServices(DefaultServiceManager.java:55) at com.atlassian.jira.service.DefaultServiceManager.getServices(DefaultServiceManager.java:39) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.destroy(ConsistencyCheckImpl.java:90) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextDestroyed(ConsistencyLauncher.java:33) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3710) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4283) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4132) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:683) at org.apache.catalina.startup.Catalina.start(Catalina.java:537) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.service.DefaultServiceManager.loadServices(DefaultServiceManager.java:55) at com.atlassian.jira.service.DefaultServiceManager.getServices(DefaultServiceManager.java:39) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.destroy(ConsistencyCheckImpl.java:90) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextDestroyed(ConsistencyLauncher.java:33) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3710) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4283) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4132) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:683) at org.apache.catalina.startup.Catalina.start(Catalina.java:537) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) Caused by: java.lang.NoClassDefFoundError: org/aspectj/lang/Signature at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760) ... 33 more {code}

    Atlassian JIRA | 1 decade ago | Nick Menere [Atlassian]
    org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Cannot load JDBC driver class 'com.mysql.jdbc.Driver')
  6. 0

    jira won't work on sun one. i'm describing my attempt to install and configure. jira sunone installation ======================== this describes installing jira 2.4.1 on sun one application server 7 using Oracle 9i. 0) follow atlassian install guide to configure jira for oracle. 1) configure the sun one instance's "server.policy" file as follows: 1.1) add the following to domains/[domain]/[server]/config/server.policy": --------------------------------------------------------------------- grant { permission java.security.AllPermission; }; ---------------------------------------------------------------------- This basically just turns on all security permissions (e.g. write to filesystem, set system property) to avoid trouble with the server. 2) add the jdbc driver to the server classpath 2.1) hit the admin console at http://host:4848 and log in 2.2) click on your server instance under "app server instances" in the 2.3) click on "JVM settings" 2.4) click on "path settings" 2.5) add the location of your tier 4 jdbc driver jar (e.g. ojdbc14.jar) under "classpath suffix". 3) create oracle connection pool "jdbc/JiraOraclePool" on the admin console using these parameters: 3.1) DataSource classname: "oracle.jdbc.pool.OracleDataSource" 3.2) Transaction isolation: "serializable" 3.2) Properties: 3.2.1) "URL" "jdbc:oracle:thin:@host:port:sid" 3.2.2) "user" "username" 3.2.3) "password" "password" 4) create datasource "jdbc/JiraDS" using "jdbc/JiraOraclePool" on the admin console 4.1) hit "jdbc/jdbc resources" and click new 4.2) enter "jdbc/JiraDS" as jndi name 4.3) select "jdbc/JiraOraclePool" from pool name combo box. 5) deploy as war file on the admin console 5.1) click on "server instance"/applications/web apps/ 5.2) hit "deploy" and browse for war file. 5.3) specify "context-root" This happened ============= When trying to access Jira it produces the following stracktrace on the server console. From what I read: 1) Jira uses SiteMesh's com.opensymphony.module.sitemesh.util.Container class to do servlet container detection and thinks Sun ONE is Tomcat. 2) Looking into SiteMesh, this seems to be caused by trying to classload org.apache.jasper.runtime.JspFactoryImpl". 3) Sun ONE's servlet engine is indeed based on Tomcat (or is in fact? I don't know). The appserver runtime jar is full of tomcat classes anyway. 4) Based on this detection, JIRA then turns of transactions and the jdbc driver starts complaining. StackTrace ========== -------------------------------------------------------------------------- INFO: CORE3282: stdout: 2003-10-20 14:16:45,070 WARN [atlassian.jira.upgrade.ConsistencyCheckImpl] Detected that you are using Tomcat - turned off all transactions. INFO: CORE3282: stdout: 2003-10-20 14:17:13,902 ERROR [core.entity.jdbc.DatabaseUtil] Unable to esablish a connection wi th the database... Error was:java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction INFO: CORE3282: stdout: 2003-10-20 14:17:13,902 ERROR [core.entity.jdbc.DatabaseUtil] Could not get table name informati on from the database, aborting. WARNING: CORE3283: stderr: Could not connect to database. Check your entityengine.xml settings: org.ofbiz.core.entity.Ge nericDataSourceException: Unable to esablish a connection with the database. (ORA-01453: SET TRANSACTION must be first s tatement of transaction WARNING: CORE3283: stderr: ) WARNING: CORE3283: stderr: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the da tabase. (ORA-01453: SET TRANSACTION must be first statement of transaction WARNING: CORE3283: stderr: ) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:213) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:283) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConnection(ConsistencyCheckImpl. java:144) WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl .java:90) WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java: 81) WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher .java:18) WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3255) WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardContext.start(StandardContext.java:3575) WARNING: CORE3283: stderr: at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardHost.start(StandardHost.java:638) WARNING: CORE3283: stderr: at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:345) WARNING: CORE3283: stderr: at org.apache.catalina.startup.Embedded.start(Embedded.java:957) WARNING: CORE3283: stderr: at com.iplanet.ias.web.WebContainer.start(WebContainer.java:426) WARNING: CORE3283: stderr: at com.iplanet.ias.web.WebContainer.startInstance(WebContainer.java:514) WARNING: CORE3283: stderr: at com.iplanet.ias.server.J2EERunner.confPostInit(J2EERunner.java:170) -------------------------------------------------------------------------

    Atlassian JIRA | 1 decade ago | Simon Mittag
    org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the da tabase. (ORA-01453: SET TRANSACTION must be first statement of transaction )

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.ofbiz.core.entity.GenericDataSourceException

      SQL Exception while executing the following:SELECT ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield (Invalid column name 'CUSTOMFIELDTYPEKEY'.)

      at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery()
    2. org.ofbiz.core
      GenericDelegator.findAll
      1. org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:336)
      2. org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050)
      3. org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
      4. org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
      5. org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
      6. org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
      7. org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696)
      7 frames
    3. com.atlassian.jira
      DefaultCustomFieldManager.<init>
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:113)
      2. com.atlassian.jira.issue.managers.DefaultCustomFieldManager.getCustomFieldsFromDB(DefaultCustomFieldManager.java:270)
      3. com.atlassian.jira.issue.managers.DefaultCustomFieldManager.populateCache(DefaultCustomFieldManager.java:323)
      4. com.atlassian.jira.issue.managers.DefaultCustomFieldManager.<init>(DefaultCustomFieldManager.java:78)
      4 frames
    4. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:274)
      4 frames
    5. org.picocontainer.defaults
      DecoratingComponentAdapter.getComponentInstance
      1. org.picocontainer.defaults.InstantiatingComponentAdapter.newInstance(InstantiatingComponentAdapter.java:100)
      2. org.picocontainer.defaults.ConstructorInjectionComponentAdapter.instantiateComponent(ConstructorInjectionComponentAdapter.java:200)
      3. org.picocontainer.defaults.InstantiatingComponentAdapter.getComponentInstance(InstantiatingComponentAdapter.java:48)
      4. org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42)
      5. org.picocontainer.defaults.SynchronizedComponentAdapter.getComponentInstance(SynchronizedComponentAdapter.java:35)
      6. org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42)
      6 frames
    6. com.atlassian.jira
      ProfilingComponentAdapter.getComponentInstance
      1. com.atlassian.jira.config.component.ProfilingComponentAdapter.getComponentInstance(ProfilingComponentAdapter.java:27)
      1 frame
    7. org.picocontainer.defaults
      DefaultPicoContainer.getComponentInstanceOfType
      1. org.picocontainer.defaults.DefaultPicoContainer.getComponentInstanceOfType(DefaultPicoContainer.java:306)
      1 frame
    8. com.atlassian.jira
      DefaultFieldLayoutManager.<init>
      1. com.atlassian.jira.ManagerFactory.getCustomFieldManager(ManagerFactory.java:194)
      2. com.atlassian.jira.issue.fields.DefaultFieldManager.getCustomFieldManager(DefaultFieldManager.java:766)
      3. com.atlassian.jira.issue.fields.DefaultFieldManager.isCustomField(DefaultFieldManager.java:564)
      4. com.atlassian.jira.issue.fields.DefaultFieldManager.getOrderableField(DefaultFieldManager.java:654)
      5. com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.<init>(DefaultFieldLayoutManager.java:50)
      5 frames
    9. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:274)
      4 frames
    10. org.picocontainer.defaults
      DecoratingComponentAdapter.getComponentInstance
      1. org.picocontainer.defaults.InstantiatingComponentAdapter.newInstance(InstantiatingComponentAdapter.java:100)
      2. org.picocontainer.defaults.ConstructorInjectionComponentAdapter.instantiateComponent(ConstructorInjectionComponentAdapter.java:200)
      3. org.picocontainer.defaults.InstantiatingComponentAdapter.getComponentInstance(InstantiatingComponentAdapter.java:48)
      4. org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42)
      5. org.picocontainer.defaults.SynchronizedComponentAdapter.getComponentInstance(SynchronizedComponentAdapter.java:35)
      6. org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:42)
      6 frames
    11. com.atlassian.jira
      ProfilingComponentAdapter.getComponentInstance
      1. com.atlassian.jira.config.component.ProfilingComponentAdapter.getComponentInstance(ProfilingComponentAdapter.java:27)
      1 frame
    12. org.picocontainer.defaults
      DefaultPicoContainer.getComponentInstance
      1. org.picocontainer.defaults.DefaultPicoContainer.getComponentInstance(DefaultPicoContainer.java:298)
      1 frame
    13. com.atlassian.jira
      LicenseComponentAdaptor.getComponentInstance
      1. com.atlassian.jira.config.component.LicenseComponentAdaptor.loadComponent(LicenseComponentAdaptor.java:128)
      2. com.atlassian.jira.config.component.LicenseComponentAdaptor.getComponentInstance(LicenseComponentAdaptor.java:105)
      2 frames
    14. org.picocontainer.defaults
      DefaultPicoContainer.getComponentInstances
      1. org.picocontainer.defaults.DefaultPicoContainer.getComponentInstancesOfType(DefaultPicoContainer.java:274)
      2. org.picocontainer.defaults.DefaultPicoContainer.getComponentInstances(DefaultPicoContainer.java:266)
      2 frames
    15. com.atlassian.jira
      ConsistencyLauncher.contextInitialized
      1. com.atlassian.jira.ComponentManager.eagerlyInstantiate(ComponentManager.java:296)
      2. com.atlassian.jira.ComponentManager.start(ComponentManager.java:211)
      3. com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:25)
      3 frames
    16. Glassfish Core
      Catalina.process
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3271)
      2. org.apache.catalina.core.StandardContext.start(StandardContext.java:3613)
      3. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
      4. org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
      5. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
      6. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
      7. org.apache.catalina.core.StandardService.start(StandardService.java:497)
      8. org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
      9. org.apache.catalina.startup.Catalina.start(Catalina.java:512)
      10. org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
      11. org.apache.catalina.startup.Catalina.process(Catalina.java:180)
      11 frames
    17. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    18. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
      1 frame