Java 11 and Groovy Compatibility and JAXBContext !

If you see the following error during compile : 

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':compileTestGroovy'.
> org/codehaus/groovy/ast/MethodCallTransformation


Add the folling line to your gradle file :

ext['groovy.version'] = '2.5.6'  //i.e your grovy version.


Another issues with java 11

 Unable to load class groovy.xml.jaxb.Jaxb GroovyMethods due to missing dependency javax/xml/bind/JAXBContext 

You can fix this by adding the following dependency on the latest groovy version

Useful Unix Commands

1. Count number of lines on all the files in the current folder

wc -l *

2. Count the number of files on the current directory :

ls | wc -l

3. Print all the line containing word/s in a file
grep -iw "search words" arc.log

4. Thread dumping for a process
 jcmd 8308 JFR.start duration=100s filename=tempo.jfr

Simple hack to Update System Properties and Environment variables on Window !

If you don't have a permission to edit the System variable on your local window machine, the following hack might work

Click Window and  type "SystemPropertiesAdvanced"  on Search programs and file search text option. Then, once you see the SystemPropertiesAdvanced shortcut, right click it and open it as an administrator.  You might be able to edit it now.

MySql Query to turn ON Query statistics I/O

SET STATISTICS IO ON
SET STATISTICS TIME ON
SELECT er.ReportID, er.ReportName, er.ReportNumber
FROM dbo.EmployeeReports er
WHERE er.ReportNumber LIKE '%33%'
SET STATISTICS IO OFF
SET STATISTICS TIME OFF

MySQL Nested Case SQL statements (CASE WHEN OR THEN ELSE END )

Following is an example of nested MySQL Case When or then else End statement.

select
  CASE
  When (table.field1 = '01')
    THEN
      CASE
      When (SUBSTRING_INDEX(table.field1, ' ', 1) = 'abc')
         THEN '01abc'
         ELSE 'abc'
      END
  WHEN (table.field1 = '02')
    THEN
      CASE
      When ((SUBSTRING_INDEX(table.field1, ' ', 1)) = 'def')
        THEN '02def'
        ELSE 'def'
      END
  When (table.field1 = '03')
    THEN
      CASE
      When ((SUBSTRING_INDEX(table.field1, ' ', 1)) = 'efg')
        THEN '03efg'
      ELSE 'efg'
      END
  WHEN (table.field1 = '04')
    THEN
      CASE
      When ((SUBSTRING_INDEX(table.field1, ' ', 1)) = 'pqr')
        THEN '04pqr'
      ELSE 'pqr'
      END
  END
from table ;

Is this the beginning of the end of BitCoin, Etherum and LiteCoin ? Did it really crashed today evening ??

The BitCoin was traded at $14,212 at 6:40 PM CST, December 19 2017. The price is almost 27% less than its highest value. At the time of the post of this blog, the BitCoin is now backed up to $17,149 

The Etherum was traded at $705 at 6:40 PM CST, December 19 2017. The price is almost 17% less than its highest value. At the time of the post of this blog, the Etherum is now backed up to $772 The

LiteCoin was traded at $277 at 6:40 PM CST, December 19 2017. The price is almost 37% less than its highest value of $371. At the time of the post of this blog, the LiteCoin is now backed up to $320 

Where as the Bitcoin Cash is enjoying a ride of $3100 per bitcoin cash which is almost 41% higher than its yesterday's price.

Fix for xcrun: error: invalid active developer path after updating your mac OS to Sierra

If you are geting the following error with Git or any other tools while running it on from your terminal
 xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun. 

 using the following command to fix it
xcode-select --install