]> git.mxchange.org Git - jcore.git/blobdiff - src/org/mxchange/jcore/BaseFrameworkSystem.java
Changed to SortedSet to keep ordering
[jcore.git] / src / org / mxchange / jcore / BaseFrameworkSystem.java
index f6a1cb5ff98ccb123acb378775119cb3478ff8eb..b48ad50e49d6a32faf7699efc7e860a0cfc2e47b 100644 (file)
@@ -33,6 +33,7 @@ import java.util.Map;
 import java.util.Properties;
 import java.util.ResourceBundle;
 import java.util.StringTokenizer;
+import org.apache.commons.lang3.ArrayUtils;
 import org.apache.logging.log4j.LogManager;
 import org.apache.logging.log4j.Logger;
 import org.mxchange.jcore.application.Application;
@@ -40,7 +41,7 @@ import org.mxchange.jcore.client.Client;
 import org.mxchange.jcore.contact.Contact;
 import org.mxchange.jcore.database.backend.DatabaseBackend;
 import org.mxchange.jcore.database.frontend.DatabaseFrontend;
-import org.mxchange.jcore.database.storage.Storeable;
+import org.mxchange.jcore.database.storage.Storable;
 import org.mxchange.jcore.manager.Manageable;
 
 /**
@@ -103,7 +104,12 @@ public class BaseFrameworkSystem implements FrameworkInterface {
        /**
         * DatabaseFrontend instance
         */
-       private DatabaseFrontend wrapper;
+       private DatabaseFrontend frontend;
+
+       /**
+        * Session id assigned with this basket, or any other unique identifier
+        */
+       private String sessionId;
 
        /**
         * Initialize object
@@ -215,14 +221,27 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                // Trace messahe
                this.getLogger().trace(MessageFormat.format("targetClass={0},methodName={1}", targetClass, methodName)); //NOI18N
 
-               // Get target class instance
-               Class<? extends FrameworkInterface> c = this.getClassFromTarget(instance, targetClass);
 
-               // Init field instance
+               // Init method instance
                Method method = null;
 
-               // Use reflection to get all attributes
-               method = c.getDeclaredMethod(methodName, new Class<?>[0]);
+               // Try it from target class
+               try {
+                       // Get target class instance
+                       Class<? extends FrameworkInterface> c = this.getClassFromTarget(instance, targetClass);
+
+                       // Init field instance
+                       method = c.getDeclaredMethod(methodName, new Class<?>[0]);
+               } catch (final NoSuchMethodException e) {
+                       // Didn't found it
+                       this.getLogger().warn(e);
+
+                       // So try it from super class
+                       Class<? extends FrameworkInterface> c = this.getClassFromTarget(instance, "BaseFrameworkSystem"); //NOI18N
+
+                       // Init field instance
+                       method = c.getDeclaredMethod(methodName, new Class<?>[0]);
+               }
 
                // Assert on field
                assert (method instanceof Method) : "method is not a Method instance"; //NOI18N
@@ -240,21 +259,33 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @param instance Actual instance to call
         * @param targetClass Target class name
         * @param methodName Method name
-        * @param value Value to check type from
+        * @param type Type reflection to check type from
         * @return A Method instance
         */
-       private Method getMethodFromName (final FrameworkInterface instance, final String targetClass, final String methodName, final Object value) throws NoSuchMethodException {
+       private Method getMethodFromName (final FrameworkInterface instance, final String targetClass, final String methodName, final Class<?> type) throws NoSuchMethodException {
                // Trace messahe
-               this.getLogger().trace(MessageFormat.format("targetClass={0},methodName={1}", targetClass, methodName)); //NOI18N
+               this.getLogger().trace(MessageFormat.format("targetClass={0},methodName={1},type={2}", targetClass, methodName, type)); //NOI18N
 
-               // Get target class instance
-               Class<? extends FrameworkInterface> c = this.getClassFromTarget(instance, targetClass);
-
-               // Init field instance
+               // Init method instance
                Method method = null;
 
-               // Use reflection to get all attributes
-               method = c.getDeclaredMethod(methodName, value.getClass());
+               // Try it from target class
+               try {
+                       // Get target class instance
+                       Class<? extends FrameworkInterface> c = this.getClassFromTarget(instance, targetClass);
+
+                       // Init field instance
+                       method = c.getDeclaredMethod(methodName, type);
+               } catch (final NoSuchMethodException e) {
+                       // Didn't found it
+                       this.getLogger().warn(e);
+
+                       // So try it from super class
+                       Class<? extends FrameworkInterface> c = this.getClassFromTarget(instance, "BaseFrameworkSystem"); //NOI18N
+
+                       // Init field instance
+                       method = c.getDeclaredMethod(methodName, type);
+               }
 
                // Assert on field
                assert (method instanceof Method) : "method is not a Method instance"; //NOI18N
@@ -281,7 +312,7 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         */
        protected final void abortProgramWithException (final Throwable throwable) {
                // Log exception ...
-               this.getLogger().catching(throwable);
+               this.logException(throwable);
 
                // .. and exit
                System.exit(1);
@@ -315,6 +346,15 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                return BaseFrameworkSystem.bundle;
        }
 
+       /**
+        * Setter for bundle instance
+        *
+        * @param bundle the bundle to set
+        */
+       protected static void setBundle (final ResourceBundle bundle) {
+               BaseFrameworkSystem.bundle = bundle;
+       }
+
        /**
         * Client instance
         *
@@ -370,7 +410,8 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                // Init default values:
                // Default database backend
                BaseFrameworkSystem.properties.put("org.mxchange.database.backend.class", "org.mxchange.jcore.database.backend.base64.Base64CsvDatabaseBackend"); //NOI18N
-               BaseFrameworkSystem.properties.put("database.backend.storagepath", "data/"); //NOI18N
+               BaseFrameworkSystem.properties.put("org.mxchange.database.backend.storagepath", "data/"); //NOI18N
+               BaseFrameworkSystem.properties.put("org.mxchange.database.datasource.name", ""); //NOI18N
 
                // For MySQL backend
                BaseFrameworkSystem.properties.put("org.mxchange.database.mysql.host", "localhost"); //NOI18N
@@ -402,15 +443,12 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @param columnName Column name to convert
         * @return Attribute name
         */
-       protected String convertColumnNameToAttribute (final String columnName) {
+       protected String convertColumnNameToFieldName (final String columnName) {
                // Trace message
                this.getLogger().trace(MessageFormat.format("columnName={0} - CALLED!", columnName)); //NOI18N
 
-               // First all lower case
-               String lower = columnName.toLowerCase();
-
-               // Then split on "_"
-               StringTokenizer tokenizer = new StringTokenizer(lower, "_"); //NOI18N
+               // Split on "_"
+               StringTokenizer tokenizer = new StringTokenizer(columnName, "_"); //NOI18N
 
                // Resulting string
                StringBuilder builder = new StringBuilder(tokenizer.countTokens());
@@ -520,12 +558,15 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                        String token = tokenizer.nextToken();
 
                        // Debug message
-                       this.getLogger().debug(MessageFormat.format("token={0}", token)); //NOI18N
+                       this.getLogger().debug(MessageFormat.format("token={0} - BEFORE", token)); //NOI18N
 
                        // Make it upper-case
                        char c = token.charAt(0);
                        token = String.valueOf(c).toUpperCase() + token.substring(1);
 
+                       // Debug message
+                       this.getLogger().debug(MessageFormat.format("token={0} - AFTER", token)); //NOI18N
+
                        // Add token
                        builder.append(token);
                }
@@ -542,19 +583,18 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         *
         * @param str String to tokenize and get array from
         * @param delimiter Delimiter
-        * @param size Size of array
         * @return Array from tokenized string
-        * @todo Get rid of size parameter
+        * TODO Get rid of size parameter
         */
-       protected String[] getArrayFromString (final String str, final String delimiter, final int size) {
+       protected String[] getArrayFromString (final String str, final String delimiter) {
                // Trace message
-               this.getLogger().trace(MessageFormat.format("str={0},delimiter={1},size={2} - CALLED!", str, delimiter, size)); //NOI18N
+               this.getLogger().trace(MessageFormat.format("str={0},delimiter={1} - CALLED!", str, delimiter)); //NOI18N
 
                // Get tokenizer
                StringTokenizer tokenizer = new StringTokenizer(str, delimiter);
 
                // Init array and index
-               String[] tokens = new String[size];
+               String[] tokens = new String[tokenizer.countTokens()];
                int index = 0;
 
                // Run through all tokens
@@ -595,13 +635,10 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                Method method = this.getMethodFromName(instance, targetClass, methodName);
 
                // Get value from field
-               Boolean value = false;
-
-               // Try to get the value by invoking the method
-               value = (Boolean) method.invoke(instance);
+               Boolean value = (Boolean) method.invoke(instance);
 
                // Trace message
-               this.getLogger().trace("value=" + value + " - EXIT!");
+               this.getLogger().trace(MessageFormat.format("value={0} - EXIT!", value)); //NOI18N
 
                // Return value
                return value;
@@ -613,23 +650,27 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @param instance The instance to call
         * @param targetClass Target class to look in
         * @param methodName Method name to look for
+        * @param columnName Column name
         * @param value Boolean value from field
         * @throws java.lang.NoSuchMethodException If the method was not found
         * @throws java.lang.IllegalAccessException If the method cannot be accessed
         * @throws java.lang.reflect.InvocationTargetException Some other problems?
         */
-       protected void setBooleanField (final FrameworkInterface instance, final String targetClass, final String methodName, final Boolean value) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
+       protected void setBooleanField (final FrameworkInterface instance, final String targetClass, final String methodName, final String columnName, final Boolean value) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
                // Trace messahe
                this.getLogger().trace(MessageFormat.format("targetClass={0},methodName={1}", targetClass, methodName)); //NOI18N
 
+               // Get field type
+               Class<?> type = this.getType(instance, targetClass, columnName);
+
                // Get method instance
-               Method method = this.getMethodFromName(instance, targetClass, methodName, value);
+               Method method = this.getMethodFromName(instance, targetClass, methodName, type);
 
                // Try to get the value by invoking the method
                method.invoke(instance, value);
 
                // Trace message
-               this.getLogger().trace("EXIT!");
+               this.getLogger().trace("EXIT!"); //NOI18N
        }
 
        /**
@@ -654,16 +695,19 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         */
        protected Object getField (final FrameworkInterface instance, final String targetClass, final String methodName) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
                // Trace messahe
-               this.getLogger().trace(MessageFormat.format("targetClass={0},methodName={1}", targetClass, methodName)); //NOI18N
+               this.getLogger().trace(MessageFormat.format("instance={0},targetClass={1},methodName={2}", instance, targetClass, methodName)); //NOI18N
 
                // Get method to call
                Method method = this.getMethodFromName(instance, targetClass, methodName);
 
+               // Debug message
+               this.getLogger().debug(MessageFormat.format("method={0},instance={1}", method, instance)); //NOI18N
+
                // Get value from field
                Object value = method.invoke(instance);
 
                // Trace messahe
-               this.getLogger().trace("value=" + value + " - EXIT!");
+               this.getLogger().trace(MessageFormat.format("value={0} - EXIT!", value)); //NOI18N
 
                // Return value
                return value;
@@ -675,23 +719,70 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @param instance The instance to call
         * @param targetClass Target class to look in
         * @param methodName Method name to look for
+        * @param columnName Column name
         * @param value Any value from field
         * @throws java.lang.NoSuchMethodException If the method was not found
         * @throws java.lang.IllegalAccessException If the method cannot be accessed
         * @throws java.lang.reflect.InvocationTargetException Some other problems?
         */
-       protected void setField (final FrameworkInterface instance, final String targetClass, final String methodName, final String value) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
+       protected void setField (final FrameworkInterface instance, final String targetClass, final String methodName, final String columnName, final Object value) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
                // Trace messahe
-               this.getLogger().trace(MessageFormat.format("targetClass={0},methodName={1},value={2}", targetClass, methodName, value)); //NOI18N
+               this.getLogger().trace(MessageFormat.format("instance={0},targetClass={1},methodName={2},value={3}", instance, targetClass, methodName, value)); //NOI18N
+
+               // Get field type
+               Class<?> type = this.getType(instance, targetClass, columnName);
+
+               // Debug message
+               this.getLogger().debug(MessageFormat.format("type={0}", type)); //NOI18N
+
+               // Init object
+               Object object = value;
+
+               // Is the value null?
+               if ("null".equals(value)) { //NOI18N
+                       // Warning message
+                       this.getLogger().warn(MessageFormat.format("columnName={0} has null value.", columnName)); //NOI18N
+
+                       // Set null
+                       object = null;
+               } else {
+                       // Hard-coded "cast" again ... :-(
+                       // TODO Can't we get rid of this???
+                       switch (type.getSimpleName()) {
+                               case "Long": // Long object //NOI18N
+                                       object = Long.parseLong((String) value);
+                                       break;
+
+                               case "Float": // Float object //NOI18N
+                                       object = Float.parseFloat((String) value);
+                                       break;
+
+                               case "Boolean": // Boolean object //NOI18N
+                                       object = Boolean.parseBoolean((String) value);
+                                       break;
+
+                               case "String": // String object //NOI18N
+                                       break;
+
+                               default: // Unsupported type
+                                       throw new IllegalArgumentException(MessageFormat.format("value {0} has unsupported type {1}", value, type.getSimpleName())); //NOI18N
+                       }
+               }
+
+               // Debug message
+               this.getLogger().debug(MessageFormat.format("object={0}", object)); //NOI18N
 
                // Get method to call
-               Method method = this.getMethodFromName(instance, targetClass, methodName, value);
+               Method method = this.getMethodFromName(instance, targetClass, methodName, type);
+
+               // Debug message
+               this.getLogger().debug(MessageFormat.format("method={0},instance={1},value[{2}]={3}", method, instance, value.getClass().getSimpleName(), value)); //NOI18N
 
                // Get value from field
-               method.invoke(instance, value);
+               method.invoke(instance, object);
 
                // Trace messahe
-               this.getLogger().trace("EXIT!");
+               this.getLogger().trace("EXIT!"); //NOI18N
        }
 
        /**
@@ -724,7 +815,7 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                this.getLogger().trace(MessageFormat.format("str={0}", str)); //NOI18N
 
                // Is it null?
-               if (str == null) {
+               if (null == str) {
                        // Return empty string
                        return ""; //NOI18N
                }
@@ -746,7 +837,7 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @throws java.lang.IllegalAccessException If the method cannot be accessed
         * @throws java.lang.reflect.InvocationTargetException Any other problems?
         */
-       protected Iterator<Map.Entry<Field, Object>> fieldIterator (final Storeable instance, final String className) throws IllegalArgumentException, NoSuchMethodException, IllegalAccessException, InvocationTargetException {
+       protected Iterator<Map.Entry<Field, Object>> fieldIterator (final Storable instance, final String className) throws IllegalArgumentException, NoSuchMethodException, IllegalAccessException, InvocationTargetException {
                // Trace message
                this.getLogger().trace(MessageFormat.format("instance={0},className={1} - CALLED!", instance, className)); //NOI18N
 
@@ -835,16 +926,46 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @return DatabaseFrontend instance
         */
        protected final DatabaseFrontend getFrontend () {
-               return this.wrapper;
+               return this.frontend;
        }
 
        /**
         * Setter for wrapper instance
         *
-        * @param wrapper A DatabaseFrontend instance
+        * @param frontend A DatabaseFrontend instance
         */
-       protected final void setFrontend (final DatabaseFrontend wrapper) {
-               this.wrapper = wrapper;
+       protected final void setFrontend (final DatabaseFrontend frontend) {
+               this.frontend = frontend;
+       }
+
+       /**
+        * Setter for session id
+        *
+        * @param sessionId Session id
+        */
+       @Override
+       public final void setSessionId (final String sessionId) {
+               this.sessionId = sessionId;
+       }
+
+       /**
+        * Getter for session id
+        *
+        * @return Session id
+        */
+       @Override
+       public final String getSessionId () {
+               return this.sessionId;
+       }
+
+       /**
+        * Checks if the bundle is initialized
+        *
+        * @return Whether the bundle has been initialized
+        */
+       protected boolean isBundledInitialized () {
+               // Check it
+               return (bundle instanceof ResourceBundle);
        }
 
        /**
@@ -852,19 +973,19 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         */
        protected void initBundle () {
                // Trace message
-               this.getLogger().trace("CALLED!");
+               this.getLogger().trace("CALLED!"); //NOI18N
 
                // Is the bundle set?
-               if (bundle instanceof ResourceBundle) {
+               if (this.isBundledInitialized()) {
                        // Is already set
                        throw new IllegalStateException("called twice"); //NOI18N
                }
 
                // Set instance
-               bundle = ResourceBundle.getBundle(FrameworkInterface.I18N_BUNDLE_FILE); // NOI18N
+               setBundle(ResourceBundle.getBundle(FrameworkInterface.I18N_BUNDLE_FILE)); // NOI18N
 
                // Trace message
-               this.getLogger().trace("EXIT!");
+               this.getLogger().trace("EXIT!"); //NOI18N
        }
 
        /**
@@ -959,12 +1080,12 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                this.getLogger().trace(MessageFormat.format("key={0},value={1} - CALLED!", key, value)); //NOI18N
 
                // Both should not be null
-               if (key == null) {
+               if (null == key) {
                        // key is null
-                       throw new NullPointerException("key is null");
-               } else if (value == null) {
+                       throw new NullPointerException("key is null"); //NOI18N
+               } else if (null == value) {
                        // value is null
-                       throw new NullPointerException("value is null");
+                       throw new NullPointerException("value is null"); //NOI18N
                }
 
                // Set it
@@ -995,9 +1116,9 @@ public class BaseFrameworkSystem implements FrameworkInterface {
        }
 
        /**
-        * Some "setter" for a value in given Storeable instance and target class
+        * Some "setter" for a value in given Storable instance and target class
         * 
-        * @param instance An instance of a Storeable class
+        * @param instance An instance of a Storable class
         * @param targetClass The target class (where the field resides)
         * @param columnName Column name (= field name)
         * @param value Value to set
@@ -1005,42 +1126,42 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @throws java.lang.IllegalAccessException If the setter cannot be accessed
         * @throws java.lang.reflect.InvocationTargetException Any other problem?
         */
-       protected void setValueInStoreableFromColumn (final Storeable instance, final String targetClass, final String columnName, final String value) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
+       protected void setValueInStorableFromColumn (final Storable instance, final String targetClass, final String columnName, final Object value) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
                // Trace message
-               this.getLogger().trace("instance=" + instance + ",targetClass=" + targetClass + ",columnName=" + columnName + ",value=" + value + " - CALLED!");
+               this.getLogger().trace(MessageFormat.format("instance={0},targetClass={1},columnName={2},value={3} - CALLED!", instance, targetClass, columnName, value)); //NOI18N
 
                // A '$' means not our field
-               if (columnName.startsWith("$")) {
+               if (columnName.startsWith("$")) { //NOI18N
                        // Don't handle these
-                       throw new IllegalArgumentException("columnsName contains $");
+                       throw new IllegalArgumentException("columnsName contains $"); //NOI18N
                }
 
                // Determine if the given column is boolean
                if (this.isBooleanField(instance, targetClass, columnName)) {
                        // Debug message
-                       this.getLogger().debug("Column " + columnName + " represents a boolean field.");
+                       this.getLogger().debug(MessageFormat.format("Column {0} represents a boolean field.", columnName)); //NOI18N
 
                        // Yes, then call other method
-                       this.setBooleanField(instance, targetClass, this.convertColumnNameToSetterMethod(columnName), Boolean.parseBoolean(value));
+                       this.setBooleanField(instance, targetClass, this.convertColumnNameToSetterMethod(columnName), columnName, (Boolean) value);
                }
 
                // Convert column name to field name
                String methodName = this.convertColumnNameToSetterMethod(columnName);
 
                // Debug message
-               this.getLogger().debug(MessageFormat.format("methodName={0}", methodName));
+               this.getLogger().debug(MessageFormat.format("methodName={0}", methodName)); //NOI18N
 
                // Get field
-               this.setField(instance, targetClass, methodName, value);
+               this.setField(instance, targetClass, methodName, columnName, value);
 
                // Trace message
-               this.getLogger().trace("EXIT!");
+               this.getLogger().trace("EXIT!"); //NOI18N
        }
 
        /**
-        * Some "getter" for a value from given Storeable instance and target class
+        * Some "getter" for a value from given Storable instance and target class
         *
-        * @param instance An instance of a Storeable class
+        * @param instance An instance of a Storable class
         * @param targetClass The target class (where the field resides)
         * @param columnName Column name (= field name)
         * @return  value Value to get
@@ -1048,20 +1169,20 @@ public class BaseFrameworkSystem implements FrameworkInterface {
         * @throws java.lang.IllegalAccessException If the getter cannot be accessed
         * @throws java.lang.reflect.InvocationTargetException Some other problems?
         */
-       protected Object getValueInStoreableFromColumn (final Storeable instance, final String targetClass, final String columnName) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
+       protected Object getValueInStorableFromColumn (final Storable instance, final String targetClass, final String columnName) throws NoSuchMethodException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
                // Trace message
-               this.getLogger().trace(MessageFormat.format("instance={0},targetClass={1},columnName={2} - CALLED!", instance, targetClass, columnName));
+               this.getLogger().trace(MessageFormat.format("instance={0},targetClass={1},columnName={2} - CALLED!", instance, targetClass, columnName)); //NOI18N
 
                // A '$' means not our field
-               if (columnName.startsWith("$")) {
+               if (columnName.startsWith("$")) { //NOI18N
                        // Don't handle these
-                       throw new IllegalArgumentException("columnsName contains $");
+                       throw new IllegalArgumentException("columnsName contains $"); //NOI18N
                }
 
                // Determine if the given column is boolean
                if (this.isBooleanField(instance, targetClass, columnName)) {
                        // Debug message
-                       this.getLogger().debug("Column " + columnName + " represents a boolean field.");
+                       this.getLogger().debug(MessageFormat.format("Column {0} represents a boolean field.", columnName)); //NOI18N
 
                        // Yes, then call other method
                        return this.getBooleanField(instance, targetClass, this.convertColumnNameToGetterMethod(columnName, true));
@@ -1071,15 +1192,87 @@ public class BaseFrameworkSystem implements FrameworkInterface {
                String methodName = this.convertColumnNameToGetterMethod(columnName, false);
 
                // Debug message
-               this.getLogger().debug(MessageFormat.format("methodName={0}", methodName));
+               this.getLogger().debug(MessageFormat.format("methodName={0}", methodName)); //NOI18N
 
                // Get field
                Object value = this.getField(instance, targetClass, methodName);
 
                // Trace message
-               this.getLogger().trace("value=" + value + " - EXIT!");
+               this.getLogger().trace(MessageFormat.format("value={0} - EXIT!", value)); //NOI18N
 
                // Return value
                return value;
        }
+
+       /**
+        * Some getter for type reflection of given column name
+        *
+        * @param instance The instance to check
+        * @param targetClass Target class to check
+        * @param columnName Column name
+        * @return Type reflection of value
+        */
+       private Class<?> getType (final FrameworkInterface instance, final String targetClass, final String columnName) {
+               // Trace message
+               this.getLogger().trace(MessageFormat.format("instance={0},targetClass={1},columnName={2} - CALLED!", instance, targetClass, columnName)); //NOI18N
+
+               // Init field tye
+               Class<?> type = null;
+
+               // Get super class fields
+               Field[] superFields = this.getClassFromTarget(instance, "BaseFrameworkSystem").getDeclaredFields(); //NOI18N
+
+               // Get all attributes from given instance
+               Field[] fields = ArrayUtils.addAll(superFields, this.getClassFromTarget(instance, targetClass).getDeclaredFields());
+
+               // Debug message
+               this.getLogger().debug(MessageFormat.format("fields()={0}", fields.length)); //NOI18N
+
+               // Convert column_name to fieldName ;-)
+               String fieldName = this.convertColumnNameToFieldName(columnName);
+
+               // Debug message
+               this.getLogger().debug(MessageFormat.format("fieldName={0}", fieldName)); //NOI18N
+
+               // Search for proper field instance
+               for (final Field field : fields) {
+                       // Is a dollar character there?
+                       if (field.getName().startsWith("$")) { //NOI18N
+                               // Debug message
+                               this.getLogger().debug(MessageFormat.format("Field name {0} starts with a dollar, skipped.", field.getName())); //NOI18N
+                               // Skip this
+                               continue;
+                       }
+
+                       // Debug message
+                       this.getLogger().debug(MessageFormat.format("field.getName()={0},fieldName={1}", field.getName(), fieldName)); //NOI18N
+
+                       // Does it match?
+                       if (field.getName().equals(fieldName)) {
+                               // Found it
+                               type = field.getType();
+
+                               // Debug message
+                               this.getLogger().debug(MessageFormat.format("Found fieldName={0}: setting type={1}", fieldName, type.getSimpleName())); //NOI18N
+
+                               // Don't continue with searching
+                               break;
+                       }
+               }
+
+               // Debug message
+               this.getLogger().debug(MessageFormat.format("type={0}", type)); //NOI18N
+
+               // type should not be null
+               if (null == type) {
+                       // No null allowed
+                       throw new NullPointerException("type is null"); //NOI18N
+               }
+
+               // Trace message
+               this.getLogger().debug(MessageFormat.format("type={0} - EXIT!", type)); //NOI18N
+
+               // Return it
+               return type;
+       }
 }