Win a copy of Murach's MySQL this week in the JDBC and Relational Databases forum!

Manikandan Periyasamy

Greenhorn
+ Follow
since Aug 13, 2004
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Manikandan Periyasamy

hello everybody,

I have created a function to display the rows in a table. The function is
returning the refcursor. I am calling the refcursor in Callable Statement, but
i am getting No class found for refcursor. I have seen these queries earlier in
this forum.

I am using postgresql 7.3.4 and pg74.215.jdbc3.jar.

As per the solutions given for earlier queries i tried to give getString(1), but
i am getting null value.

i am attaching the code along with this mail.

This is my pl/pgsql

CREATE or REPLACE FUNCTION displayall() RETURNS refcursor AS '
DECLARE
cursor1 cursor for select pageid,keyword from Maintable;

BEGIN
open cursor1;
return cursor1;
END;

'language 'plpgsql';

My jdbc code is

con.setAutoCommit(false);
CallableStatement cstmt2=null;
cstmt2=con.prepareCall("{? = call displayall()}");
cstmt2.registerOutParameter(1,Types.OTHER);
cstmt2.executeUpdate();
ResultSet rs2=(ResultSet)cstmt2.getObject(1);

i am getting No class found for refcursor and the error is pointing to
cstmt2.executeUpdate() line.

I also tried to use

con.setAutoCommit(false);
CallableStatement cstmt2=null;
cstmt2=con.prepareCall("{? = call displayall()}");
cstmt2.registerOutParameter(1,Types.OTHER);
String test=cstmt2.getString(1);

But test is pointing to null.

Can anyone please help me in solving this problem. I need to sort out this issue
at the earliest as i need to use Callable Statement in JDBC and also pl/pgsql.

Reply awaited.

Regards
P.mani
I am using Tomcat 4.1.30 and am getting an error that says
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:
java.sql.SQLException: No suitable driver.

I have been trying to fix this problem for a week now and its getting very frustrating. Any help would be appreciated.

my os is redhat linux 9 and database is postgresql 8
i have a jsp file which contains one textfield.when a user enter the text in that box (on blur from textbox)immediately i want check wheather it's existing user name in database or not.how do to this?
Hi,
can anybody send me a code for how to create a calendar control in jsp.
18 years ago
JSP
In My database i have a view.I try to get the datas from view from my jsp application.i can't get the data's.anybody help me?.
I am using the following code Snippet in my javascript .i am using Tomcat server.

var oXMLHTTP = new ActiveXObject( "Microsoft.XMLDom" );
var sURL = "http://sys21/webframetest/validate.jsp?DateTime=" + "'" + target + "'"
oXMLHTTP.open("GET", sURL, false);
oXMLHTTP.send();

I am received the follwoing error msg:
Object doesn't support this property or method
I am using Activex object in javascript.but i got the error msg Activex not defined.how to solve it?.
i am using jsp and postgresql for developing.i got the exception like java.lang.ClassFormatError: org/apache/jsp/wfDigital_jsp (Code of a method longer than 65535 bytes)
any one help me to solve this?
19 years ago
JSP
hello exports
i am using ireport ide for developing my reports.if any body knows how to create a templates in jasper.