here is the code
this is the code of sql mapping file before I add the field <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd";> <sqlMap namespace="AsetNDetail"> <typeAlias alias="asetNdetail" type="org.pustaka.domain.AsetNDetail"/> <resultMap id="asetNdetailResult" class="asetNdetail"> <result property="no_aset" column="NO_ASET"/> <result property="ddc4" column="DDC4"/> <result property="no_detail" column="NO_DETAIL"/> <result property="kode_rak" column="KODE_RAK"/> <result property="cetakan" column="CETAKAN"/> <result property="edisi" column="EDISI"/> <result property="ukuran" column="UKURAN"/> <result property="harga" column="HARGA"/> <result property="sumber" column="SUMBER"/> <result property="jml_halaman" column="JML_HALAMAN"/> <result property="tahun_cetak" column="TAHUN_CETAK"/> <result property="tgl_masuk" column="TGL_MASUK"/> <result property="ket" column="KET"/> <result property="no_ddc" column="NO_DDC"/> <result property="ddc2" column="DDC2"/> <result property="ddc3" column="DDC3"/> <result property="judul" column="JUDUL"/> <result property="pengarang" column="PENGARANG"/> <result property="penerbit" column="PENERBIT"/> <result property="indek" column="INDEK"/> <result property="isbn" column="ISBN"/> <result property="status_detail" column="STATUS_DETAIL"/> <result property="gambar" column="GAMBAR"/> <result property="ringkasan" column="RINGKASAN"/> <result property="ket_detail" column="KET_DETAIL"/> </resultMap> <select id="findAsetNDetailByNo" resultMap="asetNdetailResult" parameterClass="asetNdetail"> select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where ASET.NO_ASET = #no_aset# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByNoAset" resultMap="asetNdetailResult"> select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where ASET.NO_ASET like #no_aset# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByNoDetail" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where ASET.NO_DETAIL = #no_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByStatus" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL like #status_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK order by DETAIL.JUDUL ASC </select> <select id="findAsetNDetailByJudul" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.JUDUL like #judul# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByPengarang" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.PENGARANG like #pengarang# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByPenerbit" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.PENERBIT like #penerbit# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByJudulPengarang" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.JUDUL like #judul# and DETAIL.PENGARANG like #pengarang# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByPengarangPenerbit" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.PENGARANG like #pengarang# and DETAIL.PENERBIT like #penerbit# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByJudulPenerbit" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.JUDUL like #judul# and DETAIL.PENERBIT like #penerbit# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByMonth" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL = #status_detail# and ASET.TGL_MASUK between #ket# and #ket_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByKetRak" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where RAK.KET_RAK = #ket_rak# and DETAIL.STATUS_DETAIL = #status_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailDiktatByJurusan" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where ASET.NO_ASET like #no_aset# and DETAIL.STATUS_DETAIL = #status_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailRusak" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL = #status_detail# and ASET.KET = #ket# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK union select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL = #status_detail# and ASET.KET = #pengarang# and ASET.TGL_RUSAK1 between #ringkasan# and #ket_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <update id="addAsetDiktat" parameterClass="asetNdetail"> insert into ASET(NO_ASET, NO_DETAIL, KODE_RAK, CETAKAN, HARGA, TAHUN_CETAK, TGL_MASUK, KET) values(#no_aset#, #no_detail#, #kode_rak#, #cetakan#, #harga#, #tahun_cetak#, #tgl_masuk#, #ket#) </update> <update id="addAsetNonBuku" parameterClass="asetNdetail"> insert into ASET(NO_ASET, NO_DETAIL, KODE_RAK, HARGA, SUMBER, TGL_MASUK, KET) values(#no_aset#, #no_detail#, #kode_rak#, #harga#, #sumber#, #tgl_masuk#, #ket#) </update> <update id="addAsetBuku" parameterClass="asetNdetail"> insert into ASET(NO_ASET, DDC4, NO_DETAIL, KODE_RAK, CETAKAN, EDISI, UKURAN, HARGA, SUMBER, JML_HALAMAN, TAHUN_CETAK, TGL_MASUK, KET) values(#no_aset#, #ddc4#, #no_detail#, #kode_rak#, #cetakan#, #edisi#, #ukuran#, #harga#, #sumber#, #jml_halaman#, #tahun_cetak#, #tgl_masuk#, #ket#) </update> <update id="updateAsetDiktat" parameterClass="asetNdetail"> update ASET set KODE_RAK = #kode_rak#, CETAKAN = #cetakan#, HARGA = #harga#, TAHUN_CETAK = #tahun_cetak#, TGL_MASUK = #tgl_masuk#, KET = #ket# where NO_ASET = #no_aset# </update> <update id="updateAsetNonBuku" parameterClass="asetNdetail"> update ASET set KODE_RAK = #kode_rak#, HARGA = #harga#, SUMBER = #sumber#, TGL_MASUK = #tgl_masuk#, KET = #ket# where NO_ASET = #no_aset# </update> <update id="updateAsetBuku" parameterClass="asetNdetail"> update ASET set DDC4 = #ddc4#, KODE_RAK = #kode_rak#, CETAKAN = #cetakan#, EDISI = #edisi#, UKURAN = #ukuran#, HARGA = #harga#, SUMBER = #sumber#, JML_HALAMAN = #jml_halaman#, TAHUN_CETAK = #tahun_cetak#, TGL_MASUK = #tgl_masuk#, KET = #ket# where NO_ASET = #no_aset# </update> <update id="deleteAset" parameterClass="asetNdetail"> delete from ASET where NO_ASET = #no_aset# </update> </sqlMap> and this the code after i add a field on table <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd";> <sqlMap namespace="AsetNDetail"> <typeAlias alias="asetNdetail" type="org.pustaka.domain.AsetNDetail"/> <resultMap id="asetNdetailResult" class="asetNdetail"> <result property="no_aset" column="NO_ASET"/> <result property="ddc4" column="DDC4"/> <result property="no_detail" column="NO_DETAIL"/> <result property="kode_rak" column="KODE_RAK"/> <result property="cetakan" column="CETAKAN"/> <result property="edisi" column="EDISI"/> <result property="ukuran" column="UKURAN"/> <result property="harga" column="HARGA"/> <result property="sumber" column="SUMBER"/> <result property="jml_halaman" column="JML_HALAMAN"/> <result property="tahun_cetak" column="TAHUN_CETAK"/> <result property="tgl_masuk" column="TGL_MASUK"/> <result property="ket" column="KET"/> <result property="no_ddc" column="NO_DDC"/> <result property="ddc2" column="DDC2"/> <result property="ddc3" column="DDC3"/> <result property="judul" column="JUDUL"/> <result property="pengarang" column="PENGARANG"/> <result property="penerbit" column="PENERBIT"/> <result property="indek" column="INDEK"/> <result property="isbn" column="ISBN"/> <result property="status_detail" column="STATUS_DETAIL"/> <result property="gambar" column="GAMBAR"/> <result property="ringkasan" column="RINGKASAN"/> <result property="ket_detail" column="KET_DETAIL"/> <result property="tgl_rusak1" column="TGL_RUSAK1"/> </resultMap> <select id="findAsetNDetailByNo" resultMap="asetNdetailResult" parameterClass="asetNdetail"> select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where ASET.NO_ASET = #no_aset# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByNoAset" resultMap="asetNdetailResult"> select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where ASET.NO_ASET like #no_aset# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByNoDetail" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where ASET.NO_DETAIL = #no_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByStatus" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL like #status_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK order by DETAIL.JUDUL ASC </select> <select id="findAsetNDetailByJudul" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.JUDUL like #judul# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByPengarang" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.PENGARANG like #pengarang# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByPenerbit" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.PENERBIT like #penerbit# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByJudulPengarang" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.JUDUL like #judul# and DETAIL.PENGARANG like #pengarang# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByPengarangPenerbit" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.PENGARANG like #pengarang# and DETAIL.PENERBIT like #penerbit# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByJudulPenerbit" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.JUDUL like #judul# and DETAIL.PENERBIT like #penerbit# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByMonth" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL = #status_detail# and ASET.TGL_MASUK between #ket# and #ket_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailByKetRak" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK, ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where RAK.KET_RAK = #ket_rak# and DETAIL.STATUS_DETAIL = #status_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailDiktatByJurusan" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where ASET.NO_ASET like #no_aset# and DETAIL.STATUS_DETAIL = #status_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <select id="findAsetNDetailRusak" resultMap="asetNdetailResult" > select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL = #status_detail# and ASET.KET = #ket# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK union select ASET.NO_ASET, ASET.DDC4, ASET.NO_DETAIL, ASET.KODE_RAK, ASET.CETAKAN, ASET.EDISI, ASET.UKURAN, ASET.HARGA, ASET.SUMBER, ASET.JML_HALAMAN, ASET.TAHUN_CETAK, ASET.TGL_MASUK, ASET.KET, DETAIL.NO_DDC, DETAIL.DDC2, DETAIL.DDC3, DETAIL.JUDUL, DETAIL.PENGARANG, DETAIL.PENERBIT, DETAIL.INDEK, DETAIL.ISBN, DETAIL.STATUS_DETAIL, DETAIL.GAMBAR, DETAIL.RINGKASAN, DETAIL.KET_DETAIL, RAK.KET_RAK , ASET.TGL_RUSAK1 from ASET, DETAIL, RAK where DETAIL.STATUS_DETAIL = #status_detail# and ASET.KET = #pengarang# and ASET.TGL_RUSAK1 between #ringkasan# and #ket_detail# and ASET.NO_DETAIL = DETAIL.NO_DETAIL and ASET.KODE_RAK = RAK.KODE_RAK </select> <update id="addAsetDiktat" parameterClass="asetNdetail"> insert into ASET(NO_ASET, NO_DETAIL, KODE_RAK, CETAKAN, HARGA, TAHUN_CETAK, TGL_MASUK, KET) values(#no_aset#, #no_detail#, #kode_rak#, #cetakan#, #harga#, #tahun_cetak#, #tgl_masuk#, #ket#) </update> <update id="addAsetNonBuku" parameterClass="asetNdetail"> insert into ASET(NO_ASET, NO_DETAIL, KODE_RAK, HARGA, SUMBER, TGL_MASUK, KET) values(#no_aset#, #no_detail#, #kode_rak#, #harga#, #sumber#, #tgl_masuk#, #ket#) </update> <update id="addAsetBuku" parameterClass="asetNdetail"> insert into ASET(NO_ASET, DDC4, NO_DETAIL, KODE_RAK, CETAKAN, EDISI, UKURAN, HARGA, SUMBER, JML_HALAMAN, TAHUN_CETAK, TGL_MASUK, KET) values(#no_aset#, #ddc4#, #no_detail#, #kode_rak#, #cetakan#, #edisi#, #ukuran#, #harga#, #sumber#, #jml_halaman#, #tahun_cetak#, #tgl_masuk#, #ket#) </update> <update id="updateAsetDiktat" parameterClass="asetNdetail"> update ASET set KODE_RAK = #kode_rak#, CETAKAN = #cetakan#, HARGA = #harga#, TAHUN_CETAK = #tahun_cetak#, TGL_MASUK = #tgl_masuk#, KET = #ket# where NO_ASET = #no_aset# </update> <update id="updateAsetNonBuku" parameterClass="asetNdetail"> update ASET set KODE_RAK = #kode_rak#, HARGA = #harga#, SUMBER = #sumber#, TGL_MASUK = #tgl_masuk#, KET = #ket# where NO_ASET = #no_aset# </update> <update id="updateAsetBuku" parameterClass="asetNdetail"> update ASET set DDC4 = #ddc4#, KODE_RAK = #kode_rak#, CETAKAN = #cetakan#, EDISI = #edisi#, UKURAN = #ukuran#, HARGA = #harga#, SUMBER = #sumber#, JML_HALAMAN = #jml_halaman#, TAHUN_CETAK = #tahun_cetak#, TGL_MASUK = #tgl_masuk#, KET = #ket# where NO_ASET = #no_aset# </update> <update id="deleteAset" parameterClass="asetNdetail"> delete from ASET where NO_ASET = #no_aset# </update> </sqlMap> and this is the error code after run the file HTTP Status 500 - -------------------------------------------------------------------------------- type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:595) root cause javax.servlet.ServletException at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:536) at org.apache.jsp.formCariAset_jsp._jspService(formCariAset_jsp.java:1262) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:595) -- View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14484571.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
