HP3000-L Archives

February 2009, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Cathlene Mc Rae <[log in to unmask]>
Reply To:
Cathlene Mc Rae <[log in to unmask]>
Date:
Mon, 16 Feb 2009 11:49:37 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (62 lines)
java /jdbc  for mpe access: 

java.sql.DriverManager.getConnection(url)

where:
 
String url = 
 
      "jdbc:allbase://host[:port]/database?UID=uid&PWD=pwd" 
 
 
     
java.sql.DriverManager.getConnection(url, uid, pwd)

where:

 
String url =       "jdbc:allbase://host[:port]/database[?TRACE=trace]";String 
uid = "uid";String pwd = "pwd"; 
 

host
Name or IP address of the sever host

port
Optional port number on which the JDBC Monitor is listening. If not specified, 
the default part number 31700 is used.

database
ALLBASE/SQL or IMAGE/SQL database name.

uid
Server host userid that is authorized to access the database.

pwd
Server host password that matches the user id provided above.


Sample code: 

java.sql.DriverManager.getConnection( 
 
      "jdbc:allbase://host/dbname",  
 
      "user1.acct1",  
 
      "upass1.apass1"); 

or 
java.sql.DriverManager.getConnection(  
      "jdbc:allbase://host/dbname",      "sess1,user1.acct1,group1",    
  "upass1.apass1.gpass1"); 

Best Regards

 Cathlene Mc Rae
HP SR. Response Center Engineer
[log in to unmask]

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2