sir, i downloaded beer4all project from sourceforge.net site. i want to rearrange the war files folder structure to the common structure, javasource webcontents like that please help me where i ll keep program files whether inside the javasource or webcontents? in beer4all project uses SQL database but i am having Access only.is it possible to change the database completely from SQL to Access?
- sql is a query language, which is used by all database-systems (...i know of) - MySql would be a free database-system, same goes for hsqldb - you should be able to run the project on both of these database-systems
I am having only Access database only, no MySQL when i deploy and run the project it gives java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. and also when i import the project into workspace means which xml i ll buid the antbuild or i want to add package build.xml like other struts project or what i tried that too but i think that is not a way i know someone(Especially Mr.Merril) can definitely help me out. thanks in advance
- i really don't understand your sentence with the "build.xml" in it, even though i read it 5 times.
- i cannot give you complete deployment/installation guide for JBoss. how should that possibly work? try a seperate tomcat first, as a hint.
- i'm not sure if you understood my answer that you need to install MySQL first.
generally i advice you to work step by step. catch yourself a simple tutorial and study it carefully. post any problems you have, but give it a try first. dont start with any ms-access / full blown app-server configs first.
Read the project-files/readme.first file. This explains how to set up the database:
The Beer4All Example Struts application uses OJB (jakarta.apache.org/ojb) version 0.9.4. It also uses the Hypersonic database. The repository.xml file that is located in the beer4all/WEB-INF/classes directory has a hard-coded path that must be modified to reflect your environment before the example application will run.
Copy the files (beer4all.data, beer4all.script and beer4all.properties file included in the zip to a location on your machine. Then update the repository.xml file to reflect this location. Install the .WAR file into a compliant container (this example was tested on Tomcat 4.1.9beta) and all of it should work.