Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-23857

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

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Won't Do
    • None
    • oracle-jdbc15-11.2.0.1.0.jar

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? 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

          is related to

          Suggestion - JRASERVER-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:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: