Prachi, You get such message because some of your tables do not have PRIMARY KEY defined. Could you show you table definition here (SQL scrtipt)? May be we have a bug for MySql metadata extraction logic.
Web Console use fields from PRIMARY KEY to describe Key POJO that will be used later as key to put values into cache. You could read about primary keys here: https://en.wikipedia.org/wiki/Unique_key#Defining_primary_keys_in_SQL Any way, primary keys is not mandatory and after metadata loaded one can specify key fields manually. On Fri, Oct 23, 2015 at 11:36 PM, Prachi Garg <[email protected]> wrote: > On Thu, Oct 22, 2015 at 7:04 PM, Alexey Kuznetsov <[email protected] > > > wrote: > > > Prachi, > > > > If this issue: https://issues.apache.org/jira/browse/IGNITE-1761 > > > > Is the same as you propose? > > > > Yes, looks like the same thing :-) > > > > > P.S. > > Did you managed to load metadata from your MySQL database? > > > > I did. But when I try to select the table and load the metadata, I get the > following message - > "Some tables have no primary key. > You will need to configure key type and key fields for such tables after > load complete." > Even though I have a primary key specified in my table. Am I missing > something? > > Thanks, > -P > > > > On Fri, Oct 23, 2015 at 1:06 AM, Prachi Garg <[email protected]> wrote: > > > > > Thanks! > > > > > > I think we should also provide an option on the client side for the > user > > to > > > browse to the local folder of his system. > > > > > > -P > > > > > > On Thu, Oct 22, 2015 at 12:39 AM, Dmitriy Setrakyan < > > [email protected] > > > > > > > wrote: > > > > > > > On Wed, Oct 21, 2015 at 5:08 PM, Prachi Garg <[email protected]> > > wrote: > > > > > > > > > I am trying to load metadata from MySQL database, but the web > console > > > > > doesn't allow me to provide the MySQL driver JAR. It is set to H2, > by > > > > > default, and doesn't let me change. I tried running the Ignite web > > > agent > > > > in > > > > > both test and non-test modes. How can I provide the MySQL driver > JAR? > > > > > > > > > > > > > The question (?) helper popup next to the driver field actually > > explains > > > > what to do. You need to copy the driver JAR into the “jdbc-drivers” > > > folder > > > > in the agent. > > > > > > > > > > > > > Thanks, > > > > > -Prachi > > > > > > > > > > > > > > > > > > > > -- > > Alexey Kuznetsov > > GridGain Systems > > www.gridgain.com > > > -- Alexey Kuznetsov GridGain Systems www.gridgain.com
