Win a copy of Functional Reactive Programming this week in the Other Languages forum!
    Bookmark Topic Watch Topic
  • New Topic

Problem oin connecting Oracle database in JBOSS AS 4.2.3

 
Suddhasattwa Mukherjee
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi All,
I am using JBoss AS 4.2.3.GA.I have to use oracle 10g as database.For this I put a file named oracle-ds.xml in .../default/deploy/ folder.
The code is given..



Now when I am running the server ,it is starting.But whenever their is database hit it throw's an error....





Can you please tell me what iss the problem?And how to solve it?
Please help me out....
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Report post to moderator
Did you place the oracle jdbc driver jar in the server/default/lib folder?
 
Suddhasattwa Mukherjee
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Report post to moderator
I have placed the classes12.jar file in the specified folder.Is it right?I am using Jdk6.May I have to place ojdbc6.jar instead of classes12.jar?
 
Anne Crace
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Report post to moderator
Yes. We had the same problem with our app. We had an include statement for ojdbc14.jar in our build.xml, but it didn't put it in the right directory. Put it in the location (server\default\lib) mentioned in the previous post and it should work.
 
Mark Kin
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Report post to moderator
I am trying to configure the oracle datasource and I copied and made the necessary changes for oracle-ds.xml. My oracle datasource is 'TestOraDatasource' and when I try to lookup the datasource using 'TestOraDatasource' in the application its giving me HSQLDB datasource which is the default one for jboss.

How do I make my oracle datasource as the default datasource ?

Thanks


 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Report post to moderator
Amarnatha, welcome to Java Ranch.

Please do not append a new question to an old topic. Instead, please create a new topic. And provide the *-ds.xml file and the code you are using to lookup the datasource, and an explanation of how you know you are getting HSQLDB.
 
    Bookmark Topic Watch Topic
  • New Topic