Invalid type Oracle11g on JIRA startup

[Deleted user]

When running JIRA 6.3.12 + Oracle11g XE + ojdbc6-11.2.0.2.0.jar it can't create Quartz-related tables: 

CREATE TABLE JQUARTZ_BLOB_TRIGGERS (SCHED_NAME VARCHAR(120), TRIGGER_NAME VARCHAR(200) NOT NULL, TRIGGER_GROUP VARCHAR(200) NOT NULL, BLOB_DATA BYTEA, CONSTRAINT PK_JQUARTZ_BLOB_TRIGGERS PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP))

Error was: java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype

First I had the same error with Postgres which was fixed by editing fieldtype file, so I've done the same fix but it didn't help:     

<field-type-def type="quartz-char-8" sql-type="VARCHAR(8)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-16" sql-type="VARCHAR(16)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-40" sql-type="VARCHAR(40)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-80" sql-type="VARCHAR(80)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-95" sql-type="VARCHAR(95)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-120" sql-type="VARCHAR(120)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-200" sql-type="VARCHAR(200)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-250" sql-type="VARCHAR(250)" java-type="String"></field-type-def>
<field-type-def type="quartz-char-512" sql-type="VARCHAR(512)" java-type="String"></field-type-def>
<field-type-def type="quartz-boolean" sql-type="BOOL" java-type="Boolean"></field-type-def>
<field-type-def type="quartz-data" sql-type="BYTEA" java-type="java.lang.Object"></field-type-def>
<field-type-def type="quartz-long-int" sql-type="NUMERIC(18,0)" java-type="Long"></field-type-def>
<field-type-def type="quartz-int" sql-type="NUMERIC(9,0)" java-type="Integer"></field-type-def>
<field-type-def type="quartz-small-int" sql-type="NUMERIC(4,0)" java-type="Integer"></field-type-def>
<field-type-def type="quartz-numeric" sql-type="NUMERIC(13,4)" java-type="Long"></field-type-def>

My dbconfig.xml:

<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>oracle10g</database-type>
  <jdbc-datasource>
    <url>jdbc:oracle:thin:@localhost:1521:xe</url>
    <driver-class>oracle.jdbc.OracleDriver</driver-class>
    <username>system</username>
    <password>oracle</password>

    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
  </jdbc-datasource>
</jira-database-config>

[Rodrigo Girardi Adami]

That's odd. This is not a common error for sure. 

I was able to find this JIRA KB related to this error, but not exactly the same symptom. Check here.

I also recommend to use the Oracle standard or Enterprise database, not the XE due to many limitations it have. Is not supported for production environments.

Cheers,

Rodrigo