Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-23857

JIRA can't connect to Oracle due to the 'Locale not recognized' error

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Won't Do
    • None
    • None
    • oracle-jdbc15-11.2.0.1.0.jar
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Users connecting Oracle to JIRA running with similar locale information:

           user.country                                  : IR
     user.language                                 : fa

      Will see the following error in they log file which prevents the application from starting up correctly.

      2011-02-15 20:46:46,765 Thread-1 ERROR      [jira.appconsistency.db.DatabaseConsistencyCheck] There was a SQL exception checking for database driver correctness. Skipping.
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Locale not recognized)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:212)

      A possible work around this issue is to specify in JAVA_OPTS -Dfile.encoding=UTF8 -Duser.language=en -Duser.region=US -Duser.country=US or any other JDBC supported locale.

      Some more context into this problem can be found at:
      http://forums.oracle.com/forums/thread.jspa?messageID=1686281

      Attachments

        Issue Links

          relates to

          Suggestion - JRACLOUD-23857 JIRA can't connect to Oracle due to the 'Locale not recognized' error

          • Closed

          Activity

            People

              Unassigned Unassigned
              bdziedzic Bogdan Dziedzic [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: