RE: RE: newbie jsp question

2002-03-20 Thread Randy Layman 


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

2002-03-20 Thread Magnus Jansson 

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

RE: newbie jsp question

2002-03-19 Thread Jeff Macomber 

Jansson,

You are going to need a JDBC driver for Interbase 6.5 first.  Then I would
recommend looking at the examples that come with the driver on how they
handle insertion of BLOB data and escaping stored procedures.  

Hope this helps,
Jeff

-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]

RE: newbie jsp question

2002-03-19 Thread Randy Layman 


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]

Ang: RE: newbie jsp question

2002-03-19 Thread Magnus Jansson 

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]

Re: Newbie JSP Question:

2001-08-30 Thread Nirav S. Desai 

Do you have a submit button. 
Peter L. Markowsky wrote:
 
 I know this doesn't relate to Tomcat directly, but since Tomcat hosts JSPs
 or at least is able I was wondering if anyone out there knew / could
 recommend how to pass values from one JSP page to another. The problem I'm
 having is that when I try to submit a form and then use
 request.getParameter( parametername ) I keep getting nulls even though I
 specify the parameter name.
 -Thanks for all the Help
 Pete Markowsky

-- 
Nirav S. Desai
Software Engineer
Vecna Technologies, Inc.
6525 Belcrest Rd, Suite 612
Hyattsville MD, 20782
Phone: 301.864.7253
Fax:   301.699.3180

Re: Newbie JSP Question:

2001-08-30 Thread Dmitri Colebatch 

try request.setAttribute( ... ) in the first jsp and request.getAttribute(
... ) in the second.

hth
dim


On Thu, 30 Aug 2001, Peter L. Markowsky wrote:

 I know this doesn't relate to Tomcat directly, but since Tomcat hosts JSPs
 or at least is able I was wondering if anyone out there knew / could
 recommend how to pass values from one JSP page to another. The problem I'm
 having is that when I try to submit a form and then use
 request.getParameter( parametername ) I keep getting nulls even though I
 specify the parameter name.
   -Thanks for all the Help
   Pete Markowsky

Re: Newbie JSP Question:

2001-08-30 Thread Guilherme Zambon 

Take care with the case sensitive.
A way to see which parameters were passed is using a code like:
%@ page import=java.util.*%
html
head
/head
body
pre
%
Enumeration e = request.getParameterNames();
String s = new String();
while(e.hasMoreElements()) {
s = (String) e.nextElement();
%
The parameter %=s% has value%=request.getParameter(s)%br
%
}
%
/pre
/body
- Original Message - 
From: Peter L. Markowsky [EMAIL PROTECTED]
To: Sukhwinder Singh [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 6:28 PM
Subject: Newbie JSP Question:


I know this doesn't relate to Tomcat directly, but since Tomcat hosts JSPs
or at least is able I was wondering if anyone out there knew / could
recommend how to pass values from one JSP page to another. The problem I'm
having is that when I try to submit a form and then use
request.getParameter( parametername ) I keep getting nulls even though I
specify the parameter name.
-Thanks for all the Help
Pete Markowsky