Wednesday, October 26, 2016

Hibernate Display Real SQL Queries

if I set
true
in my hibernate.cfg.xml configuration file in the console I can see the SQL.
But it's not real SQL... Can I see the SQL code that will be passed directly to database?

Example:
I see
select this_.code from true.employee this_ where this_.code=?

Can I see
select employee.code from employee where employee.code=12

the real SQL?

Only Solution is http://www.mkyong.com/hibernate/how-to-display-hibernate-sql-parameter-values-solution/

Friday, September 2, 2016

Staying Fully Charged

https://spark.adobe.com/video/0oDJWtBkGvrSV

this model has been created by Paul Martin , over the past few years.  Thanks to him for sharing same.

If it helps you stay fully charged.

Wednesday, March 9, 2016

Saturday, February 27, 2016

REST API : Using the Correct Return Types

What should DELETE return ?
Depending on the case can return following.

  • 200 OK, if the resource is deleted successfully and there is something to tell the client.
  • 202 Accepted, if the request is accepted but not deleted yet. This response should include some indications. Kind of batch delay , or if deletion takes time or resource marked for deletion and actual deletion happens later...
  • 204 No Content,  if the resource is deleted successfully and there is nothing to tell the client.
  • In subsequent following ‘delete’ request return  404 , if resource doesn’t exists and it’s already deleted …. Idempotence is not about always returning the same result each time (I'm looking at you Twitter).  it just means that issuing the same request multiple times won't produce additional side effects  
What should PUT return ?

The HTTP specification (RFC 2616) has a number of recommendations that are applicable. Here is my interpretation:
  • HTTP status code 200 OK for a successful PUT of an update to an existing resource. No response body needed. (Per Section 9.6, 204 No Content is even more appropriate.)
  • HTTP status code 201 Created for a successful PUT of a new resource, with the most specific URI for the new resource returned in the Location header field and any other relevant URIs and metadata of the resource echoed in the response body. (RFC 2616 Section 10.2.2)
  • HTTP status code 409 Conflict for a PUT that is unsuccessful due to a 3rd-party modification, with a list of differences between the attempted update and the current resource in the response body. (RFC 2616 Section 10.4.10)
  • HTTP status code 400 Bad Request for an unsuccessful PUT, with natural-language text (such as English) in the response body that explains why the PUT failed. (RFC 2616 Section 10.4)


What can POST return
  • 201 : for immediate successful creation. Body has the unique if of created entity.
  • 202 : if request to create is taken successfully, but creation is not complete yet.
  • 500 : server side error in creation.

 Following Flow Diagram can be useful


Thursday, February 4, 2016

Java Endorsed

What is the concept of endorsed directory??
To put it in simple words , Suppose I have a class called Some.class which is present in two jar files named file1.jar and file2.jar.

Suppose I have following  directory & file structure:
  • lib\file1.jar
  • lib\endorsed\file2.jar

Then Some.class will be called from file2.jar get called.

More Details at
  • http://docs.oracle.com/javase/6/docs/technotes/guides/standards/ 
  • http://stackoverflow.com/questions/2859471/what-is-the-exact-way-to-use-endorsed-directory-in-jdk1-6 
Way to do it in pom.xml

<plugins>
    <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>2.3.2</version>
        <configuration>
            <source>1.6</source>
            <target>1.6</target>
            <compilerArguments>
                <endorseddirs>${endorsed.dir}</endorseddirs>
            </compilerArguments>
        </configuration>
    </plugin>
</plugins>
 


Why do i need it ?
 it is a mechanism to provide newer versions of an endorsed standard than those included in the Java 2 Platform.
 
Which means, a user can provide newer versions of certain packages than those provided by the JDK. If there are newer implementations of these packages in the directories specified by java.endorsed.dirs, those implementations will be loaded instead of the default ones that come with the JDK.

Roughly speaking the Endorsed Standards APIs include:
  • javax.rmi.CORBA
  • various org.omg.* packages
  • org.w3c.dom
  • various org.xml.sax.* packages

Monday, January 4, 2016

Jasper Tabular Display : Use of views

http://stackoverflow.com/questions/18599795/jasper-reports-align-dynamic-text-fields-and-their-labels-horizontally?lq=1
above link helped me solve a good issue ... where i had variable contents in each row ( in a table ) , Helped me understand Use of Frames.

Thursday, December 3, 2015

Oracle SQL

Nice tutorial



We had a scenario , where we broke a master table CLOB column , into multiple rows in child tables VARCHAR2.
Functions LISTAGG and XMLAGG didn't help us , we keep getting 'concatinated string too large' error.... the above link helped us