[
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17155813#comment-17155813
]
Alex O'Ree commented on JUDDI-1015:
-----------------------------------
[~kurtstam] may need your help with this one. After changing the columns, looks
like find business based on discovery url barfs with the following:
ERROR: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
Jul 10, 2020 9:17:44 PM org.apache.juddi.v3.tck.TckFindEntity findBusiness
SEVERE: org.hibernate.exception.SQLGrammarException: could not prepare statement
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not prepare statement
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:492)
at org.apache.juddi.query.EntityQuery.getQueryResult(EntityQuery.java:163)
at
org.apache.juddi.query.FindBusinessByDiscoveryURLQuery.select(FindBusinessByDiscoveryURLQuery.java:75)
at org.apache.juddi.api.impl.InquiryHelper.findBusiness(InquiryHelper.java:206)
at
org.apache.juddi.api.impl.UDDIInquiryImpl.findBusiness(UDDIInquiryImpl.java:211)
at org.apache.juddi.v3.tck.TckFindEntity.findBusiness(TckFindEntity.java:89)
at
org.apache.juddi.api.impl.API_070_FindEntityTest.findEntities(API_070_FindEntityTest.java:96)
I'm not super sure how to apply this type of cast using the current query
mechanisms that we have. Any ideas?
> Oracle database start up issue due to max string length
> -------------------------------------------------------
>
> Key: JUDDI-1015
> URL: https://issues.apache.org/jira/browse/JUDDI-1015
> Project: jUDDI
> Issue Type: Bug
> Reporter: Alex O'Ree
> Assignee: Alex O'Ree
> Priority: Major
> Fix For: 3.3.8
>
>
> from the juddi mailing list
>
> {color:#172b4d}Oracle Version of Juddi Due to string limit for a column
> CREATE TABLE j3_binding_template (entity_key VARCHAR2(255) NOT NULL,
> access_point_type VARCHAR2(255), access_point_url VARCHAR2(4096),
> hosting_redirector VARCHAR2(255), service_key VARCHAR2(255) NOT NULL, PRIMARY
> KEY (entity_key)) {color}*Oracle max varchar limit: 4000*
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
