org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration])

Atlassian JIRA | Tim Colson (yahoo) | 1 decade ago
  1. 0

    Just tried installing JIRA 2.6.1 Enterprise -- installed ok, but after creating a project, creating a bug in that project, and finally trying to add that project to my dashboard -- it seems to have melted down. :-( Now I cannot even log into JIRA. Upon startup, I found this trace in the tomcat stdout.log which I realize uses "POSITION" as a fieldname -- something which is VERBOTEN in HSQLDB 1.7.2RC5 and above. POSITION is a reserved token in SQL apparently. FYI -- it can still be used if the field is fully qualified with the tablename, ex.PORTLETCONFIGURATION.POSITION, but it would be better to change the fieldname. I use the name "ORDINAL" -- Check webster.com for the def'n: "1 : a number designating the place (as first, second, or third) occupied by an item in an ordered sequence" In the meantime -- is there a way I can workaround this? Cheers, Timo 2004-04-28 08:00:59,829 ERROR [jira.action.admin.DataExport] Error exporting: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration]) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration]) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:295) 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:705) at com.atlassian.jira.action.admin.DataExport.execute(DataExport.java:58) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34) at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:90) at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:51) at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50) at org.quartz.core.JobRunShell.run(JobRunShell.java:147) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387) java.sql.SQLException: Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:226) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:328) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:290) 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:705) at com.atlassian.jira.action.admin.DataExport.execute(DataExport.java:58) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34) at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:90) at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:51) at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50) at org.quartz.core.JobRunShell.run(JobRunShell.java:147) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387) 2004-04-28 08:00:59,869 WARN [service.services.export.ExportService] Exception running export service Error in action: com.atlassian.jira.action.admin.DataExport@a0560e, result: error Error exporting: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration]) com.atlassian.core.AtlassianCoreException: Error in action: com.atlassian.jira.action.admin.DataExport@a0560e, result: error Error exporting: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration]) at com.atlassian.core.action.ActionUtils.checkForErrors(ActionUtils.java:53) at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:91) at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:51) at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50) at org.quartz.core.JobRunShell.run(JobRunShell.java:147) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)

    Atlassian JIRA | 1 decade ago | Tim Colson (yahoo)
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration])
  2. 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')
  3. 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
  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, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration])

      at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement()
    2. org.ofbiz.core
      GenericDelegator.findAll
      1. org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:295)
      2. org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
      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:705)
      7 frames
    3. com.atlassian.jira
      DataExport.execute
      1. com.atlassian.jira.action.admin.DataExport.execute(DataExport.java:58)
      1 frame
    4. webwork.dispatcher
      GenericDispatcher.executeAction
      1. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131)
      1 frame
    5. com.atlassian.core
      DefaultActionDispatcher.execute
      1. com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
      1 frame
    6. com.atlassian.jira
      ServiceRunner.execute
      1. com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:90)
      2. com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:51)
      3. com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
      3 frames
    7. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:147)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)
      2 frames