Ultradev4 JSP Tutorial help

Dev Shed Forums Sponsor:

May 21st, 2001, 07:27 AM

ricardomolero

Junior Member

Join Date: May 2001

Location: Brazil

Posts: 0

Time spent in forums: < 1 sec
Reputation Power: 0

Ultradev4 JSP Tutorial help

Hi everybody!

Im new to JSP and Im trying to use DreamWeaver Ultradev 4 to start. Im using its tutorial JSP site.

SYSTEM

-Windows 2000
-Tomcat and JDK installed

PROBLEM:

-After making the *.war file (with all the files in my directory) I can access the search page, but when I try to make a search I get the following error message:

Error: 500
Location: /test/Results.jsp
Internal Servlet Error:

javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Invalid cursor state
... a lot of at apache........;at apache.........;at apache......

Can someone tell me whats happening????
Whats the solution????
Who killed Mr. Burns???

Thanks for reading!
Many thanks for any help!

Ricardo Luis de Oliveira Molero
São Paulo, Brazil
URL

Comments on this post

JimmyGosling agrees!

May 22nd, 2001, 09:38 AM

TonyA

Junior Member

Join Date: May 2001

Location: Rep. of Ireland

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

Your problem is with the database your using,

javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Invalid cursor state
... a lot of at apache........;at apache.........;at apache......

An invalid cursor state usually indicates a problem on your result set.

A typical example would be not using the next() function of the result set to get into the actual data.

When you query a database it(usually) returns a resultset. Initally the cursor is not pointing to the first record in the database. Therefore you use next() to enter into the records.
It looks something like this:

PHP Code:


		
			
<%

Connection conn;

ResultSet results;

String url = "jdbc: odbc: Personal";

String username = "DEMO";

String password = "DEMO";

try

{

// Initiate the JDBC-ODBC Driver

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");



// Connect to the ODBC Source

conn=DriverManager.getConnection(url,username,password);



Statement smt=conn.createStatement();



results=smt.executeQuery("SELECT * FROM fuser");



results.next();

%>

It may be something more subtle however, if you can post some code, somone will be able to point out exactly where your error is.

Hope this helps.

Comments on this post

JimmyGosling agrees!

Viewing: Dev Shed Forums > Programming Languages > Java Help > Ultradev4 JSP Tutorial help

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump