RE: RE: newbie jsp question
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
Ang: RE: RE: newbie jsp question
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:
