You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Joni Tan <ja...@hotmail.com> on 2007/12/21 09:55:54 UTC
error after adding a field in table
i am making a project using ibatis , tomcat 4.1, and postgres sql as
database.
this program is ok till this last few days, but when I add a field at a
table I got a page hadle exception error, I have add the sql mapping for the
new field but I still get the error. This error make all my pages that
connect to database can't be run correctly, the java page hadle exception
always come out when i try to connect to the database after I add the field
>.<
anyboy have clues about this error ?
--
View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14452238.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: error after adding a field in table
Posted by Christopher Lamey <cl...@localmatters.com>.
On 12/26/07 12:24 AM, "Joni Tan" <ja...@hotmail.com> wrote:
>
> it's "localhost_log.2007-12-26.txt" log file, there is another log file
> "localhost_examples_log.2007-12-26.txt" but i think it's just an example log
> file and it doesn't have any exception
>
> hmm, i don't have exception caught like try and catch in my codding. But a
> while ago i add a simple try and catch in my codding and the status error is
> same like before.
>
> try {
> ...
> }catch(Exception ex) {
> out.println(ex);
> }
And this is in your jsp file? Do you have some kind of error handler setup
for HTTP 500s? I haven't written scriplets in jsp files for a while, but
the implicit variable 'out' is a stream to the response, so it'll just show
up in the browser - not a logfile.
In general, you should use some kind of logging facility (commons-logging,
JDK logging, log4j, etc.), know how it is configured, and know where the
logs are being written. Not having the ability to log correctly makes for
very difficult and painful development. For example, without proper
logging, you don't know what the root cause of your current exception, which
would give you a very detailed message including the line of source code
causing the problem.
> the thing that make me strange is i just add a column in one of my sql
> mapping file but it make all my page that connect to database become error.
>> .<
>
> is that any specific manner when making a sql mapping in IBATIS? Because i
> just try adding a field again in another table that don't have any relation
> with other table (the query only from one table) and it run normaly( no
> error) but in the sql mapping have more than one table (that error since one
> week ago till now) it become error. --'
Yes, there is a specific manner when making a sql mapping in iBATIS.
Download the PDF here:
http://ibatis.apache.org/javadownloads.cgi
And read up in the "Mapped Statements" section. Specifically you need to
know what columns are being returned by the SQL and how they are being
mapped back to Java.
My guess is that you have a "select *" somewhere in your SQL that's causing
the problem. When you add the new column to your table, it's getting
returned via the "select *", but isn't accounted for in your resultMap for
the statement.
Without knowing what the root exception is exactly, debugging this problem
is a game of chance. You really need to find out where your exceptions are
going.
Cheers,
topher
RE: error after adding a field in table
Posted by Joni Tan <ja...@hotmail.com>.
it's "localhost_log.2007-12-26.txt" log file, there is another log file
"localhost_examples_log.2007-12-26.txt" but i think it's just an example log
file and it doesn't have any exception
hmm, i don't have exception caught like try and catch in my codding. But a
while ago i add a simple try and catch in my codding and the status error is
same like before.
try {
...
}catch(Exception ex) {
out.println(ex);
}
the thing that make me strange is i just add a column in one of my sql
mapping file but it make all my page that connect to database become error.
>.<
is that any specific manner when making a sql mapping in IBATIS? Because i
just try adding a field again in another table that don't have any relation
with other table (the query only from one table) and it run normaly( no
error) but in the sql mapping have more than one table (that error since one
week ago till now) it become error. --'
Christopher Lamey wrote:
>
> Hm, nothing helpful there.
>
> Which log file was that? Are there other log files? If so, do they have
> any exceptions or errors in them?
>
> Also, how is your application handling errors? Can you provide more
> detail on how the JSPs are invoking the Java code and how exceptions are
> being caught?
>
>
--
View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14500079.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
RE: error after adding a field in table
Posted by Chris Lamey <cl...@localmatters.com>.
Hm, nothing helpful there.
Which log file was that? Are there other log files? If so, do they have any exceptions or errors in them?
Also, how is your application handling errors? Can you provide more detail on how the JSPs are invoking the Java code and how exceptions are being caught?
-----Original Message-----
From: Joni Tan [mailto:james7_05@hotmail.com]
Sent: Tue 12/25/2007 6:06 PM
To: user-java@ibatis.apache.org
Subject: Re: error after adding a field in table
the tomcat log file content this
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploying class repositories to
work directory C:\eclipse\workspace\Pustaka\work\org\apache\jsp
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy class files
/WEB-INF/classes to C:\eclipse\workspace\Pustaka\WEB-INF\classes
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-collections.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-collections.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-dbcp.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-dbcp.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-digester.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-digester.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-fileupload.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-fileupload.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-lang.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-lang.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-logging.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-logging.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-pool.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-pool.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-resources.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-resources.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-services.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-services.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-validator.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-validator.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/dbunit-2.0.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\dbunit-2.0.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/ibatis-common-2.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\ibatis-common-2.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/ibatis-dao-2.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\ibatis-dao-2.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/ibatis-sqlmap-2.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\ibatis-sqlmap-2.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/jakarta-oro.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\jakarta-oro.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/junit.jar to C:\eclipse\workspace\Pustaka\WEB-INF\lib\junit.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/mysql-connector-java-3.0.8-stable-bin.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\mysql-connector-java-3.0.8-stable-bin.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/struts.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\struts.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Reloading checks are enabled for
this Context
2007-12-26 07:59:27 ContextConfig[/Pustaka]: Missing application web.xml,
using defaults only
2007-12-26 07:59:27 StandardManager[/Pustaka]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:27 StandardManager[/Pustaka]: Seeding of random number
generator has been completed
2007-12-26 07:59:27 StandardWrapper[/Pustaka:default]: Loading container
servlet default
2007-12-26 07:59:27 StandardWrapper[/Pustaka:invoker]: Loading container
servlet invoker
2007-12-26 07:59:27 HostConfig[localhost]: Deploying configuration
descriptor admin.xml
2007-12-26 07:59:30 HostConfig[localhost]: Deploying configuration
descriptor manager.xml
2007-12-26 07:59:30 WebappLoader[/manager]: Deploying class repositories to
work directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\manager
2007-12-26 07:59:30 ContextConfig[/manager]: Configured an authenticator for
method BASIC
2007-12-26 07:59:30 StandardManager[/manager]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:30 StandardManager[/manager]: Seeding of random number
generator has been completed
2007-12-26 07:59:30 StandardWrapper[/manager:default]: Loading container
servlet default
2007-12-26 07:59:30 StandardWrapper[/manager:invoker]: Loading container
servlet invoker
2007-12-26 07:59:30 HostConfig[localhost]: Deploying web application
directory ROOT
2007-12-26 07:59:30 StandardHost[localhost]: Installing web application at
context path from URL file:C:\Program Files\Apache Group\Tomcat
4.1\webapps\ROOT
2007-12-26 07:59:30 WebappLoader[]: Deploying class repositories to work
directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\_
2007-12-26 07:59:30 StandardManager[]: Seeding random number generator class
java.security.SecureRandom
2007-12-26 07:59:30 StandardManager[]: Seeding of random number generator
has been completed
2007-12-26 07:59:30 StandardWrapper[:default]: Loading container servlet
default
2007-12-26 07:59:30 StandardWrapper[:invoker]: Loading container servlet
invoker
2007-12-26 07:59:30 HostConfig[localhost]: Deploying web application
directory tomcat-docs
2007-12-26 07:59:30 StandardHost[localhost]: Installing web application at
context path /tomcat-docs from URL file:C:\Program Files\Apache Group\Tomcat
4.1\webapps\tomcat-docs
2007-12-26 07:59:30 WebappLoader[/tomcat-docs]: Deploying class repositories
to work directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\tomcat-docs
2007-12-26 07:59:30 StandardManager[/tomcat-docs]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:30 StandardManager[/tomcat-docs]: Seeding of random number
generator has been completed
2007-12-26 07:59:30 StandardWrapper[/tomcat-docs:default]: Loading container
servlet default
2007-12-26 07:59:30 StandardWrapper[/tomcat-docs:invoker]: Loading container
servlet invoker
2007-12-26 07:59:30 HostConfig[localhost]: Deploying web application
directory webdav
2007-12-26 07:59:30 StandardHost[localhost]: Installing web application at
context path /webdav from URL file:C:\Program Files\Apache Group\Tomcat
4.1\webapps\webdav
2007-12-26 07:59:30 WebappLoader[/webdav]: Deploying class repositories to
work directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\webdav
2007-12-26 07:59:31 StandardManager[/webdav]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:31 StandardManager[/webdav]: Seeding of random number
generator has been completed
2007-12-26 07:59:31 StandardWrapper[/webdav:default]: Loading container
servlet default
2007-12-26 07:59:31 StandardWrapper[/webdav:invoker]: Loading container
servlet invoker
2007-12-26 08:02:28 StandardWrapperValve[jsp]: Servlet.service() for servlet
jsp threw 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)
what kind of error like that ? I don't understand >.<
--
View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14498625.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: error after adding a field in table
Posted by Joni Tan <ja...@hotmail.com>.
the tomcat log file content this
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploying class repositories to
work directory C:\eclipse\workspace\Pustaka\work\org\apache\jsp
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy class files
/WEB-INF/classes to C:\eclipse\workspace\Pustaka\WEB-INF\classes
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-collections.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-collections.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-dbcp.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-dbcp.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-digester.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-digester.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-fileupload.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-fileupload.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-lang.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-lang.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-logging.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-logging.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-pool.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-pool.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-resources.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-resources.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-services.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-services.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/commons-validator.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\commons-validator.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/dbunit-2.0.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\dbunit-2.0.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/ibatis-common-2.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\ibatis-common-2.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/ibatis-dao-2.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\ibatis-dao-2.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/ibatis-sqlmap-2.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\ibatis-sqlmap-2.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/jakarta-oro.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\jakarta-oro.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/junit.jar to C:\eclipse\workspace\Pustaka\WEB-INF\lib\junit.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/mysql-connector-java-3.0.8-stable-bin.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\mysql-connector-java-3.0.8-stable-bin.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Deploy JAR
/WEB-INF/lib/struts.jar to
C:\eclipse\workspace\Pustaka\WEB-INF\lib\struts.jar
2007-12-26 07:59:27 WebappLoader[/Pustaka]: Reloading checks are enabled for
this Context
2007-12-26 07:59:27 ContextConfig[/Pustaka]: Missing application web.xml,
using defaults only
2007-12-26 07:59:27 StandardManager[/Pustaka]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:27 StandardManager[/Pustaka]: Seeding of random number
generator has been completed
2007-12-26 07:59:27 StandardWrapper[/Pustaka:default]: Loading container
servlet default
2007-12-26 07:59:27 StandardWrapper[/Pustaka:invoker]: Loading container
servlet invoker
2007-12-26 07:59:27 HostConfig[localhost]: Deploying configuration
descriptor admin.xml
2007-12-26 07:59:30 HostConfig[localhost]: Deploying configuration
descriptor manager.xml
2007-12-26 07:59:30 WebappLoader[/manager]: Deploying class repositories to
work directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\manager
2007-12-26 07:59:30 ContextConfig[/manager]: Configured an authenticator for
method BASIC
2007-12-26 07:59:30 StandardManager[/manager]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:30 StandardManager[/manager]: Seeding of random number
generator has been completed
2007-12-26 07:59:30 StandardWrapper[/manager:default]: Loading container
servlet default
2007-12-26 07:59:30 StandardWrapper[/manager:invoker]: Loading container
servlet invoker
2007-12-26 07:59:30 HostConfig[localhost]: Deploying web application
directory ROOT
2007-12-26 07:59:30 StandardHost[localhost]: Installing web application at
context path from URL file:C:\Program Files\Apache Group\Tomcat
4.1\webapps\ROOT
2007-12-26 07:59:30 WebappLoader[]: Deploying class repositories to work
directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\_
2007-12-26 07:59:30 StandardManager[]: Seeding random number generator class
java.security.SecureRandom
2007-12-26 07:59:30 StandardManager[]: Seeding of random number generator
has been completed
2007-12-26 07:59:30 StandardWrapper[:default]: Loading container servlet
default
2007-12-26 07:59:30 StandardWrapper[:invoker]: Loading container servlet
invoker
2007-12-26 07:59:30 HostConfig[localhost]: Deploying web application
directory tomcat-docs
2007-12-26 07:59:30 StandardHost[localhost]: Installing web application at
context path /tomcat-docs from URL file:C:\Program Files\Apache Group\Tomcat
4.1\webapps\tomcat-docs
2007-12-26 07:59:30 WebappLoader[/tomcat-docs]: Deploying class repositories
to work directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\tomcat-docs
2007-12-26 07:59:30 StandardManager[/tomcat-docs]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:30 StandardManager[/tomcat-docs]: Seeding of random number
generator has been completed
2007-12-26 07:59:30 StandardWrapper[/tomcat-docs:default]: Loading container
servlet default
2007-12-26 07:59:30 StandardWrapper[/tomcat-docs:invoker]: Loading container
servlet invoker
2007-12-26 07:59:30 HostConfig[localhost]: Deploying web application
directory webdav
2007-12-26 07:59:30 StandardHost[localhost]: Installing web application at
context path /webdav from URL file:C:\Program Files\Apache Group\Tomcat
4.1\webapps\webdav
2007-12-26 07:59:30 WebappLoader[/webdav]: Deploying class repositories to
work directory C:\Program Files\Apache Group\Tomcat
4.1\work\Standalone\localhost\webdav
2007-12-26 07:59:31 StandardManager[/webdav]: Seeding random number
generator class java.security.SecureRandom
2007-12-26 07:59:31 StandardManager[/webdav]: Seeding of random number
generator has been completed
2007-12-26 07:59:31 StandardWrapper[/webdav:default]: Loading container
servlet default
2007-12-26 07:59:31 StandardWrapper[/webdav:invoker]: Loading container
servlet invoker
2007-12-26 08:02:28 StandardWrapperValve[jsp]: Servlet.service() for servlet
jsp threw 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)
what kind of error like that ? I don't understand >.<
--
View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14498625.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: error after adding a field in table
Posted by Larry Meadors <lm...@apache.org>.
Look in the tomcat logs directory.
Larry
On Dec 24, 2007 7:58 PM, Joni Tan <ja...@hotmail.com> wrote:
>
>
> Where can i find the logs ?
> I'm still new in iBATIS
> Thanks for the reply
>
>
> Anything in the logs?
>
> The jsp exception isn't really showing where the error is.
>
> Larry
>
>
> <\quote>
> --
> View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14492813.html
>
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
Re: error after adding a field in table
Posted by Joni Tan <ja...@hotmail.com>.
Where can i find the logs ?
I'm still new in iBATIS
Thanks for the reply
Anything in the logs?
The jsp exception isn't really showing where the error is.
Larry
<\quote>
--
View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14492813.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: error after adding a field in table
Posted by Larry Meadors <lm...@apache.org>.
Anything in the logs?
The jsp exception isn't really showing where the error is.
Larry
On Dec 23, 2007 9:40 PM, Joni Tan <ja...@hotmail.com> wrote:
>
>
> 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.
>
>
Re: error after adding a field in table
Posted by Joni Tan <ja...@hotmail.com>.
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.
Re: error after adding a field in table
Posted by Larry Meadors <lm...@apache.org>.
No clues. But maybe if we could see what the exception was and some of
the code we could help.
Larry
On Dec 21, 2007 1:55 AM, Joni Tan <ja...@hotmail.com> wrote:
>
> i am making a project using ibatis , tomcat 4.1, and postgres sql as
> database.
> this program is ok till this last few days, but when I add a field at a
> table I got a page hadle exception error, I have add the sql mapping for the
> new field but I still get the error. This error make all my pages that
> connect to database can't be run correctly, the java page hadle exception
> always come out when i try to connect to the database after I add the field
> >.<
>
> anyboy have clues about this error ?
> --
> View this message in context: http://www.nabble.com/error-after-adding-a-field-in-table-tp14452238p14452238.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>