Hi Peter Thanks for the reply I presently have the driver I need to connect for sqlserver. Reading the tutorials one needs to connect with sqlserver via RPC, for database connectivity I need to follow all the basic steps in there? Sorry to ask this because I am getting confused by this
1. Create a service on the server. 2. Invoke the service from the client. 3. Serialize the data objects. 4. Handle exceptions: checked and unexpected. I need to follow all these steps to connect, right? Thanks a lot for reply On Jul 6, 2:17 pm, Piotr Kirklewski <[email protected]> wrote: > Hi mate > > When you build your GWT application with Eclipse 3.4 its using RPC > I'm connecting to my postgres database so you need to research on the > driver youneed for SQL server > . > So: > import java.sql.Connection; > import java.sql.ResultSet; > import java.sql.DriverManager; > import java.sql.Statement; > import java.sql.SQLException; > > c = > DriverManager.getConnection("jdbc:postgresql://192.168.55.101/databasename", > "username", "pass"); > Statement select = > c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.TYPE_SCROLL_SENSITIVE); > ResultSet res = select.executeQuery("select * from fred;"); > > Next stick the results int an array and grab them on the client side > from "reusult" : > > markers[x][0] = new String(result[x][0]); > markers[x][1] = new String(result[x][1]); > markers[x][2] = new Float(result[x][2]); > markers[x][3] = new Float(result[x][3]); > > I can;t help much with the tree view though. > > Regards > > Peter --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
