Tamamlanmış

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.

Beceriler: Veri Tabanı Yönetimi, J2EE, Java, Java Spring, MySQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Concord, United States

Proje NO: #19267666

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 300%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(24 Değerlendirme)
4.1

Bu iş için 17 freelancer ortalamada $234 teklif veriyor

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 Daha Fazla

$200 USD in 3 gün içinde
(68 Değerlendirme)
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 Daha Fazla

$500 USD in 5 gün içinde
(23 Değerlendirme)
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 Daha Fazla

$155 USD in 3 gün içinde
(47 Değerlendirme)
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 in 3 gün içinde
(3 Değerlendirme)
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 in 3 gün içinde
(8 Değerlendirme)
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, Daha Fazla

$155 USD in 3 gün içinde
(13 Değerlendirme)
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 Daha Fazla

$150 USD in 3 gün içinde
(8 Değerlendirme)
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 Daha Fazla

$300 USD in 3 gün içinde
(6 Değerlendirme)
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 Daha Fazla

$155 USD in 3 gün içinde
(3 Değerlendirme)
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 Daha Fazla

$155 USD in 3 gün içinde
(3 Değerlendirme)
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 Daha Fazla

$144 USD in 3 gün içinde
(1 Yorum)
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 Daha Fazla

$250 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$166 USD in 3 gün içinde
(0 Değerlendirme)
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 in 5 gün içinde
(0 Değerlendirme)
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 in 4 gün içinde
(0 Değerlendirme)
0.0