URGENT!!!Help me Pleeez!!!! sun.jdbc.odbc.JdbcOdbcConnection throws java.lang.UnsupportedOperationException
2 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   AR_K
Posted On:   Sunday, April 21, 2002 10:25 PM

Hi, My Connection object creates the statement fine when I run it in my localhost. (I use Tomcat 4.0.1.) But when the codes were uploaded to the actual server, I get a run time error tht says.... "The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request. exception java.lang.UnsupportedOperationException at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.java:1011) at org.apache.jsp.DisplayQuiz$jsp._jspService(DisplayQuiz$jsp.java, Compiled Code) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.j   More>>

Hi,
My Connection object creates the statement fine when I run it in my localhost. (I use Tomcat 4.0.1.) But when the codes were uploaded to the actual server, I get a run time error tht says....

			
"The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.
exception

java.lang.UnsupportedOperationException
at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.java:1011)
at org.apache.jsp.DisplayQuiz$jsp._jspService(DisplayQuiz$jsp.java, Compiled Code)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
.........................."

My code tht generates this error is:
			
ResultSet _orsQuiz = _oDb.conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery("Select * from qryQA where QuizID='"+_strQuizID+"' and UserID='"+_strUserID+"' and Category='"+_strQuizCategory+"'");


Can anyone help me plz? Its quite urgent.

thanks,
Anitha    <<Less

Re: URGENT!!!Help me Pleeez!!!! sun.jdbc.odbc.JdbcOdbcConnection throws java.lang.UnsupportedOperationException

Posted By:   harish_nanjundappa  
Posted On:   Tuesday, April 23, 2002 02:16 AM

First of all u r using jdbc bridge , replace it with pure java driver (jdbc net) and before using advanced features of jdbc 2.0 like scrollable result set go through the documentation whether it supports the jdbc 2.0 implementation.

Re: URGENT!!!Help me Pleeez!!!! sun.jdbc.odbc.JdbcOdbcConnection throws java.lang.UnsupportedOperationException

Posted By:   Kesavan_Srinivasan  
Posted On:   Sunday, April 21, 2002 11:30 PM

Hi,

I dont think that JDBC-ODBC Driver supports creating a statement which is CONCUR_UPDATEABLE. For this u can use other type of drivers like iNetSprinta or iNetOpta. If u need further clarifications write me at kesavansrini@yahoo.co.in

Kesavan.

About | Sitemap | Contact