Foros

Inicio » Liferay Portal » English » 3. Development

How to use existing tables of a database in liferay 6.1	sudhansu rana	30 de octubre de 2012 23:12
RE: How to use existing tables of a database in liferay 6.1	Harish Kumar	30 de octubre de 2012 23:44
RE: How to use existing tables of a database in liferay 6.1	sudhansu rana	31 de octubre de 2012 1:01
RE: How to use existing tables of a database in liferay 6.1	Harish Kumar	31 de octubre de 2012 2:43
RE: How to use existing tables of a database in liferay 6.1	Jignesh Vachhani	31 de octubre de 2012 0:11
RE: How to use existing tables of a database in liferay 6.1	Nikhil Nishchal	31 de octubre de 2012 0:27
RE: How to use existing tables of a database in liferay 6.1	sudhansu rana	14 de diciembre de 2012 6:47

How to use existing tables of a database in liferay 6.1

30 de octubre de 2012 23:12

Respuesta

sudhansu rana

Ranking: New Member

Mensajes: 8

Fecha de incorporación: 21 de agosto de 2012

Mensajes recientes

Hi,
I am new to liferay.
I have an existing database and some table names which are fixed and cannot be changed.
They don't follow any Namespace so i cannot use service builder.(like abc and not with namespace PR pr_abc)

Please advice how to use them either in service builder or spring+hibernate.

Thanks
Sudhansu

Autentíquese para votar.

Marcar como inapropiado

RE: How to use existing tables of a database in liferay 6.1

30 de octubre de 2012 23:44

Respuesta

Harish Kumar

Ranking: Regular Member

Mensajes: 227

Fecha de incorporación: 31 de julio de 2010

Mensajes recientes

1http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Connecting+to+Separate+Database+Using+Build-service+in+Plugins+SDK

Autentíquese para votar.

Marcar como inapropiado

Marcar como respuesta

RE: How to use existing tables of a database in liferay 6.1

31 de octubre de 2012 0:11

Respuesta

Jignesh Vachhani

Ranking: Liferay Master

Mensajes: 755

Fecha de incorporación: 10 de marzo de 2008

Mensajes recientes

Hi Sudhansu,
If its compolsary to use separate database then you can follow the link send by Haris.
Otherwise if table value is fixed and won't change anymore, then you can copy those tables in liferay DB and then try with my below approach.

I didn't try with table but i tried with view.
In that i created sql view and then i created service with the same name of view and access the data from that view using service builder only.
But here you need to make sure that entity name should be same as view or table name.
Please try and put your feedback here.

Autentíquese para votar.

Marcar como inapropiado

Marcar como respuesta

RE: How to use existing tables of a database in liferay 6.1

31 de octubre de 2012 0:27

Respuesta

Nikhil Nishchal

Ranking: Junior Member

Mensajes: 74

Fecha de incorporación: 21 de junio de 2012

Mensajes recientes

Hello sudhansu rana,
For Connecting to a Database with Plugins SDK you can use above link given by Harish.
However,
If you existing table is going to use only once while importing data to liferay.
then you can do these steps:
make a portlet in liferay.
in this portlet read data from existing table using JDBC.
And, then using liferayservice add them to liferay as per requirement.

Autentíquese para votar.

Marcar como inapropiado