Suoritettu

Multiple SQL DB connection (100 DBs) in Spring boot application using JDBC Template

**While replying please mention your approach to solve this problem**

Here is my scenario,

DB1: jdbc:informix://localhost:9090/test1

DB2: jdbc:informix://localhost:9090/test2

.

.

DB2: jdbc:informix://localhost:9090/test100

Every HTTP request from user has an associated ID.

Once the end point is called I have to read the ID and connect to the respective Database. For example: if ID=1 then I have to connect to DB1, if ID=2 then DB2.

Solution looking for is:

1) Efficient way to do it

2) Less application overhead

3) 1000+ users a day

I researched: Spring Multi tenancy architecture, and Dynamic data source routing.

I want to know efficient solution and method to do it.

Here is my scenario,

DB1: jdbc:postgresql://localhost:9090/test1

DB2: jdbc:postgresql://localhost:9090/test2

.

.

DB2: jdbc:postgresql://localhost:9090/test100

Every HTTP request from user has an associated ID.

Once the end point is called I have to read the ID and connect to the respective Database. For example: if ID=1 then I have to connect to DB1, if ID=2 then DB2.

Solution looking for is:

1) Efficient way to do it

2) Less application overhead

3) 1000+ users a day

I researched: Spring Multi tenancy architecture, and Dynamic data source routing.

I want to know efficient solution and method to do it.

Here is my scenario,

DB1: jdbc:postgresql://localhost:9090/test1

DB2: jdbc:postgresql://localhost:9090/test2

.

.

DB2: jdbc:postgresql://localhost:9090/test100

Every HTTP request from user has an associated ID.

Once the end point is called I have to read the ID and connect to the respective Database. For example: if ID=1 then I have to connect to DB1, if ID=2 then DB2.

Solution looking for is:

1) Efficient way to do it

2) Less application overhead

3) 1000+ users a day

I researched: Spring Multi tenancy architecture, and Dynamic data source routing.

I want to know efficient solution and method to do it.

Taidot: Tietokannan hallinto, J2EE, Java, Java Spring, MySQL

Näytä lisää: sql 2005 connection string adodbconnection providersqloledb, sql 2000 connection asp, configure sql server connection primavera installation, spring boot jdbc, spring boot multiple mysql datasource, multiple database connections hibernate spring, spring boot multiple datasource configuration example, spring boot 2.0 multiple data sources, spring boot jpa multiple databases, spring boot multiple data sources jdbctemplate example, configure multiple datasources in spring, project management, english, java, mysql, database administration, database programming, spring, associated trusted sql server connection blackberry unite, liferay jboss sql server connection

Tietoa työnantajasta:
( 0 arvostelua ) Concord, United States

Projektin tunnus: #19267666

Myönnetty käyttäjälle:

meetravig

Hi there, I read and understood your requirement that you want to connect to different databases in Spring based on the user request. I am very good at Spring programming and worked with Multi-Tenancy application Lisää

$300 USD 5 päivässä
(24 Arvostelua)
4.1

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

suju8811

Hello, I am very interested in your job. I am very familiar with Java Spring and Multi tendent(SAAS) system master. I already implemented such a system in my project. With my skills and experience, I can satisfy y Lisää

$200 USD 3 päivässä
(68 arvostelua)
7.5
zameerfaiz

Greetings, I hereby offer my services to configure your application to use multiple databases in an efficient manner. I am expert java developer with hands on experience on spring and spring boot. I have gone throug Lisää

$500 USD 5 päivässä
(23 arvostelua)
6.6
shiningdevelopor

I have been working as a full stack web developer for over 5 years. I am highly skilled in Web and App so I feel confident that I can do your job without fail. I can start working right now and I will guarantee the q Lisää

$155 USD 3 päivässä
(47 arvostelua)
6.1
YuriyStepanovich

Hello, I am good java developer. I have many experiences with jdbc. I can do your project. Please contact me to finish your project. Thank you.

$555 USD 3 päivässä
(3 arvostelua)
5.5
JwL1013

Hi Client I am an expert with java spring. [login to view URL] Here is my github account. If possible to come on chat, please contact me. Thank you.

$200 USD 3 päivässä
(8 arvostelua)
4.5
MaZheng225

Dear, client. I am a senior Java Spring & JDBC expert with over 3 years of rich experineces. It is my main skill. If you want, I can add liquibase and Audit log. I am ready to begin immediately and if you hire me, Lisää

$155 USD 3 päivässä
(13 arvostelua)
4.7
goldsea808

hello,how are you.i read your bid carefully. i am java/javafx expert and have full experience for 12 years. java/javafx is my top skill and passision. i can provide most quality and high speed. if you want to succe Lisää

$150 USD 3 päivässä
(8 arvostelua)
4.4
phantom1222

Dear sir. I have read your description with great interest. I have experiences with lots of project. Also I am able to finish the task in time. If you send me a message, we can discuss more. I am waiting for yo Lisää

$300 USD 3 päivässä
(6 arvostelua)
3.8
tanishasharma

Hi How are you? As a 10+yrs exp developer, I understand your project best and can deliver solution according to need. Our recent, project- E-commerce platform,with custom CMS [login to view URL] A p Lisää

$155 USD 3 päivässä
(3 arvostelua)
2.6
bluestar1027

Hi Dear. Don't worry for your project, i can do your project completely. Because of i'm dedicated and created developer for project and love to develop for you. if you don't satisfy my result, i will return your mon Lisää

$155 USD 3 päivässä
(3 arvostelua)
2.3
waseemsaleemg

Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we’re Micros Lisää

$144 USD 3 päivässä
(1 arvostelu)
1.7
amirmujtaba92786

Hi, I am really interested in this job. Client satisfaction is my top priority... I HAVE EXPERIENCE IN MULTITANANCY with same concept as YOUR REQUIREMENT. I am experienced Full Stack Developer having profession Lisää

$250 USD 7 päivässä
(0 arvostelua)
0.0
Swapnilja

Hello ***** We provides dedicate developers and Development and design services as well. ***** We are having a great team of Mobile developers with 7-8 years of experience in their field, we work with fully enthusi Lisää

$155 USD 3 päivässä
(0 arvostelua)
0.0
jagadeshraj05

As per your requirement, it is easy to be done with Hikari Connection pool with JDBC template in spring. In that we can create and destroy many connections for respective database names. As you have asked we can cre Lisää

$166 USD 3 päivässä
(0 arvostelua)
0.0
msbhosale97

Hello, there ! I have read your requirements. I am interested in your project. Feel free to contact Thanks and Regards

$166 USD 5 päivässä
(0 arvostelua)
0.0
harikulkarni31

DB1: jdbc:informix://localhost:9090/test1 As this is Id I can read the Path param from the URL and get the exact ID and connect to the database efficiently.

$277 USD 4 päivässä
(0 arvostelua)
0.0