Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38489

Table SAKAI_MESSAGE_BUNDLE is not created in Oracle

    XMLWordPrintable

    Details

    • Previous Issue Keys:
      KNL-1394

      Description

      This error is raised when Hibernate try to create SAKAI_MESSAGE_BUNDLE table:

      2015-11-18 03:12:19,362 WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create table SAKAI_MESSAGE_BUNDLE (ID number(19,0) not null, BASENAME varchar2(255 char), MODULE_NAME varchar2(255 char), LOCALE varchar2(255 char), PROP_NAME varchar2(255 char), DEFAULT_VALUE long, PROP_VALUE long, primary key (ID))
      java.sql.SQLSyntaxErrorException: ORA-01754: a table may contain only one column of type LONG

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)

      This is a problem because of the hbm file declares to columns as text type, and hibernate use Long in Oracle instead of Clob. Looking at this thread and doc:

      http://stackoverflow.com/questions/3719905/why-has-hibernate-switched-to-use-long-over-clob/3721717

      https://developer.jboss.org/wiki/HibernateCoreMigrationGuide35

      We must to change the type to "materialized_clob".

      Bye.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  k1team KERNEL TEAM (Inactive)
                  Reporter:
                  jjmerono@um.es Juan José Meroño Sánchez
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code