From: david20@alpha2.axp.mdx.ac.uk
Sent: Thursday, August 17, 2000 1:30 PM
To: Info-VAX@Mvb.Saic.Com
Subject: Re: Java support on OpenVMS?

In article <399C0502.B2962CD@rtfmcsi.com>, Chuck Chopp <ChuckChopp@rtfmcsi.com> writes:
>What amount of support exists in OpenVMS for Java?
>
>Is there a Java VM?  If yes, what version of Java does it support?
>

See 

http://www.digital.com/java/download/jdk_ovms/1.2.2/j2sdk1.2.2_highlights.html

and

http://www.digital.com/java/download/fastvm_ovms/1.2.2/fvm122_highlights.html

These are betas for VMS 7.2

For VMS 7.1 there is the JDK 1.1.8-5  for further details see

http://www.digital.com/java/downloads/index.html



>Is anybody producing Java development tools for OpenVMS or does all Java
>development have to be done on another platform and then the byte-code
>gets moved to OpenVMS?
>

>Is there any support for accessing system services and RTL's or
>functions in user-written shareable images from Java apps on OpenVMS?
>
>Is there any JDBC support in OpenVMS to allow Java applications to have
>access to databases on OpenVMS or on other platforms?
>

You can certainly access Oracle via JDBC. Oracle provides a JDBC thin driver
(Type 4 driver) and a JDBC-OCI driver (Type 2 driver).

I've used the JDBC thin driver to access a Oracle 7.3.2.3.2  database on VMS
7.1. 

eg

Alpha2:typ/pag EMPLOYEE.JAVA

/*
 * This sample shows how to list all the names from the EMP table
 *
 * It uses the JDBC THIN driver.  See the same program in the
 * oci7 or oci8 samples directories to see how to use the other drivers.
 */

// You need to import the java.sql package to use JDBC
import java.sql.*;

class Employee
{
  public static void main (String args [])
       throws SQLException
  {
    // Load the Oracle JDBC driver
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

    // Connect to the database
    // You must put a database name after the @ sign in the connection URL.
    // You can use either the fully specified SQL*net syntax or a short cut
    // syntax as <host>:<port>:<sid>.  The example uses the short cut syntax.
    Connection conn =
      DriverManager.getConnection
("jdbc:oracle:thin:@alpha1.mdx.ac.uk:1526:MYSID",
                                   "user1", "password1");
 
etc


(SID, username and password changed).


Alpha2:java "Employee"
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
JAMES
FORD
MILLER

As to other JDBC drivers you would need to talk the Database suppliers.
If like Oracle's JDBC Thin driver it is pure Java then it should work
on VMS. If it isn't a pure Java driver then it obviously depends on whether
the database supplier has a VMS version.
 

David Webb
VMS and Unix team leader
CCSS
Middlesex University


>
>I've done a lot of software development work on OpenVMS with C/C++,
>Fortran, COBOL, Pascal and a little bit of ADA over the past 15 years or
>so, but I've recently started working with Java for work on apps that
>run on NetWare and Linux.  I'm working on an application that I'd like
>to have a portion of it run on OpenVMS, NetWare, Linux and possibly
>WinNT/Win2K.  I'm hoping that I can do this in Java but I'll fall back
>on C++ if necessary.  I'm asking these questions because I've really
>heard very little about Java support in OpenVMS.
>
>
>TIA,
>
>Chuck
>--
>Chuck Chopp
>
>ChuckChopp@rtfmcsi.com            http://www.rtfmcsi.com
>                                  ICQ # 22321532
>RTFM Consulting Services Inc.     864 801 2795 voice & voicemail
>103 Autumn Hill Road              864 801 2774 fax
>Greer, SC  29651                  800 400 4935 pager
>                                  8004004935@alphapage.airtouch.com
>
>