on 06-29-2005 10:40 PM
I am trying to access my local SQL Server from within a servlet in a Web Module Project created with NetWeaver Developer Studio. I have used the Visual Administrator to set up my SQL Server JDBC driver and data source. I am calling the following in the servlet:
public void doWork(
HttpServletRequest request,
HttpServletResponse response)
throws ServletException {
try {
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("jdbc/NorthwindDB");
Connection con = ds.getConnection();
String query =
"select ProductName, UnitsInStock, Discontinued from Products";
Statement stmt = con.createStatement();
try {
ResultSet rs = stmt.executeQuery(query);
try {
System.out.println(
"product list (name, in stock," + "discontinued)");
while (rs.next()) {
System.out.println(
rs.getString("ProductName")
+ " "
+ rs.getInt("UnitsInStock")
+ " "
+ rs.getString("Discontinued"));
}
} finally {
rs.close();
}
} finally {
stmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
throw new ServletException(e.toString());
} catch (NamingException e) {
e.printStackTrace();
throw new ServletException(e.toString());
}
}
I am getting the following error when attempting to execute:
Application error occurred during the request procession.
Details: javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'BC_DDDBTABLERT'.
at com.ipaper.eip.j2eetesting.DBConnectivityWM.servlets.ShowSQLTable.doWork(ShowSQLTable.java:84)
at com.ipaper.eip.j2eetesting.DBConnectivityWM.servlets.ShowSQLTable.doGet(ShowSQLTable.java:23)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:391)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:265)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:345)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:323)
at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:865)
at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:240)
at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)
at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)
at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)
at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)
Any ideas??? Not sure what this 'BC_DDDBTABLERT' table is referring to.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.