aspose file tools*
The moose likes JBoss/WildFly and the fly likes Problem oin connecting Oracle database in JBOSS AS 4.2.3 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Reply locked New topic
Author

Problem oin connecting Oracle database in JBOSS AS 4.2.3

Suddhasattwa Mukherjee
Ranch Hand

Joined: May 28, 2008
Posts: 52
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

Joined: Jul 20, 2005
Posts: 10288
    
168

Did you place the oracle jdbc driver jar in the server/default/lib folder?


[My Blog] [JavaRanch Journal]
Suddhasattwa Mukherjee
Ranch Hand

Joined: May 28, 2008
Posts: 52
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

Joined: Aug 29, 2005
Posts: 223
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.


SCJP, SCJD
Mark Kin
Greenhorn

Joined: Jun 20, 2009
Posts: 5
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

Joined: May 14, 2008
Posts: 5845
    
    7

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.


JBoss In Action
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem oin connecting Oracle database in JBOSS AS 4.2.3