How can I use my own custom table instead of user_ table in liferay?

[Tanaji M. Londhe, modificado 11 Anos atrás.]

I want to create my own table for user_ table (which is liferay created automatically).
Here I want to store all inforamation of user_ table into my custom created table.

[srikanth a, modificado 11 Anos atrás.]

Hi Tanaji,
Is there any specific reason for you to store the information into the custom table?
Do you want to rename the table name?
Do you want to add more fields into it?

If you can share more details then it will be easy to analyze it.

regards
Sri

[Tanaji M. Londhe, modificado 11 Anos atrás.]

Hi Srikanth,
Thanks for reply.
To add more information into automatically created table we can use Liferay Expando.
Here we want to remove unnecessary fields from the table.
How can i remove unnecessary fields from the table.

[Hitoshi Ozawa, modificado 11 Anos atrás.]

It's not too wise to delete columns from default liferay tables because you'll have to modifiy corresponding programs as well.

That said, just modify liferay's service.xml file and rebuild services and wsdd. As I said above, you'll have to modify program codes
to make liferay build properly.

[Tanaji M. Londhe, modificado 11 Anos atrás.]

Where I can get all service.xml which is related to tables which is liferay created automatically. I searched in /liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23 but not getting.
Is there any way so i can connect to my custom tables which is not present in liferay tables.
I know the concept of Service Builder using that you can tables, interfaces, services ...etc

[srikanth a, modificado 11 Anos atrás.]

Hi Tanaji,
It is not advisable to change the tables because of the problems which may arise in the java classes.

Where I can get all service.xml which is related to tables which is liferay created automatically. I searched in /liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23 but not getting.
>>>> You find this service xml in the portal source under portal. You modify it and rebuild it.

Is there any way so i can connect to my custom tables which is not present in liferay tables. >>> i didn't get this statement.


regards
Sri

[Tanaji M. Londhe, modificado 11 Anos atrás.]

Ok. But how can i add my custom tables into liferay.

[srikanth a, modificado 11 Anos atrás.]

Hi Tanaji,
You can add your custom tables through service.xml created in you custom portlet application.

regards
Sri

[Tanaji M. Londhe, modificado 11 Anos atrás.]

Hi Srikanth,
I am having company table which is created by liferay and aslo having company table which is my custom.
Here I want to compulsary to manage both the table. So how can i sync both the tables in liferay ?
Custom company table having different columns which is not present in company table of a liferay created.
DB name : portalDB (it contains company table)
DB name : customPortalDB (it contains my new custom company table)

[Raja Nagendra Kumar, modificado 11 Anos atrás.]

Use the API

http://docs.liferay.com/portal/6.1/javadocs/com/liferay/portlet/expando/service/persistence/ExpandoTableUtil.html

Regards,
Nagendra

[Tanaji M. Londhe, modificado 11 Anos atrás.]

Here my custom company table is already created manually. Is it right way to use Expando concept, so it will sync both the tables.

[Raja Nagendra Kumar, modificado 11 Anos atrás.]

Liferay recommends usage of Expando Approach to add new columns to existing tables, so that, it helps in upgrade/migration etc..

It is ok of having created your table.. but you need to write a syncup logic using the hook or expando api's
http://www.liferay.com/web/juan.fernandez/blog/-/blogs/4746086

My recommendation is re-look at your needs by using the expando concepts, so that you don't have to worry about syncup your self.

Regards,
Nagendra

[Tanaji M. Londhe, modificado 11 Anos atrás.]

I have custom database like portalCustomDB which contains table name company.
I want to access that company table into my class for perform some CRUD operations on it. How can I acheive this thing?

[Mani kandan, modificado 11 Anos atrás.]

If you want add more filed in another table take your own code for adding user with the help of UserServiceUtil.addUser();

[Tanaji M. Londhe, modificado 11 Anos atrás.]

No. I am not adding any field into liferay's created database. Here I am using my custom database and also want to use my liferay's created database.
Now I want to access data from custom database into my portlet class.
Here I have created tables manually into my custom database. (I am not using service builder to create custom tables)

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

Google for "service builder external database" and you'll find your answer.

[Tanaji M. Londhe, modificado 11 Anos atrás.]

thnx David.
I go through this post http://bairdblog.wordpress.com/2011/02/11/using-liferay-6-0-x-service-builder-with-external-databases/
same thing i implement.
But now i want to perform some CRUD on my custom table which is present in external Database.
Which way i can go ahead ?

[Mani kandan, modificado 11 Anos atrás.]

You can get data from multiple database using context.xml file.

Or have a look this link, thread

[Tanaji M. Londhe, modificado 11 Anos atrás.]

finally I got a sucess.

[Abdul Kaleem, modificado 10 Anos atrás.]

Tanaji Londhe:

finally I got a sucess.

Hi Tanaji Londhe,

can you tell us the steps of success you got,

how did you make it work,

thanks

[Tanaji Londhe, modificado 10 Anos atrás.]

May I know what is your requirement ?
I have manage Liferay's Company table with my custom Company table using Expando field (used to store custom company id) and perform CRUD operation on it using jdbc.

[Bharamani P Tashildar, modificado 8 Anos atrás.]

Hi all,

How to add data in liferay user_ table?

[Olaf Kock, modificado 8 Anos atrás.]

Bharamani P Tashildar:

How to add data in liferay user_ table?

Crossreferencing the answer in this thread. Please don't resurrect old threads by adding a new question to it.

Short answer: You don't modify Liferay's tables - you don't even look at them.