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.
So I read the tutorial again and I originally missed the fact that the project was made with the Glassfish server and the code I quoted is referencing a connection pool
Open the New File wizard by pressing the New File ( New File button ) button in the IDE's main toolbar. Select the GlassFish server category, then select JDBC Resource and click Next.
In step 2, General Attributes, choose the Create New JDBC Connection Pool option, then in the JNDI Name text field, type in jdbc/IFPWAFCAD.
How would I make the connection without the Glassfish option? I am using Tomcat 6 and just need a site with examples that I can work through.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Change data source in IFPWAFCAD netbeans demo project from mysql to microsoft sqlserver