Hi,
Thanks for replying
I am getting the following error
[ERROR] Uncaught exception escaped
java.lang.ClassCastException: java.util.ArrayList cannot be cast to
java.lang.String
at com.example.test7.client.Test7$1MyHandler$1.onSuccess(Test7.java:
1)
at
com.google.gwt.user.client.rpc.impl.RequestCallbackAdapter.onResponseReceived
(RequestCallbackAdapter.java:215)
at com.google.gwt.http.client.Request.fireOnResponseReceivedImpl
(Request.java:264)
at com.google.gwt.http.client.Request.fireOnResponseReceivedAndCatch
(Request.java:236)
at com.google.gwt.http.client.Request.fireOnResponseReceived
(Request.java:227)
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.dev.shell.MethodAdaptor.invoke(MethodAdaptor.java:
103)
at com.google.gwt.dev.shell.ie.IDispatchImpl.callMethod
(IDispatchImpl.java:126)
at com.google.gwt.dev.shell.ie.IDispatchProxy.invoke
(IDispatchProxy.java:155)
at com.google.gwt.dev.shell.ie.IDispatchImpl.Invoke
(IDispatchImpl.java:294)
at com.google.gwt.dev.shell.ie.IDispatchImpl.method6
(IDispatchImpl.java:194)
at org.eclipse.swt.internal.ole.win32.COMObject.callback6
(COMObject.java:117)
at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1925)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2966)
at com.google.gwt.dev.SwtHostedModeBase.processEvents
(SwtHostedModeBase.java:235)
at com.google.gwt.dev.HostedModeBase.pumpEventLoop
(HostedModeBase.java:558)
at com.google.gwt.dev.HostedModeBase.run(HostedModeBase.java:405)
at com.google.gwt.dev.HostedMode.main(HostedMode.java:232)
any suggestions where am i going wrong ?
On Jul 15, 11:44 am, Chad <[email protected]> wrote:
> Rahul,
>
> Based on your query (select SourceTableName from SourceTables), I
> would guess that your result set would contain a single column with
> string data (char or varchar in SQL). If that's correct, then your
> loop should look more like this:
>
> while (rs.next()) {
> rowArray.add(rs.getString(1));
>
> }
>
> You can also use the column name, as in:
>
> while (rs.next()) {
> rowArray.add(rs.getString("SourceTableName"));
>
> }
>
> Your code would only work if the SourceTableName column in the
> SourceTables table is of an integer type.
>
> HTH,
> Chad
>
> On Jul 15, 9:58 am, Rahul <[email protected]> wrote:
>
> > Hi,
> > I apologize because this topic is again n again asked on the forum,
> > but after reading the topics I was not able to get an answer to my
> > problem.
>
> > I am connecting to a server and trying to display an sql query on the
> > browser. Here is my server side code:
>
> > public class GreetingServiceImpl extends RemoteServiceServlet
> > implements
> > GreetingService {
> > private Connection conn = null;
> > private String status;
> > private String connString = "Initial value";
> > private String url = "jdbc:sqlserver:;database";
> > private String user = "";
> > private String pass = "";
> > public ResultSet rs;
> > public Statement stm;
> > ArrayList rowArray = new ArrayList();
> > String name;
> > public ArrayList greetServer(String input) {
> > String serverInfo = getServletContext().getServerInfo();
> > String userAgent =
> > getThreadLocalRequest().getHeader("User-Agent");
> > // String s1 = "Select * from Patient";
> > try {
> > Class.forName
> > ("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
> > // conn = DriverManager.getConnection(url,user,pass);
> > conn = DriverManager.getConnection
> > ("jdbc:sqlserver:;database","username","password");
> > connString = "We connected";
> > stm = conn.createStatement();
> > String query1;
> > rs = stm.executeQuery("select SourceTableName from
> > SourceTables");
>
> > while (rs.next()) {
> > rowArray.add(String.valueOf(rs.getInt(1)));
>
> > }
>
> > } catch (Exception e) { connString = e.getMessage();}
>
> > // if (conn != null)
> > // connString = "We connected";
> > // else
> > // connString = "We failed to connect";
>
> > return rowArray;
> > }
>
> > }
>
> > I am confused in the following areas:
> > 1) My sql query contains 4 values (string) is while(rs.next()) loop
> > the correct way to copy into from ResultSet to Arraylist?
> > 2) I have made my return type to Arraylist, so in the default gwt
> > application when the user clicks the send button would it show the
> > four values of my sql query or not?
>
> > If anyone has some tutorials over how to do this plz tell the links
> > that would be very helpful
> > 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
-~----------~----~----~----~------~----~------~--~---
