Mailing-List: contact dev-help@ignite.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ignite.incubator.apache.org
Date: Sun, 8 Feb 2015 05:48:34 +0000 (UTC)
From: "Pavel Konstantinov (JIRA)" <jira@apache.org>
To: dev@ignite.incubator.apache.org
Message-ID: <JIRA.12758700.1417455970000.293717.1423374514887@Atlassian.JIRA>
In-Reply-To: <JIRA.12758700.1417455970000@Atlassian.JIRA>
References: <JIRA.12758700.1417455970000@Atlassian.JIRA>
 <JIRA.12758700.1417455970236@arcas>
Subject: [jira] [Comment Edited] (IGNITE-32) Need to create a utility for
 auto-schema loading from databases
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/IGNITE-32?page=3Dcom.atlassian.=
jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D14311=
124#comment-14311124 ]=20

Pavel Konstantinov edited comment on IGNITE-32 at 2/8/15 5:47 AM:
------------------------------------------------------------------

1. Need to fix a little typo in the CP set - add '*' to the end (%IGNITE_HO=
ME%\bin\include\schema-load\\*)
2. Warning on SchemaLoad start:
{code}
S:\work\ignite-fabric-1.0.0-SNAPSHOT\bin>ignite-schema-load.bat
=D0=87=D1=85=D1=82 08, 2015 1:43:34 PM java.util.prefs.WindowsPreferences <=
init>
WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs at r=
oot 0x80000002. Windows RegCreateKeyEx(...) returned error code 5.
{code}


was (Author: pkonstantinov):
1. Need to fix a little typo in the CP set - add '*' to the end (%IGNITE_HO=
ME%\bin\include\schema-load\*)
2. Warning on SchemaLoad start:
{code}
S:\work\ignite-fabric-1.0.0-SNAPSHOT\bin>ignite-schema-load.bat
=D0=87=D1=85=D1=82 08, 2015 1:43:34 PM java.util.prefs.WindowsPreferences <=
init>
WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs at r=
oot 0x80000002. Windows RegCreateKeyEx(...) returned error code 5.
{code}


> Need to create a utility for auto-schema loading from databases
> ---------------------------------------------------------------
>
>                 Key: IGNITE-32
>                 URL: https://issues.apache.org/jira/browse/IGNITE-32
>             Project: Ignite
>          Issue Type: Task
>          Components: UI
>            Reporter: Dmitriy Setrakyan
>            Assignee: Alexey Kuznetsov
>            Priority: Critical
>             Fix For: sprint-1
>
>         Attachments: ignite-32-01.png, ignite-32-02.png, ignite-32-03.png=
, ignite-32-04.png, ignite_patch.diff
>
>
> Need to create utility for auto-schema loading:
> # Should be written in Java
> # Preferably no additional dependencies should be added to the project.=
=20
> The process is composed of 2 parts, schema mapping and automatic data loa=
ding.
> h3. Schema Mapping
> # Should be a standalone GUI utility
> # Users should select schemas, then tables from schemas, then fields from=
 tables, and automatically generate Spring XML for SQL Query metadata confi=
guration.
> # Should also optionally automatically generate POJO classes.
> # Should automatically map SQL table names to Java standard allowing user=
s to provide customer Regex.
> # By default, every  table should be mapped to a separate Cache, but user=
 should be able to override this in any possible way.
> h3. Automatic {{GridCacheStore}} implementation
> # The new {{GridCacheStore}} implementation should read the XML configura=
tion generated by *Schema Mapping* step and automatically implement all CRU=
D and TX operations out of the box.
> # The implementation of the {{loadCache(...)}} method should accept SQL f=
or loading (or where clause) as a parameter. Users should be able to preloa=
d a portion of the table based on some search criteria on startup or at any=
 point after.


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)