Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
5.2.7, 6.1.3, 6.4.7, 7.0.2, 7.1.2
-
Database: Oracle
-
5.02
-
32
-
Severity 3 - Minor
-
2
-
Description
Summary
Due to the fix in JRA-12304, on every JIRA startup the database displays additional INFO logging about a change in the database columns. This seems unnecessary to appear on every startup.
Steps to Reproduce
Use a non-4-byte character set for your Oracle database.
Expected Results
JIRA starts up without core.entity.jdbc.DatabaseUtil outputting information about the DB being changed on every startup.
Actual Results
On every startup the following is written to the logs:
2014-01-10 17:58:24,760 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Product Name is Oracle 2014-01-10 17:58:24,760 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Product Version is Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning option 2014-01-10 17:58:24,760 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Driver Name is Oracle JDBC driver 2014-01-10 17:58:24,761 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Driver Version is 11.2.0.2.0 2014-01-10 17:58:25,917 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Column "AUTHOR" of type "VARCHAR2" of table "jiraaction" of entity "Action" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR). 2014-01-10 17:58:26,224 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Column "ACTIONTYPE" of type "VARCHAR2" of table "jiraaction" of entity "Action" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR). 2014-01-10 17:58:26,243 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Column "ACTIONLEVEL" of type "VARCHAR2" of table "jiraaction" of entity "Action" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR). 2014-01-10 17:58:26,261 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Column "UPDATEAUTHOR" of type "VARCHAR2" of table "jiraaction" of entity "Action" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR). 2014-01-10 17:58:26,281 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Column "APPLICATION_NAME" of type "VARCHAR2" of table "cwd_application" of entity "Application" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR). 2014-01-10 17:58:26,300 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Column "LOWER_APPLICATION_NAME" of type "VARCHAR2" of table "cwd_application" of entity "Application" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
Workaround
Always use the recommended encoding of AL32UTF8 when using Oracle.
Attachments
Issue Links
- is caused by
-
JRASERVER-12304 Oracle DB Text Columns Exceed 255 Character Limit on Import
- Closed
- mentioned in
-
Page Loading...