RE: creating different different database on each submission of creat_accou

[Jorge Díaz，修改在8 年前。]

I don't understand exactly what do you want to do, as for me it has no sense to create different company with different databases when somebody create a new account, as creating a new database can only be done by a technical user.

At Liferay, you can have different instances (companies) in different databases using sharding, but it is not possible to configure it without stoping liferay and configure portal-ext.properties with new shard. That new shard will be empty.

If you only need to store a new data called "company" for each user, in same database, I think your best option is to use custom fields (aka expando), more info at:

• https://dev.liferay.com/discover/portal/-/knowledge_base/6-2/custom-fields
• https://www.liferay.com/es/community/wiki/-/wiki/Main/Expando

[Shiva Krishna Goud，修改在8 年前。]

it's better to go with custom fields(expando),,because "sharding" concept needs to be configured manually in portal-ext.properties and dependency xml files need to be modified and need to restart the server

[Rakesh Kumar，修改在8 年前。]

hi shiva,

my requirement is creating different instance databases for every submission.
i don't think i can achieve this by using "expando" concept,because it is feature of Liferay that allows users to add custom fields into the database without having to actually manually modify the database.

rakesh

[Manish Yadav，修改在8 年前。]

Rakesh Kumar:

hi shiva,

my requirement is creating different instance databases for every submission.
i don't think i can achieve this by using "expando" concept,because it is feature of Liferay that allows users to add custom fields into the database without having to actually manually modify the database.

rakesh

your requirement is really weird and not good design... but in case you have last option and any how you want to achieve your requirement then try with Java.sql package .. create your own connection object and run sql queries and do whatever you want .. for eg :-
http://www.tutorialspoint.com/jdbc/jdbc-create-database.htm

[Rakesh Kumar，修改在8 年前。]

hi manish,

you mean to say ,i need to use custom sql for achieving my requirement?
does ext plugin is correct method to override the create_account page or i have to choose another method for this??
if i use "Java.sql package" , do i need to create ext plugin or a simple portlet ??
how can i use sql for create_account page.

rakesh

[sricanth arroju，修改在8 年前。]

Why you want to create a new databse each user Registration. yes masnish was suggesting to create a Custom portlet.

Thanks,
Sricanth

[Rakesh Kumar，修改在8 年前。]

hi sricanth,

i want new database because once i will login then i will be having option in navigation bar like (adding employee name ,adding department ,deleting employee name...etc ) so for this purpose i will be using new database and . And this database will be for particular company.Likewise so many instance database has to be created . One more thing is we are not going to add complete registration form details in to instance database(on submit it has to created). for this purpose we will use master database where each and every registered user information will be available.
this instance database ,we will use for dynamic changes like after login i can add ,delete ,update tables in instance database.

regards
rakesh

[Shiva Krishna Goud，修改在8 年前。]

actually this is multi tenancy(sharding) but if u want to create a new instance and map to new schema , liferay will check for below properties in portal-ext.properties and other spring config files while starting the server
shard.selector=com.liferay.portal.dao.shard.ManualShardSelector
shard.available.names=default,one,two,three,four....N

pls check this thread
https://www.liferay.com/community/forums/-/message_boards/message/13660401

[Rakesh Kumar，修改在8 年前。]

My dear friend shiva, this sharding concept is for creating different databases for instances (means for different company websites ).
But here i have to create instance database when i submit the form.

[Jorge Díaz，修改在8 年前。]

Liferay sharding functionality allows configuring more than one database with a single installation but it is not possible to create a new shard without restarting the system

With Liferay, there is no other alternative, so if this functionality does no not cover your requirements, perhaps you should think about changing them, or perhaps using other product.

[Patrick Wolf，修改在8 年前。]

Hi Rakesh, Please let me spell out your requirement so that it is crystal clear. I assume you would like to use Liferay as a multi-tenant platform. Future users interested in your SaaS Liferay solution fill out a form in order to register. Once the form is completed and submitted, a new Liferay instance with its own company name and database schema is automatically created.
You may need to develop a portlet that creates a new Liferay instance from the form that is submitted, but the new user's data will be scattered across Liferay's database. The other possibility would be to create a shard per new submitted forms, then each new instance would have its data separated from the other instances but a restart of Liferay would be necessary after the modification of the liferay-ext.properties file.

[Rakesh Kumar，修改在8 年前。]

hi Patrick ,

thanks for your suggestion.

rakesh

[Rakesh Kumar，修改在8 年前。]

Hi all
It feels good when after a effort i got ..yes, I did !
hurraayyy i got ! before few days it was a pain to me as because so much effort suggestion but all comes in negative
but today i got and it is been executed along with mine team member(3_Member)...i humbly thanks to everyone who supported me/suggestion....
after few days related to this i will postmine blog, stay tuned .

Team-Member

Rakesh-kumarProfile_Liferay

Abhishek-kumarProfile_Liferay

Chennamma-rathodeProfile_Liferay



regards
Rakesh-kumar

[abhishek kumar，修改在8 年前。]

Thanks rakesh ! indeed.....

regards'
Abhishek

[Yuvraj Verma，修改在6 年前。]

Hi Rakesh,

I am also facing same problem i.e. "creating different different database on each submission of creat_accou" Can you please help me out how to solve the same.

you can send the process on my email ID , [e-mail]

Thanks in advance.
Yuvraj Verma
9650106013

[Manish Yadav，修改在6 年前。]

Yuvraj Verma:

Hi Rakesh,

I am also facing same problem i.e. "creating different different database on each submission of creat_accou" Can you please help me out how to solve the same.

you can send the process on my email ID , [e-mail]

Thanks in advance.
Yuvraj Verma
9650106013

Why you want to create different database for each user ?Its really weird requirement