Monthly Archives: September 2008

Call SQL procedure and function with JDBC and Hibernate

  This article is to give some introductions of how to call the SQL procedure and function with JDBC and Hibernate feature.   Call SQL Procedure with JDBC   connection = openSessionInViewInterceptor .getSessionFactory().openStatelessSession().connection(); CallableStatement callableStatement = connection .prepareCall("call proc_my_procedure(?)"); callableStatement.setObject("in_user … Continue reading

Posted in Database | 10 Comments

Some explanation of XML Schema namespace using with Axis Web Service

We will use the following example to explain how schema works <xs:schema xmlns:xs="; xmlns:x="urn:sapParam" targetNamespace="urn:sapParam" elementFormDefault="qualified" attributeFormDefault="unqualified">                 <xs:complexType name="mainTable">                                 <xs:sequence>                                                 <xs:element name="child_email" type="x:TableOfChildEmail" nillable="true" minOccurs="0" maxOccurs="unbounded"/>                                                 <xs:element name="ipaddress_range" type="x:TableOfIpaddress" nillable="true" minOccurs="0" maxOccurs="unbounded"/>                                                 <xs:element name="website" nillable="false" … Continue reading

Posted in Web Service | Leave a comment