I'm trying to setup portal server instance on app server. I have configured
portal-oracle-ds.xml file as below
<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:oracle:thin:@ip-address:1521:dsn</connection-url>
<driver-class>>oracle.jdbc.xa.client.OracleXADataSource</driver-class>
<user-name>user</user-name>
pass
</local-tx-datasource>
Is anything wrong here ? Any help is greatly appreciated.
All I did was moved jboss-portal.sar directory to server/default/deploy and
copied the portal-oracle-ds.xml file to deploy directory.
I keep getting the following exceptions..:...
16:37:16,370 INFO DriverManagerConnectionProvider:147 - cleaning up connection
pool: jdbc:derby:testDB10.1;create=true
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1306)
at org.hibernate.loader.Loader.list(Loader.java:1286)
at
org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:872)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:973)
======
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3915611#3915611
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3915611
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
