Find Jobs
Hire Freelancers

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

$30-250 USD

Suoritettu
Julkaistu lähes 5 vuotta sitten

$30-250 USD

Maksettu toimituksen yhteydessä
**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.
Projektin tunnus (ID): 19267666

Tietoa projektista

10 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
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 applications and I can deliver your project to your satisfaction. I would prefer Multi-tenancy than the Dynamic data source routing. When the user request comes, based on the id, the right connection will be picked up. Let us connect and discuss this further to take it forward. The bid may change upon a clear understanding of the project.
$300 USD 5 päivässä
5,0 (27 arvostelua)
4,5
4,5
10 freelancerit tarjoavat keskimäärin $232 USD tätä projektia
Käyttäjän avatar
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 you fully. Please hire me. Looking forward to hear from you. Thank you. Regards!
$200 USD 3 päivässä
5,0 (78 arvostelua)
7,7
7,7
Käyttäjän avatar
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 through the attached document and am confident enough to deliver this requirement. Can you please spare some time to discuss more details. Looking forward to discuss your requirements in detail. Best Regards.
$500 USD 5 päivässä
4,8 (27 arvostelua)
6,9
6,9
Käyttäjän avatar
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 quality of code and keep the timeline as well. If you are willing to work with me, please contact me. Regards.
$155 USD 3 päivässä
4,9 (50 arvostelua)
6,2
6,2
Käyttäjän avatar
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 success, please contact me. Then, I will give you good result. hire me.
$150 USD 3 päivässä
4,8 (8 arvostelua)
4,4
4,4
Käyttäjän avatar
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 professional skills in Angular 6/7 (Social Authentication, Location map etc) HTML, CSS, Bootstrap Java, Springboot, Hibernate, JPA, REST API Oracle, MySQL, PostgreSQL GitHub, GitLab, AWS (EC2, RDS, S3) etc. I've worked on financial project for a loan providing organization having about more than 5 Lac clients. Also have worked for Rescue Services providing department It will be a great opportunity for me work on your project. Just inbox for more details and discussion, thank you. Best regards Amir
$250 USD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 create an endpoint which provides database name and we can create a new connection using database credentials (But you did not mention what to do by creating connection. If mentioned it would be more clarity to provide you the full application itself - spring boot). I have already done this for my own application. It will be easy for me to do with good quality.
$166 USD 3 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED STATES lippu
Concord, United States
5,0
2
Maksutapa vahvistettu
Liittynyt huhtik. 12, 2019

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.