Library Management Java Project | Net Beans | Java Server Pages

Library Management java project This is a web application used by librarians to handle typical operations in a library.

Technologies and Products used NetBeans 5.0 Tomcat 5.5 embeded in NetBeans Oracle10g Express Edition Jboss 4.0.3 Java Server Pages (JSP) Java Beans Enterprise Java Beans

• • • • • • •

The following are the steps to related to be taken to run the existing part of the application : 1. Create lm account with password lm in Oracle10g Express Edition. This must be done by

after you log in as SYSTEM user.

2. 3.

create user lm identified by lm; grant connect,resource to lm;

4. Create required tables in lm account by using commands in tables.sql file of lm.zip. 5. Download lm.zip and unzip it into d:\lm directory. You can substitue d:\ with another path

if you like. 6. Download library.zip and unzip it into d:\library directory. You can substitue d:\ with

another path if you like. 7. Start NetBeans 5.0 8. Add JBOSS Server with NetBeans using Tools->Server Manager 9. Copy ojdbc14.jar into JBOSS_HOME\server\default\lib directory. 10. Configure Oracle-ds.xml in default\deploydirectory to add another local-tx-datasource entry as follows: 11. 12. 13.

LibraryDS jdbc:oracle:thin:@localhost:1521:XE 14. oracle.jdbc.driver.OracleDriver 15. lm 16. lm 17. org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter 18. 19. Oracle9i 20. 21.

22. Open library project in NetBeans using File->Open Project option.

23. Build library project. 24. Copy library.jar of dist directory to server\default\deploy of JBoss.

25. Start JBOSS 4.x 26. Open lm project in NetBeans using File->Open Project option. 27. Add Oracle Library - ojdbc14.jar, Library Bean jar file - library.jar and JOBSS_HOME\client\jbossall-client.jar to this project. 28. Build and deploy the project to embeded Tomcat of NetBeans. 29. Run this project - you must see index.jsp page.

Deploying Web Application In Tomcat of JBoss The following procedure explains how to deploy a web application lm, developed with Tomcat that is embeded with NetBeans to Tomcat embeded in JBOSS application server. 1. You better change port number at which Tomcat in JBoss is running using

JBOSS_HOME\server\default\deploy\jbossweb-tomcat55.sar\server.xml file. Change port number of HTTP Container from 8080 to 9999. This is required as Oracle10g also uses 8080. 2. Copy lm.war from dist directory of lm project into JBOSS_HOME\server\default\deploy directory. 3. Run the application using the following url: 4.

http://localhost:9999/lm

5. You should see login page of the application.