August 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-751) SDO_WITHIN_DISTANCE function of Oracle Spatial Connector is pushing string literal to data source

by Larry O'Leary (JIRA)

SDO_WITHIN_DISTANCE function of Oracle Spatial Connector is pushing string literal to data source ------------------------------------------------------------------------------------------------- Key: TEIID-751 URL: https://jira.jboss.org/jira/browse/TEIID-751 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 6.1.0, 6.0.0 Reporter: Larry O'Leary Assignee: Larry O'Leary Priority: Minor Fix For: 6.2.0 Executing a query which uses the SDO_WITHIN_DISTANCE function in criteria results in an invalid query being sent to Oracle. Query: SELECT RECORD_ID FROM OraSpatialSrcTable WHERE sdo_within_distance(MARKER, '(SDO_GEOMETRY(2001, 8307, MDSYS.SDO_POINT_TYPE(90.0, -45.0, NULL), NULL, NULL))', "DISTANCE=25.0 UNIT=NAUT_MILE") = 'TRUE' Results In Exception: ERROR <com.metamatrix.core|0> [MetaMatrix][Oracle JDBC Driver][Oracle]ORA-29900: operator binding does not exist ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_WITHIN_DISTANCE' Executing statement: SELECT ORASPATIALSRCTABLE.RECORD_ID FROM ORASPATIALSRCTABLE WHERE SDO_WITHIN_DISTANCE(ORASPATIALSRCTABLE.MARKER, '(SDO_GEOMETRY(2001, 8307, MDSYS.SDO_POINT_TYPE(90.0, -45.0, NULL), NULL, NULL))', 'DISTANCE=25.0 UNIT=NAUT_MILE') = TRUE java.sql.SQLException: [MetaMatrix][Oracle JDBC Driver][Oracle]ORA-29900: operator binding does not exist ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_WITHIN_DISTANCE' at com.metamatrix.common.util.exception.SQLExceptionUnroller.unRollException(SQLExceptionUnroller.java:43) at com.metamatrix.connector.jdbc.JDBCBaseExecution.createError(JDBCBaseExecution.java:147) at com.metamatrix.connector.jdbc.JDBCBaseExecution.createAndLogError(JDBCBaseExecution.java:103) at com.metamatrix.connector.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:89) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.processNewRequest(ConnectorWorker.java:274) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.processBatchRequest(ConnectorWorker.java:165) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:139) at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:51) The exception is due to the second parameter of SDO_WITHIN_DISTANCE being escaped as a string. The expected query should be: SELECT ORASPATIALSRCTABLE.RECORD_ID FROM ORASPATIALSRCTABLE WHERE SDO_WITHIN_DISTANCE(ORASPATIALSRCTABLE.MARKER, (SDO_GEOMETRY(2001, 8307, MDSYS.SDO_POINT_TYPE(90.0, -45.0, NULL), NULL, NULL)), 'DISTANCE=25.0 UNIT=NAUT_MILE') = TRUE In the above query the first parameter was an element of type String. If the first parameter was of type Object, the function is rewritten correctly. This appears to be primarily due to the function signatures of sdo_within_distance and the query rewriter performing an implicit convert on the second parameter to make it match the function signature of String, Object, String rather than Object, String, String. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-1104) Teiid engine will be clusterable.

by Van Halbert (JIRA)

Teiid engine will be clusterable. --------------------------------- Key: TEIID-1104 URL: https://jira.jboss.org/browse/TEIID-1104 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Van Halbert Assignee: Steve Hawkins The Teiid engine must support the ability to be clustered. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

4
10
0 / 0

[JBoss JIRA] Created: (TEIID-1008) Correlated subquery handling for Oracle/MySQL

by Steven Hawkins (JIRA)

Correlated subquery handling for Oracle/MySQL --------------------------------------------- Key: TEIID-1008 URL: https://jira.jboss.org/jira/browse/TEIID-1008 Project: Teiid Issue Type: Quality Risk Components: Connector API, Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1 Most version of Oracle and MySQL only support one level of nesting for correlated reference appearing in non-inlineview subqueries. These queries are perfectly legal in Teiid and sources such as PostgreSQL. To work around we'll need to add a new capability and planner logic to prevent pushdown. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1148) Require the use of CXF

by Steve Hawkins (JIRA)

Require the use of CXF ---------------------- Key: TEIID-1148 URL: https://jira.jboss.org/browse/TEIID-1148 Project: Teiid Issue Type: Sub-task Components: XML Connector Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1 Given the current direction of the JBoss WS project and that the other SOA projects do not have a specific implementation target, we can require the use of CXF. There are some additional installation steps needed that will be added to the admin guide / release notes. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

3
11
0 / 0

[JBoss JIRA] Created: (TEIID-1215) Add a performance tuning chapter to the admin guide

by Steve Hawkins (JIRA)

Add a performance tuning chapter to the admin guide --------------------------------------------------- Key: TEIID-1215 URL: https://jira.jboss.org/browse/TEIID-1215 Project: Teiid Issue Type: Feature Request Components: Documentation Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 The admin guide should have a performance chapter especially to cover buffer manager configuration. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1103) Add ability to disable hostname verification on the server side for SSL connections

by Marc Shirley (JIRA)

Add ability to disable hostname verification on the server side for SSL connections ----------------------------------------------------------------------------------- Key: TEIID-1103 URL: https://jira.jboss.org/browse/TEIID-1103 Project: Teiid Issue Type: Feature Request Reporter: Marc Shirley Assignee: Steve Hawkins Should include the ability to disable hostname verification for SSL connections. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

3
11
0 / 0

[JBoss JIRA] Created: (TEIID-1231) Model visibility should only refer to whether entries are in metadata

by Steve Hawkins (JIRA)

Model visibility should only refer to whether entries are in metadata --------------------------------------------------------------------- Key: TEIID-1231 URL: https://jira.jboss.org/browse/TEIID-1231 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.1.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 Visibility should only apply to whether a table/model shows up in the system tables and should have nothing to do with whether it can be accessed. If a designer user wants to make a model non-accessable with the ease of the visibility mechansim, then they should create a data role ("default") that does not have permissions for model. Our roles would then need a boolean attribute (any-authenticated) to denote that any authenticated user has the role. Designer/JOPR will also need to add support for the "any-authenticated" attribute. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1195) Error message that a VDB was deployed in "deployed in inactive state" is insufficient for users to easily correct problem

by Paul Nittel (JIRA)

Error message that a VDB was deployed in "deployed in inactive state" is insufficient for users to easily correct problem ------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1195 URL: https://jira.jboss.org/browse/TEIID-1195 Project: Teiid Issue Type: Bug Affects Versions: 7.1 Environment: All Reporter: Paul Nittel Assignee: Steve Hawkins Attachments: server.log.zip Admittedly this stems from another bug (where VDBs with even a warning are not deployed), but the lack of details surrounding the decision to deploy in an inactive state causes confusion. Even though my logging is set to DEBUG, the server log contains no details as to why the VDB was not made active. Please see the attached log file. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

4
6
0 / 0

[JBoss JIRA] Created: (TEIID-1171) Add support for the with clause

by Steve Hawkins (JIRA)

Add support for the with clause ------------------------------- Key: TEIID-1171 URL: https://jira.jboss.org/browse/TEIID-1171 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.2 The with clause would be a useful feature to take advantage of common sub expressions. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1106) Create the ModeShape connector to be used with the ModeShape jdbc driver to access the ModeShape JCR repository

by Van Halbert (JIRA)

Create the ModeShape connector to be used with the ModeShape jdbc driver to access the ModeShape JCR repository --------------------------------------------------------------------------------------------------------------- Key: TEIID-1106 URL: https://jira.jboss.org/browse/TEIID-1106 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Reporter: Van Halbert Assignee: Van Halbert -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

4
10
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2010