Bug 1260896

Summary: Caching Guide - User Query Cache
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jan Stastny <jstastny>
Component: DocumentationAssignee: David Le Sage <dlesage>
Status: CLOSED CURRENTRELEASE QA Contact: Jan Stastny <jstastny>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.2.0Keywords: Documentation
Target Milestone: CR2   
Target Release: 6.2.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Build Name: 23073, Development Guide Volume 5: Caching Guide-6.2 Build Date: 04-09-2015 14:10:18 Topic ID: 43090-769664 [Latest]
Last Closed: 2015-09-29 00:56:37 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Jan Stastny 2015-09-08 07:32:21 UTC 
Title: User Query Cache

Describe the issue:
Duplicate note (it is repeated later in a NOTE):
> Note that if either of these mechanisms are used, Teiid must also have result set caching enabled (the default is enabled). 

Also whole this fragment is duplicate:
> End users or client applications explicitly state whether to use result set 
> caching. This can be done by setting the JDBC ResultSetCacheMode execution 
> property to true (by default it is set to false):
>
>  
>
> Properties info = new Properties();
>
> ...
> 
> info.setProperty("ResultSetCacheMode", "true");
> 
> Connection conn = DriverManager.getConnection(url, info);
>  
>
> Another way to do this is by adding a Cache Hint to the query. Note that if 
> either of these mechanisms are used, Teiid must also have result set caching 
> enabled (the default is enabled). 

Suggestions for improvement:


Additional information:
Comment 1 David Le Sage 2015-09-09 00:13:34 UTC 
Thanks. Duplicated paragraphs removed.