You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/06/01 00:53:13 UTC
[jira] [Commented] (TRAFODION-2018) JDBCT4 does not support
procedure list on DBVisualizer
[ https://issues.apache.org/jira/browse/TRAFODION-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15308984#comment-15308984 ]
ASF GitHub Bot commented on TRAFODION-2018:
-------------------------------------------
Github user kevinxu021 commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/508#discussion_r65287704
--- Diff: core/conn/jdbcT4/src/main/java/org/trafodion/jdbc/t4/T4DatabaseMetaData.java ---
@@ -3092,27 +3090,40 @@ public boolean dataDefinitionIgnoredInTransactions() throws SQLException {
// dropped from the search."
procedureNamePattern = "%";
+ }else{
+ procedureNamePattern = sqlValueFormat(procedureNamePattern);
+ }
+ MetadataHolder mdHolder = this.connection_.mdHolder_;
+ int retryCnt = 0;
+ while(retryCnt < 3 ) {
+ try {
+ PreparedStatement ps = mdHolder.getPStatement(SQL_API_SQLPROCEDURES, this.connection_);
+ ps.setObject(1, schemaPattern);
+ ps.setObject(2, procedureNamePattern);
+ return ps.executeQuery();
+ } catch (SQLException e) {
+ mdHolder.removePStatement(SQL_API_SQLPROCEDURES);
+ ++retryCnt;
+ if( retryCnt >= 3 ) {
+ throw e;
+ }
+ }
}
- getSQLCatalogsInfo(connection_.getServerHandle(), // Server Handle
- SQL_API_SQLPROCEDURES, // catalogAPI
- catalogNm, // catalog
- schemaNm, // schema
- procedureNamePattern, // table name
- "", // tableTypeList
- "", // cloumn name
- (int) 0, // cloumnType
- (int) 0, // rowIdScope
- (long) 0, // nullable
- (int) 0, // uniqueness
- (int) 0, // accuracy
- (short) 0, // sqlType
- (int) 0, // metadataId
- "", // fcatalog
- "", // fschema
- "" // ftable
- );
+ return null;
+ }
--- End diff --
As you know, it doesn't support getProcedures and getProcedureColumns and you can have a try by any Trafodion driver. Trafodion has JDBC/ODBC/ADO drivers that they has different description for metadata API. So it's not necessary to implement on server-side(MXOSRVR) by if condition( if JDBC then ... else if ODBC then ... else if ADO then ...)
> JDBCT4 does not support procedure list on DBVisualizer
> -------------------------------------------------------
>
> Key: TRAFODION-2018
> URL: https://issues.apache.org/jira/browse/TRAFODION-2018
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-jdbc-t4
> Reporter: Kevin Xu
> Assignee: Kevin Xu
>
> 1.Open DBV
> 2. Connect to Trafodion
> 3. Show procedure list on the left tree// Error here
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)