Alexey, This what my table looked like.
| person | CREATE TABLE `person` ( `id` int(11) NOT NULL, `orgId` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `salary` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | But I dropped the table and re-created. Works fine now. Thanks, -P On Fri, Oct 23, 2015 at 9:49 AM, Alexey Kuznetsov <[email protected]> wrote: > 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 >
