Visakhapatnam District Cricket Association Website

Major Operations

The following are the major operations of this portal:

• Home page displays tables with teams and points in each division.
• Search page - where user can search for players based on name and age.
• Displaying scoreboard of a match
• Displaying batting and bowling statistics of a player
• Displaying matches of a league
• Displaying matches of a team
• Displaying top batsmen and top bowlers of the selected division.
• User providing feedback about the site
• User subscribing for newsletter.

Technologies and Products used

• Tomcat 4.x
• Oracle8i
• Weblogic Server 7.0
• Java Server Pages (JSP)
• Java Beans
• Enterprise Java Beans

The following table lists operations and associated objects and files.

Operation	Files	Associated Objects
Home page	home.jsp , leaguetable.jsp	DBUtil class
Displaying matches of a division	divisionmatches.jsp	DBUtil class
Displaying players of a Team	players.jsp	DBUtil class
Displaying matches of a Team	matches.jsp	DBUtil class
Displaying details of a player	playerdetails.jsp	DBUtil class
Searching for players	searchplayers.jsp	DBUtil class
Top batting and bowling statistics	topplayers.jsp	DBUtil class
Scoreboard of a match	scoreboard.jsp, batting.jsp, bowling.jsp	DBUtil class
Feedback of user	feedback.html, feedback.jsp	FeedbackBean JavaBean
User subscribing	subscriber.html, subscriber.jsp	SubscriberBean JavaBean, Subscriber EJB

The following are the steps to related to be taken to run the existing part of the application :

1. Download vdca.zip and unzip it into webapps directory of Tomcat installation directory.
2. Make sure you copy classes111.zip ( after renaming it to classes111.jar) or classes12.jar into WEB-INF/lib directory
3. Copy examples.properties file from c:\weblogic\weblogic700\samples\server\src directory of Weblogic server to subscriber directory
4. Run s.bat in subscriber directory to path to ANT program in WEBLOGIC server.
5. Build the ejb in subscriber directory by running ant program.
6. Copy subscriber_client.jar from subscriber directory to vl/WEB-INF/lib
7. Compile javabeans in WEB-INF/classes/vdcadirectory. Run batch file s.bat before compiling javabeans. You may have to make necessary changes to batch file depending on the directory structure of your system.
8. Also make sure the classpath of Tomcat is changed to include weblogic.jar using setclasspath.cmd in BIN directory of Tomcat. After the change set CLASSPATH in setclasspath.cmd should look like as shown below:

   rem Set standard CLASSPATH
   rem Note that there are no quotes as we do not want to introduce random
   rem quotes into the CLASSPATH
   set CLASSPATH=%JAVA_HOME%\lib\tools.jar;c:\weblogic\weblogic700\server\lib\weblogic.jar
   

9. Create account vdca with password vdca in Oracle Database. If you cannot do this, you can still use SCOTT account with TIGER password. Then use SCOTT and TIGER in place of VDCA and VDCA in the remaining process.
10. Create required tables in Oracle using TABLES.TXT file and also insert some sample data.
11. Place pictures realated to players in images directory. This application uses JPG files. Each player has an id and the picture of the player will be named as playerid.jpg. For example, player 1 has picture names as 1.jpg.
12. Make sure Oracle and Tomcat are running.
13. Start Weblogic Server and create the following
    • A connection pool with the name ejbOracle- It should access Oracle with vdca user and vdca password
    • A TxDataSource with the name ejb.oracle and JNDI name ejb.oracle
14. Run the application using the following url:

       http://localhost:8080/vdca
     

15. You should see home page of the application.