Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | App - Schema Browser |
| Version | 15.0 |
Add Index Columns in Schema Browser for Generic-JDBC ... this will be just like VoltDB. VoltIndexColumnsNode.java
index columns node added for generic connections. Needs testing. Error logging set on since there are many different ways to have sql exceptions get thrown unique to each different jdbc driver implementation.
Need to verify with Customer if it works correctly for CONNX JDBC Driver for Adabas with a Generic Connection.
Need to verify with Customer if it works correctly for CONNX JDBC Driver for Adabas with a Generic Connection.
@Shavi: this issue was specific for CONNX JDBC Driver and we tested for Oracle, Derby etc. Are you getting any exceptions ? If not the system catalog tables may not have the column information. I spoke with Ivan and he will update the issue.
@Shavi: this issue was specific for CONNX JDBC Driver and we tested for Oracle, Derby etc. Are you getting any exceptions ? If not the system catalog tables may not have the column information. I spoke with Ivan and he will update the issue.
You are correct that Generic MySQL connection does not display the index columns. We added support, in ads, to use the driver method getMetaData() to extract the index info. The mysql driver is not returning anything for index columns because its code is not supporting extraction of index columns.
If an exception is thrown ads will log it; if you see an exception please reopen issue with the information to reproduce the exception. If the columns don't display and there is no exception, this just means that the specific vendor driver is not supporting extraction of the index colums...
You are correct that Generic MySQL connection does not display the index columns. We added support, in ads, to use the driver method getMetaData() to extract the index info. The mysql driver is not returning anything for index columns because its code is not supporting extraction of index columns.
If an exception is thrown ads will log it; if you see an exception please reopen issue with the information to reproduce the exception. If the columns don't display and there is no exception, this just means that the specific vendor driver is not supporting extraction of the index colums...
Issue #12724 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 15.0.10-6 |
| No time estimate |
index columns node added for generic connections. Needs testing. Error logging set on since there are many different ways to have sql exceptions get thrown unique to each different jdbc driver implementation.