[
https://issues.jboss.org/browse/TEIIDDES-1667?page=com.atlassian.jira.plu...
]
Mark Drilling commented on TEIIDDES-1667:
-----------------------------------------
Barry,
I applied the patches. It did require a couple more changes to get the function
procedures to validate (I test 'both ways': ScalarFunction in a Function Model and
a function procedure in a Relational Model). Once I got everything to validate, I
attempted to run a preview and also deploy a VDB with the models. I'm getting the
following exception. This was against a 8.3 (CR2) Teiid Server...
----------------------------------------------
16:53:36,865 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB
PREVIEW_788ae101-13e9-447a-85cf-c3487c52f8fc_TEIIDDES1667_FuncTestMdl.1 model
"FuncTestMdl" metadata is currently being loaded. Start Time: 5/10/13 4:53 PM
16:53:36,871 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB
PREVIEW_788ae101-13e9-447a-85cf-c3487c52f8fc_TEIIDDES1667_FuncTestMdl.1 model
"FuncTestMdl" metadata loaded. End Time: 5/10/13 4:53 PM
16:53:36,885 ERROR [org.jboss.threads.executor] (teiid-async-threads - 4) Task execution
failed for task org.teiid.jboss.VDBService$6@566749c5:
org.teiid.metadata.MetadataException: TEIID30388 UDF "MakeList(object items) : object
result" could not be loaded, since no method on class
"org.me.functions.MyMathFunctions" with name "makeList" has a matching
type signature.
at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:326)
[teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:225)
[teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:99)
[teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:86)
[teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:254)
[teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:289)
[teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:180)
[teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.jboss.VDBService.access$900(VDBService.java:93)
[teiid-jboss-integration-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
[teiid-jboss-integration-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:801)
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:842)
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: java.lang.NoSuchMethodException: makeList Args: [class
org.teiid.query.util.CommandContext, class java.lang.Object]
at
org.teiid.core.util.ReflectionHelper.findBestMethodWithSignature(ReflectionHelper.java:191)
[teiid-common-core-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:320)
[teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
... 14 more
Ability to define UDF with vararg to be used in a static VDB
------------------------------------------------------------
Key: TEIIDDES-1667
URL:
https://issues.jboss.org/browse/TEIIDDES-1667
Project: Teiid Designer
Issue Type: Bug
Components: Teiid Integration
Affects Versions: 8.0
Environment: JBoss AS 7.1.1
Teiid 8.3.0
Teiid Designer 8.0.0
Reporter: Shakir Shaik
Assignee: Mark Drilling
Fix For: 8.2
Attachments: FunctionMethodDescriptor.patch, FunctionPlugin.patch,
MyMathFunctions.jar, MyMathFunctions.java, RelationalPlugin.patch, UdfManager.patch
I am not able to use a UDF with vararg and deploy the same in a static VDB.
Please see the details in the following thread of Teiid Designer User forum discussions:
https://community.jboss.org/thread/223823?tstart=0
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira