[
http://jira.nuxeo.org/browse/NXP-4094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=60608#action_60608
]
Radu Darlea commented on NXP-4094:
----------------------------------
There are several problems involved.
1. The Boolean type is not supported by the Oracle server. On H2 and PostgreSQL
it is supported though. As result, NXP_TAGGING table can't be created:
isPrivate field is boolean. As fix, the field can be redefined as integer. The
field is made NUMERIC(10,0) in the table. I tried to set a different precision
at column creation but the type definition was returned the same by
dialect.getTypeName(sqlType, length, precision, scale);
2. The Tag schema is used in JPA queries, and the same problem happens for the
field private1: it is declared as xs:boolean. Although the column is created as
NUMERIC(1,0), the queries are made using the boolean values. Again this is
working on H2 and PostgreSQL, but on Oracle it fails to precompile the queries.
Also changed it to xs:integer.
3. The joins are made on fields within the tables. The joins fail because
Oracle can't join on CLOB. The NXP_TAGGING needs to hold varchar instead CLOB.
> Make tag service works with Oracle configuration
> ------------------------------------------------
>
> Key: NXP-4094
> URL: http://jira.nuxeo.org/browse/NXP-4094
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Affects Versions: 5.2 GA
> Reporter: Radu Darlea
> Assignee: Radu Darlea
> Fix For: 5.3
>
>
> The tag service configured with XA fails to create the tables for Oracle. The
> used configuration is:
> <?xml version="1.0"?>
> <datasources>
> <xa-datasource>
> <jndi-name>nxtags</jndi-name>
>
> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
> <xa-datasource-property
> name="URL">jdbc:oracle:thin:@localhost:1521:XE</xa-datasource-property>
> <xa-datasource-property name="User">nuxeo</xa-datasource-property>
> <xa-datasource-property name="Password">nuxeo</xa-datasource-property>
> <track-connection-by-tx/>
> </xa-datasource>
> </datasources>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://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
