[JBoss JIRA] (TEIID-3968) OData 4 array type handling
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3968:
-------------------------------------
Summary: OData 4 array type handling
Key: TEIID-3968
URL: https://issues.jboss.org/browse/TEIID-3968
Project: Teiid
Issue Type: Bug
Components: OData
Reporter: Steven Hawkins
Assignee: Steven Hawkins
To ensure we are appropriate returning the correct error messages, creating the right upstream changes, etc. we have several paths to validate wrt array handling. There are:
In the translator - ODataProcedureExecution.getQueryParameters, ODataFilterVisitor.visit(Function) and ODataFilterVisitor.visit(ColumnReference), ODataExpressionToSQLVisitor.visitAlias, ODataUpdateVisitor.visit(Update)
In the OData service - ODataExpressionToSQLVisitor.visit(Alias)
>From the spec it appears that a uri should be able to specify arrays, but olingo and other frameworks may have limitations. For example it should be possible to have an array argument to a function, but the olingo framework will complain that arrays are not allowed in the resource part of the uri.
At the very least we'll capture what won't work with this issue.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Durgadatta Sahu (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Durgadatta Sahu commented on TEIID-3959:
----------------------------------------
Yes , got it. Thanks a lot. Now it is working fine.
Thanks,
Durga
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
> Attachments: UDFVDB.vdb, UDFVDB.vdb
>
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3959:
---------------------------------------
The vdb has a root folder that is not expected, however we are still picking up the vdb.xml and still proceeding with deployment. We'll need to either allow the root folder generally or provide a better error message in this case.
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
> Attachments: UDFVDB.vdb, UDFVDB.vdb
>
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3958) NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIID-3958?page=com.atlassian.jira.plugin... ]
Marc Shirley updated TEIID-3958:
--------------------------------
Attachment: testStream.vdb
> NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
> ----------------------------------------------------------------------------------------------
>
> Key: TEIID-3958
> URL: https://issues.jboss.org/browse/TEIID-3958
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1, 8.7.1.6_2
> Environment: Migrated web services model from EDS 5.3.1 that does not include 'stream' parameter in the invokeHttp() procedure
> DV 6.1 - translator-ws-8.7.1.redhat-8.jar
> DV 6.2 - translator-ws-8.7.1.6_2-redhat-6.jar
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Attachments: testStream.vdb
>
>
> Appears to still be an issue similar to TEIID 2537. Executing against the invokeHttp() procedure generated by JBDS 5 for Teiid Designer 7.7.3 without a stream parameter results in a slightly different stack trace, but appears to be the same issue.
> 2016-01-21 12:53:50,297 ERROR \[org.teiid.PROCESSOR\] (Worker22_QueryProcessorQueue117472) TEIID30019 Unexpected exception for request FzkQneotrSUs.5: java.lang.NullPointerException
> at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:174)
> at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:207) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3958) NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIID-3958?page=com.atlassian.jira.plugin... ]
Marc Shirley commented on TEIID-3958:
-------------------------------------
I have a VDB (ie, the affected model), but not currently a datasource and query to test with. I'll attach the VDB and try to get the other parts later today.
> NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
> ----------------------------------------------------------------------------------------------
>
> Key: TEIID-3958
> URL: https://issues.jboss.org/browse/TEIID-3958
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1, 8.7.1.6_2
> Environment: Migrated web services model from EDS 5.3.1 that does not include 'stream' parameter in the invokeHttp() procedure
> DV 6.1 - translator-ws-8.7.1.redhat-8.jar
> DV 6.2 - translator-ws-8.7.1.6_2-redhat-6.jar
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
>
> Appears to still be an issue similar to TEIID 2537. Executing against the invokeHttp() procedure generated by JBDS 5 for Teiid Designer 7.7.3 without a stream parameter results in a slightly different stack trace, but appears to be the same issue.
> 2016-01-21 12:53:50,297 ERROR \[org.teiid.PROCESSOR\] (Worker22_QueryProcessorQueue117472) TEIID30019 Unexpected exception for request FzkQneotrSUs.5: java.lang.NullPointerException
> at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:174)
> at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:207) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Durgadatta Sahu (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Durgadatta Sahu updated TEIID-3959:
-----------------------------------
Attachment: UDFVDB.vdb
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
> Attachments: UDFVDB.vdb, UDFVDB.vdb
>
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Durgadatta Sahu (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Durgadatta Sahu updated TEIID-3959:
-----------------------------------
Attachment: UDFVDB.vdb
Here I have attached test vdb file that I am trying to deploy. I am using teiid-8.12.2-server .
Thanks
Durga
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
> Attachments: UDFVDB.vdb
>
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3967) Function class not found results in an uncaught exception
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3967?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3967:
----------------------------------
Description: We throw a runtime MetadataException when a UDF fails to validate when the composite vdb is being built. This exception is not caught and ends up with default handling including sys.err printout. It would be better to catch this or even better to have the function validation performed by the metadata validator - as having these exceptions happen during VDBRepository.finishDeployment is unexpected. (was: We throw a runtime MetadataException when a UDF fails to validate when the composite vdb is being built. This exception is not caught and ends up with default handling including sys.err printout. It would be better to catch this or even better to have the function validation performed by the VDB validator - as having these exceptions happen during VDBRepository.finishDeployment is unexpected.)
> Function class not found results in an uncaught exception
> ---------------------------------------------------------
>
> Key: TEIID-3967
> URL: https://issues.jboss.org/browse/TEIID-3967
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> We throw a runtime MetadataException when a UDF fails to validate when the composite vdb is being built. This exception is not caught and ends up with default handling including sys.err printout. It would be better to catch this or even better to have the function validation performed by the metadata validator - as having these exceptions happen during VDBRepository.finishDeployment is unexpected.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3967) Function class not found results in an uncaught exception
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3967:
-------------------------------------
Summary: Function class not found results in an uncaught exception
Key: TEIID-3967
URL: https://issues.jboss.org/browse/TEIID-3967
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0
We throw a runtime MetadataException when a UDF fails to validate when the composite vdb is being built. This exception is not caught and ends up with default handling including sys.err printout. It would be better to catch this or even better to have the function validation performed by the VDB validator - as having these exceptions happen during VDBRepository.finishDeployment is unexpected.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3966) google spreadsheet translator using Collections.singletonList instance returned by the runtime doesn't support the set method.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3966?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3966:
----------------------------------
Steps to Reproduce: (was:
)
Priority: Major (was: Minor)
Affects Version/s: 8.6
(was: 8.12.4)
> google spreadsheet translator using Collections.singletonList instance returned by the runtime doesn't support the set method.
> --------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3966
> URL: https://issues.jboss.org/browse/TEIID-3966
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.6
> Reporter: marco ardito
> Assignee: Steven Hawkins
> Fix For: 8.13, 9.0, 8.12.x
>
>
> This arised as a follow-up of a forum thread, I tried to create a google spreadsheet dynamic VDB, exposing both the source as is, and also a model with a restricted view using only some fileds in the source model. from the sql client (squirrel) connnected to the vdb, but only the raw source model works, while any query to the view shows error
> org.teiid.core.TeiidException
> SQLState: 38000
> ErrorCode: 0
> In the thread, Steven Hawkins spotted the bug:<<The issue is that the translator is using Collections.singletonList to return the row and the engine is expecting it to be modifiable to avoid the additional copy one the value types are corrected. The SingletonList instance returned by the runtime unfortunately doesn't support the set method. >>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month