Results 1 to 7 of 7
  1. #1
    cyrodjohn is offline Member
    Join Date
    Feb 2010
    Posts
    4
    Rep Power
    0

    Question Making a connection between multiple databases

    I'm using JAVA DB (derby)

    I want to import a public view of my data to another database (also in java db).

    I want to pass this data and save in to the other database. I'm having trouble since the general rule is one connection to one database.

    Help would be much appreciated.

  2. #2
    FON
    FON is offline Senior Member
    Join Date
    Dec 2009
    Location
    Belgrade, Serbia
    Posts
    366
    Rep Power
    6

    Default

    Does this have to be done in real time in your java code
    or u can use some tools or some simple *.csv files import/export to get this done once?

  3. #3
    cyrodjohn is offline Member
    Join Date
    Feb 2010
    Posts
    4
    Rep Power
    0

    Default

    Hey thanks for replying: This has to be done real time.

  4. #4
    cyrodjohn is offline Member
    Join Date
    Feb 2010
    Posts
    4
    Rep Power
    0

    Default

    Hey thanks for replying: This has to be done real time.

  5. #5
    FON
    FON is offline Senior Member
    Join Date
    Dec 2009
    Location
    Belgrade, Serbia
    Posts
    366
    Rep Power
    6

    Default

    Quote Originally Posted by cyrodjohn View Post

    ...since the general rule is one connection to one database....
    And if you create 2 connections to both databases...?

  6. #6
    cyrodjohn is offline Member
    Join Date
    Feb 2010
    Posts
    4
    Rep Power
    0

    Default

    It throws an exception. We are working on a big project involving many databases. I need to access the data from the other database (public view) and then send it to the other database.

    What topic should i read to help me solve this problem?

  7. #7
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

Similar Threads

  1. Facing problem in making connection to mail server
    By Basit56 in forum New To Java
    Replies: 2
    Last Post: 01-22-2010, 07:27 PM
  2. Interface to connect multiple databases
    By sruz in forum Advanced Java
    Replies: 1
    Last Post: 11-04-2009, 04:20 PM
  3. multiple users with single connection
    By nishi.kishore in forum Java Servlet
    Replies: 3
    Last Post: 09-06-2009, 04:15 PM
  4. Hibernate with multiple databases
    By dsr0781 in forum JDBC
    Replies: 5
    Last Post: 06-23-2008, 02:06 PM
  5. multiple databases
    By varunthecool in forum JDBC
    Replies: 2
    Last Post: 07-09-2007, 09:06 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •