http://www.postgresql.org/layout/images/hdr_left.pnghttp://www.postgresql.org/layout/images/hdr_right.png http://jakarta.apache.org/tomcat/images/tomcat.gif http://www.jboss.com/themes/jbosstheme/img/logo.gif -


Jboss Postgresql the full j2ee stack Installation

original author Paul Norton v1.0 04/07/05:BST(GMT+1) 19:00


Requires

..she is beautiful i love her :)

  • JBOSS 4.02Peace, Harmony, Love and hugs to all in the Jboss mind set NOTE: 4.03RC1 Untested but I dont see an issue

Important

<YOUR_POSTGRESQL_INSTALL_DIR> == install directory of your Postgresql Server

Eg D:\Program Files\PostgreSQL == <YOUR_POSTGRESQL_INSTALL_DIR>
<YOUR_RAPLA_DIR> == install directory of your rapla

Eg c:\rapla-webapp-1.0beta1 ==<YOUR_RAPLA_DIR>
<JBOSS_HOME> == the directory root of JBOSS
Eg D:\apps\jboss\jboss-4.0.2==<JBOSS_HOME>

1)[follow these instructions for setting up the webapp and Postgresql|http://rapla.homelinux.org/en/Wiki.jsp?page=PostgresqlWebappUpdate]

2) Copy the postgresql-8.0-311.jdbc3.jar to the webapp server

NOTE: Not strictly necessary but good house keeping

Copy the <JBOSS_HOME>\server\default to  <jbosS_home>\server\rapla
Copy <YOUR_POSTGRESQL_INSTALL_DIR>\8.0\jdbc\postgresql-8.0-311.jdbc3.jar to <JBOSS_HOME>\server\rapla\lib

3)NOTE: you MUST have followed these instructions for setting up the webapp and Postgresql

cd into <YOUR_RAPLA_DIR>

create a directory named rapla
mkdir rapla
    copy the <YOUR_RAPLA_DIR>\webapp\* and all the contents
to  <YOUR_RAPLA_DIR>\rapla

4) Sanity check

<YOUR_RAPLA_DIR>\webapp\
and
<YOUR_RAPLA_DIR>\rapla\
SHOULD BE INDENTICAL

5) Create rapla war file NOTE: Assumes you have java jre/bin in path please use absolute commands if not :)

cd <YOUR_RAPLA_DIR>\rapla
and run the follwoing
     jar -cvf rapla.war .

6) Deploy rapla war file under jboss NOTE: chown and chmod linux peeps

7) Start JBOSS / running Rapla

cd into <JBOSS_HOME>\bin
run the following command
  run -c rapla

No Errors ?? Gr8
copy <YOUR_RAPLA_DIR>\rapla\rapla.war
 into <JBOSS_HOME>\server\rapla\deploy\

Hot deploy so np 4u :)

point your browser @ http://localhost:8080/raplaor http://your_app_srv_ip:your_app_srv_port/your_app_name

7)Data Sanity check

In the rapla user interface create a new resource under person give it values jboss jboss then

psql -U rapla rapla
select * from resource_attribute_value where value='jboss';

Hope this helps you. Remember I'm human and this is a first draft any positive comments or suggestions for improvements to alien_morph/hotmail.com replace / with @ and make sure you mention Rapla JBOSS in your topic

I'd also like to thanks the Rapla team for their great work, I'm sure you agree this is a best of breed solution :)

Kind regards Paul