*
The moose likes JBoss/WildFly and the fly likes Steps to change from Hypersonic to Oracle DB in jboss4.2.3 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Steps to change from Hypersonic to Oracle DB in jboss4.2.3" Watch "Steps to change from Hypersonic to Oracle DB in jboss4.2.3" New topic
Author

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

Apoorva Prakash
Greenhorn

Joined: Jul 03, 2011
Posts: 3
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

Joined: May 14, 2008
Posts: 5812
    
    7

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.


JBoss In Action
Apoorva Prakash
Greenhorn

Joined: Jul 03, 2011
Posts: 3
Hi,

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

Please help.

Thanks & regards,
Apoorva


[Thumbnail for j error.jpg]

Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

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

Joined: May 14, 2008
Posts: 5812
    
    7

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

Joined: Jul 03, 2011
Posts: 3
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>
 
Don't get me started about those stupid light bulbs.
 
subject: Steps to change from Hypersonic to Oracle DB in jboss4.2.3
 
Similar Threads
Derby and HSQLDB
Deploy to Oracle Database but no table found
Jboss With Oracle
configuring persistence
Hypersonic issue of Jboss