[JBoss JIRA] Created: (TEIID-1256) Clear caches when VDB with same version re-deployed
by Ramesh Reddy (JIRA)
Clear caches when VDB with same version re-deployed
---------------------------------------------------
Key: TEIID-1256
URL: https://jira.jboss.org/browse/TEIID-1256
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 7.1.1
When a VDB with same name and version is re-deployed, the new re-deployed VDB may have its metadata changed. In this case if Teiid has any
PreparedPlanCache
ResultSetCache
they need to flushed for that VDB, otherwise it will produce wrong results. One issue is there could be active connections on VDB, those need to be terminated also. Based on how failover is configured they may re-connect on the next query automatically.
--
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
13 years, 12 months
[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
13 years, 12 months
[JBoss JIRA] Created: (TEIID-1252) LOB handling strategry issues
by Steven Hawkins (JIRA)
LOB handling strategry issues
-----------------------------
Key: TEIID-1252
URL: https://jira.jboss.org/browse/TEIID-1252
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Affects Versions: 7.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.1.1
LOBs returned from sources cause executions to stay alive until the user query has been completed - this is true even if the LOB values are not returned to the user.
Whenever an execution is kept alive, it's associated connection is held until the execution is closed - thus source connections may be held out of their pool indefinately.
Currently each source execution will attempt to obtain a new connection from the pool, which with LOB handling will cause potentially many connections even to the same source to be held out of the their pool indefinitely.
--
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
13 years, 12 months
[JBoss JIRA] Created: (TEIID-1279) Got an Unexpected exception when starting the server, after digging, I think the message should have indicated that the UDF requires static methods
by Van Halbert (JIRA)
Got an Unexpected exception when starting the server, after digging, I think the message should have indicated that the UDF requires static methods
---------------------------------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1279
URL: https://jira.jboss.org/browse/TEIID-1279
Project: Teiid
Issue Type: Bug
Components: Server
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Minor
Fix For: 7.1.1
When trying to start the server got this exception:
Caused by: Unexpected exception while loading org.teiid.translator.jdbc.modeshape.functions.Cast.public java.lang.Object org.teiid.translator.jdbc.modeshape.functions.Cast.cast(java.lang.String,java.lang.String) with args= [class java.lang.String, class java.lang.String]
at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:315)
at org.teiid.query.function.FunctionTree.addSource(FunctionTree.java:138)
at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:82)
at org.teiid.query.metadata.TransformationMetadata.<init>(TransformationMetadata.java:160)
at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:102)
at org.teiid.deployers.CompositeVDB.update(CompositeVDB.java:84)
at org.teiid.deployers.CompositeVDB.<init>(CompositeVDB.java:64)
at org.teiid.deployers.VDBRepository.addVDB(VDBRepository.java:82)
at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:145)
at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:60)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
After digging into the code, I realized that the function methods are required to be static. It sure would have been nice if the error would have indicated the reason. And I can see this error happening in development.
--
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
13 years, 12 months
[JBoss JIRA] Created: (TEIID-1237) Stored procedures should allow for better use of inout/out/return values
by Steven Hawkins (JIRA)
Stored procedures should allow for better use of inout/out/return values
------------------------------------------------------------------------
Key: TEIID-1237
URL: https://jira.jboss.org/browse/TEIID-1237
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.2
Teiid stored procedure command or assignment statements do not typically make use of inout/out/return values (the exception is if a resultset is not returned). It would be better to allow variables to be used in inout/out positions to capture the out values.
e.g. instead of
call proc(1)
just implicitly creating the result set to return,
a = call proc(1, b)
would also assign the return value to a and would set an out value to b.
--
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
13 years, 12 months