Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to connect java with oracle rdb

 
Jay Vasudeva
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!!
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Stefan Wagner
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Jay Vasudeva
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic