aspose file tools*
The moose likes JDBC and the fly likes how to connect java with oracle rdb Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to connect java with oracle rdb" Watch "how to connect java with oracle rdb" New topic
Author

how to connect java with oracle rdb

Jay Vasudeva
Greenhorn

Joined: Sep 22, 2004
Posts: 21
Hey!

Guys, I am new to this forum. It looked greatly helpful so I thought maybe any one of you might have some information on this.

I am developing an application to connect a jsp page to a RDB database which is running on OPENVMS VAX (not ALPHA) platform. It seems like there are JDBC drivers to connect to RDB for ALPHA platform.

I have been really unsuccessful to find a way to connect the jsp page to the oracle RDB database running on VAX.


Any help or guidance will be greatly appreciated!!


SCJP 1.4<br />SCWCD 1.4 ( next... )
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29237
    
139

Jitesh,
Welcome to JavaRanch! I'm not sure I understand your question. Can you clarify what you are looking for? A few comments that spring to mind:

Sun has a tutorial on JDBC. It is a good place to start.

Another recommendation is not to put JDBC in a JSP. It is cleaner to put it in a servlet and then forward to a JSP.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Stefan Wagner
Ranch Hand

Joined: Jun 02, 2003
Posts: 1923

Isn't the hardware - if you use jdbc - completely out of interest?
With my ora-jars, I can access a ora-database, running on linux, as well, as running on a windows-platform.
Why should I need a different one, when the DB is running on a VAX?

Do I miss something?


http://home.arcor.de/hirnstrom/bewerbung
Jay Vasudeva
Greenhorn

Joined: Sep 22, 2004
Posts: 21
I am going to try the JDBC driver that oracle provides for RDB. The only thing that gave confused me was...in the driver definition file..under the minimum requirements, is said

OPENVMS ALPHA platform

and ALPHA is a more advanced platform than VAX...that is the only thing that stopped me.

Although, by monday I am going to try everything that I have found so far...

I just hope what you saying is right..hardware should really not affect the connection...

If it works, I will post everywhere on the web so nobody will have this much trouble anymore..

thanks guys..

If there is still anyone with any more ideas..i will accept it with great appreciation..
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Originally posted by Jeanne Boyarsky:

Another recommendation is not to put JDBC in a JSP. It is cleaner to put
it in a servlet and then forward to a JSP.


it is also not recommended that put your jdbc code in your servlet. servlet should be used for request/response instead.

put your jdbc stuff in some regular java class.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29237
    
139

it is also not recommended that put your jdbc code in your servlet. servlet should be used for request/response instead.

put your jdbc stuff in some regular java class.

True. I think it is better to put it in the servlet than in a JSP. Code in a JSP should be avoided if at all possible. I agree that it is better to keep the JDBC code in a separate class entirely.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to connect java with oracle rdb
 
Similar Threads
jsp connect to oracle rdb(vax)
JDBC/ODBC Not Closing
JDBC Driver for Oracle RDB
Retrieving and Presenting huge data
DSN connection