-
1. Re: Server startup error in jboss-soa-p-5 soa platform installation
pmuthya Feb 1, 2012 3:10 PM (in response to girish_shivanigi)In you service/deploy/jbossesb.esb, check these files
jbossesb-service.ml, if you see the datasource declaration and relevant details, like below:
<?xml version="1.0" encoding="UTF-8"?>
<server>
<mbean code="org.jboss.internal.soa.esb.dependencies.DatabaseInitializer"
name="jboss.esb:service=MessageStoreDatabaseInitializer">
<attribute name="Datasource">java:/JBossESBDS</attribute>
<attribute name="ExistsSql">select count(*) from message</attribute>
<attribute name="SqlFiles">
message-store-sql/oracle/create_database.sql
</attribute>
<depends>jboss.jca:service=DataSourceBinding,name=JBossESBDS</depends>
</mbean>
</server>
message-store-ds.xml,
should have the jndi name and connection properties setup correctly.
-
2. Re: Server startup error in jboss-soa-p-5 soa platform installation
tcunning Feb 1, 2012 4:36 PM (in response to pmuthya)Did you use the jboss-as/tools/schema script to change your settings? If not I'd advise using that script rather than doing everything by hand.
-
3. Re: Server startup error in jboss-soa-p-5 soa platform installation
girish_shivanigi Feb 2, 2012 12:14 AM (in response to tcunning)Yup, I used schema scripts to update the database configurations
-
4. Re: Server startup error in jboss-soa-p-5 soa platform installation
tcunning Feb 2, 2012 9:49 AM (in response to girish_shivanigi)Did you configure it to use the SYS user? It looks like that won't work - your or your DBA need to provide a different user with add/drop privileges, or you can change a parameter (07_DICTIONARY_ACCESSIBILITY) - but it looks like Oracle strongly advises against doing that. It looks like it'd be better just to set up a new user for this purpose.
-
5. Re: Server startup error in jboss-soa-p-5 soa platform installation
pmuthya Feb 2, 2012 12:50 PM (in response to tcunning)Is there some documentation which explains on the usage of scripts for setting up a new jboss soa platform?
-
6. Re: Server startup error in jboss-soa-p-5 soa platform installation
girish_shivanigi Feb 2, 2012 11:23 PM (in response to girish_shivanigi)Hi,
I did change the 07_DICTIONARY_ACCESSIBILITY to true but didn't work, also created the new user and gave all the grants to the new user still doesn't work
Is there anything else I am missing there?
Regards
Girish
-
7. Re: Server startup error in jboss-soa-p-5 soa platform installation
girish_shivanigi Feb 3, 2012 6:07 AM (in response to girish_shivanigi)Hi,
The issue has been resolved, below are the steps
1) Created new db user and granted connec,resource permission to the user.
2) Changed SYS user the new user credetntials in all *-ds.xml (datasource files) for all the components.
Thanks everyone for the help
Regards
Girish
-
8. Re: Server startup error in jboss-soa-p-5 soa platform installation
tcunning Feb 3, 2012 10:41 PM (in response to pmuthya)P M wrote:
Is there some documentation which explains on the usage of scripts for setting up a new jboss soa platform?
-
9. Re: Server startup error in jboss-soa-p-5 soa platform installation
girish_shivanigi Feb 6, 2012 3:58 AM (in response to tcunning)Hi All,
Having made progress on the above issues, I am bumping into these exceptions below during the server startup.. Please help
1) java.lang.IllegalStateException: deployment file does not exist D:\JBoss%20SOA%20Platform\SOA_ROOT\jboss-soa-p-5\jboss-as\server\default\deploy\oracle-ds.xml
and getting below excepion for java:/juddiDB
2) 12:19:43,529 INFO [DatasourceConnectionProvider] Using datasource: java:/juddiDB
12:19:43,533 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
12:19:43,534 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0
12:19:43,563 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect
12:19:43,574 INFO [JdbcSupportLoader] Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
12:19:43,575 WARN [SettingsFactory] Could not obtain connection metadata
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
3) BPEL schema access..
12:19:44,865 INFO [JdbcSupportLoader] Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
12:19:44,866 WARN [SettingsFactory] Could not obtain connection metadata
java.sql.SQLException: Unsupported feature
4)
12:19:59,565 INFO [DatasourceConnectionProvider] Using datasource: java:/JbpmDS
12:19:59,567 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
12:19:59,568 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0
12:19:59,569 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect
12:19:59,571 INFO [JdbcSupportLoader] Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
12:19:59,572 WARN [SettingsFactory] Could not obtain connection metadata
java.sql.SQLException: Unsupported feature