I need to do a proof-of-concept project to demo a web application that can do a simple query on one of my Microsoft SQLserver tables. I am using netbeans 7.2.1 and
Java sdk 1.6. I found a simple project on the netbeans learning site called IFPWAFCAD that does a query on a mysql database table and returns the results. The URL for the project is
http://netbeans.org/kb/docs/web/mysql-webapp.html and I downloaded the application from the link "you can download the sample application" on that page.
The
jdbc driver to my sqlserver is setup and running in netbeans. What I am having trouble with is determining how to switch the data source from the mysql to my Microsoft sqlserver. I see a resource-ref tag in the web.xml file and I can see the query code in the index.jsp and response.jsp. But I don't understand where the dataSource that is called in index.jsp with the code below is defined in the project.
Thanks for any help.