[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread Alex O'Ree (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176710#comment-17176710
 ] 

Alex O'Ree commented on JUDDI-1015:
---

pretty sure this is fixed. i'll leave it open for a few more days to hear back 
from the folks on the mailing list that reporting this. it can always be 
reopened after the release is cut

> 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.9
>
>
> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176687#comment-17176687
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 4d7bc5a3bf37e7d5341286432c129f8fb1a4b203 in juddi's branch 
refs/heads/master from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=4d7bc5a ]

JUDDI-1015 reduces sql identifiers for better support for both mssql and for 
oracledb.
JUDDI-1101 related. also resolves sql query issues for discoery url due to 
varchar to clob change


> 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.9
>
>
> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176686#comment-17176686
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 7a26bedd92cff633d641118d19b5237ac8474105 in juddi's branch 
refs/heads/master from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=7a26bed ]

Merge branch 'master' into bug/JUDDI-1015


> 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.9
>
>
> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176683#comment-17176683
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit c6e69a48bfe61dde00a8ff8873bb8f946e06e4ea in juddi's branch 
refs/heads/master from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=c6e69a4 ]

JUDDI-1015 adds oracle and mssql drivers to the mix along with an example for 
oracle db


> 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.9
>
>
> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176685#comment-17176685
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 93f2d3693cff16e52129171368d36b2580fc in juddi's branch 
refs/heads/master from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=93f2d36 ]

Merge branch 'master' into bug/JUDDI-1015


> 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.9
>
>
> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176682#comment-17176682
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 7d562f926b974d46b5e0f9e76d774a10ff9dc889 in juddi's branch 
refs/heads/master from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=7d562f9 ]

JUDDI-1015 incomplete fix for certain columns being too long on specific 
database vendors (oracle in this case). this has some test failures and query 
issues due to the column type changes.


> 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.9
>
>
> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176674#comment-17176674
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 4d7bc5a3bf37e7d5341286432c129f8fb1a4b203 in juddi's branch 
refs/heads/bug/JUDDI-1015 from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=4d7bc5a ]

JUDDI-1015 reduces sql identifiers for better support for both mssql and for 
oracledb.
JUDDI-1101 related. also resolves sql query issues for discoery url due to 
varchar to clob change


> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-08-12 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17176673#comment-17176673
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 7a26bedd92cff633d641118d19b5237ac8474105 in juddi's branch 
refs/heads/bug/JUDDI-1015 from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=7a26bed ]

Merge branch 'master' into bug/JUDDI-1015


> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-07-16 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17159606#comment-17159606
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 93f2d3693cff16e52129171368d36b2580fc in juddi's branch 
refs/heads/bug/JUDDI-1015 from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=93f2d36 ]

Merge branch 'master' into bug/JUDDI-1015


> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-07-16 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17159605#comment-17159605
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit c6e69a48bfe61dde00a8ff8873bb8f946e06e4ea in juddi's branch 
refs/heads/bug/JUDDI-1015 from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=c6e69a4 ]

JUDDI-1015 adds oracle and mssql drivers to the mix along with an example for 
oracle db


> 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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-07-10 Thread Alex O'Ree (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)

[jira] [Commented] (JUDDI-1015) Oracle database start up issue due to max string length

2020-07-10 Thread ASF subversion and git services (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17155812#comment-17155812
 ] 

ASF subversion and git services commented on JUDDI-1015:


Commit 7d562f926b974d46b5e0f9e76d774a10ff9dc889 in juddi's branch 
refs/heads/bug/JUDDI-1015 from Alex O'Ree
[ https://gitbox.apache.org/repos/asf?p=juddi.git;h=7d562f9 ]

JUDDI-1015 incomplete fix for certain columns being too long on specific 
database vendors (oracle in this case). this has some test failures and query 
issues due to the column type changes.


> 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)