Transcript

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
2. 3.

after you log in as SYSTEM user.

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. <local-tx-datasource> <jndi-name>LibraryDS</jndi-name> <connection-url>jdbc:oracle:thin:@localhost:1521:XE</connectionurl> 14. <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 15. <user-name>lm</user-name> 16. <password>lm</password> 17. <exception-sorter-classname>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exce ption-sorter-class-name> 18. <metadata> 19. <type-mapping>Oracle9i</type-mapping> 20. </metadata> 21. </local-tx-datasource>

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

Run this project . 24. 1.jsp page.ojdbc14.war from dist directory of lm project into JBOSS_HOME\server\default\deploy directory. 2. Copy library.23. 25. Run the application using the following url: 4.jar of dist directory to server\default\deploy of JBoss. http://localhost:9999/lm 5.jar and JOBSS_HOME\client\jbossall-client. Open lm project in NetBeans using File->Open Project option. .x 26.you must see index. Start JBOSS 4.library. Copy lm. Build and deploy the project to embeded Tomcat of NetBeans. 29.jar to this project. You better change port number at which Tomcat in JBoss is running using JBOSS_HOME\server\default\deploy\jbossweb-tomcat55. Build library project. 3. 28.jar.sar\server. You should see login page of the application.xml file. Deploying Web Application In Tomcat of JBoss The following procedure explains how to deploy a web application lm. Change port number of HTTP Container from 8080 to 9999. Library Bean jar file . developed with Tomcat that is embeded with NetBeans to Tomcat embeded in JBOSS application server. 27. Add Oracle Library . This is required as Oracle10g also uses 8080.