AdvancedGettingStarted

What do you need to develop an app?

Tools

To develop apps, you will need the following tools. Click on their name to open the setup instructions page for that tool. Scroll down for the download links for these tools. ) page)

• uOttawa VPN: Client software to allow your laptop to connect to the University network. Not needed if you are working from a lab computer. Only needed if you are using your personal laptop.
• Notepad++: An advanced text editor that allows you to edit the HTML, JS (Javascipt) and CSS (Cascading Style Sheets) for your app.
• Java JRE: The runtime environment for Java applications. You need this for Apache Tomcat (below) which is a Java application.
• Apache Tomcat: The "web container" in which your app will live and allows the app to communicate with the Quickforms Server.
• QFDao.jar: An open source middleware, Quickforms Service-REST, simplifies the task of building such mobile apps and data marts in an integrated fashion.
• quickforms.war: The Quickforms Service web application packaged as an archive. You need this to provide basic service for the Quickforms App you developed.

Needed to create new apps from scratch (that is creating the database as well):

• [SQL Server 2008 R2 Management Studio Express (32-bit)] (http://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPRWT_x64_ENU.exe)
• SQL Server 2008 R2 Management Studio Express (64-bit)
• SQL Server 2008 RS Standard A more powerful version of SQL Server.

Remember to add the resource code to the context.xml file of your apache tomcat to make sure that you connect to your database. The context.xml file should be at C:\Program Files\Apache Software Foundation\Tomcat 8.0\conf. This what it looks like:

<Resource driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"  maxActive="15" maxIdle="5" 
maxWait="5000" name="jdbc/sample" password="segcourse" type="javax.sql.DataSource" 
url="jdbc:sqlserver://137.122.93.142:1433;autoReconnect=true" username="segcourse" />

Note: One important aspect of Quickforms apps is that name of the application must be the SAME as the name of the database. Quickforms automatically access the database that corresponds to the application name. In the above, the name of the database and password should be the one you created.