Nov 23, 2010

sqlplus syntax

sqlplus sys/oracle@:/ as sysdba
eg:sqlplus sys/oracle@10.177.219.131:1521/orcl.idc.oracle.com as sysdba

Oct 19, 2010

Generate Java Code from WSDL

Overview

The wsimport tool generates JAX-WS portable artifacts, such as:

  • Service Endpoint Interface (SEI)
  • Service
  • Exception class mapped from wsdl:fault (if any)
  • Async Reponse Bean derived from response wsdl:message (if any)
  • JAXB generated value types (mapped java classes from schema types)

These artifacts can be packaged in a WAR file with the WSDL and schema documents along with the endpoint implementation to be deployed. also provides wsimport ant task, see Wsimport ant task.

Launching wsimport

  • Solaris/Linux
    • /bin/wsimport.sh -help
  • Windows
    • \bin\wsimport.bat -help

Syntax

wsimport [options] 

The following table lists the wsimport options.

Option

Description

-d   

Specify where to place generated output files

-b   

Specify external JAX-WS or JAXB binding files (Each must have its own -b)

-B 

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::  

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   

Specify where to place generated source files

-verbose  

Output messages about what the compiler is doing

-version  

Print version information

-wsdllocation  
@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

Multiple JAX-WS and JAXB binding files can be specified using -b option and they can be used to customize various things like package names, bean names, etc. More information on JAX-WS and JAXB binding files can be found in the customization documentation.

Example

wsimport -p stockquote http://stockquote.xyz/quote?wsdl
This will generate the Java artifacts and compile them by importing the http://stockquote.xyz/quote?wsdl.


Ant task

An Ant task for the wsimport tool is provided along with the tool. The attributes and elements supported by the Ant task are listed below:

        wsdl="..."     

destdir="directory for generated class files"
sourcedestdir="directory for generated source files"
keep="true|false"
extension="true|false"
verbose="true|false"
version="true|false"
wsdlLocation="..."
catalog="catalog file"
package="package name"



Attribute

Description

Command line

wsdl

WSDL file

WSDL

destdir

Specify where to place output generated classes

-d

sourcedestdir

Specify where to place generated source files, keep is turned on with this option

-s

keep

Keep generated files, tunred on with sourcedestdir option

-keep

verbose

Output messages about what the compiler is doing

-verbose

binding

Specify external JAX-WS or JAXB binding files

-b

extension

allow vendor extentions (funcionality not specified by the specification). Use of extensions may result in applications that are not portable or may not interoperate with other implementations

-extension

wsdllocation
The wsdl URI passed thru this option will be used to set the value of @WebService.wsdlLocation and @WebServiceClient.wsdlLocation annotation elements on the generated SEI and Service interface
-wsdllocation
catalog
Specify catalog file to resolve external entity references, it supports TR9401, XCatalog, and OASIS XML Catalog format. Additionally, ant xmlcatalog type can be used to resolve entities, see wsimport_catalog sample.
-catalog
package
Specifies the target package -p

The binding attributes is like a path-like structure and can also be set via nested elements, respectively. Before this task can be used, a element needs to be added to the project as given below:




where jaxws.classpath is a reference to a path-like structure, defined elsewhere in the build environment, and contains the list of classes required by the JAX-WS tools.

Examples

destdir="${build.classes.home}"
debug="true"
wsdl="AddNumbers.wsdl"
binding="custom.xml"/>


The above example generates client-side artifacts for AddNumbers.wsdl, stores .class files in the ${build.classes.home} directory using the custom.xml customization file. The classpath used is xyz.jar and compiles with debug information on.

keep="true"
sourcedestdir="${source.dir}"
destdir="${build.classes.home}"
wsdl="AddNumbers.wsdl">




The above example generates portable artifacts for AddNumbers.wsdl, stores .java files in the ${source.dir} directory, stores .class files in the ${build.classes.home} directory.

Source: https://jax-ws.dev.java.net/jax-ws-ea3/docs/wsimport.html


Oct 6, 2010

What are PermSize and MaxPermSize and how they work in Java?

Permanent Generation (which is “Perm” in PermSize)

The permanent generation is used to hold reflective of the VM itself such as class objects and method objects. These reflective objects are allocated directly into the permanent generation, and it is sized independently from the other generations. Generally, sizing of this generation can be ignored because the default size is adequate. However, programs that load many classes may need a larger permanent generation.

PermSize is additional separate heap space to the -Xmx value set by the user. The section of the heap reserved for the permanent generation holds all of the reflective data for the JVM. You should adjust the size accordingly if your application dynamically load and unload a lot of classes in order to optimize the performance.

By default, MaxPermSize will be 32mb for -client and 64mb for -server. However, if you do not set both PermSize and MaxPermSize, the overall heap will not increase unless it is needed. When you set both PermSize and MaxPermSize, for example, 192mb, the extra heap space will get allocated when it startup and will stay allocated.

Source : http://www.dbuggr.com/smallwei/permsize-maxpermsize-work-java/

Sep 27, 2010

Oracle DB 11g Uninstallation.

In order to uninstall Oracle Database 11g go to "deinstall" directory in $ORACLE_HOME:

echo
$ORCALE_HOME

/u01/app/oracle/product/11.2.0

cd $ORACLE_HOME/dbhome_1/deinstall

#run deinstall script (none a graphical):
sh deinstall



Source: http://www.emarcel.com/emarcel/database/114-uninstalldb11g

Sep 22, 2010

ADF Faces - Relationship Between Scopes and Page Flow



Source : http://download.oracle.com/docs/cd/E15523_01/web.1111/b31973/af_lifecycle.htm#CHDGGGBI

Important News Related to Sun Certification

New Certification Titles (Effective September 1, 2010)

Use the following table to see how the Sun Certification titles have been rebranded under the Oracle Certification program.

Former Sun Certification Title New Oracle Certification Title
JAVA TECHNOLOGY
Sun Certified Java Associate Oracle Certified Associate, Java SE 5/SE 6
Sun Certified Java Programmer (SCJP) SE 5 Oracle Certified Professional, Java SE 5 Programmer
Sun Certified Java Programmer (SCJP) SE 6 Oracle Certified Professional, Java SE 6 Programmer
Sun Certified Java Developer (SCJD) Oracle Certified Master, Java SE6 Developer
Sun Certified Web Component Developer (SCWCD) EE5 Oracle Certified Professional, Java EE 5 Web Component Developer
Sun Certified Business Component Developer (SCBCD) EE5 Oracle Certified Professional, Java EE 5 Business Component Developer
Sun Certified Developer for Java Web Services 5 (SCDJWS) Oracle Certified Professional, Java EE 5 Web Services Developer
Sun Certified Enterprise Architect (SCEA) EE5 Oracle Certified Master, Java EE 5 Enterprise Architect
Sun Certified Mobile Application Developer (SCMAD) Oracle Certified Professional, Java ME 1 Mobile Application Developer
Sun Certified JSP and Servlet Developer for the Java EE6 Platform Oracle Certified Professional, Java Platform, Enterprise Edition 6 JavaServer Pages and Servlet Developer
Sun Certified EJB Developer for the Java EE6 Platform Oracle Certified Professional, Java Platform, Enterprise Edition 6 Enterprise JavaBeans Developer
Sun Certified JPA Developer for the Java EE6 Platform Oracle Certified Professional, Java Platform, Enterprise Edition 6 Java Persistence API Developer
Sun Certified Developer for the Java Web Services for the Java EE6 Oracle Certified Professional, Java Platform, Enterprise Edition 6 Web Services Developer
Sun Certified Developer for the JSF for the Java EE6 Platform Oracle Certified Professional, Java Platform, Enterprise Edition 6 JavaServer Faces Developer
ORACLE SOLARIS
Sun Certified Solaris Associate (SCSAS) Oracle Certified Associate, Oracle Solaris 10 Operating System
Sun Certified System Administrator (SCSA) for Solaris OS 10 Oracle Certified Professional, Oracle Solaris 10 System Administrator
Sun Certified Network Administrator (SCNA) for Solaris OS 10 Oracle Certified Expert, Oracle Solaris 10 Network Administrator
Sun Certified Security Administrator (SCSECA) for Solaris OS 10 Oracle Certified Expert, Oracle Solaris 10 Security Administrator
MYSQL, OPENOFFICE, ORACLE SOLARIS CLUSTER
Sun Certified MySQL 5.0 Database Administrator (SCMDBA) Oracle Certified Professional, MySQL 5.0 Database Administrator
Sun Certified MySQL 5.0 Developer (SCMDEV) Oracle Certified Professional, MySQL 5.0 Developer
Sun Certified MySQL Associate (SCMA) Oracle Certified Associate, MySQL 5.0/5.1/5.5
Sun Certified MySQL 5.1 Cluster Database Administrator (SCMCDBA) Oracle Certified Expert, MySQL 5.1 Cluster Database Administrator
Sun Certified System Administrator for Sun Cluster 3.2 Oracle Certified Professional, Oracle Solaris Cluster 3.2 System Administrator
Sun Certified OpenOffice.org Calc Specialist Oracle Certified Expert, OpenOffice.org Calc
Sun Certified OpenOffice.org Impress Specialist Oracle Certified Expert, OpenOffice.org Impress
Sun Certified OpenOffice.org Writer Specialist Oracle Certified Expert, OpenOffice.org Writer
Sun Certified Specialist for NetBeans IDE Oracle Certified Expert, NetBeans Integrated Development Environment 6.1 Programmer


Source : http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=433&p_org_id=1080544&lang=US

Sep 16, 2010

Block/Enable usage of USB Removable Disks

Block usage of USB Removable Disks

To block your computer's ability to use USB Removable Disks follow these steps:

  1. Open Registry Editor.
  2. In Registry Editor, navigate to the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\USBSTOR
  1. Locate the following value (DWORD):

Start and give it a value of 4.

Note: As always, before making changes to your registry you should always make sure you have a valid backup. In cases where you're supposed to delete or modify keys or values from the registry it is possible to first export that key or value(s) to a .REG file before performing the changes.

  1. Close Registry Editor. You do not need to reboot the computer for changes to apply.

Enable usage of USB Removable Disks

To return to the default configuration and enable your computer's ability to use USB Removable Disks follow these steps:

  1. Go to the registry path found above.
  1. Locate the following value:
Start and give it a value of 3.