At 08:42 PM 10/31/00 +1000, Kate McNamara wrote:
>1. How can I update the value of a session var? When someone on my site fills
>in a form, I need the var to update for the rest of the session - do I just
>use putValue? This doesn't seem to be working, any suggestions....?
putValue is deprecated in Servlets 2.2. Try using setAttribute instead. See
the Servlet 2.2 spec:
http://java.sun.com/products/servlet/download.html#specs
for more details.
>2. How can I use the resultset first() method? I understand this is part of
>a later version of JDBC than I currently use but I can't seem to track down
>the details. Any help would be greatly appreciated.
You need a driver that supports the JDBC 2.0 core API. If you go to:
http://java.sun.com/j2se/1.3/docs/guide/jdbc/index.html
and chase the links to ResultSet.first(), you'll see this stated.
>3. I have a form which adds info to a database, it works fine, then I use the
>form again and I get an SQL General Exception and the server crashes. I know
>this isn't much info to go on, but does anyone have any suggestions to offer?
> I've done virtually everything I can think of. At one point the error log
>on the server indicated "an error outside the VM" if that sheds any light on
>the issue for anyone...Im using Orion server with SQL Server 7.0 and an
>ODBC-JDBC
>bridge.
This is a common problem with the JDBC-ODBC bridge. The best thing you can
do is switch to another driver. You might take a look at the Sprinta 2000
driver from i-net software:
http://www.inetsoftware.de
This is a JDBC 2.0 driver that supports MS SQL Server. You can download a
trial version from the web site and give it a test drive.
--
Martin Cooper
Tumbleweed Communications
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
