import java.util.*;
import java.sql.*;
import java.sql.Date;
import lotus.jdbc.domino.*;
public class Domino_Sample1
{
public static void main( String[] args)
{
Connection con;
Statement stmt;
ResultSet rs;
ResultSetMetaData rsmd = null;
String name;
String sql = "SELECT COUNT(*) FROM Employees";
String connStr = "jdbc:domino:/NSR6/JdbcDemo.nsf";
java.text.DecimalFormat moneyForm = new java.text.DecimalFormat("##,###.##");
try {
try {
Class.forName("lotus.jdbc.domino.DominoDriver"); }
catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundExecption: " + e.getMessage());
}
// GET CONNECTION
System.out.println();
System.out.println("Connecting to URL " + connStr);
con = DriverManager.getConnection(connStr,"","");
System.out.println();
// Create Statement
stmt = con.createStatement();
// Execute statement
rs = stmt.executeQuery(sql);
System.out.println("Executing... " + sql);
System.out.println();
// Get Result set metadata
rsmd = rs.getMetaData();
// Find number of columns in the result set
int colCount = rsmd.getColumnCount();
// Array to hold max display size per column
int[] len = new int[colCount+1];
// Print column Labels as header
for (int i=1; i<= colCount; i++)
{
// Get column label.
String label = rsmd.getColumnLabel(i);
// Store the maximum of display size or label length
if (label.length() > 10)
len = label.length();
else
len = 10;
// Print label
System.out.print(label);
// Pad with blanks
fill(" ",len-label.length());
// Column seperator
System.out.print(" ");
}
// New line
System.out.println();
for (int i=1; i<= colCount; i++)
{
fill("-", len);
System.out.print(" ");
}
// New line
System.out.println();
// Fetch all rows in the result set
while (rs.next())
{
// Get all columns as String.
String EmpId = rs.getString(1);
printCol(len[1], EmpId);
String Fname = rs.getString(2);
printCol(len[2], Fname);
String Lname = rs.getString(3);
printCol(len[3], Lname);
Date Hday = rs.getDate(4);
printCol(len[4], Hday.toString());
Date Bday = rs.getDate(5);
printCol(len[5], Bday.toString());
float Salary = rs.getFloat(6);
printCol(len[6], moneyForm.format(Salary));
System.out.println();
}
// Close the statement
stmt.close();
// Close the connection
con.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
}
// Print a string N times
static void fill(String s, int times)
{
if (times <= 0)
return;
for (int i=0; i<times; i++)
{
System.out.print(s);
}
}
// Print a column and pad it with blanks + separator
static void printCol(int len, String s)
{
System.out.print(s);
fill(" ",len-s.length());
System.out.print(" ");
}
}
con = DriverManager.getConnection(connStr,[b]""[/b],[b]""[/b]);
For Lotus Notes, a full user license is required; mail IDs are not supported. Notes database files can reside on a server. You do not need to have local copies of these files but must have at least Reader access to them through Notes.
One of the following:
Microsoft Windows 98; Microsoft Windows NT 4.0 or higher; or Microsoft Windows 2000.
Q. What security is in place when I use Domino Driver for JDBC to access Domino?
A. LDDJ uses the same security as the Notes client does. The Notes ID in use determines the level of access to a database. To run an application unattended without ever receiving a password prompt, you must use a non-password-protected ID.
Note: You can remove password protection from your ID by clearing it (File - Tools - User ID - Clear Password), unless your Domino administrator required a password to be used when your ID was created. In this case, you won't be able to clear it.
Q. Does Domino support transaction rollbacks or two-phase commits?Frag mich seit Monaten, ob es irgendwie möglich ist Domino in 2-Phase commit Operationen von Session Enterprise Java Beans einzubinden. Das ist nämlich das coolste feature von EJB: Du kannst Zugriffe auf verschiedene Systeme (also z.B. Oracle und SAP) in einen 2-phase-commit Transaktions-kontext bringen und beide sind in einer atomaren Transaktion (beide werden ausgeführt oder keins).
A. No. The connection automatically commits changes after executing each statement.