How to connect with database without service builder

[ramakanth reddy, modificado 11 Anos atrás.]

Hi

I need to connect to database in life-ray 6.1 without need of service builder,i need to connect to DB with Spring+hibernate configuration ,can anyone help me how to achieve this.

Regards
Ramakanth

[Manish Yadav, modificado 11 Anos atrás.]

Hello Ramakanth,
I recommend Portlet In Action book.You can get Step by step tutorial of Portlet Spring MVC with hibernate and using Spring DAO. Each chapter have example source code written in Spring MVC and with both build tools maven and ANT.

Read Chapter 7-8 for spring DAO and Hibernate.

you can download source code of Each chapter from below link
www.manning.com/sarin/PiA_sourcecode.zip

[ramakanth reddy, modificado 11 Anos atrás.]

Hi Manish

Thanks for your reply ,it helped me a lot and resolved my problem.

One more question,in my application i have ten portlets,can i have single spring and hibernate configuration file for ten portlets.if yes,how can achieve this.please guide me regarding this.

[Manish Yadav, modificado 11 Anos atrás.]

Dear Ramakanth,

You can create spring or Hibernate project and write all connection and your CRUD operations then create jar of that project and copy that jar into tomcat lib or your server lib.so you can access same connection in your complete application.

Thanks & Regards
Manish Yadav
Email:- [e-mail]
Contact No:- [phone]

[David H Nebinger, modificado 11 Anos atrás.]

Note that unless you are using a JNDI data source, your 10 portlets will each have their own connection (possibly connection pool) to the database, dramatically increasing the resource consumption on your portal.

[ramakanth reddy, modificado 10 Anos atrás.]

David H Nebinger:

Note that unless you are using a JNDI data source, your 10 portlets will each have their own connection (possibly connection pool) to the database, dramatically increasing the resource consumption on your portal.

Hi David

Thanks for your reply.

I am having a requirement to connect to database without need of service builder.

Does Liferay provides a way to achieve this without writing external code.

Bcoz if write a code to connect database with hibernate still there will be two open connections 1.liferay and 2.hibernate.



Regards
Ramakanth