Tuesday, February 27, 2007

Talk to Gary about the Database

I asked Gary what values would be expected by the tables in the database and how can I check the table contents. He told me that I can't run the "select * from [tableName]" which I have tried. For security issues, I can't query the Banner using this command. He showed me how to execute the stored procedure he gave me. He told me start with simple things first. He told me to just build a simple webapp that queries the database using the stored procudure given. After that I can elaborate more and it is possible that I will have to write some stored procudures to get what I need.

After I went home, I did some research on how connect to SQL server 2005 database from GWT. I didn't find sample code for it. Finally I think that maybe GWT only use the traditional way of Java database connection, which may similar to what I did for Traffobase last semester. I will try to do this tomorrow. Hope it will work.

No comments: