Question Max Dimukhametov · Mar 21, 2018

Hi all.

I have some problem with getting data from external source (PostgreSQL) via JDBC and load it in DeepSee and I resolved some problems while writing this question :)

So..Below I proved my steps of working:

  1. Created SQL Gateway Connection
  2. Created class for loading data via JDBC
    Connection=##class
    1. In 2 line I got exception (not saved it) and I exclusive this option
  3. Next I Created projections via SQL wizard and now all tables stored in Cache and I get needed data via  ##class(%ResultSet.SQL).%Prepare()
  4. After that I create model (StudentRating) in sequence by result set
7
0 597