ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prachi Garg <pg...@gridgain.com>
Subject Re: Ignite Web Console - Loading metadata from MySQL
Date Fri, 23 Oct 2015 17:08:50 GMT
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 <akuznetsov@gridgain.com>
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 <pgarg@gridgain.com> wrote:
>
> > On Thu, Oct 22, 2015 at 7:04 PM, Alexey Kuznetsov <
> akuznetsov@gridgain.com
> > >
> > 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 <pgarg@gridgain.com> 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 <
> > > dsetrakyan@apache.org
> > > > >
> > > > wrote:
> > > >
> > > > > On Wed, Oct 21, 2015 at 5:08 PM, Prachi Garg <pgarg@gridgain.com>
> > > 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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message