Constructor Detail

• JdbcConeSearcher

  public JdbcConeSearcher​(java.sql.Connection connection,
                          java.lang.String tableName,
                          java.lang.String raCol,
                          java.lang.String decCol,
                          AngleUnits units,
                          java.lang.String tileCol,
                          SkyTiling tiling,
                          java.lang.String cols,
                          java.lang.String where,
                          boolean bestOnly,
                          boolean prepareSql,
                          boolean closeConnection)
                   throws java.sql.SQLException

  Constructor.

  Parameters:

  connection - live connection to database

  tableName - name of a table in the database to search

  raCol - name of table column containing right ascension

  decCol - name of table column containing declination

  units - angular units used by ra and dec columns

  tileCol - column containing a sky tiling index value, or null

  tiling - tiling scheme used by tileCol column

  cols - list of column names for the SELECT statement

  where - additional WHERE clause constraints

  bestOnly - true iff only the closest match is required (hint)

  prepareSql - whether to use PreparedStatements or not

  closeConnection - whether to close the connection when this object is closed

  Throws:

  java.sql.SQLException

Method Detail

• performSearch

  public uk.ac.starlink.table.StarTable performSearch​(double ra,
                                                      double dec,
                                                      double sr)
                                               throws java.io.IOException

  Description copied from interface: ConeSearcher
  Returns a table consisting of all the objects within a given search radius of a specified point on the sky. If no matching objects are found, then it is preferable to return an empty table with the correct columns. However, if this cannot be done, it is permissible to return null. For every table returned, the columns should be the same.

  Specified by:

  performSearch in interface ConeSearcher

  Parameters:

  ra - right ascension in degrees of search region centre

  dec - declination in degrees of search region centre

  sr - search radius in degrees

  Returns:

  table containing records in the given cone, or possibly null if no records are found

  Throws:

  java.io.IOException

• getRaIndex

  public int getRaIndex​(uk.ac.starlink.table.StarTable result)

  Description copied from interface: ConeSearcher
  Returns the index of a column giving the right ascension in the returned table. This should be the same quantity which is used for the match assessment.

  Specified by:

  getRaIndex in interface ConeSearcher

  Parameters:

  result - table returned by performSearch

  Returns:

  index of RA column, or -1 if it can't be found

• getDecIndex

  public int getDecIndex​(uk.ac.starlink.table.StarTable result)

  Description copied from interface: ConeSearcher
  Returns the index of a column giving the declination in the returned table. This should be the same quantity which is used for the match assessment.

  Specified by:

  getDecIndex in interface ConeSearcher

  Parameters:

  result - table returned by performSearch

  Returns:

  index of dec column, or -1 if it can't be found

• close

  public void close​()

  Closes the connection if requested to.

  Specified by:

  close in interface ConeSearcher