create or replace and compile java source named accidentreport as

import java.net.URL;
import java.sql.*;
import java.io.*;
import oracle.sql.*;
//import oracle.jdbc.driver.*;
import oracle.jdbc.*;
import oracle.xml.parser.v2.*;
// import javax.mail.internet.MimeUtility;
// import java.net.*;
import org.w3c.dom.*;
import sun.misc.BASE64Decoder;
//import org.xml.sax.*;
import java.util.StringTokenizer;

public class AccidentReport {


  public static void create(String   inDotCaseNum,
                            NUMBER   inDocXmlId,
                            NUMBER   inTempReportPk,
                            NUMBER   inMarrsReportPk,
                            String[] outError)

  {

//  String ver;
//  System.out.println("at the beginning");
//  ver = System.getProperty("java.version");
//  System.out.println("The JDK version is " + ver);

    DOMParser theParser = new DOMParser();

    try
     {

// System.out.println("do connection");

        Connection conn = new OracleDriver().defaultConnection();

// System.out.println("connection made");

        conn.setAutoCommit(false);

        InputStream XMLStreamToParse = null;
        XMLDocument theXMLDoc        = null;
        BLOB        diagramBlob      = null;
        BLOB        signatureBlob    = null;

        CaseRecord caseData = new CaseRecord(inTempReportPk.intValue());

// =========== Get the Data ================================


        String sql = "select img_id,"    +
                     "       docxml_frm"   +
                     "  from accident_image " +
                     " where case_num  = '" + inDotCaseNum + "'" +
                     "   and docxml_id = " + inDocXmlId.intValue();

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery(sql);

        while (rset.next())
        {
           Clob accidentReport = ((OracleResultSet)rset).getClob(2);

// System.out.println(accidentReport.length());
// System.out.println("DATA!!!");

// This will print out clob:
// System.out.println(accidentReport.getSubString(1,(int)accidentReport.length()));
           // Create Parser and Parse the XML CLOB.
           XMLStreamToParse = accidentReport.getAsciiStream();
           theParser.parse(XMLStreamToParse);
           theXMLDoc = theParser.getDocument();

// this will print the Doc
// theXMLDoc.print(System.out);

           // Extract Case Level Element Data from XML
           caseData.setLocalCode(getXMLString(theXMLDoc,"Local_Code","Value"));
           caseData.setAmended(getXMLString(theXMLDoc,"Amended_Report","Value"));
           caseData.setAccdDate(getXMLDate(theXMLDoc,"Accident_Date"));
           caseData.setAccdTime(getXMLString(theXMLDoc,"Accident_Time","Hour") + ":" +
                                  getXMLString(theXMLDoc,"Accident_Time","Minute"));
           caseData.setNumVehicles(getXMLString(theXMLDoc,"Number_Vehicles","Value"));
           caseData.setNumInjured(getXMLString(theXMLDoc,"Number_Injured","Value"));
           caseData.setNumKilled(getXMLString(theXMLDoc,"Number_Killed","Value"));
           caseData.setPoliceInvestigated(getXMLString(theXMLDoc,"Police_Investigated","Value"));
           caseData.setAccdReconstructed(getXMLString(theXMLDoc,"Accident_Reconstructed","Value"));
           caseData.setDriverLeftScene(getXMLString(theXMLDoc,"Driver_Left_Scene","Value"));
           caseData.setPolicePhotographed(getXMLString(theXMLDoc,"Police_Photographed","Value"));
           caseData.setCollisionType(getXMLString(theXMLDoc,"Collision_Manner_Type","Code"));
           caseData.setVehDamageOver1000(getXMLString(theXMLDoc,"Any_Vehicle_Damage_Over_1000","Value"));
           caseData.setReferenceMarker(getXMLString(theXMLDoc,"Reference_Marker","Value"));
           caseData.setLatitude(getXMLString(theXMLDoc,"Reported_Latitude","Value"));
           caseData.setLongitude(getXMLString(theXMLDoc,"Reported_Longitude","Value"));
           caseData.setAccdCounty(getXMLString(theXMLDoc,"Accident_County","Code"));
           caseData.setLocationType(getXMLString(theXMLDoc,"Location_Type","Code"));
           caseData.setMunicipality(getXMLString(theXMLDoc,"Municipality","Value"));
           caseData.setAccdStreet(getXMLString(theXMLDoc,"AccidentStreet","Value"));
           caseData.setIntersection(getXMLString(theXMLDoc,"Intersection","Value"));
           caseData.setIntersectingStreet(getXMLString(theXMLDoc,"Intersecting_Street","Value"));
           caseData.setOffsetDistance(getXMLString(theXMLDoc,"Offset_Distance","Value"));
           caseData.setDistanceType(getXMLString(theXMLDoc,"Distance_Type","Code"));
           caseData.setDirection(getXMLString(theXMLDoc,"Direction","Code"));
           caseData.setNearestIntersectPt(getXMLString(theXMLDoc,"Nearest_Intersection_Point","Value"));
           caseData.setPoliceRank(getXMLString(theXMLDoc,"Investigator","Police_Rank"));
           caseData.setInvestigatorName(getXMLString(theXMLDoc,"Investigator","First_Name") + " " +
                                          getXMLString(theXMLDoc,"Investigator","Middle_Name") + " " +
                                           getXMLString(theXMLDoc,"Investigator","Last_Name"));
           caseData.setBadgeNumber(getXMLString(theXMLDoc,"Investigator","Badge_Number"));
           caseData.setNCICOrganization(getXMLString(theXMLDoc,"NCIC_Organization","Value"));
           caseData.setPrecPostTroopZone(getXMLString(theXMLDoc,"Investigator","Precinct_Post_Troop_Zone"));
           caseData.setStationBeatSector(getXMLString(theXMLDoc,"Investigator","Station_Beat_Sector"));
           caseData.setReviewingOfficer(getXMLString(theXMLDoc,"Investigator","Reviewing_Officer"));
           caseData.setPoliceReviewDate(getXMLDate(theXMLDoc,"Police_Review_Date"));
           caseData.setPoliceReviewTime(getXMLString(theXMLDoc,"Police_Review_Time","Hour") + ":" +
                                          getXMLString(theXMLDoc,"Police_Review_Time","Minute"));
           caseData.setPedBikeLocation(getXMLString(theXMLDoc,"Pedestrian_Bicyclist_Location","Code"));
           caseData.setPedBikeAction(getXMLString(theXMLDoc,"Pedestrian_Bicyclist_Action","Code"));
           caseData.setTrafficControlType(getXMLString(theXMLDoc,"Traffic_Control_Type","Code"));
           caseData.setLightCondition(getXMLString(theXMLDoc,"Light_Condition","Code"));
           caseData.setRoadCharacteristics(getXMLString(theXMLDoc,"Road_Characteristics","Code"));
           caseData.setRoadSurfaceCondition(getXMLString(theXMLDoc,"Roadway_Surface_Condition","Code"));
           caseData.setWeatherCondition(getXMLString(theXMLDoc,"Weather_Conditions","Code"));
           caseData.setOnRoad(getXMLString(theXMLDoc,"OnRoad","Value"));
           caseData.setFirstEvent(getXMLString(theXMLDoc,"First_Event","Code"));
           caseData.setWorkRelated(getXMLString(theXMLDoc,"Work_Related","Value"));
           caseData.setRoadSurface(getXMLString(theXMLDoc,"Roadway_Surface","Code"));
           caseData.setNonHighway(getXMLString(theXMLDoc,"Non_Highway","Value"));
           caseData.setTowing(getXMLString(theXMLDoc,"Towing","Value"));
           caseData.setNumTravelLanes(getXMLString(theXMLDoc,"Number_Travel_Lanes","Value"));
           caseData.setPostedSpeedLimit(getXMLString(theXMLDoc,"Posted_Speed_Limit","Value"));
           caseData.setTRACSCaseNum(getXMLString(theXMLDoc,"TRACS_Case_Number","Value"));
           

     //      caseData.setFormType(getXMLString(theXMLDoc,"Form_Type","Name"));
     //      caseData.setFormVersion(getXMLString(theXMLDoc,"Form_Type","Version"));

           // Concatenate seperate Notes into one String
           // Text Node child of Element Node "Notes"
           String notes = new String();
           NodeList notesNodes = theXMLDoc.getElementsByTagName("Notes");
           for (int n=0; n < notesNodes.getLength(); n++)
             {
                 Element noteElement = (Element)notesNodes.item(n);
                 if (n==0)
                   notes = noteElement.getFirstChild().getNodeValue();
                 else
                   notes = notes + " " + noteElement.getFirstChild().getNodeValue();
             }

           // insert case level data into Oracle Table, empty for BLOBS
           stmt = conn.createStatement();

           stmt.executeUpdate(
             "insert into sms.clob_report_case " +
               "(MARRS_REPORT_PK, CLOB_REPORT_PK, DOT_CASE_NUM, LOCAL_CODE, AMENDED_REPORT, ACCIDENT_DATE, ACCIDENT_TIME," +
               "NUMBER_VEHICLES, NUMBER_INJURED, NUMBER_KILLED, POLICE_INVESTIGATED, ACCIDENT_RECONSTRUCTED," +
               "DRIVER_LEFT_SCENE, POLICE_PHOTOGRAPHED, COLLISION_MANNER_TYPE, DIAGRAM, ANY_VEHICLE_DAMAGE_OVER_1000," +
               "REFERENCE_MARKER,  REPORTED_LATITUDE, REPORTED_LONGITUDE, ACCIDENT_COUNTY, LOCATION_TYPE," +
               "MUNICIPALITY, ACCIDENT_STREET, INTERSECTION, INTERSECTING_STREET, OFFSET_DISTANCE, DISTANCE_TYPE," +
               "DIRECTION, NEAREST_INTERSECTION_POINT, INVESTIGATOR_SIGNATURE, POLICE_RANK," +
               "INVESTIGATOR_NAME, BADGE_NUMBER, NCIC_ORGANIZATION, PRECINCT_POST_TROOP_ZONE, STATION_BEAT_SECTOR," +
               "REVIEWING_OFFICER, POLICE_REVIEW_DATE, POLICE_REVIEW_TIME, PED_BICYCLIST_LOCATION_1, PED_BICYCLIST_ACTION_2," +
               "TRAFFIC_CONTROL_TYPE_3, LIGHT_CONDITION_4, ROAD_CHARACTERISTICS_5, ROADWAY_SURFACE_CONDITION_6, WEATHER_CONDITIONS_7," +
               "ONROAD_27, FIRST_EVENT_28, WORK_RELATED, ROADWAY_SURFACE, NON_HIGHWAY," +
               "TOWING, NUMBER_TRAVEL_LANES, POSTED_SPEED_LIMIT, FORM_TYPE, FORM_VERSION, TRACS_CASE_NUM) " +
             "values (" +
                      inMarrsReportPk.intValue() + "," +          // MARRS_REPORT_PK
                      inTempReportPk.intValue()  + "," +          // CLOB_REPORT_PK
                "'" + inDotCaseNum               + "'," +         // DOT_CASE_NUM
                "'" + caseData.getLocalCode()    + "'," +         // LOCAL_CODE
                "'" + caseData.getAmended()      + "'," +         // AMENDED_REPORT
                "to_date('" + caseData.getAccdDate() + "','MM/DD/YYYY')," +   // ACCIDENT_DATE
                "'" + caseData.getAccdTime()           + "'," +   // ACCIDENT_TIME
                "'" + caseData.getNumVehicles()        + "'," +   // NUMBER_VEHICLES
                "'" + caseData.getNumInjured()         + "'," +   // NUMBER_INJURED
                "'" + caseData.getNumKilled()          + "'," +   // NUMBER_KILLED
                "'" + caseData.getPoliceInvestigated() + "'," +   // POLICE_INVESTIGATED
                "'" + caseData.getAccdReconstructed()  + "'," +   // ACCIDENT_RECONSTRUCTED
                "'" + caseData.getDriverLeftScene()    + "'," +   // DRIVER_LEFT_SCENE
                "'" + caseData.getPolicePhotographed() + "'," +   // POLICE_PHOTOGRAPHED
                "'" + caseData.getCollisionType()      + "'," +   // COLLISION_MANNER_TYPE
                "empty_blob()," +                                 // DIAGRAM
                "'" + caseData.getVehDamageOver1000() + "'," +    // ANY_VEHICLE_DAMAGE_OVER_1000
                "substr('" + caseData.getReferenceMarker() + "',1,12)," +   // REFERENCE_MARKER
                "'" + caseData.getLatitude()          + "'," +    // REPORTED_LATITUDE
                "'" + caseData.getLongitude()         + "'," +    // REPORTED_LONGITUDE
                "'" + caseData.getAccdCounty()        + "'," +    // ACCIDENT_COUNTY
                "'" + caseData.getLocationType()      + "'," +    // LOCATION_TYPE
                "'" + replace(caseData.getMunicipality()      ,"'","''") + "'," +    // MUNICIPALITY
                "'" + replace(caseData.getAccdStreet()        ,"'","''") + "'," +    // ACCIDENT_STREET
                "'" + replace(caseData.getIntersection()      ,"'","''") + "'," +    // INTERSECTION
                "'" + replace(caseData.getIntersectingStreet(),"'","''") + "'," +    // INTERSECTION
                "'" + replace(caseData.getOffsetDistance()    ,"'","''") + "'," +    // OFFSET_DISTANCE
                "'" + caseData.getDistanceType()                     + "'," +    // DISTANCE_TYPE
                "'" + caseData.getDirection()                        + "'," +    // DIRECTION
                "'" + replace(caseData.getNearestIntersectPt(),"'","''") + "'," +   // NEAREST_INTERSECTION_POINT
                "empty_blob()," +                                 // INVESTIGATOR_SIGNATURE
                "'" + caseData.getPoliceRank() + "'," +           // POLICE_RANK
                "substr('" + replace(caseData.getInvestigatorName(),"'","''") + "',1,50)," +  // INVESTIGATOR_NAME
                "'" + caseData.getBadgeNumber()       + "'," +    // BADGE_NUMBER
                "substr(ltrim('" + caseData.getNCICOrganization() + "'),1,5)," +  // NCIC_ORGANIZATION
                "'" + caseData.getPrecPostTroopZone() + "'," +    // PRECINCT_POST_TROOP_ZONE
                "'" + caseData.getStationBeatSector() + "'," +    // STATION_BEAT_SECTOR
                "'" + replace(caseData.getReviewingOfficer(),"'","''") + "'," +     // REVIEWING_OFFICER
                "to_date('" + caseData.getPoliceReviewDate() + "','MM/DD/YYYY')," + // POLICE_REVIEW_DATE
                "'" + caseData.getPoliceReviewTime()     + "'," +  // POLICE_REVIEW_TIME
                "'" + caseData.getPedBikeLocation()      + "'," +  // PED_BICYCLIST_LOCATION_1
                "'" + caseData.getPedBikeAction()        + "'," +  // PED_BICYCLIST_ACTION_2
                "'" + caseData.getTrafficControlType()   + "'," +  // TRAFFIC_CONTROL_TYPE_3
                "'" + caseData.getLightCondition()       + "'," +  // LIGHT_CONDITION_4
                "'" + caseData.getRoadCharacteristics()  + "'," +  // ROAD_CHARACTERISTICS_5
                "'" + caseData.getRoadSurfaceCondition() + "'," +  // ROADWAY_SURFACE_CONDITION_6
                "'" + caseData.getWeatherCondition()     + "'," +  // WEATHER_CONDITIONS_7
                "'" + caseData.getOnRoad()               + "'," +  // ONROAD_27
                "'" + caseData.getFirstEvent()           + "'," +  // FIRST_EVENT_28
                "'" + caseData.getWorkRelated()          + "'," +  // WORK_RELATED
                "'" + caseData.getRoadSurface()          + "'," +  // ROADWAY_SURFACE
                "'" + caseData.getNonHighway()           + "'," +  // NON_HIGHWAY
                "'" + caseData.getTowing()               + "'," +  // TOWING
                "'" + caseData.getNumTravelLanes()       + "'," +  // NUMBER_TRAVEL_LANES
                "'" + caseData.getPostedSpeedLimit()     + "'," +  // POSTED_SPEED_LIMIT
                "''," +                                            // FORM_TYPE
                "''," +                                            // FORM_VERSION
                "'" + caseData.getTRACSCaseNum()         + "')"   // TRACS_CASE_NUM
                );
                
        if (notes != null)        
        {
        
        String              sqlText                 = null;
        Statement           stmt1                   = null;
        ResultSet           rset1                   = null;
        CLOB                notes_clob              = null;
        long                pos = 1;
       
            stmt1 = conn.createStatement();
                          
            sqlText = 
                "SELECT notes " +
                "FROM   sms.clob_report_case " +
                "WHERE  clob_report_pk  = " + inTempReportPk.intValue() + 
                " FOR UPDATE";
                
            rset1 = stmt1.executeQuery(sqlText);
            rset1.next();
            notes_clob = ((OracleResultSet) rset1).getCLOB(1);
            
            
            StringTokenizer tokenizer = new StringTokenizer(notes);
                     
            int count = 1;
            int  tokencnt = tokenizer.countTokens();
            
            while (tokenizer.hasMoreTokens())
            {
                String tempStr = null;
                
                if(count < tokencnt)
                   tempStr = tokenizer.nextToken() + " ";
                else
                   tempStr = tokenizer.nextToken();
                   
                notes_clob.putString(pos, tempStr);             
                pos = pos + tempStr.length();
                count = count + 1;
            }  
  

            stmt1.execute("commit");
            rset1.close();
            stmt1.close();
          }
          
           // System.out.println("Case inserted complete");
           // Get Blob columns from database
           // use as OutputStreams to write to from XML data
           ResultSet rsetBlobs = stmt.executeQuery(
                                    "select diagram, " +
                                    "       investigator_signature" +
                                    "  from sms.clob_report_case "  +
                                    " where clob_report_pk = " + inTempReportPk.intValue()  +
                                    " for update");
           while(rsetBlobs.next())
           {

              diagramBlob = ((OracleResultSet)rsetBlobs).getBLOB(1);
              signatureBlob = ((OracleResultSet)rsetBlobs).getBLOB(2);

              // ImageLoad will take Blob column from data base and write
              // to it from the XML from the document Element specified.
              
              imageLoad(theXMLDoc, diagramBlob, "Diagram", conn);
              imageLoad(theXMLDoc, signatureBlob, "Investigator_Signature", conn);
           }
           
           stmt.execute("commit");

       // ***************  Case Data insert complete *************** //

       // ******* Begin Vehicle Inserts ******* //

           // Get Node List of vehicles
           NodeList nodeListVeh = theXMLDoc.getElementsByTagName("Vehicle");
//  System.out.println("Vehicle Count: " + nodeListVeh.getLength());
           int vehicleCount = nodeListVeh.getLength();

           // Loop through the vehicles
           for (int n=0; n < nodeListVeh.getLength(); n++)
           {
              Node vehNode =  nodeListVeh.item(n);
              NodeList vehChildren = vehNode.getChildNodes();

              VehicleRecord vehRecord = new VehicleRecord(inTempReportPk.intValue());

              for (int vc=0; vc < vehChildren.getLength(); vc++)
              {

                  Node vcNode = vehChildren.item(vc);
                  if (vcNode.getNodeType() == 1)
                  {
                     Element vehChildElement = (Element)vcNode;

                     populateVehicle(vehRecord,vehChildElement);

                   }

              }  // for Vehicle Children

              insertVehicle(conn, vehRecord);

           }  // for each Vehicle Loop

       // ******* Begin Individual Inserts ******* //

           // Get Node List of Individuals
           NodeList nodeListInd = theXMLDoc.getElementsByTagName("Individual");
           // System.out.println("Individual Count: " + nodeListInd.getLength());
           int individualCount = nodeListInd.getLength();

           // Loop through the individuals
           for (int i=0; i < nodeListInd.getLength(); i++)
           {
              Node indNode =  nodeListInd.item(i);
              NodeList indChildren = indNode.getChildNodes();

              IndividualRecord indRecord = new IndividualRecord(inTempReportPk.intValue());

              for (int ic=0; ic < indChildren.getLength(); ic++)
              {

                  Node icNode = indChildren.item(ic);
                  if (icNode.getNodeType() == 1)
                  {
                     Element indChildElement = (Element)icNode;

                     populateIndividual(indRecord,indChildElement);

                   }

              }  // for Individual Children

              insertIndividual(conn, indRecord);

           }  // for each Individual Loop

        } //end while from select XML CLob from accident_image

// System.out.println("closing connection");
       conn.close();

     }
     catch(Exception e)
      {
        e.printStackTrace();
        outError[0] = "Error " + e;
      }
  }


// *******************************************************************
// *****    getXMLString                                         *****
// *******************************************************************
  public static String getXMLString(XMLDocument inXMLDoc,
                                    String      inElementName,
                                    String      inAttrName)

  {
     NodeList theNode = inXMLDoc.getElementsByTagName(inElementName);

     if (theNode.getLength() > 0)
      {
        Element  elemNode = (Element)theNode.item(0);
        return(elemNode.getAttribute(inAttrName));
      }
     else
      {
        return("");
      }
  }

// *******************************************************************
// *****    getXMLDate                                           *****
// *******************************************************************
  public static String getXMLDate(XMLDocument inXMLDoc,
                                  String      inElementName)
  {
     NodeList theNode = inXMLDoc.getElementsByTagName(inElementName);
     Element  elemNode = (Element)theNode.item(0);
     return(elemNode.getAttribute("Month") + "/" +
              elemNode.getAttribute("Day") + "/" +
                elemNode.getAttribute("Year"));
  }

// *******************************************************************
// *****    imageLoad                                            *****
// *******************************************************************
  public static void imageLoad(XMLDocument  inXMLDoc,
                               Blob         databaseBlob,
                               String       inImageName,
                               Connection   conn)
  {

   try {

   NodeList  nd = inXMLDoc.getElementsByTagName(inImageName);
   Node theNode = nd.item(0).getFirstChild();  // first child is Text Node of the Image
   String tempStr = theNode.getNodeValue();
   
   oracle.sql.CLOB newClob = oracle.sql.CLOB.createTemporary(conn, false, oracle.sql.CLOB.DURATION_CALL);
   newClob.setString(1, tempStr);
   
   //System.out.println("String: " + inImageName + ":" + tempStr);
   //System.out.println("clob  : " + inImageName + ":" + newClob.getSubString(1, (int) newClob.length()));
   //System.out.println("databaseBlob.length(): " + databaseBlob.length());
   
   Base64 myImage = new Base64();
   
   BLOB myImageBlob = myImage.decode(newClob);
   
   if (myImageBlob != null) {
   
     OutputStream out = databaseBlob.setBinaryStream(0L);
     InputStream   in = myImageBlob.getBinaryStream();
     
     byte[] buf = new byte[ (int) myImageBlob.length() + 1];
     
     in.read(buf,  1, (int) buf.length);
     out.write(buf, 1, (int)  buf.length);
  
     in.close();
     out.flush();
     out.close();
   
   }
   
   }
   catch (Exception e)
   {
     e.printStackTrace();
   }
   
 
/*

    BASE64Decoder base64 = new BASE64Decoder();
    OutputStream  outstrm = null;
    NodeList      nd = inXMLDoc.getElementsByTagName(inImageName);

    try  // Output streams
    {

      Node          theNode = nd.item(0).getFirstChild();  // first child is Text Node of the Image
      String        tempStr = theNode.getNodeValue();
      if (!tempStr.equals("Null"))
        {
         byte          theBytes[] = tempStr.getBytes();
         ByteArrayInputStream xmlDiagram = new ByteArrayInputStream(theBytes);

          // outstrm is the empty BLOB within the database
          outstrm = databaseBlob.getBinaryOutputStream();

          try  // Input stream to output Stream
          {
            base64.decodeBuffer(xmlDiagram, outstrm);
          }
          catch (Exception e)
          {
             e.printStackTrace();
// System.out.println("converstion error: " + e);
          }

          outstrm.close();
         }

    }
    // if the Node is null, just catch the exception and ignore it
    catch (NullPointerException npe)
    {
    }
    catch (Exception e) // Output Streams
    {
        e.printStackTrace();
// System.out.println("converstion error: " + e);
    }  */

  }  // Public imageLoad

// *******************************************************************
// *****    populateVehicle                                      *****
// *******************************************************************
  public static void populateVehicle(VehicleRecord inVehRecord,
                                     Element       inElement)
  {
     if (inElement.getLocalName() == "Vehicle_Id")
         inVehRecord.setVehicleID(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Passenger_Count")
         inVehRecord.setPassengerCount(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Public_Property_Damage")
         inVehRecord.setPubPropertyDamage(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Registrant_First_Name")
         inVehRecord.setRegistrantFirstName(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Registrant_Middle_Name")
         inVehRecord.setRegistrantMiddleName(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Registrant_Last_Name")
         inVehRecord.setRegistrantLastName(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Registrant_Sex")
         inVehRecord.setRegistrantSex(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Registrant_Birth_Date")
         inVehRecord.setRegistrantBirthDate(inElement.getAttribute("Month") + "/" +
                                             inElement.getAttribute("Day") + "/" +
                                              inElement.getAttribute("Year"));
     else if (inElement.getLocalName() == "Hazmat")
       {
         inVehRecord.setHazmatCode(inElement.getAttribute("Code"));
         inVehRecord.setHazmatReleased(inElement.getAttribute("Released"));
         inVehRecord.setHazmatHasPlacard(inElement.getAttribute("Has_Placard"));
       }
     else if (inElement.getLocalName() == "Registrant_Street_Address_1")
         inVehRecord.setRegistrantAddress(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Registrant_City")
         inVehRecord.setRegistrantCity(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Registrant_State")
         inVehRecord.setRegistrantState(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Registrant_Zip_Code")
         inVehRecord.setRegistrantZipCode(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Plate_Number")
         inVehRecord.setPlateNumber(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Plate_State")
         inVehRecord.setPlateState(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Year")
         inVehRecord.setYear(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Insurance_Carrier_Code")
         inVehRecord.setInsCarrierCode(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Vehicle_Make")
         inVehRecord.setVehMake(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Body_Type")
         inVehRecord.setBodyType(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Vehicle_Wide")
         inVehRecord.setVehWide(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Vehicle_Long")
         inVehRecord.setVehLong(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Vehicle_Overweight_Permit")
         inVehRecord.setVehOverweight(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Vehicle_Over_Dimension_Permit")
         inVehRecord.setVehOverdimension(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Damage")
       {
         String damageCat = inElement.getAttribute("Category");
         if (damageCat.equals("1"))
            inVehRecord.setDamage1(inElement.getAttribute("Type"));
         else if (damageCat.equals("2"))
            inVehRecord.setDamage2(inElement.getAttribute("Type"));
         else if (damageCat.equals("-") && inVehRecord.getDamage3().equals(""))
            inVehRecord.setDamage3(inElement.getAttribute("Type"));
         else if (damageCat.equals("-") && inVehRecord.getDamage4().equals(""))
            inVehRecord.setDamage4(inElement.getAttribute("Type"));
         else if (damageCat.equals("-") && inVehRecord.getDamage5().equals(""))
            inVehRecord.setDamage5(inElement.getAttribute("Type"));
       }
     else if (inElement.getLocalName() == "Towed_By")
         inVehRecord.setTowedBy(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Towed_To")
         inVehRecord.setTowedTo(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Vehicle_Contributing_Factor")
       {
         if (inVehRecord.getContributingFactor1() == "")
            inVehRecord.setContributingFactor1(inElement.getAttribute("Code"));
         else if (inVehRecord.getContributingFactor2() == "")
            inVehRecord.setContributingFactor2(inElement.getAttribute("Code"));
       }
     else if (inElement.getLocalName() == "Direction_Travel")
         inVehRecord.setDirectionTravel(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Pre_Accident_Action")
         inVehRecord.setPreAccdAction(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Second_Event")
         inVehRecord.setSecondEvent(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Private_Property_Damage")
         inVehRecord.setPrivatePropDamage(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Vehicle_Towed")
         inVehRecord.setVehTowed(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Vehicle_Placard")
         inVehRecord.setVehPlacard(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "VIN")
         inVehRecord.setVIN(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Unknown_Speed_Indicator")
         inVehRecord.setUnknownSpeedInd(inElement.getAttribute("Value"));

  } // End populateVehicle

// *******************************************************************
// *****    insertVehicle                                        *****
// *******************************************************************
  public static void insertVehicle(Connection    inConn,
                                   VehicleRecord inVehRecord)
  {

// System.out.println("inserting vehicle " + inVehRecord.getVehicleID());

     try
     {
      Statement vStmt = inConn.createStatement();

      vStmt.executeUpdate("insert into sms.clob_report_vehicle " +
          "(CLOB_REPORT_PK, VEHICLE_ID, PASSENGER_COUNT, PUBLIC_PROPERTY_DAMAGE, REGISTRANT_NAME, " +
          "REGISTRANT_SEX, REGISTRANT_BIRTH_DATE, HAZMAT_CODE, HAZMAT_RELEASED, HAZMAT_HAS_PLACARD, " +
          "REGISTRANT_ADDRESS, REGISTRANT_CITY, REGISTRANT_STATE, REGISTRANT_ZIP_CODE, PLATE_NUMBER, " +
          "PLATE_STATE, YEAR, VEHICLE_MAKE, BODY_TYPE, INS_CARRIER_CODE, " +
          "VEH_WIDE, VEH_LONG, VEH_OVERWEIGHT_PERMIT, VEH_OVER_DIM_PERMIT, DAMAGE_1, " +
          "DAMAGE_2, DAMAGE_3, DAMAGE_4, DAMAGE_5, TOWED_BY, " +
          "TOWED_TO, CONTRIBUTING_FACTOR_1, CONTRIBUTING_FACTOR_2, DIRECTION_TRAVEL, PRE_ACCIDENT_ACTION, " +
          "SECOND_EVENT, PRIVATE_PROP_DAMAGE, VEHICLE_TOWED, VEHICLE_PLACARD, VIN, " +
          "UNKNOWN_SPEED_IND) " +
        "values (" +
                      inVehRecord.getCasePk()            + "," +     //  CLOB_REPORT_PK
                "'" + inVehRecord.getVehicleID()         + "'," +    //  VEHICLE_ID
                "'" + inVehRecord.getPassengerCount()    + "'," +    //   PASSENGER_COUNT
                "'" + inVehRecord.getPubPropertyDamage() + "'," +    //   PUBLIC_PROPERTY_DAMAGE
                "substr(ltrim('" + replace(inVehRecord.getRegistrantName(),"'","''") + "'),1,50)," +  //   REGISTRANT_NAME
                "'" + inVehRecord.getRegistrantSex()     + "'," +    //   REGISTRANT_SEX
               "to_date('" + inVehRecord.getRegistrantBirthDate() + "','MM/DD/YYYY')," + //   REGISTRANT_BIRTH_DATE
                "'" + inVehRecord.getHazmatCode()        + "'," +    //   HAZMAT_CODE
                "'" + inVehRecord.getHazmatReleased()    + "'," +    //   HAZMAT_RELEASED
                "'" + inVehRecord.getHazmatHasPlacard()  + "'," +    //   HAZMAT_HAS_PLACARD
                "'" + replace(inVehRecord.getRegistrantAddres(),"'","''") + "'," +    //   REGISTRANT_ADDRESS
                "'" + replace(inVehRecord.getRegistrantCity()  ,"'","''") + "'," +    //   REGISTRANT_CITY
                "'" + inVehRecord.getRegistrantState()   + "'," +    //   REGISTRANT_STATE
                "'" + inVehRecord.getRegistrantZipCode() + "'," +    //   REGISTRANT_ZIP_CODE
                "'" + replace(inVehRecord.getPlateNumber(),"'","") + "'," +           //   PLATE_NUMBER
                "'" + inVehRecord.getPlateState()       + "'," +     //   PLATE_STATE
                "'" + inVehRecord.getYear()             + "'," +     //   YEAR
                "'" + inVehRecord.getVehMake()          + "'," +     //   VEHICLE_MAKE
                "'" + inVehRecord.getBodyType()         + "'," +     //   BODY_TYPE
                "'" + inVehRecord.getInsCarrierCode()   + "'," +     //   INS_CARRIER_CODE
                "'" + inVehRecord.getVehWide()          + "'," +     //   VEH_WIDE
                "'" + inVehRecord.getVehLong()          + "'," +     //   VEH_LONG
                "'" + inVehRecord.getVehOverweight()    + "'," +     //   VEH_OVERWEIGHT_PERMIT
                "'" + inVehRecord.getVehOverdimension() + "'," +     //   VEH_OVER_DIM_PERMIT
                "'" + inVehRecord.getDamage1()          + "'," +     //   DAMAGE_1
                "'" + inVehRecord.getDamage2()          + "'," +     //   DAMAGE_2
                "'" + inVehRecord.getDamage3()          + "'," +     //   DAMAGE_3
                "'" + inVehRecord.getDamage4()          + "'," +     //   DAMAGE_4
                "'" + inVehRecord.getDamage5()          + "'," +     //   DAMAGE_5
                "'" + replace(inVehRecord.getTowedBy(),"'","''") + "'," +     //   TOWED_BY
                "'" + replace(inVehRecord.getTowedTo(),"'","''") + "'," +     //   TOWED_TO
                "'" + inVehRecord.getContributingFactor1() + "'," +  //   CONTRIBUTING_FACTOR_1
                "'" + inVehRecord.getContributingFactor2() + "'," +  //   CONTRIBUTING_FACTOR_2
                "'" + inVehRecord.getDirectionTravel()     + "'," +  //   DIRECTION_TRAVEL
                "'" + inVehRecord.getPreAccdAction()       + "'," +  //   PRE_ACCIDENT_ACTION
                "'" + inVehRecord.getSecondEvent()         + "'," +  //   SECOND_EVENT
                "'" + inVehRecord.getPrivatePropDamage()   + "'," +  //   PRIVATE_PROP_DAMAGE
                "'" + inVehRecord.getVehTowed()            + "'," +  //   VEHICLE_TOWED
                "'" + inVehRecord.getVehPlacard()          + "'," +  //   VEHICLE_PLACARD
                "'" + inVehRecord.getVIN()                 + "'," +  //   VIN
                "'" + inVehRecord.getUnknownSpeedInd() + "')");      //   UNKNOWN_SPEED_IND

        vStmt.execute("commit");
        vStmt.close();

     }
     catch (Exception e)
     {
        e.printStackTrace();
//  System.out.println("vehicle error: " + e)
     }

  } // Insert Vehicle Record

// *******************************************************************
// *****    populateIndividual                                   *****
// *******************************************************************
  public static void populateIndividual(IndividualRecord inIndRecord,
                                        Element          inElement)
  {

     if (inElement.getLocalName() == "Individual_Vehicle_Id")
         inIndRecord.setVehicleID(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Emotional_Status")
         inIndRecord.setEmotionalStatus(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Seat_Position")
         inIndRecord.setSeatPostion(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Ejected")
         inIndRecord.setEjected(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Left_Scene")
         inIndRecord.setLeftScene(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "First_Name")
         inIndRecord.setFirstName(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Middle_Name")
         inIndRecord.setMiddleName(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Last_Name")
         inIndRecord.setLastName(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Street_Address_1")
         inIndRecord.setStreetAddress(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "City")
         inIndRecord.setCity(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "State")
         inIndRecord.setState(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "Zip_Code")
         inIndRecord.setZipCode(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "License_Number")
         inIndRecord.setLicenseNumber(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "License_State")
         inIndRecord.setLicenseState(inElement.getAttribute("Code"));
     else if (inElement.getLocalName() == "EMST_CDE")
         inIndRecord.setEMSTCde(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Hospital_CDE")
         inIndRecord.setHospitalCde(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Birth_Date")
         inIndRecord.setBirthDate(inElement.getAttribute("Month") + "/" +
                                             inElement.getAttribute("Day") + "/" +
                                              inElement.getAttribute("Year"));
     else if (inElement.getLocalName() == "Sex")
         inIndRecord.setSex(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Age")
         inIndRecord.setAge(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Unlicensed_Driver")
         inIndRecord.setUnlicensedDriver(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Deceased")
         inIndRecord.setDeceasedInd(inElement.getAttribute("Value"));
     else if (inElement.getLocalName() == "Death_Date")
         inIndRecord.setDeceasedDate(inElement.getAttribute("Month") + "/" +
                                             inElement.getAttribute("Day") + "/" +
                                              inElement.getAttribute("Year"));
     else if (inElement.getLocalName() == "Injury")
       {
         inIndRecord.setInjLocation(inElement.getAttribute("Location"));
         inIndRecord.setInjType(inElement.getAttribute("Type"));
       }
     else if (inElement.getLocalName() == "Ticket")
       {
         if (inIndRecord.getTicketNumbers() == "")
           inIndRecord.setTicketNumbers(inElement.getAttribute("Number"));
         else
           inIndRecord.setTicketNumbers(inIndRecord.getTicketNumbers() + ", " + inElement.getAttribute("Number"));

         if (inIndRecord.getTicketViolations() == "")
           inIndRecord.setTicketViolations(inElement.getAttribute("Violation"));
         else
           inIndRecord.setTicketViolations(inIndRecord.getTicketViolations() + ", " + inElement.getAttribute("Violation"));
       }
     else if (inElement.getLocalName() == "Safety_Equipment")
         inIndRecord.setSafetyEquipment(inElement.getAttribute("Type"));

  }  // End populateIndividual

// *******************************************************************
// *****    insertIndividual                                     *****
// *******************************************************************
  public static void insertIndividual(Connection       inConn,
                                      IndividualRecord inIndRecord)
  {

// System.out.println("Individual " + inIndRecord.getName());
     try
     {
      Statement iStmt = inConn.createStatement();

      // Update vehicle record with the Driver Information if Seat Position = '1'
      if (inIndRecord.getSeatPosition().equals("1"))
    {
         iStmt.executeUpdate("update sms.clob_report_vehicle set " +
                 "license_number    = '" + inIndRecord.getLicenseNumber() + "', " +
                 "license_state     = '" + inIndRecord.getLicenseState() + "', " +
                 "driver_name       = '" + replace(inIndRecord.getName(),"'","''") + "', " +
                 "driver_address    = '" + replace(inIndRecord.getStreetAddress(),"'","''") + "', " +
                 "driver_city       = '" + replace(inIndRecord.getCity(),"'","''") + "', " +
                 "driver_state      = '" + inIndRecord.getState() + "', " +
                 "driver_zip_code   = '" + inIndRecord.getZipCode() + "', " +
                 "driver_birth_date = to_date('" + inIndRecord.getBirthDate()+ "','MM/DD/YYYY')," +
                 "driver_sex        = '" + inIndRecord.getSex() + "', " +
                 "unlicensed_driver = '" + inIndRecord.getUnlicensedDriver() + "', " +
                 "left_scene        = '" + inIndRecord.getLeftScene() + "', " +
                 "ticket_numbers    = substr('" + inIndRecord.getTicketNumbers() + "',1,60), " +
                 "violations        = substr('" + inIndRecord.getTicketViolations() + "',1,50)" +
           " where clob_report_pk = " + inIndRecord.getCasePk() +
           "   and vehicle_id = '" + inIndRecord.getVehicleID() + "'");
      }

      iStmt.executeUpdate("insert into sms.clob_report_individual " +
          "(CLOB_REPORT_PK, VEHICLE_ID, SEAT_POSITION, SAFETY_EQUIPMENT, EJECTED, " +
          " AGE, SEX, INJURY_LOCATION, INJURY_TYPE, EMOTIONAL_STATUS, " +
          " EMST_CDE, HOSPITAL_CDE, NAME, DECEASED_IND, DECEASED_DATE) " +
        "values (" +
                  inIndRecord.getCasePk()          + "," +   // CLOB_REPORT_PK
            "'" + inIndRecord.getVehicleID()       + "'," +  // VEHICLE_ID
            "'" + inIndRecord.getSeatPosition()    + "'," +  // SEAT_POSITION
            "'" + inIndRecord.getSafetyEquipment() + "'," +  // SAFETY_EQUIPMENT
            "'" + inIndRecord.getEjected()         + "'," +  // EJECTED
            "'" + inIndRecord.getAge()             + "'," +  // AGE
            "'" + inIndRecord.getSex()             + "'," +  // SEX
            "'" + inIndRecord.getInjLocation()     + "'," +  // INJURY_LOCATION
            "'" + inIndRecord.getInjType()         + "'," +  // INJURY_TYPE
            "'" + inIndRecord.getEmotionalStatus() + "'," +  // EMOTIONAL_STATUS
            "substr('" + inIndRecord.getEMSTCde()     + "',1,8)," +  // EMST_CDE
            "substr('" + inIndRecord.getHospitalCde() + "',1,8)," +  // HOSPITAL_CDE
            "substr('" + replace(inIndRecord.getName(),"'","''") + "',1,50)," +  // NAME
            "'" + inIndRecord.getDeceasedInd()     + "'," +  // DECEASED_IND
            "to_date('" + inIndRecord.getDeceasedDate()+ "','MM/DD/YYYY'))"); //DECEASED_DATE

        iStmt.execute("commit");
        iStmt.close();

     }
     catch (Exception e)
     {
        e.printStackTrace();
//  System.out.println("vehicle error: " + e)
     }

  } // End insertIndividual

// *******************************************************************
// *****    replace                                              *****
// *******************************************************************
  static String replace(String str, String pattern, String replace) {
      int s = 0;
      int e = 0;
      StringBuffer result = new StringBuffer();

      while ((e = str.indexOf(pattern, s)) >= 0) {
          result.append(str.substring(s, e));
          result.append(replace);
          s = e+pattern.length();
      }
      result.append(str.substring(s));
      return result.toString();
   } // end Replace

} //Class AccidentReport
;

629                  "'" + inVehRecord.getPlateState()       + "'," +     //   P
LATE_STATE
630                  "'" + inVehRecord.getYear()             + "'," +     //   Y
EAR
631                  "'" + inVehRecord.getVehMake()          + "'," +     //   V
EHICLE_MAKE
632                  "'" + inVehRecord.getBodyType()         + "'," +     //   B
ODY_TYPE
633                  "'" + inVehRecord.getInsCarrierCode()   + "'," +     //   I
NS_CARRIER_CODE
634                  "'" + inVehRecord.getVehWide()          + "'," +     //   V
EH_WIDE
635                  "'" + inVehRecord.getVehLong()          + "'," +     //   V
EH_LONG
636                  "'" + inVehRecord.getVehOverweight()    + "'," +     //   V
EH_OVERWEIGHT_PERMIT
637                  "'" + inVehRecord.getVehOverdimension() + "'," +     //   V
EH_OVER_DIM_PERMIT
638                  "'" + inVehRecord.getDamage1()          + "'," +     //   D
AMAGE_1
639                  "'" + inVehRecord.getDamage2()          + "'," +     //   D
AMAGE_2
640                  "'" + inVehRecord.getDamage3()          + "'," +     //   D
AMAGE_3
641                  "'" + inVehRecord.getDamage4()          + "'," +     //   D
AMAGE_4
642                  "'" + inVehRecord.getDamage5()          + "'," +     //   D
AMAGE_5
643                  "'" + replace(inVehRecord.getTowedBy(),"'","''") + "'," +
   //   TOWED_BY
644                  "'" + replace(inVehRecord.getTowedTo(),"'","''") + "'," +
   //   TOWED_TO
645                  "'" + inVehRecord.getContributingFactor1() + "'," +  //   C
ONTRIBUTING_FACTOR_1
646                  "'" + inVehRecord.getContributingFactor2() + "'," +  //   C
ONTRIBUTING_FACTOR_2
647                  "'" + inVehRecord.getDirectionTravel()     + "'," +  //   D
IRECTION_TRAVEL
648                  "'" + inVehRecord.getPreAccdAction()       + "'," +  //   P
RE_ACCIDENT_ACTION
649                  "'" + inVehRecord.getSecondEvent()         + "'," +  //   S
ECOND_EVENT
650                  "'" + inVehRecord.getPrivatePropDamage()   + "'," +  //   P
RIVATE_PROP_DAMAGE
651                  "'" + inVehRecord.getVehTowed()            + "'," +  //   V
EHICLE_TOWED
652                  "'" + inVehRecord.getVehPlacard()          + "'," +  //   V
EHICLE_PLACARD
653                  "'" + inVehRecord.getVIN()                 + "'," +  //   V
IN
654                  "'" + inVehRecord.getUnknownSpeedInd() + "')");      //   U
NKNOWN_SPEED_IND
655
656          vStmt.execute("commit");
657          vStmt.close();
658
659       }
660       catch (Exception e)
661       {
662          e.printStackTrace();
663  //  System.out.println("vehicle error: " + e)
664       }
665
666    } // Insert Vehicle Record
667
668  // *******************************************************************
669  // *****    populateIndividual                                   *****
670  // *******************************************************************
671    public static void populateIndividual(IndividualRecord inIndRecord,
672                                          Element          inElement)
673    {
674
675       if (inElement.getLocalName() == "Individual_Vehicle_Id")
676           inIndRecord.setVehicleID(inElement.getAttribute("Value"));
677       else if (inElement.getLocalName() == "Emotional_Status")
678           inIndRecord.setEmotionalStatus(inElement.getAttribute("Code"));
679       else if (inElement.getLocalName() == "Seat_Position")
680           inIndRecord.setSeatPostion(inElement.getAttribute("Code"));
681       else if (inElement.getLocalName() == "Ejected")
682           inIndRecord.setEjected(inElement.getAttribute("Code"));
683       else if (inElement.getLocalName() == "Left_Scene")
684           inIndRecord.setLeftScene(inElement.getAttribute("Value"));
685       else if (inElement.getLocalName() == "First_Name")
686           inIndRecord.setFirstName(inElement.getAttribute("Value"));
687       else if (inElement.getLocalName() == "Middle_Name")
688           inIndRecord.setMiddleName(inElement.getAttribute("Value"));
689       else if (inElement.getLocalName() == "Last_Name")
690           inIndRecord.setLastName(inElement.getAttribute("Value"));
691       else if (inElement.getLocalName() == "Street_Address_1")
692           inIndRecord.setStreetAddress(inElement.getAttribute("Value"));
693       else if (inElement.getLocalName() == "City")
694           inIndRecord.setCity(inElement.getAttribute("Value"));
695       else if (inElement.getLocalName() == "State")
696           inIndRecord.setState(inElement.getAttribute("Code"));
697       else if (inElement.getLocalName() == "Zip_Code")
698           inIndRecord.setZipCode(inElement.getAttribute("Value"));
699       else if (inElement.getLocalName() == "License_Number")
700           inIndRecord.setLicenseNumber(inElement.getAttribute("Value"));
701       else if (inElement.getLocalName() == "License_State")
702           inIndRecord.setLicenseState(inElement.getAttribute("Code"));
703       else if (inElement.getLocalName() == "EMST_CDE")
704           inIndRecord.setEMSTCde(inElement.getAttribute("Value"));
705       else if (inElement.getLocalName() == "Hospital_CDE")
706           inIndRecord.setHospitalCde(inElement.getAttribute("Value"));
707       else if (inElement.getLocalName() == "Birth_Date")
708           inIndRecord.setBirthDate(inElement.getAttribute("Month") + "/" +
709                                               inElement.getAttribute("Day")
+ "/" +
710                                                inElement.getAttribute("Year"
));
711       else if (inElement.getLocalName() == "Sex")
712           inIndRecord.setSex(inElement.getAttribute("Value"));
713       else if (inElement.getLocalName() == "Age")
714           inIndRecord.setAge(inElement.getAttribute("Value"));
715       else if (inElement.getLocalName() == "Unlicensed_Driver")
716           inIndRecord.setUnlicensedDriver(inElement.getAttribute("Value"));
717       else if (inElement.getLocalName() == "Deceased")
718           inIndRecord.setDeceasedInd(inElement.getAttribute("Value"));
719       else if (inElement.getLocalName() == "Death_Date")
720           inIndRecord.setDeceasedDate(inElement.getAttribute("Month") + "/"
+
721                                               inElement.getAttribute("Day")
+ "/" +
722                                                inElement.getAttribute("Year"
));
723       else if (inElement.getLocalName() == "Injury")
724         {
725           inIndRecord.setInjLocation(inElement.getAttribute("Location"));
726           inIndRecord.setInjType(inElement.getAttribute("Type"));
727         }
728       else if (inElement.getLocalName() == "Ticket")
729         {
730           if (inIndRecord.getTicketNumbers() == "")
731             inIndRecord.setTicketNumbers(inElement.getAttribute("Number"));
732           else
733             inIndRecord.setTicketNumbers(inIndRecord.getTicketNumbers() + ",
 " + inElement.getAttribute("Number"));
734
735           if (inIndRecord.getTicketViolations() == "")
736             inIndRecord.setTicketViolations(inElement.getAttribute("Violatio
n"));
737           else
738             inIndRecord.setTicketViolations(inIndRecord.getTicketViolations(
) + ", " + inElement.getAttribute("Violation"));
739         }
740       else if (inElement.getLocalName() == "Safety_Equipment")
741           inIndRecord.setSafetyEquipment(inElement.getAttribute("Type"));
742
743    }  // End populateIndividual
744
745  // *******************************************************************
746  // *****    insertIndividual                                     *****
747  // *******************************************************************
748    public static void insertIndividual(Connection       inConn,
749                                        IndividualRecord inIndRecord)
750    {
751
752  // System.out.println("Individual " + inIndRecord.getName());
753       try
754       {
755        Statement iStmt = inConn.createStatement();
756
757        // Update vehicle record with the Driver Information if Seat Position
 = '1'
758        if (inIndRecord.getSeatPosition().equals("1"))
759      {
760           iStmt.executeUpdate("update sms.clob_report_vehicle set " +
761                   "license_number    = '" + inIndRecord.getLicenseNumber() +
 "', " +
762                   "license_state     = '" + inIndRecord.getLicenseState() +
"', " +
763                   "driver_name       = '" + replace(inIndRecord.getName(),"'
","''") + "', " +
764                   "driver_address    = '" + replace(inIndRecord.getStreetAdd
ress(),"'","''") + "', " +
765                   "driver_city       = '" + replace(inIndRecord.getCity(),"'
","''") + "', " +
766                   "driver_state      = '" + inIndRecord.getState() + "', " +

767                   "driver_zip_code   = '" + inIndRecord.getZipCode() + "', "
 +
768                   "driver_birth_date = to_date('" + inIndRecord.getBirthDate
()+ "','MM/DD/YYYY')," +
769                   "driver_sex        = '" + inIndRecord.getSex() + "', " +
770                   "unlicensed_driver = '" + inIndRecord.getUnlicensedDriver(
) + "', " +
771                   "left_scene        = '" + inIndRecord.getLeftScene() + "',
 " +
772                   "ticket_numbers    = substr('" + inIndRecord.getTicketNumb
ers() + "',1,60), " +
773                   "violations        = substr('" + inIndRecord.getTicketViol
ations() + "',1,50)" +
774             " where clob_report_pk = " + inIndRecord.getCasePk() +
775             "   and vehicle_id = '" + inIndRecord.getVehicleID() + "'");
776        }
777
778        iStmt.executeUpdate("insert into sms.clob_report_individual " +
779            "(CLOB_REPORT_PK, VEHICLE_ID, SEAT_POSITION, SAFETY_EQUIPMENT, EJ
ECTED, " +
780            " AGE, SEX, INJURY_LOCATION, INJURY_TYPE, EMOTIONAL_STATUS, " +
781            " EMST_CDE, HOSPITAL_CDE, NAME, DECEASED_IND, DECEASED_DATE) " +
782          "values (" +
783                    inIndRecord.getCasePk()          + "," +   // CLOB_REPORT
_PK
784              "'" + inIndRecord.getVehicleID()       + "'," +  // VEHICLE_ID
785              "'" + inIndRecord.getSeatPosition()    + "'," +  // SEAT_POSITI
ON
786              "'" + inIndRecord.getSafetyEquipment() + "'," +  // SAFETY_EQUI
PMENT
787              "'" + inIndRecord.getEjected()         + "'," +  // EJECTED
788              "'" + inIndRecord.getAge()             + "'," +  // AGE
789              "'" + inIndRecord.getSex()             + "'," +  // SEX
790              "'" + inIndRecord.getInjLocation()     + "'," +  // INJURY_LOCA
TION
791              "'" + inIndRecord.getInjType()         + "'," +  // INJURY_TYPE

792              "'" + inIndRecord.getEmotionalStatus() + "'," +  // EMOTIONAL_S
TATUS
793              "substr('" + inIndRecord.getEMSTCde()     + "',1,8)," +  // EMS
T_CDE
794              "substr('" + inIndRecord.getHospitalCde() + "',1,8)," +  // HOS
PITAL_CDE
795              "substr('" + replace(inIndRecord.getName(),"'","''") + "',1,50)
," +  // NAME
796              "'" + inIndRecord.getDeceasedInd()     + "'," +  // DECEASED_IN
D
797              "to_date('" + inIndRecord.getDeceasedDate()+ "','MM/DD/YYYY'))"
); //DECEASED_DATE
798
799          iStmt.execute("commit");
800          iStmt.close();
801
802       }
803       catch (Exception e)
804       {
805          e.printStackTrace();
806  //  System.out.println("vehicle error: " + e)
807       }
808
809    } // End insertIndividual
810
811  }
812  ;
813  /
Enter value for invehrecord:
old 553:          else if (damageCat.equals("-") && inVehRecord.getDamage3().equ
als(""))
new 553:          else if (damageCat.equals("-") getDamage3().equals(""))
old 555:          else if (damageCat.equals("-") && inVehRecord.getDamage4().equ
als(""))
new 555:          else if (damageCat.equals("-") getDamage4().equals(""))
old 557:          else if (damageCat.equals("-") && inVehRecord.getDamage5().equ
als(""))
new 557:          else if (damageCat.equals("-") getDamage5().equals(""))
create or replace and compile java source named sms.accidentreport2 as
                                                    *
ERROR at line 1:
ORA-29536: badly formed source: Encountered "getDamage3" at line 552, column
41.
Was expecting one of:
"instanceof" ...
")" ...
"<" ...
"?" ...
"==" ...
"<=" ...
">=" ...
"!=" ...
"||" ...
"&&" ...
"++" ...
"--" ...
"+" ...
"-" ...
"*" ...
"/" ...
"&" ...
"|" ...
"^" ...
"%" ...
">" ...
"=" ...
"*=" ...
"/=" ...
"%=" ...
"+=" ...
"-=" ...
"<<=" ...
">>=" ...
">>>=" ...
"&=" ...
"^=" ...
"|=" ...
"<<" ...
"." ...
"[" ...
"(" ...


SQL>