SELECT * FROM tablename LIMIT 1000, 2000

import java.sql.*; 
 
public class Td1 {
    private static final String dbDriver = "transbase.jdbc.Driver";
    private static final String dbUrl = "jdbc:transbase://localhost/";
    private static final String dbDatabase = "TECDOC_CD_3_2014";
    private static final String dbUser = "tecdoc";
    private static final String dbPassword = "tcd_error_0";
 
    public static void main (String args [])
    {
        System.out.println ("Start app!");
        try {
            Class.forName(dbDriver);
            Connection connection = DriverManager.getConnection(dbUrl + dbDatabase, dbUser, dbPassword);
        } catch (SQLException e) {
            System.out.println ("SQLException!");
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            System.out.println ("ClassNotFoundException!");
            e.printStackTrace();
        }
        System.out.println ("Finish app!");
    }
}

c:\TECDOC_CD\3_2014\db>java -cp .;./tbjdbc6.jar Td1
Start app!
SQLException!
transbase.t:
Transbase JDBC/JDBCX Driver
Release Version 4.1
Build 20130708(479)
Transbase Client Error <30209>:
IO exception on socket: jdbc:transbase://localhost/TECDOC_CD_3_2014 : Connection
 refused: connect
        at transbase.ai.<init>(Unknown Source)
        at transbase.jdbc.Connection.<init>(Unknown Source)
        at transbase.jdbc.Driver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at Td1.main(Td1.java:15)
Finish app!

SELECT
    MOD_CV
FROM ART_LOOKUP
JOIN LINK_ART ON ARL_ART_ID=LA_ART_ID
JOIN LINK_LA_TYP ON LAT_LA_ID=LA_ID
JOIN TYPES ON TYP_ID=LAT_TYP_ID
JOIN MODELS ON MOD_ID=TYP_MOD_ID
WHERE
    ARL_ART_ID={ID}