...
d ##class(%Net.Remote.Java.JavaGatewayService).ConnectGateway("127.0.0.1:22972:TEST",.gateway)
set db=##class(%Net.Remote.Java.JDBCGateway).%New(gateway)
d db.connect("jdbc:Cache://localhost:1972/TEST","_system","SYS")
w db.prepareStatement( 0 ,"select * from pcs.Invoice"),!
w db.execQuery( 0 ),!
w db.getColumnCount(),!
...

  Set gateway=##class(%Net.Remote.Gateway).%New()
  Set status=gateway.%Connect("localhost", 22972 ,"SAMPLES", 5 )
  
  Do gateway.%ClassForName("com.intersys.jdbc.CacheDriver")
  
  Set connection=##class(java.sql.DriverManager).getConnection(gateway,"jdbc:Cache://localhost:1972/SAMPLES","_SYSTEM","SYS")
  
  Set statement=connection.createStatement()
  Set resultSet=statement.executeQuery("select * from Sample.Person where ID < 10")
  Set resultSetMetaData=resultSet.getMetaData()
  Write !,"Execute query: select * from Sample.Person where ID < 10",!
  Write "----------------------------------------------",!
  Write resultSetMetaData.getColumnName( 1 )_"  "_resultSetMetaData.getColumnName( 3 )_"          "
  Write resultSetMetaData.getColumnName( 6 )_"           "_resultSetMetaData.getColumnName( 5 )_"  ",!
  Write "----------------------------------------------",!
  While (resultSet.next()) {
    Write resultSet.getString( 1 )_"   "
    Write resultSet.getString( 3 )_"   "
    Write resultSet.getString( 6 )_"   "
    Write resultSet.getString( 5 )_"   ",!
  }
  Write "----------------------------------------------",!

  Do gateway.%Disconnect()