Servlets And Database Connection

[suraj sheikh]

hello everyone,

this is the only place i can get help !

Here are the details

I have an html page, then i get the parameters to the servlets.
Then i have a standalone class responsible for data base connection.

Here is the directory structure
c:\my projects\boaintegratedworkflow\src\com\system33\model\MyOracleConnection.java

The source code is :

package com.system33.model;
import java.sql.*;
public class MyOracleConnection {
public String result="uninitialized" ;
public Connection conn=null;
public Connection connectionDriver() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc racle:thin:@localhost:1521:XE", "system","administrator");
} catch (Exception e) {
e.printStackTrace();
result="error in connection";
}
return conn;
}
public String fetchData() {
try {
Statement stmt = this.connectionDriver().createStatement();
String query="select * from boaiw";
ResultSet rs = stmt.executeQuery(query);
while(rs.next()) {
System.out.println(rs.getString(1));
result=rs.getString(1);
}
} catch (Exception e) {
e.printStackTrace();
//result="error in data return" ;
}
return result;
}
public static void main(String[] args) {
com.system33.model.MyOracleConnection obj=new com.system33.model.MyOracleConnection();
System.out.println(obj.fetchData());
}
}

This is the servlet Code

c:\my projects\boaintegratedworkflow\src\com\system33\model\Submit.java

package com.system33.web;
import com.system33.model.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
public class Submit extends HttpServlet {
public Connection conn;
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException,

ServletException {
response.setContentType("text/html");
PrintWriter out=response.getWriter();
out.println("Selection Advice<br>");
out.println("<br> Value of connection ");
com.system33.model.MyOracleConnection obj = new com.system33.model.MyOracleConnection();
out.println("<br> Data Fetched "+obj.fetchData());
out.println("<br> Data Fetched "+obj.connectionDriver());
out.println("<br> This is the new servlet<br>");
}

}

The class file lands in
c:\my projects\boaintegratedworkflow\classes\com\system33\model\MyOracleConnection.class
c:\my projects\boaintegratedworkflow\classes\com\system33\web\Submit.class

And this is not fetching the data, it throws an exception whic i am not able to see as its not being displayed on the page

Please Help me guys ! i need it

[Bear Bibeault]

Please be sure to use UBB code tags when posting code to the forums. Unformatted code is extremely hard to read and many people that might be able to help you will just move along to posts that are easier to read. Please read this for more information.

You can go back and change your post to add code tags by clicking the .

[Paul Clapham]

Your first step should be to find the stack trace of the exception. Normally you will find that somewhere in the logs of your application server. It will be very difficult to solve the problem without that information.

[suraj sheikh]

Thanks for your reply, But can you help me how to get the log on tomcat

[Bear Bibeault]

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please read this for more information.