JDBC Driver for Act-On

Build 20.0.7655

Primary Keys

You can use the getPrimaryKeys method to return information about the primary keys for Act-On tables. You can restrict the results by the table name.

The following code example outputs the column or columns composing the primary key for the Images table:

String connectionString = "jdbc:acton:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:80";

Connection conn = DriverManager.getConnection(connectionString);
ResultSet rs = conn.getMetaData().getPrimaryKeys(null,null,"Images");
while(rs.next()){
  System.out.println(rs.getString("COLUMN_NAME"));
}

The getPrimaryKeys method returns the following columns:

Column NameData TypeDescription
TABLE_CATStringThe table catalog
TABLE_SCHEMStringThe table schema.
TABLE_NAMEStringThe table name.
COLUMN_NAMEStringThe column name.
KEY_SEQshortThe sequence number, or column index starting from 1, within the foreign key.
PK_NAMEStringThe primary key name.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655