Re: odbc 2.7 columns issue

[wt]

Thanks Igor

I didn't think about the underscores in the names. Will try it in the
morning. Thanks for the tip, hopefully it will get me over the line for the
demo to the COO. 





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: odbc 2.7 columns issue

[Igor Sapego]

Ok,

This is an another bug, related to escaped table names. See [1].

I'm working on it currently. Meanwhile you can use tables without
underscores in names as a workaround.

[1] - https://issues.apache.org/jira/browse/IGNITE-10009

Best Regards,
Igor


On Thu, Oct 25, 2018 at 10:13 AM wt  wrote:

> hi
>
> here is the odbc log file
>
> odbc.log
> 
>
> My server configuration
>
>xmlns="http://ignite.apache.org/schema/dotnet/IgniteConfigurationSection;>
> 
>   
> 
>   127.0.0.1:47500..47509
> 
>   
> 
> 
>maxSize="124288000"/>
>   
>  persistenceEnabled="true" maxSize="524288000" evictionThreshold="0.85"  />
>  maxSize="524288000" evictionThreshold="0.9"/>
>   
> 
>   
>
>
> i have 1 table i am trying to view
>
> {
>   "tablename": "ESG_Focus",
>   "fields": [
> {
>   "name": "COMPANYID",
>   "datatype": "java.lang.Integer"
> },
> {
>   "name": "ESG_FOCUS_ITEM",
>   "datatype": "java.lang.String"
> },
> {
>   "name": "ESG_FOCUS_VALUE",
>   "datatype": "java.lang.String"
> },
> {
>   "name": "ID",
>   "datatype": "java.util.UUID"
> },
> {
>   "name": "RECORD_VALID_FROM",
>   "datatype": "java.sql.Timestamp"
> },
> {
>   "name": "RECORD_VALID_TO",
>   "datatype": "java.sql.Timestamp"
> }
>   ],
>   "indexinfo": []
> }
>
>
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: odbc 2.7 columns issue

[wt]

hi

here is the odbc log file

odbc.log
  

My server configuration

  http://ignite.apache.org/schema/dotnet/IgniteConfigurationSection;>

  

  127.0.0.1:47500..47509

  


  
  


  

  


i have 1 table i am trying to view

{
  "tablename": "ESG_Focus",
  "fields": [
{
  "name": "COMPANYID",
  "datatype": "java.lang.Integer"
},
{
  "name": "ESG_FOCUS_ITEM",
  "datatype": "java.lang.String"
},
{
  "name": "ESG_FOCUS_VALUE",
  "datatype": "java.lang.String"
},
{
  "name": "ID",
  "datatype": "java.util.UUID"
},
{
  "name": "RECORD_VALID_FROM",
  "datatype": "java.sql.Timestamp"
},
{
  "name": "RECORD_VALID_TO",
  "datatype": "java.sql.Timestamp"
}
  ],
  "indexinfo": []
}







--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: odbc 2.7 columns issue

[Ilya Kasnacheev]

Hello!

Can you also share your tables/caches configuration?

Regards,
-- 
Ilya Kasnacheev


ср, 24 окт. 2018 г. в 18:14, Igor Sapego :

> Hi,
>
> Can you share an ODBC log please?
>
> Best Regards,
> Igor
>
>
> On Wed, Oct 24, 2018 at 5:59 PM wt  wrote:
>
>> Hi
>>
>> Thank you for fixing the bug where in Excel i was not able to see the
>> tables. I can now however there are no columns visible and it gives an
>> error
>> that the data source did not return any columns. So it is a bit better
>> that
>> we can see the tables but we still cannot browse them and have to run a
>> select on the table to get the data back. I tried to get an odbc log but
>> nothing is logged. here is a screenshot 2018-10-24_15-58-35.png
>> <
>> http://apache-ignite-users.70518.x6.nabble.com/file/t1892/2018-10-24_15-58-35.png>
>>
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Re: odbc 2.7 columns issue

[Igor Sapego]

Hi,

Can you share an ODBC log please?

Best Regards,
Igor


On Wed, Oct 24, 2018 at 5:59 PM wt  wrote:

> Hi
>
> Thank you for fixing the bug where in Excel i was not able to see the
> tables. I can now however there are no columns visible and it gives an
> error
> that the data source did not return any columns. So it is a bit better that
> we can see the tables but we still cannot browse them and have to run a
> select on the table to get the data back. I tried to get an odbc log but
> nothing is logged. here is a screenshot 2018-10-24_15-58-35.png
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t1892/2018-10-24_15-58-35.png>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

odbc 2.7 columns issue

[wt]

Hi

Thank you for fixing the bug where in Excel i was not able to see the
tables. I can now however there are no columns visible and it gives an error
that the data source did not return any columns. So it is a bit better that
we can see the tables but we still cannot browse them and have to run a
select on the table to get the data back. I tried to get an odbc log but
nothing is logged. here is a screenshot 2018-10-24_15-58-35.png

  



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/