Database

DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000)))

DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]) AND (SELECT COUNT(*) AS DEM FROM HDMUABAN WHERE (((HDMUABAN.HD)='M1101') AND ((HDMUABAN.LOAIHD)='FBAN') AND ((Month([NGAYGIAO]))=1) AND ((Year([NGAYGIAO]))=2019)) GROUP BY HDMUABAN.HD, HDMUABAN.NGAYGIAO, HDMUABAN.LOAIHD) AS NUM <=0,[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000)))
TONGDOANHTHU2: IIf(Not IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[DOANHTHU2]+[BSLN],IIf(IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[BSLN],[DOANHTHU2]))

    string[] strSearch = TextBox1.Text.Split(' ');
    string strSelect = "SELECT INVY.ITEMNUM AS Item, " +
        "INVY.DESCRIPTION AS Description, STOCK.QTYONHAND AS Quantity, " +
        "INVY.UOM AS 'Issue By', STOCK.LOCATION AS Location, INVY.MODEL AS Model, " +
        "INVY.UD2 AS IDGroup " +
        "FROM INVY LEFT OUTER JOIN STOCK ON INVY.ITEMNUM = STOCK.ITEMNUM " +
        "LEFT OUTER JOIN vw_Koogle_ISSREC_Grouping ON INVY.ITEMNUM = vw_Koogle_ISSREC_Grouping.ITEMNUM " +
        "LEFT OUTER JOIN INVVEND ON INVY.ITEMNUM = INVVEND.ITEMNUM " +
        "WHERE ";

    foreach (string strParam in strSearch)
    {
        strSelect = strSelect + "AND ((INVY.DESCRIPTION LIKE '%" + strParam + "%') OR " +
        "(INVY.NOTES LIKE '%" + strParam + "%') OR " +
        "(INVY.MODEL LIKE '%" + strParam + "%') OR " +
        "(INVY.UD2 LIKE '%" + strParam + "%') OR " +
        "(INVY.UD1 LIKE '%" + strParam + "%') OR " +
        "(INVY.ITEMNUM LIKE '%" + strParam + "%') OR " +
        "(vw_RRD_Koogle_ISSREC_Grouping.EQNUM LIKE '%" + strParam + "%') OR " +
        "(vw_RRD_Koogle_ISSREC_Grouping.NUMCHARGEDTO LIKE '%" + strParam + "%') OR " +
        "(INVVEND.VENDORITEMNUM LIKE '%" + strParam + "%')) ";
    }
    strSelect = strSelect.Replace("WHERE AND", "WHERE") +
        "GROUP BY INVY.ITEMNUM, INVY.DESCRIPTION, STOCK.QTYONHAND, " +
        "INVY.UOM, STOCK.LOCATION, INVY.MODEL, INVY.UD2 " +
        "ORDER BY INVY.DESCRIPTION";
    sqlMP2Search.SelectCommand = strSelect;
}

<?xml version = "1.0" encoding = "utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<session-factory>
		<property name="hibernate.dialect">
			org.hibernate.dialect.Oracle10gDialect
		</property>

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

		<property name="hibernate.connection.url">
			jdbc:oracle:thin:@localhost:1521:xe
		</property>

		<property name="hibernate.connection.username">
			SYSTEM
		</property>

		<property name="hibernate.connection.password">
			testingdatabasepassword
		</property>

		<mapping resource="com/testing/classes/Person.hbm.xml" />
	</session-factory>
</hibernate-configuration>

package com.testing.classes;

public class Person {

	private int id;
	private String firstName;
	private String lastName;
	private int age;

	public Person(String firstName, String lastName, int age) {
		this.firstName = firstName;
		this.lastName = lastName;
		this.age = age;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getFirstName() {
		return firstName;
	}

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public String getLastName() {
		return lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}
}

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

<hibernate-mapping>
   <class name = "com.testing.classes.Person" table = "PERSON">
      
      <id name = "id" type = "int" column = "ID">
         <generator class="sequence">
            <param name="sequence">CREATE_PERSON_ID</param>
          </generator>   
      </id>
      <property name = "firstName" column = "FIRST_NAME" type = "string"/>
      <property name = "lastName" column = "LAST_NAME" type = "string"/>
      <property name = "age" column = "AGE" type = "int"/>
      
   </class>
</hibernate-mapping>

CREATE SEQUENCE CREATE_PERSON_ID INCREMENT BY 1 START WITH 1 MAXVALUE 9999 MINVALUE 1 CACHE 10;

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();

Person person = new Person("Name", "Last name", 48);
session.save(person);  //Eclipse says the error is here
session.beginTransaction().commit();