cancel
Showing results for 
Search instead for 
Did you mean: 

Trying to access SQL Server from Web Module Project

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Vlado
Advisor
Advisor
0 Kudos

Hi Kevin,

Check thread. It describes the same problem and especially the last three posts seem to have solved it.

Hope that helps you too!

Vladimir

Former Member
0 Kudos

That was exactly what I was needing to know. Thanks for pointing me in the right direction!

Answers (0)