[jira] [Commented] (IGNITE-32) Need to create a utility for auto-schema loading from databases

["Pavel Konstantinov (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-32?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14311138#comment-14311138 ] 

Pavel Konstantinov commented on IGNITE-32:
------------------------------------------

On Ubuntu two issues:
1. CP doesn't contains sxhema load libs
2. After I'm added libs to CP I got very strange exception:
{code}
ubuntu1204@ubuntu1204-Aspire-V3-772:/media/ssd/ignite-fabric-1.0.0-SNAPSHOT$ ./bin/ignite-schema-load.sh
Exception in thread "main" java.lang.NoClassDefFoundError: javafx/application/Application
	at java.lang.ClassLoader.defineClass1(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
	at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
	at java.net.URLClassLoader.access$100(URLClassLoader.java:71)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
	at sun.launcher.LauncherHelper.checkAndLoadMain(LauncherHelper.java:482)
Caused by: java.lang.ClassNotFoundException: javafx.application.Application
	at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
	... 13 more
ubuntu1204@ubuntu1204-Aspire-V3-772:/media/ssd/ignite-fabric-1.0.0-SNAPSHOT$ java -version
java version "1.7.0_76"
Java(TM) SE Runtime Environment (build 1.7.0_76-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.76-b04, mixed mode)
ubuntu1204@ubuntu1204-Aspire-V3-772:/media/ssd/ignite-fabric-1.0.0-SNAPSHOT$ 

{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. 
> The process is composed of 2 parts, schema mapping and automatic data loading.
> 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 configuration.
> # Should also optionally automatically generate POJO classes.
> # Should automatically map SQL table names to Java standard allowing users 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 configuration generated by *Schema Mapping* step and automatically implement all CRUD and TX operations out of the box.
> # The implementation of the {{loadCache(...)}} method should accept SQL for loading (or where clause) as a parameter. Users should be able to preload 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)