livesite data access custom datasource

sano

Hi All,

I am working with TeamSite 7.2.1 on Windows server 2003.

We are trying to figure out how to extend Livesite data access(e.g. com.interwoven.livesite.hibernate.dao.impl.BaseHibernateDataAccessObject) to retrieve data from external component.

The problem is by default the db datasource is come form the database.properties under ..\livesite_customer_src\etc\conf\livesite_customer\.

But if we want to get data from other custom database, how to implement this?

Guess we need to define custom bean in the customer_resource_config.xml, not sure is this the correct way, and if yes later how to use this in the java external class? Is there any example can refer to?

kindly advise, thanks

sano

After find some thread, i find the approach as below:

Define pool declaration in ..\livesite_customer\etc\conf\livesite_customer\resources\customer-resource-config.xml like

[html]





[/html]

then inside the external class using

Connection conn=RequestUtils.getConnection("pool_tp");
DataAccessObject dao = RequestUtils.getDaoFactory().getInstance(TestObject.class);
return dao.findAll();

but the result always 0.

Is there anything wrong here? Of course, the TestObject.hbm.xml has been created in the orm folder and some records have been created in the DB.


thanks