Connecting to SQL Server

[javaidee]

Hi I am new to GWT.

I have created a simple example to fetch data from database at Server
and format/display that at the client.

public List getEmployeeNamesFromDB (String itemsToMatch)
{
ArrayList completionList = new ArrayList();
Connection con = null;
String connectionUrl = "jdbc:microsoft:sqlserver://127.0.0.1:1433;
DatabaseName=TEST;";

try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(connectionUrl, "TEST", "test");
ResultSet rs = con.createStatement().executeQuery("SELECT TEXT FROM
TEMP");
if (rs != null & rs.next())
{
completionList.add(rs.getString("TEXT"));
}
}
catch (ClassNotFoundException cse)
{
System.out.println("Error locating driver class for connection.");
cse.printStackTrace();
}
catch (SQLException se)
{
System.out.println("Error opening a SQL Server 2005 connection.");
se.printStackTrace();
}
finally
{
if (con != null)
{
try
{
con.close();
con = null;
}
catch (SQLException se)
{
System.out.println("Error closing the connection.");
se.printStackTrace();
}
}
}
return completionList;
}

I am trying to connect to SQL Server 2005, this code perfectly works
fine when I use it outside the GWT Server Class. When I use it inside
the Server class by calling this method through the client using RPC
mechanism I get the following error.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]
Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown
Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection
(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at gwt.server.GetNamesServiceImpl.getEmployeeNamesFromDB
(GetNamesServiceImpl.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse
(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall
(RemoteServiceServlet.java:166)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost
(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:713)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter
(ServletHandler.java:1093)
at
com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter
(TransactionCleanupFilter.java:43)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter
(ServletHandler.java:1084)
at com.google.appengine.tools.development.StaticFileFilter.doFilter
(StaticFileFilter.java:124)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter
(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle
(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle
(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle
(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
405)
at com.google.apphosting.utils.jetty.DevAppEngineWebAppContext.handle
(DevAppEngineWebAppContext.java:54)
at org.mortbay.jetty.handler.HandlerWrapper.handle
(HandlerWrapper.java:139)
at com.google.appengine.tools.development.JettyContainerService
$ApiProxyHandler.handle(JettyContainerService.java:313)
at org.mortbay.jetty.handler.HandlerWrapper.handle
(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
506)
at org.mortbay.jetty.HttpConnection$RequestHandler.content
(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run
(SelectChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run
(BoundedThreadPool.java:442)

I tried everything like disabling firewall etc. but no success. The
code works fine if called outside this RPC mechanism. There is only
one value in the table for testing.

Any help/guidance will be highly appreciated, please explain in detail
as I am a starter in GWT.

Thanks.

[javaidee]

Any help in this regard please?

Thanks.

[Lothar Kimmeringer]

javaidee schrieb:

[Connection-problem with MS SQL]

> Any help in this regard please?

Try comp.lang.java.database or the corresponding newsgroup
covering MS SQL. The question has nothing to do with GWT.

Regards, Lothar