Websynergy on Oracle

1. Downloaded Oracle 10g XE for windows from www.oracle.com. Install it. I gave SYS/password
2. Access http://localhost:8080/apex -> login as SYS/password
3. Click on Administration -> Database Users -> Create users
Enter username : lportal
password : lportal
Granted all user privileges (except for the DBA checkbox)
4. Go to Oracle sql prompt and run "connect lportal/lportal;" command
5. run the following command "create schema authorization lportal;"

6. Now install websynergy (change the port of websynergy to 6060 in the setup.xml of glassfish so that it doesn't clash with oracle port. ). Start GF V2
7. copy ojdbc14.jar (Download from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html) to glassfish/domains/domain1/lib directory and restart GF V2 again
8. Go to the admin of GF V2 (http://localhost:4848) -> resources -> Connection Pools -> LiferayPool

9. Change to the following properties :
Under "General" Tab :
Datasource Classname : oracle.jdbc.pool.OracleDataSource
Under "Additional Properties" Tab : set the following properties :
username : lportal
password : lportal
URL : jdbc:oracle:thin:@localhost:1521:XE

10. Go to general tab and click on ping. If everything is fine, This should succeed :-)

11. Restart GF V2. This should create the tables and populate all the data into the oracle db.
Comments:

hi... what you said didn't work... it did change the database from hsqldb to oracle9i (for me). additionally i had to put hibernate.dialect property in portal.properties file which is located in the portal_impl.jar file which is present in the WEB-INF/lib in websynergy web application.

Posted by peter dmello on June 18, 2009 at 07:52 AM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

siddeshk123

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today