Changed the database from HypersonicSQL to PostgreSQL(=DefaultDS) as follows.
=== Environment:
- Linux(Red Hat Professional Workstation, Kernel 2.4.21)
- J2SE 1.4.2_04
- Eclipse 2.1.2
- JBoss 3.2.1_Tomcat 4.1.24
- Lomboz 2.1.3
- PostgreSQL 7.4.2
- Axis 1.1
= Step 1: Download and install PostgreSQL(see ?INSTALL? in
?postgresql-7.4.2.tar.gz? etc. for details)
| - The directory is ?/usr/local/pgsql?.
| - Compile PostgreSQL with ?--with-java? option in ?configure? command to
produce the JDBC file ?postgresql.jar?.
| - Add a user name ?postgres? with no password.
| - Set up classpath.
|
| = Step 2: Make a database in PostgreSQL
| - Initialize PostgreSQL and create a new database named ?MyStoreDbPgSQL?
for the tutorial.
| - Make the tables and the data using ?myStoreSchema.script? and
myStoreSchema.data?(+?myStoreSchemaDrop.script).
| e.g.
| a. Change the user in a console, i.e. ?su? then ?su postgres?. Start
PostgreSQL with ?pg_ctl -w start?.
| b. Open a session with ?psql MyStoreDbPgSQL?.
| c. Copy and paste each SQL code in *.script and *.data files
above.(add?;?to each SQL code)
| d. Keep ?PostgreSQL? running.
|
| = Step 3: Add a directory as a new server option
| - Copy the complete directory of ?all? under ?/JBoss-3.2.1/server? and name
it ?postgres?.
| /JBoss-3.2.1/server
| |- /all
| |- /default
| |- /minimal
| |- /postgres
|
| - Keep the directories ?all?, ?default? & ?minimal? un-touched.
| - Delete all sub-directories and files under ?/server/postgres/log? and
?/temp?.
| (adjust access mode if any troubles during start-up of JBoss (Step 12))
|
| = Step 4: Install JDBC driver for PostgreSQL
| - Delete ?hsqldb.jar? and ?hsqldb-plugin.jar? in ?/server/postgres/lib?.
| - Copy ?postgrsql.jar? from ?/usr/local/pgsql/share/java? to
?/server/postgres/lib?.
|
| = Step 5: Copy and modify the Server Definition File for Lomboz
| - Make a copy of ?jboss321all.server? in
?/opt/eclipse/plugins/com.objectlearn.jdt.j2ee/servers? as
?jboss321allpgsql.server?.
| - Add ?.bak? to all ?*.server? files in the directory except for
?jboss321allpgsql.server?.
| - In ?jboss321allpgsql.server?,
| a. change name=?JBOSS 3.2.1 ALL? in <serverDefinition> to name=?JBOSS
3.2.1 ALL PGSQL?
| b. change <startProgramArguments>-c all</startProgramArguments> to
<startProgramArguments>-c postgres</startProgramArguments>
| c. change all of ?.../server/all/...? to ?.../server/postgres/...?
| d. delete following two lines in <serverClassPath>
| <jar
type=?variable?>${classPathVariableName}/server/postgres/lib/hsqldb.jar</jar>
| <jar
type=?variable?>${classPathVariableName}/server/postgres/lib/hsqldb-plugin.jar</jar>
| and add
| <jar
type=?variable?>${classPathVariableName}/server/postgres/lib/postgresql.jar</jar>
|
| = Step 6: Prepare the Service Description File
| - Delete ?/server/postgres/deploy/hsqldb-ds.xml? or add ?.bak? to disable.
| - Copy ?postgres-ds.xml? in ?/jboss-3.2.1/docs/examples/jca? to
?/server/postgres/deploy?
| - In ?postgres-ds.xml?, the contents of <local-tx-datasource> are as
follows;
| <jndi-name>DefaultDS</jndi-name>
|
<connection-url>jdbc:postgresql://localhost/MyStoreDbPgSQL</connection-url>
| <driver-class>org.postgresql.Driver</driver-class>
| <username>postgres</username>
| <password></password>
|
| = Step 7: Modify the Login Config File
| - In ?/server/postgres/conf/login-config.xml?, the <application-policy> is
as follows;
| <application-policy name = ?PostgresDbRealm?>
| <authentication>
| <login-module code =
?org.jboss.resource.security.ConfiguredIdentityLoginModule?
| flag = ?required?>
| <module-option name = ?principal?></module-option>
| <module-option name = ?userName?>postgres</module-option>
| <module-option name = ?password?></module-option>
| <module-option name =
?managedConnectionFactoryName?>jboss.jca:service=LocalTxCM,name=DefaultDS</module-option>
| </login-module>
| </authentication>
| </application-policy>
|
| = Step 8: Modify ?standardjaws.xml?
| - In ?/server/postgres/conf/standardjaws.xml?, the top parts of <jaws> are
as follows;
| <jaws>
| <datasource>java:/DefaultDS</datasource>
| <type-mapping>PostgreSQL</type-mapping>
| <debag>false</debug>
| <default-entity>
| :
|
| = Step 9: Modify ?standardjbosscmp-jdbc.xml?
| - In ?/server/postgres/conf/standardjbosscmp-jdbc.xml?, the top parts are
as follows;
| <jbosscmp-jdbc>
| <defaults>
| <datasource>java:/DefaultDS</datasource>
| <datasource-mapping>PostgreSQL</datasource-mapping>
| <create-table>true</create-table>
| :
|
| = Step 10: Modify ?jbossmq-service.xml? (for Chapter 7 and after)
| - In ?/server/postgres/deploy/jms/jbossmq-service.xml?, the jdbc2
Persistence Manager is as follows;
| :
| <depends
optional-attribute-name=?ConnectionManager?>jboss.jca:service=LocalTxCM,name=DefaultDS</depends>
| <attribute name=?SqlProperties?>
| BLOB_TYPE=BYTES_BLOB
| INSERT_TX = INSERT INTO JMS_TRANSACTIONS (TXID) values(?)
| :
| :
| CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER
NOT NULL, \
| DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1), \
| MESSAGEBLOB BYTEA, PRIMARY KEY (MESSAGEID, DESTINATION) )
| CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
| CREATE_TABLES_ON_STARTUP = true
| </attribute>
| :
|
| *** Start Eclipse and build a new project as MyStorePgSQL.
|
| = Step 11: Confirm ?xdoclet.xml? is with PostgreSQL
| - In ?/MyStorePgSQL/MyStoreMgr/META-INF/xdoclet.xml?, the JBoss part is as
follows;
| <jboss
| :
| datasource=?java:/DefaultDS?
| datasourcemapping=?PostgreSQL?
| preferredrelationmapping=?foreign-key?
| />
| :
| = Step 12: Start JBoss from ?Lomboz J2EE View?
| - If any failure/error messages such as ?XAConnectionFactory not bound?
appear during start-up process,
| stop JBoss (keep PostgreSQL running) and check the tables in the database.
| a. $ psql MyStoreDbPgSQL
| b. =# \dt
| - if the tables ?jms_messages? and ?jms_transactions? exist, drop both of
them.
| c. =# DROP TABLE jms_messages;
| d. =# DROP TABLE jms_transactions;
| - Re-start JBoss
jbosszone
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3868920#3868920
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3868920
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
