• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

how to connect java with oracle rdb

 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!!
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 1923
Scala Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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..
 
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic