[
https://jira.nuxeo.org/browse/NXP-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-3993:
-----------------------------------
Upgrade notes:
- String fields are now by default mapped to a VARCHAR type. You can ALTER
TABLE your old database to turn CLOBs into VARCHARs if needed.
- To have a string field (ex: my:field) mapped to a CLOB, you must give it
type="largetext" in the repository config extension point
(org.nuxeo.ecm.core.repository.RepositoryService):
<component name="...">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"
factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository>
<schema>
<field type="largetext">note</field>
<field type="largetext">my:field</field>
...
</schema>
...
</repository>
</repository>
</extension>
</component>
was:
- String fields are now by default mapped to a VARCHAR type. You can ALTER
TABLE your old database to turn CLOBs into VARCHARs if needed.
- To have a string field (ex: my:field) mapped to a CLOB, you must give it
type="largetext" in the repository config extension point
(org.nuxeo.ecm.core.repository.RepositoryService):
<component name="...">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"
factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository>
<schema>
<field type="largetext">note:note</field>
<field type="largetext">my:field</field>
...
</schema>
...
</repository>
</repository>
</extension>
</component>
> Avoid 2000 characters limit for some fields
> --------------------------------------------
>
> Key: NXP-3993
> URL: https://jira.nuxeo.org/browse/NXP-3993
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.2 GA
> Reporter: Delphine Renevey
> Assignee: Florent Guillaume
> Priority: Blocker
> Fix For: 5.3 RC
>
>
> In some cases the Oracle server fails to set values for some textual fields
> because the value uploaded is too large. The DB text columns are set to
> NCHARVAR2(2000), value apparently exceeded by the fields values. The limit of
> 2000 is intrinsic to Oracle NVARCHAR2, beyond that a NCLOB must be used.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
