com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Access denied for user (using password: YES)

atlassian.com | 4 months ago
  1. 0

    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'jiradbuser'@'localhost' (using password: YES)) - Atlassian Answers

    atlassian.com | 4 months ago
    com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Access denied for user (using password: YES)
  2. 0

    Could not determine database type - Atlassian Answers

    atlassian.com | 11 months ago
    com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Login failed for user 'ABNOLOGY\SVC_Jira'.
  3. 0

    {noformat} 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Converting search requests to use the new labels system field is 100% complete. 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating saved filters to use the new labels system field...DONE 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating label gadgets use the new labels system field... 2010-05-04 01:49:24,717 main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception whi le executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have a n error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:188) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:175) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.updateGadgetConfigurations(UpgradeTask_Build552.java:190) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.doUpgrade(UpgradeTask_Build552.java:151) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:562) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:466) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:402) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:353) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:292) at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100) at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) 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:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpref erence WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right s yntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:596) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1076) at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:919) at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:162) at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:960) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:183) ... 25 more {noformat}

    Atlassian JIRA | 7 years ago | George Barnett
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Installing JIRA on Tomcat 6.0 or 7.0 - Atlassian Documentation

    atlassian.com | 11 months ago
    com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Unexpected exception encountered during query.

    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. com.atlassian.jira.exception.DataAccessException

      java.sql.SQLException: Access denied for user (using password: YES)

      at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists()
    2. com.atlassian.jira
      DefaultJiraLauncher.start
      1. com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:129)
      2. com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.databaseSetup(MinimumUpgradableVersionCheck.java:49)
      3. com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.isOk(MinimumUpgradableVersionCheck.java:30)
      4. com.atlassian.jira.startup.JiraDatabaseConfigChecklist.doStartupChecks(JiraDatabaseConfigChecklist.java:64)
      5. com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:52)
      6. com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:39)
      7. com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:110)
      8. com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:315)
      9. com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:215)
      10. com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:105)
      11. com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:30)
      12. com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:77)
      13. com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
      14. com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:72)
      14 frames