Any help in this regard please? Thanks.
On Aug 20, 2:59 pm, javaidee <[email protected]> wrote: > 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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-web-toolkit?hl=en -~----------~----~----~----~------~----~------~--~---
