Re: Mechanism to Bring DataSet to Unique level

2017-08-02 Thread Gajanan Patil
Yes done that and it worked for me thanks Kasper for immediate turn around. Gajanan Patil +91-97666 96197 Sent From My Lenovo K4 Note On 3 Aug 2017 7:09 a.m., "Kasper Sørensen" wrote: > Not sure I see the problem here as BIGINT is equivalent to Long. But you > can always use String.valueOf(.

Re: Mechanism to Bring DataSet to Unique level

2017-08-02 Thread Kasper Sørensen
Not sure I see the problem here as BIGINT is equivalent to Long. But you can always use String.valueOf(...) if you want the string representation. Kasper Sørensen > On Aug 2, 2017, at 11:11, Gajanan Patil wrote: > > Hi All, > > I have table having id column with BIGINT DataType in mysql, when

Mechanism to Bring DataSet to Unique level

2017-08-02 Thread Gajanan Patil
Hi All, I have table having id column with BIGINT DataType in mysql, when we convert it to List it shows as Type Long (java language datatype). Is there any mechanism to bring this column datatype to String in Java language?. or anyother approach that willl give me dataset to type of string? y

Re: Reading Indexes created in a DB

2017-08-02 Thread Ashuthosh Bhat
Sure, it would be nice to retrieve auto-increment column details as well using metamodel. I was using 4.5.4 couldnt find anything specific and wrote little top up jdbc meta code to get those details on each table in db. Wrote code specific to MySQL though (limit), works for me as of now. Warm Re

Re: Reading Indexes created in a DB

2017-08-02 Thread Kasper Sørensen
We do have a simple boolean right now: Column.isIndexed(). So if you're just trying to find out what indexes are there, we have it covered. But there have also been some requests to improve this information, see https://issues.apache.org/jira/browse/METAMODEL-16 2017-08-02 6:58 GMT-07:00 Dennis

Re: Reading Indexes created in a DB

2017-08-02 Thread Dennis Du Krøger
I think it would make sense. At least in theory, we should be able to get that information from the JDBC metadata classes. However, not all drivers are equally nice at actually providing the data. Thinking of it, let's maybe wait with conclusions until Kasper (project lead) gets a chance to re

Re: Reading Indexes created in a DB

2017-08-02 Thread Ashuthosh Bhat
Thanks for quick revert Dennis. Can code contribution towards retrieval/creation of indexes be considered? Thanks, Ashu On Wed, Aug 2, 2017 at 12:57 PM, Dennis Du Krøger < dennis.dukro...@humaninference.com> wrote: > Hi Ashu, > > Most information from SQL databases can be gathered using the > I

Re: Reading Indexes created in a DB

2017-08-02 Thread Dennis Du Krøger
Hi Ashu, Most information from SQL databases can be gathered using the INFORMATION_SCHEMA schema. Unfortunately, indexes isn't one of them, so you'll need to see if there are some something specific for each database. E.g. for SQL Server you can query sys.indexes to get a list of all indexes. T