JBoss Community

How to configure MySQL Database with Jboss Portal Bundle 2.7.4 in wondows Platform

created by hira magin in Datasource Configuration - View the full discussion

How to configure  MySQL Database with Jboss Portal Bundle 2.7.4 in wondows Platform

Any One Can Help me . I am new in jboss portal I follow this step to configure database with jboss portal but it gives ERROR

 

 

 

 

JBOSS Portal Installation

 

Chapter 1. Download

Download JBoss portal from http://www.jboss.org/jbossportal/download/index.html.
Package: JBoss Portal + JBoss AS 4.2.3
Direct download link: http://downloads.sourceforge.net/jboss/jboss-portal-2.7.2-bundled.zip

Chapter 2. Installation

2.1 Folder structure (προτεινόμενη)

Extract jboss-portal-2.7.2-bundled.zip to a desired folder (for example C:\server\jboss). Το τελικό path του portal είναι C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2

2.2 Database

Δημιουργούμε μια βάση δεδομένων (for example jboss).
All database tables will be created for you at runtime.

2.3 JDBC connector

Download MySQL JDBC connector from http://dev.mysql.com/downloads/connector/j/5.1.html
Το αρχείο mysql-connector-java-5.1.7-bin.jar πρέπει να τοποθετηθεί στο path $JBOSS_HOME/server/default/lib (C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\server\default\lib)

2.4 JBoss and MySQL Configuration

  1. Copy  C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\setup\portal-mysql5-ds.xml (for PHP5) to C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\server\default\deploy
  2. Copy  C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\docs\examples\jca\mysql-ds.xml to C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\server\default\deploy
  3. Rename  C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\server\default\deploy\portal-hsqldb-ds.xml to portal-hsqldb-ds.xml-rename (ώστε να διαβαστούν το αντίστοιχο mysql)
  4. Rename  C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\server\default\deploy\hsqldb-ds.xml to hsqldb-ds.xml-rename (ώστε να διαβαστούν το αντίστοιχο mysql)

2.5 Configure portal-mysql5-ds.xml and mysql-ds.xml

Τροποποίηση αυτών των αρχείων για τη σωστή σύνδεση στη βάση δεδομένων (XAMMP),

  1. portal-mysql5-ds.xml: Replace        PortalDS
      jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&jdbcCompliantTruncation=false
      com.mysql.jdbc.Driver
      portal
      portalpassword

    with       PortalDS
      jdbc:mysql://localhost/jboss?useServerPrepStmts=false&jdbcCompliantTruncation=false
      com.mysql.jdbc.Driver
      root
     

  2. mysql-ds.xml: Replace

    MySqlDS
      jdbc:mysql://mysql-hostname:3306/jbossdb
      com.mysql.jdbc.Driver
      x
      y
    with
    MySqlDS
      jdbc:mysql://localhost/jboss
      com.mysql.jdbc.Driver
      root
     

 

2.6 Deploy JBoss portal

Run from console C:\server\jboss\jboss-portal-2.7.2-bundled\jboss-portal-2.7.2\bin\run.bat -b 0.0.0.0

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community