When i tried to deploy jboss-portal2.6 with mysql database, Portal deployment was fine and it was able to create default portal dashboard and editpage contents.
When i tried to deploy jboss-portal2.6 with oracle10g database, it was able to create default portal but was unable to create the dashboard and editpage contents.
These are my configurations
JBoss-4.0.5GA is my Appserver
Oracle10g is the DB
Jboss-Portal2.6
my portal-ds.xml
<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ora-web-rac1d.am.health.ge.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ora-web-rac2d.am.health.ge.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ora-web-rac3d.am.health.ge.com)(PORT=1521))(LOAD_BALANCE=yes)(FAILOVER=true))(CONNECT_DATA=(SERVICE_NAME=devag)(FAILOVER_MODE=(TYPE=SELECT)(RETRIES=180)(DELAY=5))))</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>ITConnect</user-name>
ITConn3ct
</local-tx-datasource>
Can any one help me why is it so happening only with oracledb
We needed another Oracle DB specific workaround that is not in JBoss Portal 2.6.0.
It will be included in 2.6.1 due soon