case sensitivity issue in mysql (linux on vm7)

Set how table and database names are stored on disk and used in MySQL is affected by the​lower_case_table_names system variable, which you can set when starting ​mysqld.

lower_case_table_names=2

[Info : ​http://download.oracle.com/docs/cd/E17952_01/refman-5.1-en/identifier-case-sensitivity.html]

Spss Export

Add log4j.logger.org.apache.commons.digester=OFF

log4j.logger.org.ajax4jsf=ERROR

log4j.logger.org.apache.commons.digester=ERROR

log4j.logger.org.apache.commons.beanutils=ERROR

in log4j settings . Where that lives?

"META-INF/log4j.properties" --> /gcc_lifelines/handwritten/java/log4j.properties

Another spss writer java library

​http://sourceforge.net/projects/spss-writer/

SPSS file format

male 	37 102
male 	22 115
male 	27 99
....    .. ...
female  48 107
female  21 103
female  28 122
......  .. ...

================================

In this specific example there are 	

1. There are 3 variables
2. Variable 1 is a string , Variable 2 and 3 are numeric
3. Variable 1: first column=1, last column=6
   • Notice that none of the columns overlap. The longest case for column one is the name "female", that spans from the first column to the sixth - or, the letter e. As you can see, one has to manually locate the first and last column, of each variable.
4. Variable 2: first column=9, last column=10
5. Variable 3: first column=12, last column=14

-----------------------------

The corresponding variables are the columns that are selected by the user in the UI , this is returned by getColNames() , and the data of this matrix are returned by the matrix.getData(); for example if the user has selected in the matrix viewer : PA_ID , ztgewicht and gewicht  the exported SPSS file should contain : 

PA_ID     1 2 3 4 3 7

ztgewicht 1 2 3 4 3 7

gewicht   1 2 3 4 3 7

BBMRI on VM7

• Admin page is shown in first page . (without login ) - delete user - mysql> delete from molgenispermission where id = 7;
• Admin cannot see the Biobank contents (Admin is set to View All) * restart server  - change setting on view settings  - still remaining the same problem .