NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.0+)

import java.sql.*;
...
// Create a statement:
Statement myStatement = myConnection.createStatement();
// Pass the string argument directly to the database;
// results are returned in the ResultSet object, r:
ResultSet r = myStatement.executeQuery("SELECT * from $DATA1.DBASE.EMPL");
// Retrieve successive rows from the result set and
// print the first column of each row, which is a String:
while (r.next())
System.out.println("Column 1: " + r.getString(1));
For information about how database transactions are delimited, committed, and rolled back when using JDBC, see
Transactions.
Compatible Java and SQL/MP Data Types
The following table shows which Java data types can hold which SQL/MP data types. Use this table to determine which
get() method to call to read a particular type of data from a result set or which set() method to call to define the
data type of a prepared statement's input parameter. For example, if you select CHAR data from a database, use
getString() to retrieve the CHAR data from the result set.
Compatible Java and SQL/MP Data Types
SQL Data Types
S
M
A
L
L
I
N
T
I
N
T
E
G
E
R
B
I
G
I
N
T
R
E
A
L
F
L
O
A
T
D
O
U
B
L
E
D
E
C
I
M
A
L
N
U
M
E
R
I
C
C
H
A
R
V
A
R
C
H
A
R
D
A
T
E
T
I
M
E
T
I
M
E
S
T
A
M
P
J
a
v
a
D
a
t
a
T
y
p
Byte
R s s s s s s s s s n n n
Short
R s s s s s s s s s n n n
Int
s R s s s s s s s s n n n
Long
s s R s s s s s s s n n n
Float
s s s R s s s s s s n n n
Double
s s s s s R s s s s n n n
BigDecimal
s s s s s s R s s s n n n
BigInteger
s s s s s s s s R s n n n
Boolean
R s s s s s s s s s n n n
String
s s s s s s s s R R n n n
Bytes
n n n n n n s n R R n n n
Date
n n n n n n n n n n R n n
Time
n n n n n n n n n n n R n
Timestamp
n n n n n n n n n n n n R