hira magin [https://community.jboss.org/people/vaibhavnigam] created the 
discussion

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

To view the discussion, visit: https://community.jboss.org/message/798205#798205

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




h3.  JBOSS Portal Installation 

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

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

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

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

h2. 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
[https://community.jboss.org/message/798205#798205]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to