• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
author
Posts: 5856
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 5856
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 5856
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:1521:ora</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>
 
reply
    Bookmark Topic Watch Topic
  • New Topic