Thanks Ill do that >>> [EMAIL PROTECTED] 2002-03-20 12:49:52 >>>
>From the Javadocs for java.lang.VerifyError (great source of information, by the way): Thrown when the "verifier" detects that a class file, though well formed, contains some sort of internal inconsistency or security problem. So I would say that somehow your JDBC drivers are corrupt. I have seen JBuilder produce classes that caused this - a simple recompile fixed everything for me. The Stack Trace would seem to indicate the problem is in interbase.interclient.ErrorKey. I would suggest trying to create a standalone application that exhibits this problem and contact the vendor's technical support with the issue. Randy > -----Original Message----- > From: Magnus Jansson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 20, 2002 3:14 AM > To: [EMAIL PROTECTED] > Subject: Ang: RE: newbie jsp question > > > 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(RecvMessa > ge.java:694) > at > interbase.interclient.RecvMessage.makeSQLException(RecvMessage > .java:593) > at > interbase.interclient.RecvMessage.get_EXCEPTIONS(RecvMessage.j > ava, 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.processConne > ction(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]> > -- 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]>