aspose file tools*
The moose likes IDEs, Version Control and other tools and the fly likes Change data source in IFPWAFCAD netbeans demo project from mysql to microsoft sqlserver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Change data source in IFPWAFCAD netbeans demo project from mysql to microsoft sqlserver" Watch "Change data source in IFPWAFCAD netbeans demo project from mysql to microsoft sqlserver" New topic
Author

Change data source in IFPWAFCAD netbeans demo project from mysql to microsoft sqlserver

margaret gillon
Ranch Hand

Joined: Nov 12, 2008
Posts: 318
    
    5

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.
margaret gillon
Ranch Hand

Joined: Nov 12, 2008
Posts: 318
    
    5

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 agree. Here's the link: http://aspose.com/file-tools
     
    subject: Change data source in IFPWAFCAD netbeans demo project from mysql to microsoft sqlserver