Member Avatar for ramya_bugbuster

hi friends..
i'm studying mca(5th sem)..
this sem we've a middleware project which connects 3 different databases..
yet now i used only one database.. so i dont know how to give datbase link..
i've googled.. but none has explain that clearly(not upto my satisfaction)!!

can anyone give an idea how to do this?
my project title is car subparts manufacturing company..
it has 3 branches.. each branch maintains different databases (Oracle 10g,Ms SQL server2005,DB2)..

i've to connect these all(without using LAN connection)...

pls explain me how to achieve this.... ur replies are welcomed..

Thank You.............................

  • 2 Contributors
  • 2 Replies
  • 124 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by ramya_bugbuster

Dani AI

Generated

asked how to connect three heterogeneous branch databases (Oracle 10g, SQL Server 2005, DB2) in a middleware project; 's reply added no technical help. Below is a concise, practical plan and checklist suitable for a student middleware project that must work across the Internet (not on a LAN).

A recommended architecture is a middleware application layer that talks to each branch through an adapter: either a central middleware that holds drivers and connects to each DB, or small branch-side services (REST/HTTP) that expose only needed operations. Branch-side services are safer because they avoid opening DB ports to the public Internet; central middleware is simpler for a class project if connections are made over secure channels (VPN/SSH/SSL). Avoid exposing raw DB ports without encryption and strict firewall rules.

Driver-level connection examples (JDBC patterns — replace host/port/DB with real values and include appropriate driver JARs):

Oracle (SID):  jdbc:oracle:thin:@host:1521:ORCL
Driver class:  oracle.jdbc.OracleDriver

SQL Server:    jdbc:sqlserver://host:1433;databaseName=MyDB
Driver class:  com.microsoft.sqlserver.jdbc.SQLServerDriver

DB2:           jdbc:db2://host:50000/MYDB
Driver class:  com.ibm.db2.jcc.DB2Driver

Key practical points and troubleshooting checklist:

  • Start by documenting required operations and a canonical data model (parts, inventory, orders). Build an adapter per DB that maps local schema to the canonical model.
  • Use connection pooling (HikariCP/DBCP) and store credentials securely (keystore or server-side config).
  • Do not rely on distributed two-phase commits across the public Internet; prefer eventual consistency via an asynchronous message queue (RabbitMQ/IBM MQ) or compensating transactions.
  • Test network reachability (telnet/nc to host:port), verify listener processes, confirm driver versions and JDBC URLs, check user privileges, and inspect DB logs when connections fail.
  • Secure transport with VPN/SSL/SSH tunnels and log all access for debugging.

This approach produces a clear design (sequence diagrams, adapter interfaces, security notes) suitable for assessment and avoids risky exposure of production DBs.

Recommended Answers

All 2 Replies

Member Avatar for jwenting

do your own research.
Either you're too stupid to understand the information you find (in which case you should fail the assignment) or you're too lazy (in which case you should fail as well).

Member Avatar for ramya_bugbuster

do your own research.
Either you're too stupid to understand the information you find (in which case you should fail the assignment) or you're too lazy (in which case you should fail as well).

thanks for ur kind reply..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.