This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Steps to change from Hypersonic to Oracle DB in jboss4.2.3

 
Apoorva Prakash
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,


I am facing problems in production environment with Hypersonic DB. Please mention the steps to switch to Oracle DB.


The doc which i referred was http://www.jboss.org/community/docs/DOC-13175 but i have certain questions:


1. Where should the tables be created as used by JBOSS?

2. Are these to be manually created or JBOSS creates them?

3. How can we check if we have actually switched to Oracle DB?


Thanks & Regards,

Apoorva
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1) Anywhere you like.

2) The various services that require tables will build them automatically.

3) A few ways to check. First, remove the default-ds.xml file, and also remove the hsqldb JAR files (a search will find them). Second, look in the database after you start the appserver - you should see a number of tables created.
 
Apoorva Prakash
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am getting an error while starting the JBOSS. I am attaching the snapshot.

Please help.

Thanks & regards,
Apoorva
j error.jpg
[Thumbnail for j error.jpg]
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What you posted is the deployment report, it rarely contains any information about what the problem is. You need to scroll back and find the first exception stack trace and post that. Either that or look in the server log for the first exception stack trace for an ERROR log entry.

But here is a guess: Your Oracle datasource is not named DefaultDS. There are several services that depend on a datasource with that name. You will either have to change the name of your Oracle datasource to DefaultDS, or change all of the services that need DefaultDS to use OracleDS instead.

Please post your oracle-ds.xml file.


Also, please do not post a screen shot of the command prompt - instead, copy and paste the text.
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I also noticed that you asked this question in the JBoss Community:
http://community.jboss.org/message/613329

I have decided to respond here regarding the log files you posted there (why didn't you post them here?) rather than there because having the same conversation in two locations is a pain in the @$$.

You need to remove the oracle-ds_bk.xml file from the deploy directory, the deployer has no idea what to do with it.

And how is the class com.netegrity.ra.policyserver.impl.PSManagedConnectionFactory being used? It seems to be having some issues.
 
Apoorva Prakash
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is the oracle-ds.xml content

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: oracle-ds.xml 71535 2008-04-01 07:05:03Z adrian@jboss.org $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->


<datasources>
<local-tx-datasource>
<jndi-name>OracleDSNew</jndi-name>
<connection-url>jdbcracle:thin:@10.199.212.222:1521ra</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>jboss</user-name>
<password>password</password>
<!-- <security-domain>MyOracleDbRealm</security-domain> -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>

</datasources>
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic