Map Root of project flood in Marl/sandpit/oracle/ (Mapped to S: to work with J developer) http://www.ga.gov.au:8500 JSP and html source code is in directory flood Root page is in flood_input.jsp (POST method) Any info when 'query' is clicked passed into flood_studies.jsp (l 161 creates db connecition which is closed from line 254) FIX null issue Selecting a study transfers control to flood_infolist.jsp Show table of links to details for each dataset Creates a connection through the class AvailableDataset (which takes care of closing it again). This class is in CVS Marl: /web/src pserver IN CVS: FloodDataset.java: Gets data and formats. Has an connection open but no close. Remedy: Move connection open and close to FloodDetailServlet.java All methods in FloodDataset.java (as well as FloodDetailServlet.java) now get open connection handle passed in as first parameter. To deploy. Create one jar file from java source and copy to sandpit. http://www.ga.gov.au:8500/oracle/flood/flood_infolist.jsp?sno=1&sname=Avoca%20River%20Floodplain%20Management%20Study Testing servlet/FloodDetailServlet?sno=25&sname=Geelong Flood Mitigation Strategy&dname=... OK: Detail link is live Testing servlet/FloodDetailServlet?sno=25&sname=Geelong Flood Mitigation Strategy&dname=... Geoscience Australia flood Online Search: Studies details
This data is subject to Geoscience Australia's disclaimer and copyright statements.

java.lang.NullPointerException

FAIL: Detail link is not live Testing servlet/FloodDetailServlet?sno=23&sname=Euroa Floodplain Management Study, Volum... OK: Detail link is live Testing servlet/FloodDetailServlet?sno=23&sname=Euroa Floodplain Management Study, Volum... Geoscience Australia flood Online Search: Studies details
Related study
This data is subject to Geoscience Australia's disclaimer and copyright statements.


FAIL: Detail link is not live