Thursday, January 29, 2015

Generating the client files from a WSDL in JAVA6 [Windows]

Every JDK has wsimport bat file. You can find in JAVA_HOME\bin.

Go to specific location and run wsimport command as shown in below

The above command will generate client files in c:\tmp\uploaded, Here is the wsimport options.

Option
Description
-d <directory>  
Specify where to place generated output files
-b <path>  
Specify external JAX-WS or JAXB binding files (Each <file> must have its own -b)
-B <jaxbOption>
Pass this option to JAXB schema compiler
-catalog
Specify catalog file to resolve external entity references, it supports TR9401, XCatalog, and OASIS XML Catalog format. Please read the documentation of catalog and see catalog sample.
-extension  
Allow vendor extensions (functionality not specified by the specification). Use of extensions may result in applications that are not portable or may not interoperate with other implementations
-help  
Display help
-httpproxy:<host>:<port>  
Specify an HTTP proxy server (port defaults to 8080)
-keep  
Keep generated files
-p  
Specifying a target package via this command-line option, overrides any wsdl and schema binding customization for package name and the default package name algorithm defined in the specification
-s <directory>  
Specify where to place generated source files
-verbose  
Output messages about what the compiler is doing
-version  
Print version information
-wsdllocation <location> 
@WebServiceClient.wsdlLocation value
-target  
Generate code as per the given JAX-WS specification version. version 2.0 will generate compliant code for JAX-WS 2.0 spec.
-quiet  
Suppress wsimport output

To generate in specific package format use below command:

Sample command:
wsimport -d c:\tmp -p com.csc.kiran.classes http://xyz?wsdl

here all the geneated classes will be inside the package : com.csc.kiran.classes

Monday, January 5, 2015

To delete duplicate entries from a table in oracle


To delete a duplicate entry from a table use the below query:

delete from np_tld where rowid in (select max(rowid) from np_tld group by tld having count(*) > 1)

The above query return the all the group by tld's which is having count more than 1 with in that it will select the max row id , we are going to delete all those records.