tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Magnus Jansson" <Ad...@vaddo.fhsk.se>
Subject Ang: RE: newbie jsp question
Date Wed, 20 Mar 2002 08:14:08 GMT
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..



>>> randy.layman@aswethink.com 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:Admin@vaddo.fhsk.se] 
> Sent: Tuesday, March 19, 2002 11:22 AM
> To: tomcat-user@jakarta.apache.org 
> 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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>



--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message