Package com.esri.gpt.framework.sql

Examples of com.esri.gpt.framework.sql.ManagedConnection


    }
    sbSql.append(" ORDER BY ");
    sbSql.append(sOrderByColumn).append(" ").append(sOrderByDir);

    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();
   
    // prepare the statements
    int n = 0;
    st = con.prepareStatement(sbSql.toString());
    stCount = con.prepareStatement(sbCount.toString());
View Full Code Here


          .getParameter("geoportalPassword")));
      parameters.put("serviceUrl", chkStr(request.getParameter("serviceUrl")));
      parameters.put("context", context);


      ManagedConnection mc = returnConnection(context);
      Connection toConn = mc.getJdbcConnection();
      boolean autoCommit = toConn.getAutoCommit();
      toConn.setAutoCommit(false);
      fromConn = fromDbRef.openConnection();
      /*
       * IClobMutator toCM = mc.getClobMutator(); parameters.put("toCM", toCM);
View Full Code Here

*/
public void ensureReferenceToRemoteUser(User user)
  throws IdentityException, SQLException {
 
  // establish the connection
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();
 
  // if the local id has not been set,
  //   query for an existing reference,
  //   if none was found
  //     insert a new reference
View Full Code Here

* @throws SQLException if a database exception occurs
*/
private String readValueByUserId(String field, int userId)
  throws SQLException {
  String sValue = "";
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();
  PreparedStatement st = null;
  try {   
    String sSql = "SELECT "+field+" FROM "+getUserTableName()+" WHERE USERID=?";
    logExpression(sSql);
    st = con.prepareStatement(sSql);
View Full Code Here

    throw new ImsServiceException("DeleteRecordsRequest: not authorized.");
  }

  PreparedStatement st = null;
  // establish the connection
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();

  DatabaseMetaData dmt = con.getMetaData();
  String database = dmt.getDatabaseProductName().toLowerCase();
 
  boolean autoCommit = con.getAutoCommit();
View Full Code Here

  PreparedStatement st = null;

  try {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    StringBuilder sbSql = new StringBuilder();
    sbSql.append("UPDATE ").append(getResourceTableName()).append(" ");
    sbSql.append(" SET OWNER=? ");
View Full Code Here

  try
    docUuid = Val.chkStr(docUuid);
    if (docUuid.length() > 0) {
      String sSql = "SELECT XML FROM "+getResourceDataTableName()+" WHERE DOCUUID=?";
      logExpression(sSql);
      ManagedConnection mc = returnConnection();
      Connection con = mc.getJdbcConnection();
      IClobMutator cm = mc.getClobMutator();
      st = con.prepareStatement(sSql);
      st.setString(1,docUuid);
      ResultSet rs = st.executeQuery();
      if (rs.next()) {
        return Val.chkStr(cm.get(rs,1));
View Full Code Here

  PreparedStatement st = null;

  try {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    StringBuilder sbSql = new StringBuilder();
    sbSql.append("UPDATE ").append(getResourceTableName()).append(" ");
    sbSql.append(" SET ACL=? ");
View Full Code Here

 
  PreparedStatement st = null;

  try {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    StringBuilder sbSql = new StringBuilder();
    sbSql.append("UPDATE ").append(getResourceTableName()).append(" ");
    sbSql.append(" SET APPROVALSTATUS=? ");
View Full Code Here

  try {
   
    HrRecord hr = getRepository();

    // establish the connection
    ManagedConnection mc = returnConnection();
    con = mc.getJdbcConnection();
    autoCommit = con.getAutoCommit();
    con.setAutoCommit(false);

    String sql = "";
    boolean isUpdate = false;
View Full Code Here

TOP

Related Classes of com.esri.gpt.framework.sql.ManagedConnection

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.