Metacat

import org.dataone.service.types.v2.MediaType;

import org.dataone.service.types.v2.MediaTypeProperty;

    /*public SystemMetadata asSystemMetadata(Date dateUploaded, String rightsHolder,

    }*/

    /*public Hashtable<String, String> getSystemMetadataInfo(String localId)

    }*/

          "replication_allowed, number_replicas, obsoletes, obsoleted_by, serial_version, archived, series_id, file_name, media_type " +

                String file_name = rs.getString(19);

                String media_type = rs.getString(20);

                if(file_name != null ) {

                    sysMeta.setFileName(file_name);

                }

                if(media_type != null ) {

                    MediaType mediaType = new MediaType();

                    mediaType.setName(media_type);

                    // get media type properties from another table.

                    String mediaTypePropertyQuery = "select name, value from smmediatypeproperties where guid = ?";

                    PreparedStatement stmt2 = dbConn.prepareStatement(mediaTypePropertyQuery);

                    stmt2.setString(1, guid);

                    ResultSet rs2 = stmt2.executeQuery();

                    while (rs2.next()) {

                        String name = rs2.getString(1);

                        String value = rs2.getString(2);

                        MediaTypeProperty property = new MediaTypeProperty();

                        property.setName(name);

                        property.setValue(value);

                        mediaType.addProperty(property);

                    }

                    sysMeta.setMediaType(mediaType);

                    rs2.close();

                    stmt2.close();

                }

        String obsoletedBy, BigInteger serialVersion, String seriesId, 

        String fileName, MediaType mediaType, DBConnection dbConn) throws SQLException  {

        PreparedStatement stmt = null;

        PreparedStatement stmt2 = null;

        try {

            dbConn.setAutoCommit(false);

            // Execute the insert statement

            String query = "update " + TYPE_SYSTEM_METADATA + 

                " set (date_uploaded, rights_holder, checksum, checksum_algorithm, " +

                "origin_member_node, authoritive_member_node, date_modified, " +

                "submitter, object_format, size, archived, replication_allowed, number_replicas, " +

                "obsoletes, obsoleted_by, serial_version, series_id) " +

                "= (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?) where guid = ?";

            stmt = dbConn.prepareStatement(query);

            //data values

            stmt.setTimestamp(1, new java.sql.Timestamp(dateUploaded));

            stmt.setString(2, rightsHolder);

            stmt.setString(3, checksum);

            stmt.setString(4, checksumAlgorithm);

            stmt.setString(5, originMemberNode);

            stmt.setString(6, authoritativeMemberNode);

            stmt.setTimestamp(7, new java.sql.Timestamp(modifiedDate));

            stmt.setString(8, submitter);

            stmt.setString(9, objectFormat);

            stmt.setString(10, size.toString());

            stmt.setBoolean(11, archived);

            stmt.setBoolean(12, replicationAllowed);

            stmt.setInt(13, numberReplicas);

            stmt.setString(14, obsoletes);

            stmt.setString(15, obsoletedBy);

            stmt.setString(16, serialVersion.toString());

            stmt.setString(17, seriesId);

            stmt.setString(18, fileName);

            if (mediaType == null) {

                stmt.setString(19, null);

            } else {

                stmt.setString(19, mediaType.getName());

            }

            //where clause

            stmt.setString(20, guid);

            logMetacat.debug("stmt: " + stmt.toString());

            //execute

            int rows = stmt.executeUpdate();

            //insert media type properties into another table

            if(mediaType != null && mediaType.getPropertyList() != null) {

                String sql2 = "insert into smmediatypeproperties " + 

                        "(guid, name, value) " + "values (?, ?, ?)";

                stmt2 = dbConn.prepareStatement(sql2);

                for(MediaTypeProperty item : mediaType.getPropertyList()) {

                    if(item != null) {

                        String name = item.getName();

                        String value = item.getValue();

                        stmt2.setString(1, guid);

                        stmt2.setString(2, name);

                        stmt2.setString(3, value);

                        logMetacat.debug("insert media type properties query: " + stmt2.toString());

                        int row =stmt2.executeUpdate();

                    }

                }

            }

            dbConn.commit();

            dbConn.setAutoCommit(true);

        } catch (Exception e) {

            dbConn.rollback();

            dbConn.setAutoCommit(true);

            throw new SQLException(e.getMessage());

        } finally {

            if(stmt != null) {

                stmt.close();

            }

            if(stmt2 != null) {

                stmt2.close();

            }

        }

		    sm.getFileName() == null ? null: sm.getFileName(),

		    sm.getMediaType() == null ? null: sm.getMediaType(),

            // remove the smmediatypeproperties

            query = "delete from smmediatypeproperties " + 

                    "where guid = ?";

            stmt = dbConn.prepareStatement(query);

            stmt.setString(1, guid);

            logMetacat.debug("delete smmediatypeproperties: " + stmt.toString());

            rows = stmt.executeUpdate();

            stmt.close();