Jump to content
We've recently updated our Privacy Statement, available here ×
  • BLOB and CLOB data types in Domain export


    stasp

    Issue:

    Consider the following scenario: - you create a Domain using the Domain designer using data from your database - then you export the Domain schema file to create new Domains using this file - when trying to create a new domain and import the file you just exported, the process fails with the following messages:

    [toc]
    The XML validation failed. Look for errors in the box below.
    cvc-complex-type.4: Attribute 'type' must appear on element 'field'.
    Line:295, Col:39
    cvc-complex-type.4: Attribute 'type' must appear on element 'field'.
    Line:307, Col:39
    cvc-complex-type.4: Attribute 'type' must appear on element 'field'.
    Line:353, Col:39
    ...


    Cause:

    This happens when database has BLOB or CLOB columns, which cause the problem.

    These data types are not valid for Domain schema, and these fields are getting exported without a 'type' attribute by default.


    Resolution:

    The BLOB and CLOB column types are by default not mapped to any data type in JasperReports Server configuration.

    To workaround the problem for BLOB type do the following (same steps apply for CLOB type):

    1. find <js-install>/WEB-INF/applicationContext-semanticLayer.xml file
    2. open the file and find the following property of jdbcMetaConfiguration bean:
    3. uncomment the line set the value to java.lang.String
    4. save the file and restart the server
    5. check if the problem with missing type is still there

    Ref. Case #00024434 -- 11:42, 6 March 2012 (UTC)  

     


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...