[ 
https://issues.apache.org/jira/browse/TRAFODION-2740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16175310#comment-16175310
 ] 

ASF GitHub Bot commented on TRAFODION-2740:
-------------------------------------------

Github user arvind-narain commented on a diff in the pull request:

    
https://github.com/apache/incubator-trafodion/pull/1240#discussion_r140335560
  
    --- Diff: 
dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestForeignKey.java
 ---
    @@ -74,12 +74,15 @@
        public static void doTestSuiteSetup() throws Exception {
                try{
                        _conn = DriverManager.getConnection(Utils.url, 
Utils.usr, Utils.pwd);
    -                   Statement stmt = _conn.createStatement();
    -                   
    -                   stmt.execute(strCreatePKTABLE1Query);
    -                   stmt.execute(strCreatePKTABLE2Query);
    -                   stmt.execute(strCreateFKTABLE1Query);
    -                   stmt.execute(strCreateFKTABLE2Query);
    +            try (
    --- End diff --
    
    Thanks for the change Weiqing. Learnt something new related to 
try-with-resource-statement from your change - it does reduce the earlier code 
change planned - thanks.
    
    Could you please also take care of replacing DriverMagager.getConnection 
calls from *Blob*, *Clob*, TestGetIndexInfo and this file ? This would take 
care random non-existent schema errors seen.


> JDBC Extract LOB in chunks
> --------------------------
>
>                 Key: TRAFODION-2740
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2740
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: client-jdbc-t4, connectivity-mxosrvr
>    Affects Versions: 2.2-incubating
>            Reporter: Weiqing Xu
>            Assignee: Weiqing Xu
>
> The JDBC will extract all the LOB context once.However there is a size limit 
> for the extract query. It only can extract at most 500MB. So the the 
> *_"extract"_* statement should be call multiple times to extract the whole 
> context.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to