Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 124
  • Last Modified:

Point To Server In JBoss

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
xoxomos
Asked:
xoxomos
  • 3
  • 2
1 Solution
 
gheistCommented:
Oracle JDBC documentation is a good place to start.
In your case hostname is ora11g.odscommerce.com and oracle instance name is ora11g
0
 
xoxomosAuthor Commented:
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
 
xoxomosAuthor Commented:
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
 
gheistCommented:
You just edit XMLs. There is no specific procedure.
0
 
xoxomosAuthor Commented:
Thank you!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now