The following steps explain how to set up the Parasoft JDBC Driver for the sample ParaBank application that ships with Parasoft Virtualize:

1. If you haven’t already done so, create the ParaBank project:
   1. Choose File> New> Project.
   2. Choose Virtualize> ParaBank Example Project, then click Next.
   3. Enter a name for the project, then click Finish.
2. Ensure that the project is configured to build automatically: open the Java perspective, select the ParaBank project, open the Project menu, then ensure that Build automatically is enabled.
3. Copy the ParasoftJDBCDriver.jar file to ParaBank/WebContent/WEB-INF/lib.
   • For example, on Windows, this might be C:\Users\<username>\parasoft\<your_workspace>\ParaBank\WebContent\WEB-INF\lib.
4. Edit the ParaBank/src/jdbc.properties file to read as follows (with no extra spaces):
   jdbc.driverClassName=com.parasoft.xtest.jdbc.virt.driver.JDBCProxyDriver
jdbc.url=jdbc:parasoft:proxydriver:org.hsqldb.jdbcDriver:@jdbc:hsqldb:hsql://localhost/parabank
jdbc.username=sa
jdbc.password=
   
   
   
   
5. In Virtualize, open the Java perspective then choose Run> Run Configurations.
6. Select Apache Tomcat> ParaBank Tomcat 8.5 Server.
7. Under the Arguments tab, add the following Parasoft JDBC Driver flags to what is already listed in the VM arguments section:
   -Dparasoft.virtualize.server.url=http://localhost:9080 -Dparasoft.virtualize.group.id=parabank -Dparasoft.virtualize.driver.register.jdbcproxydriver.in.drivermanager=true -Dparasoft.virtualize.driver.proxy.direct=true
   
   
   
   
8. Start (or restart) the ParaBank server with the updated Run Configuration.
9. Log in to ParaBank.

If the related JDBC Controller does not appear, try refreshing the project, cleaning the project, cleaning the server, then restarting the server.

Troubleshooting ParaBank

If you upgrade from a previous installation of Virtualize and the browser displays a 404 Error message after the upgrade—even if the Java perspective reports that the server started properly—you need to clean the workspace as follows:

1. Open the Java perspective.
2. Open the Servers view.
3. In the Servers view, right-click the ParaBank Tomcat server, then choose Clean.
   
   
   
   
4. Restart the ParaBank Tomcat server (right-click it, then choose Restart).