/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 6779

     			serialNumber=conn.getCheckOutSerialNumber();
     			pstmt = conn.prepareStatement(
     				"SELECT * FROM xml_access " +
     				"WHERE docid = ? " +
     				"WHERE guid = ? " +
     				"AND principal_name = ? " +
     				"AND permission = ? " +
     				"AND perm_type = ? " +
-...
     			// check out DBConnection
     			conn = DBConnectionPool.getDBConnection("AccessControlList.isOwned");
     			serialNumber = conn.getCheckOutSerialNumber();
     			pstmt = conn.prepareStatement("SELECT 'x' FROM xml_documents "
     					+ "WHERE docid = ? " + "AND user_owner = ?");
     			String query =
     				"SELECT id.guid FROM xml_documents xd, identifier id "
     				+ "WHERE xd.docid = id.docid " +
     						"AND xd.rev = id.rev " +
     						"AND id.guid = ? " +
     						"AND user_owner = ? ";
     			pstmt = conn.prepareStatement(query );
     			pstmt.setString(1, _guid);
     			pstmt.setString(2, user);
     			pstmt.execute();

Also available in: Unified diff