Well! I already have a connection to the database, I can extract information out from
the database but when I use execute procedure commando I only get that very hard to
debug error page from tomcat. here is a copy of it:
java.lang.VerifyError: (class: interbase/interclient/ErrorKey, method: signature:
()V) Expecting to find object/array on stack
at interbase.interclient.SQLException.(SQLException.java:96)
at interbase.interclient.RecvMessage.createSQLException(RecvMessage.java:694)
at interbase.interclient.RecvMessage.makeSQLException(RecvMessage.java:593)
at interbase.interclient.RecvMessage.get_EXCEPTIONS(RecvMessage.java, Compiled
Code)
at
interbase.interclient.Statement.remote_EXECUTE_QUERY_STATEMENT(Statement.java,
Compiled Code)
at interbase.interclient.Statement.executeQuery(Statement.java, Compiled Code)
at matsedel.input.updatematsedel_13._jspService(updatematsedel_13.java:117)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)
at org.apache.tomcat.core.Handler.invoke(Unknown Source)
at org.apache.tomcat.core.Handler.service(Unknown Source)
at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)
at org.apache.tomcat.core.ContextManager.internalService(Unknown Source)
at org.apache.tomcat.core.ContextManager.service(Unknown Source)
at org.apache.tomcat.modules.server.Ajp13Interceptor.processConnection(Unknown
Source)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
I havent got a clue what is wrong.....
here is the execute procedure part of my jsp page....
if (request.getParameter("MandagLunchUID") == null)
{
MyQuery = "EXECUTE PROCEDURE INSERT_INTO_MATSEDEL 'Mat mat mat' '2002-03-18' 1
0";
//MyQuery = "EXECUTE PROCEDURE INSERT_INTO_MATSEDEL (";
//MyQuery = MyQuery + request.getParameter("MandagLunchText") + ",";
//MyQuery = MyQuery + request.getParameter("MandagLunchDatum") + ",";
//if (IsVego.booleanValue())
//{
// MyQuery = MyQuery + "1" + ",";
//}
//else
//{
// MyQuery = MyQuery + "0" + ",";
//};
//MyQuery = MyQuery + "0)";
MyRecordSet = StatementRecordset1.executeQuery(MyQuery);
out.print("OK insert måndag lunch");
}
As you can see there is a lot of remarks there, I only have that static call right now
for test purpose..
>>> [EMAIL PROTECTED] 2002-03-19 16:44:05 >>>
You will need to learn how to use JDBC to access databases. I would
suggest either going to Sun's JDBC site or looking at Interbase. Once you
know how to execute the stored procedure from regular Java, JSP is trivial.
Randy
> -----Original Message-----
> From: Magnus Jansson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 19, 2002 11:22 AM
> To: [EMAIL PROTECTED]
> Subject: newbie jsp question
>
>
> I'm getting nuts I tries to execute a stored procedure that
> looks like this:
>
> INSERT_INTO_MATSEDEL (MATTEXT BLOB, DATUM Date, ISVEGO
> Integer, ISLUNCH Integer)
>
> But I haven't got a clue how to write the jsp code to execute
> that procedure.
>
> I'm using Interbase 6.5 Pleeeaseee help me.
>
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - - - - - - - - - - -
> Magnus Jansson
> IT-Manager
> Väddö folkhögskola
> 760 40 Väddö
> Sweden
>
> Phone: +46 (0) 176-528 00
> Cellular: +46 (0) 70-370 33 16
> Fax: +46 (0) 176-528 28
> http://www.vaddo.fhsk.se (work)
> http://www.jason.pp.se (private)
>
>
>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
