Regarding Beer4all project

[padma jenifer]

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?

[Jan Groth]

without knowing this funny sounding project

- 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

cheers,
jan

[padma jenifer]

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

[Jan Groth]

yes, mr. merril can help you out :-)

what's missing on your machine is a mySql database. i understood that you have ms access, but you need to download mySql in order to have both.

after that, you'll be able to solve this

java.sql.SQLException: Cannot connect to MySQL server on localhost:3306

after that, you can start with this issue

  
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 

... which you'll definitely need to rephrase :-)

cheers,
jan

[padma jenifer]

other struts project we are having package build .xml we run it on ant build right like that here in this project on which xml we run the ant build

[padma jenifer]

please give me the instuction how can i run this project in Jboss server

[Jan Groth]

sorry mate, i'm out...

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

happy coding,
jan

[Merrill Higginson]

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.