[
https://issues.apache.org/jira/browse/SOLR-9852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16415080#comment-16415080
]
Rani Y. commented on SOLR-9852:
-------------------------------
It shouldn't be too hard to do it.
When implementing JDBC, one of the classes which should be implemeneted in the
ResultSet, in this class there is a MetaData class, which contains all the
relevant data.
It is quite well documented, how the data should be reflected through this
meta-data. If you want to be even more standard, then you can implement answer
to some "virtual" tables which are system type tables only containing metadata
about others.
To me, its quite awkward that this was not implemented, as it prevents usage by
any tool which is not hardcoding the schema data.
> Solr JDBC doesn't implement columns' metadata
> ---------------------------------------------
>
> Key: SOLR-9852
> URL: https://issues.apache.org/jira/browse/SOLR-9852
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: Parallel SQL
> Affects Versions: 6.3
> Environment: N/A
> Reporter: Rani Y.
> Priority: Major
> Labels: solrJ
>
> This is the error I get (from Squirrel SQL) while trying to get the objects
> -meaning both tables and columns metadata
> 2016-12-12 13:47:48,241 [Thread-2] ERROR
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Error
> occurred creating data types collection
> java.lang.UnsupportedOperationException
> at
> org.apache.solr.client.solrj.io.sql.DatabaseMetaDataImpl.getTypeInfo(DatabaseMetaDataImpl.java:773)
> at
> net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypesSimpleNames(SQLDatabaseMetaData.java:1978)
> at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:900)
> at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:315)
> at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)
> at
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
> at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:315)
> at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
> at java.lang.Thread.run(Thread.java:745)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
