[JBoss Portal] - Jboss Portal DB Setup Issue
by sambit_dixit
Hi,
We are seeing a strange issue while setting up portal database. Initially we created a db user with system privileges ( similar to DBA privilege) and set this user under PortalDS datasource. Once we start the Jboss Portal Server. All the JBP/JBPM tables, Sequences( hibernate_sequence, portlet_sequence,portal_seq, instance_seq,sec_seq,user_seq) are created. We set up the portal and its security, themes etc through the admin console. Everything works fine using this db user.
Since this user has system privilege, there is a concern from DBAs as well as infrastructure to have a similar user with system privilege credential in production and staging environment.
As a next step, we created a new db user and granted "all" access to the JBP/JBPM tables and synonyms created for jboss portal sequences(hibernate_sequence, portlet_sequence,portal_seq, instance_seq,sec_seq,user_seq). In the hibernate.cfg file the hbm2ddl.auto is set to "update".
When we started the jboss portal with the user credential of newly created user in PortalDS, the application server is starting fine with 3 of the sequences ( portal_seq, instance_seq, sec_seq) giving error as (e.g. Table Not Found: portal_seq), then when i try to login to portal using portal user or admin. It is not going through.
I'm wondering why not able to get into JBP when JBP is started with a DB user not having system privilege while it is working with a DB user having system privilege. Since the tables, sequences are already created and the newly created user is being given "all" privileges on the tables and sequence synonyms.
Has anyone faced this issue or this is a limitation in JBP ?
Appreciate your response ?
Regards
-Sambit
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4242509#4242509
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4242509
17 years
[Installation, Configuration & DEPLOYMENT] - Arjuna TX Manager Class Cast Exception
by rupertlssmith
Hi,
On JBoss 4.2.2GA, I get the following exception:
| java.lang.ClassCastException: com.arjuna.ats.jbossatx.jta.TransactionManagerDelegate cannot be cast to javax.transaction.TransactionManager
| at org.hibernate.transaction.JNDITransactionManagerLookup.getTransactionManager(JNDITransactionManagerLookup.java:23)
| at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:325)
| at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300)
|
Another Forum post suggested this might be because of having the 'jta' jar in the .ear file I am trying to deploy. I checked and sure enough it was there as part of the hibernate dependencies I included. 'jta.jar' does not need to be in the .ear file as the app server already provides it. So I removed it, but I still get the above error.
So now my dependency set of jars that are in my .ear file looks like (created with mvn dependency:tree):
| [dependency:tree]
| [INFO] uk.co.thebadgerset:thecookerybook-dev:ear:0.3-SNAPSHOT
| [INFO] +- uk.co.thebadgerset:thecookerybook-backend:jar:0.3-SNAPSHOT:compile
| [INFO] | +- uk.co.thebadgerset:common:jar:0.3-SNAPSHOT:compile
| [INFO] | | +- log4j:log4j:jar:1.2.13:compile
| [INFO] | | +- regexp:regexp:jar:1.3:compile
| [INFO] | | +- xml-apis:xml-apis:jar:1.3.03:compile
| [INFO] | | +- dom4j:dom4j:jar:1.6.1:compile
| [INFO] | | +- xerces:xercesImpl:jar:2.8.0:compile
| [INFO] | | \- xalan:xalan:jar:2.7.0:compile
| [INFO] | +- uk.co.thebadgerset:configurator:jar:0.3-SNAPSHOT:compile
| [INFO] | | +- javax.xml.bind:jsr173_api:jar:1.0:compile
| [INFO] | | +- javax.xml.bind:jaxb-api:jar:2.1:compile
| [INFO] | | | +- javax.xml.stream:stax-api:jar:1.0-2:compile
| [INFO] | | | \- javax.activation:activation:jar:1.1:compile
| [INFO] | | \- com.sun.xml.bind:jaxb-impl:jar:2.1.7:compile
| [INFO] | +- uk.co.thebadgerset:catalogue:ejb:0.3-SNAPSHOT:compile
| [INFO] | | +- uk.co.thebadgerset:locator:jar:0.3-SNAPSHOT:compile
| [INFO] | | +- uk.co.thebadgerset:catalogue-model:jar:0.3-SNAPSHOT:compile
| [INFO] | | +- uk.co.thebadgerset:index-ra-client:jar:0.3-SNAPSHOT:compile
| [INFO] | | \- org.hibernate:hibernate:jar:3.2.6.ga:compile
| [INFO] | | +- net.sf.ehcache:ehcache:jar:1.2.3:compile
| [INFO] | | +- commons-logging:commons-logging:jar:1.0.4:compile
| [INFO] | | +- asm:asm-attrs:jar:1.5.3:compile
| [INFO] | | +- antlr:antlr:jar:2.7.6:compile
| [INFO] | | +- cglib:cglib:jar:2.1_3:compile
| [INFO] | | +- asm:asm:jar:1.5.3:compile
| [INFO] | | \- commons-collections:commons-collections:jar:2.1.1:compile
| [INFO] | +- uk.co.thebadgerset:index:jar:0.3-SNAPSHOT:compile
| [INFO] | \- uk.co.thebadgerset:aima:jar:0.3-SNAPSHOT:compile
| [INFO] +- uk.co.thebadgerset:thecookerybook-backend:jar:config:0.3-SNAPSHOT:compile
| [INFO] \- uk.co.thebadgerset:thecookerybook-web:war:0.3-SNAPSHOT:compile
|
I'm confused by the class cast exception because I now expect that there should be only one copy of 'com.arjuna.ats.jbossatx.jta.TransactionManagerDelegate' and 'javax.transaction.TransactionManager' on the classpath and that the former does indeed extend the latter.
I have unpacked all the above jars and scanned them and none contain 'com.arjuna.ats.jbossatx.jta.TransactionManagerDelegate' or 'javax.transaction.TransactionManager'.
Is this happening because I have included the Hibernate jars in my .ear file instead of using the container supplied version?
Any help is appreciated, thanks.
Rupert
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4242501#4242501
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4242501
17 years
