Error for java.lang.InstantiationException in using CachedRowSet

30 New Member

I'm new to JSP, and am trying this sample code for instantiating a bean for use in a disconnected ResultSet, i placed the rowset.jar under WEB-INF/lib directory but i get the following error:

javax.servlet.ServletException: interface javax.sql.rowset.CachedRowSet : java.lang.InstantiationException: javax.sql.rowset.CachedRowSet

and

root cause

java.lang.InstantiationException: interface javax.sql.rowset.CachedRowSet : java.lang.InstantiationException: javax.sql.rowset.CachedRowSet

Why won't it instantiate?

Code:
<%@ page import="sun.jdbc.rowset.CachedRowSet" %>

<HTML>
<HEAD>
<jsp:useBean id="Contacts" class="sun.jdbc.rowset.CachedRowSet" scope="session">
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstan ce();
// initialize our CachedRowSet bean
Contacts.setUsername("webuser");
Contacts.setPassword("pwd");
Contacts.setUrl("jdbc:mysql://localhost:3306/person");
// some drivers require this
Contacts.setTableName("contacts");
Contacts.setCommand("SELECT name, telephone from contacts");
Contacts.execute();
Contacts.first();
%>
</jsp:useBean>

thanks in advance.........

Regards,

V. Prasath

Jul 31 '07 #1

Subscribe Reply

3881

madhoriya22

252

Contributor

I'm new to JSP, and am trying this sample code for instantiating a bean for use in a disconnected ResultSet, i placed the rowset.jar under WEB-INF/lib directory but i get the following error:

javax.servlet.ServletException: interface javax.sql.rowset.CachedRowSet : java.lang.InstantiationException: javax.sql.rowset.CachedRowSet

and

root cause

java.lang.InstantiationException: interface javax.sql.rowset.CachedRowSet : java.lang.InstantiationException: javax.sql.rowset.CachedRowSet

Why won't it instantiate?

Code:
<%@ page import="sun.jdbc.rowset.CachedRowSet" %>

<HTML>
<HEAD>
<jsp:useBean id="Contacts" class="sun.jdbc.rowset.CachedRowSet" scope="session">
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstan ce();
// initialize our CachedRowSet bean
Contacts.setUsername("webuser");
Contacts.setPassword("pwd");
Contacts.setUrl("jdbc:mysql://localhost:3306/person");
// some drivers require this
Contacts.setTableName("contacts");
Contacts.setCommand("SELECT name, telephone from contacts");
Contacts.execute();
Contacts.first();
%>
</jsp:useBean>

thanks in advance.........

Regards,

V. Prasath

Hi,
This exception is thrown when u r trying to create a instance of a class using new operator, but it not a class instead it is interface or abstract class.
I think u hav done the same mistake.......CachedRowSet is a interface..and u trying to create instance of that...check it again.
thanks and regards,
madoriya

Jul 31 '07 #2

Similar topics

2259

CachedRowSet

by: Jeremy | last post by:

Hi, can anybody tell me where/how to get Sun's implementation of CachedRowSet?? I've found (old-ish) articles saying it's available as rowset.jar from the Early Access part of the developer...

Java

13504

Permissions error? Mac Java problem.

by: Tim Murray | last post by:

First of all, I don't know much about Java, even its naming and version numbering nomenclature, and second, if there is a better group to ask this in, please let me know. System is Mac with...

Java

28785

syntax error? "cannot find symbol"

by: Bjorn Jensen | last post by:

Hi! An beginner question: Pleas help me with this (-: Error (the arrow points on the s in sqrt) ===== tal.java:6: cannot find symbol symbol : method sqrt(int) location: class tal...

Java

4358

HTTP Status-500 error while connecting to DB2 using tomcat 4.1.34

by: kommaraju | last post by:

iam a starter to db2 & jdbc.i have a servlet program which connects to ibm db2 using jdbc.when i run this using apache tomcat 4.1.34 , it is showing a error message of HTTP STATUS 500 my jdbc...

Apache Web Server

1559

db2 udb v9 SQL6031 error on Fedora core 6 linux

by: tejpatil | last post by:

Hi All, This was installed recently on my desktop which has fedora core 6. This used to work perfectly. I used to update linux with daily updates, after few updates this started giving issues. I...

DB2 Database

1465

Can anybody post the CachedRowSet coding using jsp?

by: prasath03 | last post by:

Dear all, I need a sample coding about CachedRowSet using in jsp without bean class. That code displays 10 records per page from the database when i click the Previous and Next button or link. ...

Java

2050

Error in CachedRowSet?

by: prasath03 | last post by:

Hi All, I tried the following code to run in jsp using Tomcat 4, the following code took from web. Code: <%@ page import="sun.jdbc.rowset.CachedRowSet" %> <HTML> <HEAD> <jsp:useBean...

Java

5360

Parameters xmldata, $filestream and $filedata are all missing error

by: honguin | last post by:

Hi, With the following code, I have created a web request to a url which I am making a HTML POST with the html page request.htm, even though it makes a HTML POST, the StreamReader produces a XML...

C# / C Sharp

2949

Can i unload class in Java

by: inetjack | last post by:

Hi, This is a little test application, generating and compiling code at runtime. The loadClassLoader() method of the Factory Object suppose to unload all class previously loaded. It does not...

Java

7021

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7207

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7242

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6914

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5503

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4928

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4619

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3112

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

686

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP