Friday, October 16, 2015

A day in a Developer's life..

If you have the following requirements upon executing command in a batch file: -

1) Do not display the command being executed on the UI Solution --
echo off
cls

2) Prevent the DOS window from getting closed automatically on completion of the commands in the batch file by prompting the user to enter input is achieved by prefixing the command with cmd \k

3) Add the below commands in windows batch file if you are getting the annoying message - "Picked up JAVA_TOOL_OPTIONS: -agentlib:jvmhook ....

Solution is to unset below env variables as:
echo off
SET JAVA_TOOL_OPTIONS=
SET _JAVA_OPTIONS=
cls



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

To compare two similar excel files having many worksheets, one may download the plugin:
Spreadsheet_Compare_Setup_v1.34.8

It is downloadable from and is compatible from Excel 2000 or later:
http://sourceforge.net/projects/spreadshcompare/?source=typ_redirect


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

The classpath for this project does not appear to contain the necessary libraries to proceed with class generation.
Please insure that a JAXB implementation is available on the classpath. Couldn't find the main class com.sun.tools.xjc.XJFacade

Check with the installed JRE in eclipse

Preference > Java > Installed JRE

If it points to jre then point it to jdk installation directory.

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

Class Cast Exception when trying to unmarshall xml?


Source source = new StreamSource(inputStream);
JAXBElement<FooClass> root = unmarshaller.unmarshal(source, FooClass.class);
FooClass foo = root.getValue();
================================

Unit Test for JAXB 2.0 Marshalling


http://stackoverflow.com/questions/12125245/how-to-write-a-unit-test-for-jaxb-2-0-marshalling


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


A simple fix for this problem - rather than worrying about adding additional plugins or installs - is to install Eclipse IDE for Java EE Developers rather than Eclipse Classic (both to be found here). This comes with the JAXB support and therefore provides the >Generate>Jaxb classes option.


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

Unknown object in stream 

bouncy castle PGP object factory


This issue has no resolution upon searching in google. However, All I did was to catch the exception and voila!. The decryption worked like charm. This issue doesn't occur if the size of the encrypted data is small. You'll encounter this kind of error when the size of the encrypted data is bit larger than usual. 



========================================================================
Change the encoding from UTF-8 to ISO-8859-1
This will fix the xml parsing error - " Input is not proper UTF-8, indicate encoding!, Bytes: 0x96, 0x20, 0x42 0x61


========================================================================
If encountering "The given SOAPAction http://soa.jboss.org/serviceOp does not match an operation."

Reason could be that the endpoint URL and the WSDL  in SoapUI aren't compatible.
Still, one could submit the requests in this scenario and to avoid receiving the above error message, Please set the "Skip SOAP Action" Test step property as true.
Issue resolved! No need to import the corresponding WSDL of the endpoint service.

========================================================================
To find the size of a table (having name SERVICETABLE) in kilobytes


SELECT T.TABNAME, T.TABSCHEMA, COLCOUNT, TYPE, (DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SIZE + LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE + XML_OBJECT_P_SIZE) AS TOTAL_SIZE
FROM SYSCAT.TABLES AS T, SYSIBMADM.ADMINTABINFO AS A
WHERE T.TABNAME = A.TABNAME and t.tabname='SERVICETABLE'

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

To find the duplicates in a table:
select requesthash, count(requesthash) from SERVICETABLE group by requesthash having count(requesthash)>1

No comments: