Solved

Point To Server In JBoss

Posted on 2014-12-21
5
103 Views
Last Modified: 2015-01-05
A friend had been running Oracle database and JBoss on the same VM.  He then exported the database to a separate server apparently leaving the datasource configuration the same.   He's now getting 'route to host not found' and '.....network adapter' errors.
Where does he look to change the location from the localhost to a different server?
I'm seeing:
<datasources>
  <local-tx-datasource>
    <jndi-name>CompleteSourceDB</jndi-name>
    <connection-url>jdbc:oracle:thin:@ora11g.odscommerce.com:1521:ora11g</connection-url>      
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>moaitest_251012</user-name>
    <password>password</password>    

Would it work if he just changed the @ora11g.odscommerce.com to @new_host_name or just new_host_name?
0
Comment
Question by:xoxomos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 40512460
Oracle JDBC documentation is a good place to start.
In your case hostname is ora11g.odscommerce.com and oracle instance name is ora11g
0
 

Author Comment

by:xoxomos
ID: 40515663
Thanks.  Actually the JBoss docs. I just thought some JBoss experts might know off the top if simply putting in  the new server name in place of the @ora11g.odscommerce.com in that XML file would be ok with JBoss as far as '...path to server' for Oracle or is there some other route JBoss would require to change servers.
0
 

Author Comment

by:xoxomos
ID: 40532188
I'll try rephrasing the question.  If i am now using a different database server and different database instance_name should i be able to simply change the information in the connection_url or is it necessary to create a new XML file through some procedure specific to JBoss?
0
 
LVL 62

Accepted Solution

by:
gheist earned 500 total points
ID: 40532255
You just edit XMLs. There is no specific procedure.
0
 

Author Closing Comment

by:xoxomos
ID: 40532319
Thank you!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack 7.0.0.23 or Above. The following steps a…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question