sudarsang

CREATE TABLE CUSTOMER
(   ID          INT PRIMARY KEY AUTO_INCREMENT,
    FIRSTNAME   VARCHAR(50),
    LASTNAME    VARCHAR(50),
    EMAIL    	VARCHAR(30),
    TELEPHONE   VARCHAR(20)
);

sudarsang

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM  "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
    <appender name="console" class="org.apache.log4j.ConsoleAppender">
        <param name="Threshold" value="INFO"/>
        <param name="Target" value="System.out"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d{HH:mm:ss,SSS}- %m%n"/>
        </layout>

sudarsang

label.firstname=First Name
label.lastname=Last Name
label.email=Email
label.telephone=Telephone
label.addcustomer=Add Customer

#Validation Error Messages
Size=the {0} field must be between {2} and {1} characters long
Size.customer.firstname=FirstName must be between {2} and {1} characters
Size.customer.lastname=LastName must be between {2} and {1} characters

sudarsang

<plugin>
    <groupId>org.mortbay.jetty</groupId>
    <artifactId>jetty-maven-plugin</artifactId>
    <version>${jetty.maven.plugin.version}</version>
    <configuration>
        <scanIntervalSeconds>5</scanIntervalSeconds>
        <webAppConfig>
            <contextPath>/customerMgr</contextPath>
        </webAppConfig>
    </configuration>

sudarsang

WITH R1 AS
  (SELECT * FROM A JOIN B ON A.X = B.Y WHERE A.Z = 'abcd'
  ) ,
  
  R2 AS
  (SELECT * FROM C WHERE D.X = 'pqrs' AND D.Y IN (SELECT Y FROM R1)
  ) ,
  
  R3 AS
  (SELECT * FROM E JOIN R2 ON E.X = R2.Y WHERE E.Z = 'pqrs' AND R2.P ='bla bla'

sudarsang

/** 
 * Name: BACSOS-76-ENABLE_AUDIT.SQL
 * Author: Sudarsan Gopal
 * Date: 29/05/2015
 * Platform: SQL Server
 * Maximo Version: 7.5
 * This script will update the DB Config to enable Auditing to the selected fields as per the requirement.
**/

UPDATE MAXATTRIBUTECFG SET EAUDITENABLED=1, CHANGED='Y' WHERE OBJECTNAME='ASSET' AND ATTRIBUTENAME IN ('CHANGEBY','CHANGEDATE','CHILDREN','CLASSSTRUCTUREID','CONTRACTOR','DESCRIPTION','GLACCOUNT','INSTALLDATE','MOVEDATE','MOVEDBY','MOVEMEMO','SERIALNUM','STATUS','STATUSDATE','WARRANTYEXPDATE');