Select query in Servlet doGet()

[Vrushali Gore]

When i fire a select query in doGet method of servlet is gives me this error. If i change the query with insert query it works perfectly fine. What is the problem query and servlet. Even if i put it in class and then invoke from the servlet even it works fine. Only problem is when i try to do it from direct servlet.

Using weblogic6.1 to deploy my servlets.


java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1],
[0], [], [], [], [], [], []

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:1681)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1870)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
538)
at SelectQ.doGet(SelectQ.java:35)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
Inside SQLException.....

Thanks in advance.

[Christophe Verré]

Did you put the right driver in your lib directory ?

[Jigar Naik]

Can you show your query statment ???

[Vrushali Gore]

This is all code that i am having in doGet method. If i replace with insert query it works fine. It gives only problem if i fire query directly from doGet() method. This happens only for select query.

public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{
String url = "jdbc  :-o	  racle:thin:@dbs:1521  :-o	  rcl";
String driverName = "oracle.jdbc.driver.OracleDriver"; 
String userName = "scott";
String password = "tiger";
String sql = null;
 
pout = res.getWriter();
res.setContentType("text/html");
 
try{
Class.forName(driverName);
System.out.println("Driver loaded...");

con = DriverManager.getConnection(url, userName, password);

System.out.println("Got connected to DB.....");
 
st = con.createStatement();
System.out.println("Statement created.....");
 
sql = "select E.* from vrushaliemp E";
rs = st.executeQuery(sql);
 
while (rs.next())
{
System.out.println("Name : " + rs.getString("name"));
}
 
}
catch(ClassNotFoundException clse){
clse.printStackTrace();
System.out.println("Inside ClassNotFoundException.....");
pout.println("Error : " + clse);
}
catch(SQLException sqle){
sqle.printStackTrace();
System.out.println("Inside SQLException.....");
pout.println("Error : " + sqle);
}
 
pout.println("Inside Service");
pout.println("<br>Hello World(using HttpServlet)!!!!");
pout.println("Request Method : " + req.getMethod());
}
 

Thanks.
[ February 28, 2007: Message edited by: Ben Souther ]

[Ben Souther]

Which is line 35?

at SelectQ.doGet(SelectQ.java:35)

[Vrushali Gore]

Line no 35 is -

I guess there is some problem with execution of select query only. Because this problem is there for select query only.

rs = st.executeQuery(sql);