How to obtain name of document inside the Java class from database

vsoman1984

Hi All,

I had through the help from the community accessed the id of the documents from inside the databse.The following is the code.

DfId dfId =new DfId(objectIdString); if (dfId.isObjectId())

{ System.out.println("Successfully fetched id " + dfId); }

IDfSysObject sysObj = (IDfSysObject) mySession.getObject(dfId);

System.

out.println("Content Type ++++++ " + sysObj.getContentType());

The sysObj.getContentType() provides the content type of the object.

My next task is to obtain the actual file name of the content i.e. object_name so that i can pass the actual file name like "MyDoc.doc" to a function.Could you please help me to achieve this goal.Thank You

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

dnvhariprasad

Since you already have sysobject in hand, you can use that sysobject to get the name of the document

Use the following

IDfSysObject sysObj = (IDfSysObject) mySession.getObject(dfId);

String objName = sysObj.getObjectName()

All comments

vsoman1984

Is JDBC connectivity a possible solution? Can i directly query the tables sysobject_s to obtain the values in the field object_name.

My code which requires the name of the documents is as follows:

File temp = File.createTempFile("TestZipDocumentum", ".zip");

temp.deleteOnExit();ZipOutputStream out =new ZipOutputStream(new FileOutputStream(temp)); Iterator iter =m_docIdLookup.entrySet().iterator(); while (iter.hasNext()) { Map.Entry pairs = (Map.Entry) iter.next();

String value = (String) pairs.getValue();

inOnclick = getContent(m_sessionManager, reponame, value); out.putNextEntry(new ZipEntry("Temp" + value + ".txt")); out.write(inOnclick, 0, inOnclick.length); out.closeEntry();

}

out.close();

zipbytearray = getBytesFromFile(temp);

The line in red contains the area for the name of the files which will be contained inside the temporary zip file i will create. Currently i am hardcoding the name Temp and extention .txt and providing the objectid to uniquely identify the files.How can i replace all this by the file name as it is seen in the database like"MyDoc.doc".

Hope u will help with your guidance. Awaiting ur reply.

Thank You

vsoman1984

Hi All,

I have obtained a solution to my requirement .Would like to share it so that you may confirm it whether its a valid option and also it may help others in need of similar output.

The usage of DQL helped me in achieving the output as follows:

File temp = File.createTempFile("TestZipDocumentum", ".zip"); temp.deleteOnExit();ZipOutputStream out =new ZipOutputStream(new FileOutputStream(temp)); Iterator iter =m_docIdLookup.entrySet().iterator(); while (iter.hasNext()) { Map.Entry pairs = (Map.Entry) iter.next();

String value = (String) pairs.getValue();

inOnclick = getContent(m_sessionManager, reponame, value); String strQuery ="SELECT object_name FROM dm_sysobject WHERE r_object_id = '" + value +"'"; IDfCollection iCollection =null; DfQuery query =new DfQuery(); String docname =null; query.setDQL(strQuery);

iCollection= query.execute( getDfSession(), DfQuery.DF_QUERY ); while( iCollection.next() ) {

List row =new ArrayList();

for( int i = 0; i < iCollection.getAttrCount(); i++ ){

docname = iCollection.getValueAt( i ).toString();

System.out.println("This is name of doc for selected id " + docname); }

}

out.putNextEntry(new ZipEntry(docname)); out.write(inOnclick, 0, inOnclick.length); out.closeEntry();

}

out.close();

zipbytearray = getBytesFromFile(temp)

As a result i am able to obtain the names of the selected documents.

Thank You

Regards

Vishnu S

dnvhariprasad

Since you already have sysobject in hand, you can use that sysobject to get the name of the document

Use the following

IDfSysObject sysObj = (IDfSysObject) mySession.getObject(dfId);

String objName = sysObj.getObjectName()

vsoman1984

Thank You Hari

This is the simple method i was seeking for which i had to take the longer route .

Thanks again

Regards