[
https://issues.apache.org/jira/browse/SOLR-9852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15744424#comment-15744424
]
Rani Y. commented on SOLR-9852:
-------------------------------
I am quite sure this is something which should be implemented by JDBC.
Unless you assume that the users of the JDBC know all the columns of a given
collection/table, there should be an implementation to getting the columns data
and types.
If I understand correctly is was implemented just not in the write places,
because after a query returns, there is an ability to see the columns types.
Receiving the meta-data of all objects is the "entry level" for JDBC
implementations.
Though, it does seem quite weird, that also the Spark's JDBC implementors are
having similar problems.
> 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.
> 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
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
