Share Views Share Knowledge

Gmail 2 factor authentication using selenium webdriver in java

2019-04-20T10:49:00.002-07:00

import java.util.concurrent.TimeUnit;

import org.jboss.aerogear.security.otp.Totp;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.openqa.selenium.support.ui.ExpectedConditions;
import org.openqa.selenium.support.ui.WebDriverWait;

public class Gmail2FA {

    public static void main(String[] args) {

        System.setProperty("webdriver.gecko.driver","D:\\QA\\geckodriver-v0.24.0-win64\\geckodriver.exe");
        WebDriver driver = new FirefoxDriver();
        String baseUrl = "https://gmail.com";

        driver.get(baseUrl);


        driver.manage().window().maximize();

        driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);

      WebElement email_phone =          driver.findElement(By.xpath("//input[@id='identifierId']"));
        email_phone.sendKeys("<<YOUR ACCOUNT>>@gmail.com");
        driver.findElement(By.id("identifierNext")).click();

   WebElement password = driver.findElement(By.xpath("//input[@name='password']"));
        WebDriverWait wait = new WebDriverWait(driver, 20);
        wait.until(ExpectedConditions.elementToBeClickable(password));
        password.sendKeys("<<YOUR PASSWORD>>");
        driver.findElement(By.id("passwordNext")).click();


        String otpKeyStr;

        String twoFactorCode;

        otpKeyStr = "4wer 43r5 bsz5g liec vr5s dgtw"; // <- this 2FA secret key.

        Totp totp = new Totp(otpKeyStr);

        twoFactorCode = totp.now();

       // logger.info(twoFactorCode);

              WebElement enter2FA = driver.findElement(By.xpath("//input[@id='totpPin']"));

       enter2FA.sendKeys(twoFactorCode);
       wait.until(ExpectedConditions.elementToBeClickable(enter2FA));
       driver.findElement(By.className("CwaK9")).click();

        //logger.info("Clicking on the submit button");
//RveJvd snByac
        //clickBtn.click();

        //sleep(2);

    }

}

The type List is not generic; it cannot be parameterized with arguments <>

2016-07-30T09:54:00.002-07:00

Error:
The type List is not generic; it cannot be parameterized with arguments <

Solution:

Change
import java.awt.List;

To

import java.util.List;

How to add Oracle JDBC driver in your Maven local repository

2016-07-16T23:47:00.002-07:00

Oracle does not provide library to maven. So we need to download the jar and add path to the project.

Below is the process for installing ojdbc14.jar to maven

Step1: Download ojdbc14.jar from oracle website

Step2: Save it to a folder and in command prompt navigate to respective folder
E.g: C:\Users\Anand\Desktop

Step3: Run the below command

mvn install:install-file -DgroupId=com.oracle -Dartif
actId=ojdbc14 -Dversion=10.2.0.1.0 -Dpackaging=jar -Dfile=ojdbc14.jar -Dgenerate
Pom=true

Yow will get below messages on successful installation

[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Maven Stub Project (No POM) 1
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-install-plugin:2.4:install-file (default-cli) @ standalone-pom
---
[INFO] Installing C:\Users\AnandBaba\Desktop\ojdbc14.jar to C:\Users\AnandBaba\.
m2\repository\com\oracle\ojdbc14\10.2.0.1.0\ojdbc14-10.2.0.1.0.jar
[INFO] Installing C:\Users\ANANDB~1\AppData\Local\Temp\mvninstall910411268917029
3395.pom to C:\Users\AnandBaba\.m2\repository\com\oracle\ojdbc14\10.2.0.1.0\ojdb
c14-10.2.0.1.0.pom
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 2.432 s
[INFO] Finished at: 2016-07-17T12:08:50+05:30
[INFO] Final Memory: 6M/123M
[INFO] ------------------------------------------------------------------------
C:\Users\Anand\Desktop>

Step3:
Add below dependency in pom.xml

<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.1.0</version>
</dependency>

Exception in thread "main" com.sun.xml.internal.ws.spi.db.DatabindingException

2015-10-18T09:35:00.002-07:00

While implementing jax-ws web client using wsimport sometimes you will get the below error.

Problem:

Exception in thread "main" com.sun.xml.internal.ws.spi.db.DatabindingException: com.sun.xml.internal.bind.v2.runtime.IllegalAnnotationsException: 2 counts of IllegalAnnotationExceptions
Two classes have the same XML type name "{http://AkServices.com/}getReturnText". Use @XmlType.name and @XmlType.namespace to assign different names to them.
this problem is related to the following location:

Solution:
wsimport -keep http://localhost:8080/MySoapWebService/hello?wsdl -target 2.0

(Generate code as per the given JAX-WS specification version. version 2.0 will generate compliant code for JAX-WS 2.0 spec.)

Hibernate Example

2015-02-22T06:52:00.001-08:00

Below is the working example of Hibernate 4.0 with oracle 11g express edition as database.

Create Table:

create table EMPLOYER
(
id         NUMBER not null,
first_name VARCHAR2(20),
last_name VARCHAR2(20),
salary     INTEGER
)

Java Code:

Step1: Create New Maven Project HibernateExample
Step2: Create pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>

<groupId>com.hibernate</groupId>
<artifactId>HibernateExample</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>

<name>HibernateExample</name>
<url>http://maven.apache.org</url>

<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>

<dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>4.0.1.Final</version>
        </dependency>
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-validator</artifactId>
            <version>4.2.0.Final</version>
        </dependency>
        <dependency>
            <groupId>org.hibernate.common</groupId>
            <artifactId>hibernate-commons-annotations</artifactId>
            <version>4.0.1.Final</version>
            <classifier>tests</classifier>
        </dependency>
        <dependency>
            <groupId>org.hibernate.javax.persistence</groupId>
            <artifactId>hibernate-jpa-2.0-api</artifactId>
            <version>1.0.1.Final</version>
        </dependency>
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-entitymanager</artifactId>
            <version>4.0.1.Final</version>
        </dependency>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0</version>
        
        </dependency>
        <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-simple</artifactId>
    <version>1.6.1</version>
</dependency>
</dependencies>
</project>

Step3: Create pojo class

package com.hibernate.HibernateExample;

import java.io.*;

public class Employee implements Serializable {
    /**
    *
    */
    private static final long serialVersionUID = 1L;
    private int id;
    private String firstName;
    private String lastName;
    private int salary;

    public Employee() {}
    public Employee(int id,String fname, String lname, int salary) {
        this.id=id;
        this.firstName = fname;
        this.lastName = lname;
        this.salary = salary;
    }
    public int getId() {
        return id;
    }
    public void setId( int id ) {
        this.id = id;
    }
    public String getFirstName() {
        return firstName;
    }
    public void setFirstName( String first_name ) {
        this.firstName = first_name;
    }
    public String getLastName() {
        return lastName;
    }
    public void setLastName( String last_name ) {
        this.lastName = last_name;
    }
    public int getSalary() {
        return salary;
    }
    public void setSalary( int salary ) {
        this.salary = salary;
    }
}

Step4: Create hbm.xml file

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.hibernate.HibernateExample">
   <class name="Employee" table="EMPLOYER">
      <meta attribute="class-description">
         This class contains the employee detail.
      </meta>
      <id name="id" type="int" column="ID">
         <generator class="native"/>
      </id>
      <property name="firstName" column="FIRST_NAME" type="string"/>
      <property name="lastName" column="LAST_NAME" type="string"/>
      <property name="salary" column="SALARY" type="int"/>
   </class>
</hibernate-mapping>

Step5: Create cfg.xml file

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>


<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

<property name="connection.url">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)))</property>
<property name="connection.username">username</property>
<property name="connection.password">password</property>



<property name="show_sql">true </property>
<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hbm2ddl.auto">update </property>



<mapping resource="Employee.hbm.xml"/>


</session-factory>
</hibernate-configuration>

Step6: Create Main class

package com.hibernate.HibernateExample;

import java.util.List;
import java.util.Date;
import java.util.Iterator;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;

public class ManageEmployer {
   private static SessionFactory factory;
// private static SessionFactory sessionFactory;
   private static ServiceRegistry serviceRegistry;

public static void main(String[] args) {
      try{
        // factory = new Configuration().configure().buildSessionFactory();



         Configuration configuration = new Configuration();
         configuration.configure("hibernate.cfg.xml");
         serviceRegistry = new ServiceRegistryBuilder().applySettings(
                 configuration.getProperties()).buildServiceRegistry();
         factory = configuration.buildSessionFactory(serviceRegistry);
     }catch (Throwable ex) {
         System.err.println("Failed to create sessionFactory object." + ex);
         throw new ExceptionInInitializerError(ex);
      }
   ManageEmployer ME = new ManageEmployer();

      /* Add few employee records in database */
      Integer empID1 = ME.addEmployer(1,"Anand", "Kumar", 100000);
      Integer empID2 = ME.addEmployer(2,"Srinivas", "Das", 200000);
      Integer empID3 = ME.addEmployer(3,"Michael", "Paul", 300000);


      /* List down all the employers */
     ME.listEmployees();

      /* Update employee's records */
     ME.updateEmployer(empID1, 5000);

      /* Delete an employer from the database */
      ME.deleteEmployer(empID2);

      /* List down new list of the employers */
      ME.listEmployees();
   }

   /* Method to READ all the employees */
   public void listEmployees( ){
      Session session = factory.openSession();
      Transaction tx = null;
      try{
         tx = session.beginTransaction();
         List employees = session.createQuery("FROM Employee").list();
         for (Iterator iterator =
                           employees.iterator(); iterator.hasNext();){
            Employee employee = (Employee) iterator.next();
            System.out.print("First Name: " + employee.getFirstName());
            System.out.print(" Last Name: " + employee.getLastName());
            System.out.println(" Salary: " + employee.getSalary());
         }
         tx.commit();
      }catch (HibernateException e) {
         if (tx!=null) tx.rollback();
         e.printStackTrace();
      }finally {
         session.close();
      }
   }
   /* Method to UPDATE salary for an employee */
   public void updateEmployer(Integer EmployerID, int salary ){
      Session session = factory.openSession();
      Transaction tx = null;
      try{
         tx = session.beginTransaction();
         Employee employee =
                    (Employee)session.get(Employee.class, EmployerID);
         employee.setSalary( salary );
        session.update(employee);
         tx.commit();
      }catch (HibernateException e) {
         if (tx!=null) tx.rollback();
         e.printStackTrace();
      }finally {
         session.close();
      }
   }


   /* Method to CREATE an employer in the database */
   public Integer addEmployer(int id,String fname, String lname, int salary){
      Session session = factory.openSession();
      Transaction tx = null;
      Integer employeeID = null;
      try{
         tx = session.beginTransaction();
         Employee employee = new Employee(id,fname, lname, salary);
         employeeID = (Integer) session.save(employee);
         tx.commit();
      }catch (HibernateException e) {
         if (tx!=null) tx.rollback();
         e.printStackTrace();
      }finally {
         session.close();
      }
      return employeeID;
   }
   /* Method to DELETE an employee from the records */
   public void deleteEmployer(Integer EmployeeID){
      Session session = factory.openSession();
      Transaction tx = null;
      try{
         tx = session.beginTransaction();
         Employee employer =
                   (Employee)session.get(Employee.class, EmployeeID);
         session.delete(employer);
         tx.commit();
      }catch (HibernateException e) {
         if (tx!=null) tx.rollback();
         e.printStackTrace();
      }finally {
         session.close();
      }
   }
}

Step7: Execute the main class ManageEmployer.java

O/P:

Feb 22, 2015 7:49:10 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Feb 22, 2015 7:49:10 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.0.1.Final}
Feb 22, 2015 7:49:10 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Feb 22, 2015 7:49:10 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Feb 22, 2015 7:49:10 PM org.hibernate.cfg.Configuration configure
INFO: HHH000043: Configuring from resource: hibernate.cfg.xml
Feb 22, 2015 7:49:10 PM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: HHH000040: Configuration resource: hibernate.cfg.xml
Feb 22, 2015 7:49:11 PM org.hibernate.cfg.Configuration addResource
INFO: HHH000221: Reading mappings from resource: Employee.hbm.xml
Feb 22, 2015 7:49:11 PM org.hibernate.internal.util.xml.DTDEntityResolver resolveEntity
WARN: HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!
Feb 22, 2015 7:49:11 PM org.hibernate.cfg.Configuration doConfigure
INFO: HHH000041: Configured SessionFactory: null
Feb 22, 2015 7:49:11 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Feb 22, 2015 7:49:11 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Feb 22, 2015 7:49:11 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
Feb 22, 2015 7:49:11 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WhatSheWants) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)))]
Feb 22, 2015 7:49:11 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=system, password=****}
Feb 22, 2015 7:49:13 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
Feb 22, 2015 7:49:13 PM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
Feb 22, 2015 7:49:13 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
16 [main] INFO org.hibernate.validator.util.Version - Hibernate Validator 4.2.0.Final
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000228: Running hbm2ddl schema update
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000102: Fetching database metadata
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000396: Updating schema
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000261: Table found: SYSTEM.EMPLOYER
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000037: Columns: [last_name, id, salary, first_name]
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000108: Foreign keys: []
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000126: Indexes: [sys_c007088]
Feb 22, 2015 7:49:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000232: Schema update complete
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into EMPLOYER (FIRST_NAME, LAST_NAME, SALARY, ID) values (?, ?, ?, ?)
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into EMPLOYER (FIRST_NAME, LAST_NAME, SALARY, ID) values (?, ?, ?, ?)
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into EMPLOYER (FIRST_NAME, LAST_NAME, SALARY, ID) values (?, ?, ?, ?)
Hibernate: select employee0_.ID as ID0_, employee0_.FIRST_NAME as FIRST2_0_, employee0_.LAST_NAME as LAST3_0_, employee0_.SALARY as SALARY0_ from EMPLOYER employee0_
First Name: Zara Last Name: Ali Salary: 5000
First Name: Michael Last Name: Paul Salary: 300000
First Name: John Last Name: Paul Salary: 10000
First Name: Anand Last Name: Kumar Salary: 100000
First Name: Srinivas Last Name: Das Salary: 200000
Hibernate: select employee0_.ID as ID0_0_, employee0_.FIRST_NAME as FIRST2_0_0_, employee0_.LAST_NAME as LAST3_0_0_, employee0_.SALARY as SALARY0_0_ from EMPLOYER employee0_ where employee0_.ID=?
Hibernate: update EMPLOYER set FIRST_NAME=?, LAST_NAME=?, SALARY=? where ID=?
Hibernate: select employee0_.ID as ID0_0_, employee0_.FIRST_NAME as FIRST2_0_0_, employee0_.LAST_NAME as LAST3_0_0_, employee0_.SALARY as SALARY0_0_ from EMPLOYER employee0_ where employee0_.ID=?
Hibernate: delete from EMPLOYER where ID=?
Hibernate: select employee0_.ID as ID0_, employee0_.FIRST_NAME as FIRST2_0_, employee0_.LAST_NAME as LAST3_0_, employee0_.SALARY as SALARY0_ from EMPLOYER employee0_
First Name: Zara Last Name: Ali Salary: 5000
First Name: Michael Last Name: Paul Salary: 300000
First Name: John Last Name: Paul Salary: 10000
First Name: Anand Last Name: Kumar Salary: 5000

Folder Structure:

Hibernate Example

2015-02-22T06:52:00.000-08:00

How to open war file

2014-05-30T20:28:00.001-07:00

A WAR file (Web application ARchive) is a JAR file used to distribute a collection of JavaServer Pages, Java Servlets, Java classes, XML files, tag libraries, static web pages (HTML and related files) and other resources that together constitute a web application.

Below are the 2 methods you can use for the same

1) war/jar files can be opened with winzip

2) Use the below command

jar -xvf filename.jar

JAX-WS Exception - “return is not a valid property”

2014-05-18T01:52:00.001-07:00

While implementing java webservices and Metro as your JAX-WS provider sometimes you will need to return Json object,HashMap,....

In that case you may get the following error:

SEVERE: WSSERVLET11: failed to parse runtime descriptor: javax.xml.ws.WebServiceException: class dAO.jaxws.LoginResponse do not have a property of the name return
javax.xml.ws.WebServiceException: class dAO.jaxws.LoginResponse do not have a property of the name return
    at com.sun.xml.ws.server.sei.EndpointResponseMessageBuilder$DocLit.<init>(EndpointResponseMessageBuilder.java:258)
    at com.sun.xml.ws.server.sei.TieHandler.createResponseMessageBuilder(TieHandler.java:212)
    at com.sun.xml.ws.server.sei.TieHandler.<init>(TieHandler.java:117)
    at com.sun.xml.ws.db.DatabindingImpl.<init>(DatabindingImpl.java:110)
    at com.sun.xml.ws.db.DatabindingProviderImpl.create(DatabindingProviderImpl.java:74)
    at com.sun.xml.ws.db.DatabindingProviderImpl.create(DatabindingProviderImpl.java:58)
    at com.sun.xml.ws.db.DatabindingFactoryImpl.createRuntime(DatabindingFactoryImpl.java:127)
    at com.sun.xml.ws.server.EndpointFactory.createSEIModel(EndpointFactory.java:487)
    at com.sun.xml.ws.server.EndpointFactory.create(EndpointFactory.java:283)
    at com.sun.xml.ws.server.EndpointFactory.createEndpoint(EndpointFactory.java:158)
    at com.sun.xml.ws.api.server.WSEndpoint.create(WSEndpoint.java:577)
    at com.sun.xml.ws.api.server.WSEndpoint.create(WSEndpoint.java:560)
    at com.sun.xml.ws.transport.http.DeploymentDescriptorParser.parseAdapters(DeploymentDescriptorParser.java:303)
    at com.sun.xml.ws.transport.http.DeploymentDescriptorParser.parse(DeploymentDescriptorParser.java:179)
    at com.sun.xml.ws.transport.http.servlet.WSServletContextListener.parseAdaptersAndCreateDelegate(WSServletContextListener.java:131)
    at com.sun.xml.ws.transport.http.servlet.WSServletContainerInitializer.onStartup(WSServletContainerInitializer.java:65)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5274)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: javax.xml.bind.JAXBException: return is not a valid property on class dAO.jaxws.LoginResponse
    at com.sun.xml.bind.v2.runtime.JAXBContextImpl.getElementPropertyAccessor(JAXBContextImpl.java:985)
    at com.sun.xml.ws.db.glassfish.JAXBRIContextWrapper.getElementPropertyAccessor(JAXBRIContextWrapper.java:120)
    at com.sun.xml.ws.server.sei.EndpointResponseMessageBuilder$DocLit.<init>(EndpointResponseMessageBuilder.java:254)
    ... 23 more

Solution:

Set the Document style as follows to RPC. This annotation should come after the @WebService annotation..

@WebService(endpointInterface="dAO.LoginImpl")
@SOAPBinding(style = Style.RPC)

FreeMarker error when trying to use AJAX Theme

2013-12-05T06:57:00.000-08:00

Problem: When giving the <s:head theme="ajax" /> tag in jsp AJAX in struts 2.1.6 or dojo in struts 2.1.6.

FreeMarker template error!

Expression parameters.parseContent is undefined on line 45, column 28 in template/ajax/head.ftl.
The problematic instruction:
----------
==> ${parameters.parseContent?string} [on line 45, column 26 in template/ajax/head.ftl]
----------

Java backtrace for programmers:
----------
freemarker.core.InvalidReferenceException: Expression parameters.parseContent is undefined on line 45, column 28 in template/ajax/head.ftl.

Solution: Replace <s:head theme="ajax"> with <sx:head parseContent="true"/>

Capitalizing the first letter of a word using css

2013-09-01T05:48:00.001-07:00

Property: Text Transform

Usage:
text-transform: capitalize;

Definition:
Using this attribute/tag we can transform text with out really editing the text

capitalize : This will make the first letter of the every word as a capital letter.

<font style="text-transform: capitalize;">capitalize first letter</font>

log4j xml configuration

2013-09-01T05:22:00.003-07:00

log4j.xml :

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration debug="true"
                     xmlns:log4j='http://jakarta.apache.org/log4j/'>

   <appender name="consoleAppender" class="org.apache.log4j.ConsoleAppender">
      <layout class="org.apache.log4j.PatternLayout">
         <param name="ConversionPattern" value="%d{dd MMM yyyy HH:mm:ss} %5p %c{1} - %m%n"/>
      </layout>
   </appender>   <appender name="fileAppender" class="org.apache.log4j.RollingFileAppender">
      <param name="append" value="true"/>
      <param name="file" value="logs/logging.log"/>
      <param name="MaxFileSize" value="100kb" />
      <param name="MaxBackupIndex" value="5" />
       
      <layout class="org.apache.log4j.PatternLayout">
        
        <param name="ConversionPattern" value="%d - %c - %p - %m%n"/>
      </layout>
   </appender>
   <root>
      <level value="INFO"/>
      <appender-ref ref="consoleAppender"/>
      <appender-ref ref="fileAppender"/>
   </root>
</log4j:configuration>

log4j properties configuration

2013-09-01T05:16:00.002-07:00

log4j.properties:

# Log levels
log4j.rootLogger=TRACE,CONSOLE,R
# Appender Configuration
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
# Pattern to output the caller's file name and line number
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n
# Rolling File Appender
log4j.appender.R=org.apache.log4j.RollingFileAppender
#my log data
log4j.appender.R.File=rolling-log.log
# Path and file name to store the log file
log4j.appender.R.File=logs/testlog.log
#Max log file size.On reaching max size new file will be created automaticlly
log4j.appender.R.MaxFileSize=100KB
# Number of backup files
log4j.appender.R.MaxBackupIndex=2
# Layout for Rolling File Appender
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%d - %c - %p - %m%n

Log in php

2013-08-30T09:06:00.004-07:00

Below is the function which can be used to log data in PHP

function myLog($text)
    {
    // open the log file
    $filename = "myAppLog.log";


    //Open the file in Append mode
    $f = fopen($filename, "a") or die("Could not open the log file.");


   //Write the log to the file. The timestamp can be altered as per the requirement
    fwrite($f, date("d-m-Y, H:i")." - $text\n") or die("Could not write file");

    fclose($f);

    }

Submit form using jquery

2013-08-30T09:03:00.003-07:00

Below is the code which can be used to submit a form using jquery. Also it has facility to pass post data and redirect to other page.

<script language="javascript" src="/js/jquery-latest.js"></script>

searchScreen.jsp

' });
}

</script>

Usage: <a href="javascript:postData()">Cllick here</a>

check string value is numeric using java

2013-08-17T09:05:00.002-07:00

package com.test;

public class IntFrmStringCheck {

    private static String str=null;

    public int compare(int str )
    {
        int res=0;
        //res ==1 => Positive number
        //res==0 => non-integer

        try
        {
            //float s=Float.parseFloat(str);
            int s=Integer.parseInt(str);

          //Allow only positive numbers

           if(str.contains("-"))
           {
                res=0;
           }
           else if(s==0)
           {
               res=0;
           }
           else
           {
               res=1;
           }

        }
        catch(NumberFormatException e)
        {
            res=0;
             System.out.println("INSIDE CATCH:"+ e);
        }
        finally
        {

            //
        }
    // return res;
    }

       public static void main(String[] args)
    {
        System.out.println("RESULT:"+compare("45"));

    }


}

date validation using javascript

2013-08-17T08:52:00.007-07:00

Below is the javascript code to validate date

function ChkDate(year) {

    var str=year.split('/');
        if(str.length!=3)return false;

    var date=parseInt(str[0]);

    if(isNaN(date))return false;
        if(date==0){
        date=parseInt(str[0].substring(1,2))
    }

    var m=parseInt(str[1]);
    if(m==0){
        m=parseInt(str[1].substring(1,2))
    }

    if(isNaN(m))return false;

    var year=parseInt(str[2]);

    if(isNaN(year))return false;
    var daysInMonth = DaysArray(12)

    //    var m=monNumFor(month);
    var s=new Date().toString();
    var Arr=s.split(' ');
    for(var i=3;i<Arr.length;i++)
    {
        if(Arr[i].length==4)
        {
            Arr[3]=Arr[i];
        }
    }
    Arr[2]=parseInt(Arr[2]);//date
    Arr[1] =parseInt(monNumFor(Arr[1]));//mon
    Arr[3]=parseInt(Arr[3]);//year

    var minYear=Arr[3]-100;
    var maxYear=Arr[3]+100;

    if (date<1 || date>31 || (m ==2&& date>daysInFebruary(year)) || date > daysInMonth[m]){
        return false
    }
    if(m<1 || m>12) return false;
    if (year==0 || year<minYear || year>maxYear){
        return false
    }

    if (year>Arr[3])
    {
        return false;
    }
    if(year==Arr[3] && m>Arr[1])
    {
        return false;
    }
    if(year==Arr[3] && m==Arr[1] && date>Arr[2])
    {
        return false;
    }
    return true;
}

function daysInFebruary (year){
        return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );
}

function DaysArray(n) {
    for (var i = 1; i <= n; i++) {
        this[i] = 31
        if (i==4 || i==6 || i==9 || i==11) {this[i] = 30}
        if (i==2) {this[i] = 29}
   }
   return this
}

function monNumFor(m)
{
        switch(m)
    {
        case "Jan":
            m ="1";
            break;
        case "Feb":
            m ="2";
            break;
        case "Mar":
            m ="3";
            break;
        case "Apr":
            m ="4";
            break;
        case "May":
            m ="5";
            break;
        case "Jun":
            m ="6";
            break;
        case "Jul":
            m ="7";
            break;
        case "Aug":
            m ="8";
            break;
        case "Sep":
            m ="9";
            break;
        case "Oct":
            m ="10";
            break;
        case "Nov":
            m ="11";
            break;
        case "Dec":
            m ="12";
            break;
    }
    return m;
}

Calculate age from date using javascript

2013-08-17T08:47:00.003-07:00

Below is the javascript function which can be used to calculate age from date

//Calculate age from DOB (dd/mm/yyyy)
//This function can be customized to any other date formats
function calculate_age(yearinput){

        var year=yearinput;
        var str=year.split('/');

        var date=parseInt(str[0]);
        var month=parseInt(str[1]);
        var year=parseInt(str[2]);

        var myDate=new Date();
        myDate.setFullYear(year, month, date);

        var today = new Date();

            var bday=date;
            var bmo=(month-1);
            var byr=year;
            var byr;
            var age;
            var now = new Date();
            tday=now.getDate();
            tmo=(now.getMonth());
            tyr=(now.getFullYear());

            if((tmo > bmo)||(tmo==bmo & tday>=bday))
            {    age=byr    }
            else
            {    age=byr+1}

            return (tyr-age);
}

alphanumeric valdations using javascript regular expressions

2013-08-17T08:44:00.002-07:00

Below is the code which can be used to validate alphabetic charecters using javascript regular expressions

//Alphanumeric validations
function validatealphanumeric(name)
{
var letters = /^[0-9a-zA-Z\s]+$/;

if(name.match(letters))
{
return true;
}
else
{

return false;
}
}

Usage:

var empnumber=trim(document.getElementById('name').value);

if(validatealphanumeric(empnumber))
    {
    //return true
    }
    else if((empnumber=="") || (empnumber=="0") || (empnumber=="null") || (empnumber=="NIL") || (empnumber=="nil"))
    {
       alert('Please enter valid Employee Number');
       return false;
    }
    else
    {
       alert('Employee Number must have alphanumeric characters only');
       return false;
    }

Number validation using javascript regular expressions

2013-08-17T08:40:00.000-07:00

Below is the code which can be used to validate numbers using javascript regular expressions

//Numeric validations
function numericvalidation(number)
{
    var numericExpression = /^[0-9]+$/;
    if(number.match(numericExpression)) {
        number= "1";

        return true;
    }

    if(number!="1"){

        return false;
    }
}

Usage:

var num=document.getElementById("age").value;

if( numericvalidation(num)==false)    {
        alert("Please enter valid age");
        return false;
    }

name validation using javascript regular expressions

2013-08-17T08:34:00.002-07:00

Below is the javascript code along with implementation to validate the names for allowing alphabet characters only using regular expressions.

This code also supports spacing between the words in the names.

function validateNames(name)
{
var letters = /^[A-Za-z\s]+$/;
if(name.match(letters))
{
return true;
}
else
{
return false;
}
}

//Usage
var empname=trim(document.getElementById("employeename").value);

if(validateNames(empname))
    {
        //return true;
    }
    else if((empname=="") || (empname=="0") || (empname=="null") || (empname=="NIL") || (empname=="nil"))
    {
        alert('Please enter valid Employee Name');
           return false;
    }
    else
    {
        alert('Employee name must have alphabet characters only');
           return false;
    }

//trim function
function trim(s) {

             while (s.substring(0,1) == ' ') {
                s = s.substring(1,s.length);
              }
              while (s.substring(s.length-1,s.length) == ' ') {
                s = s.substring(0,s.length-1);
              }
              return s;

            }

Confirm in javascript

2013-08-17T08:20:00.000-07:00

Below is the code which shows the implementation of 'confirm' in javascript

function confirmDelete()
{
var x = confirm("Are you sure you want to delete?");
if (x)
return true;
else
return false;
}

Duplicate records in mysql

2013-08-13T06:24:00.001-07:00

Below is the query which can be used to find the duplicate records in a mysql table. Also can be used to retrieve the count of records matching certail condition.

select FIELD1,count(*) count FROM TABLE1 t1
join TABLE2 t2 on t2.ID=t1.EID where t1.EID in (200,300)
and t2.relation in ('FATHER','MOTHER','SISTER')
group by FIELD1
having count(*) > 0;

Bulk insert in java

2013-07-21T02:18:00.003-07:00

In some scenarios we will need to perform bulk inserts in database using java.
Below is the well tested code which can be used to retrieve data from a table using select query and insert into another table using java addBatch method.

In the below code we have used Autocommit set to false so that if any error in the complete transaction, the data will be rolled back. This is done using successflag in the below code.

FIle: BulkUpdate.java

package REPORTS;

import java.sql.*;
import java.text.*;
import java.util.*;

import connections.*;

public class BulkUpdate {

Connection con = null;
ResultSet rs=null;
//Set number of records to be inserted per batch
batchSize =500;

public void bulkInsertDB() {

try{

successflag=0;
count = 0;

con = new ConnectionDB().returnConnection();
System.out.println("creating ORACLE DB connection FOR DATA RETRIEVAL");

//INSERT TO DB CONNECTIONS
con = new ConnectionDB().returnConnection();
System.out.println("creating ORACLE DB connection FOR INSERTION");
con.setAutoCommit(false);

String sql="select * from VW_GET_DATA";
Statement stmt=con.createStatement();
rs stmt.executeQuery(sql);

//BULK INSERT
String sql_insert = "insert into TABLE (ID,NAME,LEVEL) " +
"values " +
"(?,?,?)";

PreparedStatement ps = con.prepareStatement(sql_insert);

while(rs.next())
{

ps.setString(1, rs.getString("ID"));
ps.setString(2, rs.getString("NAME"));
ps.setString(3, rs.getString("LEVEL"));

ps.addBatch();

if(++count % batchSize == 0) {

ps.executeBatch();

}//if

}//WHILE

//INSERTING REMAINING RECORDS
ps.executeBatch();

stmt.close();
ps.clearBatch();
ps.close();

//BULK INSERT END

}
catch(Exception e1) {

successflag=1;
System.out.println("ERROR:"+e1);
//SEND MAIL IF NEEDED ON FAILURE IN BULK INSERT
//YOUR CODE

}
finally
{
if(con != null)
{
try
{

if(successflag == 0)
{
con.commit();
}
else
{
con.rollback();
}

if (con != null) {
con.close();

}

}
catch(Exception e)
{
e.printStackTrace();
}
}
}

}

public static void main(String[] args) {
BulkUpdate obj = new BulkUpdate();
obj.bulkInsertDB();

}

}

LINQ in PHP

2013-06-22T06:31:00.002-07:00

Below are the features implemented in the below code

1) Implementing LINQ in PHP
2) Generating PDF in PHP using FPDF
3) Using Arrays in PHP
4) Using list in PHP
5) Oracle connection using PHP

You need to download fpdf & D3Linq (phpclasses.org) to implement the below code.

<?php

error_reporting(0);
set_time_limit(0);
date_default_timezone_set('Asia/Calcutta');

require('FPDF/fpdf.php');
include 'D3Linq.php';

$a=new D3Linq();
$b=new D3Linq();

$results_array = array();
$results_array2 = array();

$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521)))(CONNECT_DATA=(SID=DBNAME)))";

if ($conn =OCILogon("USERNAME", "PWD", $db)) {
//OCILogoff($c);
} else {
$err = OCIError();
}

$query = "SELECT * from TABLE WHERE ACTIVESTATUS=1";

$stid = OCIParse($conn, $query);
OCIExecute($stid, OCI_DEFAULT);

$pdf = new FPDF();

$ImgStartRow = 45;
$ImgStartRowright = 45;
$StartRow = 85;
$startrowright = 85;
$count=0;

while ($row = oci_fetch_object($stid)) {

$results_array[$row->GROUPID] = $row->GROUPID;

$results_array2[$row->ID] = 'GROUPID~'.$row->GROUPID.'~'.$row->EMPLOYEENAME.'~'.$row->EMPDOJ.'~'.$row->EMPSALARY.'~'.$row->EMPNAME.'~'.$row->EMPGENDER.'~'.$row->EMPAGE;

}//while

$pagecount=0;

$a->Query("SELECT key ElementName, value Value FROM results_array ");

            while ($data=$a->fetch_assoc()){



            if(($pagecount % 10) == 0)
            {

            //ADD PAGE
               $pdf->AddPage();
               $ImgStartRow = 5;
               $ImgStartRowright = 5;
               $StartRow = 19;
               $startrowright=4;

            }//if

            //DISPLAY DATA
            $phname="";
            $dojj="";


                $pdf->Image('images/1.jpg',5,$ImgStartRow );
                $pdf->Image('images/2.jpg',95,$ImgStartRow );

//IMPLEMENTING GROUP BY USING LINQ IN PHP
$b->Query("SELECT value Details FROM results_array2 where value like 'GROUPID~".$data['Value']."~%'");


    while ($GrpData=$b->fetch_assoc()){

    list($ignore, $groupid, $empname, $empdoj, $empsalary,$employeename,$empgender,$empage) = explode("~", $GrpData['Details']);

                    $count++;


            if($pagecount %2 == 0)
            {

                       $pdf->SetFont('Arial','',8); $pdf->Text(10,$StartRow,$empname); $StartRow += 6;
                    $pdf->SetFont('Arial','',6); $pdf->Text(10,$StartRow,$empdoj); $StartRow += 6;

            }
            else
            {
                    $pdf->SetFont('Arial','',8); $pdf->Text(100,$StartRow,$empname); $StartRow += 6;
                    $pdf->SetFont('Arial','',6); $pdf->Text(100,$StartRow,$empdoj); $StartRow += 6;

            }

//PDF GENERATION END




            }//inner while for grouping

            //DISPLAY DATA END

            if($count == 1)
            $finalheight = 15;
            else if($count == 2)
            $finalheight = 15;

            if($count == 1)
            $finalheightright = 20;
            else if($count == 2)
            $finalheightright = 15;



            $StartRow+=$finalheight;
            $startrowright+=$finalheightright;

            // FOR ALIGNING NO OF 5 IMAGES (ROW) PER PAGE
            $ImgStartRow +=59;
            $ImgStartRowright +=59;
            $count=0;
                $pagecount++;
            }//while key

$pdf->SetY(-8);
$pdf->SetFont('Times','I',8);

    header("Content-Transfer-Encoding", "binary");
    header('Cache-Control: maxage=600000'); //Adjust maxage appropriately
    header('Pragma: public');
    $pdf->Output('GENARTEDPDF.pdf', 'D');

$pdf->Output();

?>

Removing leading zeros using sql

2013-06-22T06:17:00.001-07:00

Update statement to remove leading (or) trailing zeros from a column. The column is a varchar field and the number of zeros vary.

TRAILING CHAR Example

UPDATE TABLENAME SET COLUMNNAME=RTRIM(COLUMNNAME,'.0');

LEADING CHAR Example

UPDATE TABLENAME SET COLUMNNAME=LTRIM(COLUMNNAME,'.0');