Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases and the fly likes JDBC with OAS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC with OAS " Watch "JDBC with OAS " New topic
Author

JDBC with OAS

Essam AbdelAziz
Ranch Hand

Joined: Mar 10, 2007
Posts: 34
Hello guys i have a problem

with deploying J2ee application

the apllication is working fine in case using tomcat as a webserver

but in case using the oracle application server i can't connect to the database

althogh using the same Way to connect to database

do i need any extra configauration for OAS to connect to DB

i use

OAS 10.1.2

jdbc connection
and this is my connection class

String url ="jdbcracle:thin:@SSLWFSRV:1521EVDB";


Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection(url,"user","Password");


thanks and regards
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2532
    
  10

Please post the errors.

You are not using the application server's database pool. You're using straightforward jdbc. So it should not be a server configuration issue.
Two possible causes for the error are: the oracle jdbc driver is not in your application's classpath, or
the database service defined in your connection string is not reachable from your OAS server.
The errors will tell you more.

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
Essam AbdelAziz
Ranch Hand

Joined: Mar 10, 2007
Posts: 34
url ="jdbcracle:thin:@SSLWFSRV:1521EVDB";

Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection(url,"user","pass");



thanks
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2532
    
  10

That is the code. Can you post the errors you get when running the code? They will maybe show us what's going wrong.

Regards, Jan
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: JDBC with OAS