Development Tools Forum

RE: Java Question

Posted By: Link, David A. \(Omaha\)
Date: Tuesday, 22 November 2005, at 5:32 p.m.

Yes you can.

Select * from <dbname1>@<dbserver1>:<table1>
Where column1 not in (select column1 from
<dbname2>@<dbserver2>:<table2>);

You just have to define the connection to dbname1@dbserver1. This is
assuming that dbserver1 and dbserver2 are aware of each other. If both
databases are on the same dbserver you don't need the @<dbserverX> in
the statement.

Make sense?

David

-----Original Message-----
From: Sharp, Kirk (USMS) [mailto:Kirk.Sharp@usdoj.gov]
Sent: Tuesday, November 22, 2005 4:05 PM
To: Link, David A. (Omaha); dev-java@iiug.org
Subject: Java Question

Thanks for your help. I have another question....

Does Java allow queries to mutliple databases using embedded SQL?

For example (Informix embedded SQL):

SELECT * FROM "database_one":comment_type
WHERE comment_type_cd NOT IN (SELECT comment_type_cd
FROM "database_two":comment_type);

If I am allowed to perform this query, how do I set up the connections
in Java?


Any help would be greatly appreciated!



-----Original Message-----
From: Link, David A. (Omaha) [mailto:DALink@west.com]
Sent: Fri 11/18/2005 1:17 PM
To: Sharp, Kirk (USMS)
Cc:
Subject: RE: Informix Enterprise Replication [45]



The transactions will get logged to the logical logs but will
get
flagged not to be replicated. So it will cause you to roll
through
logical logs quickly. But this should not cause you any issues
as long
as you do the commit frequently and have your logical logs sized
appropriately. You cannot turn off logging on a replicated
table.

Does this help?

David

-----Original Message-----
From: Sharp, Kirk (USMS) [mailto:Kirk.Sharp@usdoj.gov]
Sent: Friday, November 18, 2005 12:55 PM
To: Link, David A. (Omaha)
Subject: RE: Informix Enterprise Replication [45]

Hi David

Thank for your prompt and courteous response...

I tried using the "BEGIN WORK WITHOUT REPLICATION" statememnt
and it
works just fine.

Do you know what affect any this will have on logging? Do I need
to turn
of logging?

-----Original Message-----
From: forum.subscriber@iiug.org on behalf of Link,
David....
Sent: Thu 11/17/2005 8:14 AM
To: dev-java@iiug.org
Cc:
Subject: RE: Informix Enterprise Replication [45]



There are several ways to approach this problem.

You can allow replication to handle the deletes for you
on the
target
server. Make sure your transactions are small, commit
frequently.

The other way is to run your deletes on both servers. To
do that
you
will need to issue a "BEGIN WORK WITHOUT REPLICATION"
before
each
transaction. We do this for several of our large servers
where
we do
mass changes. This decreases the amount of traffic which
has to
get
replicated.

Whichever solution you decide to use, make sure your DBA
is in
the loop
so that he is aware of the additional work load.

If you have more questions, I am more than willing to
help.

David Link

-----Original Message-----
From: forum.subscriber@iiug.org
[mailto:forum.subscriber@iiug.org] On
Behalf Of Jean George....
Sent: Thursday, November 17, 2005 3:02 AM
To: dev-java@iiug.org
Subject: RE: Informix Enterprise Replication [43]

I guess your questions are more about replication than
java, you
may
send
the mail to the ids forum, I think that people like
madison will
lovw to
answer you...

good luck...

jgp

> -----Original Message-----
> From: forum.subscriber@iiug.org
> [mailto:forum.subscriber@iiug.org] On Behalf Of KIRK
SHARP
> Sent: Wednesday, November 16, 2005 23:04
> To: dev-java@iiug.org
> Subject: Informix Enterprise Replication [41]
>
> First, let me apoligize if I am posting this message
in the
> wrong group.
>
> I am in the process of writing a Java server
application that
> will perform archiving (remove old data (1-2 million
rows)
> from production DB and load the old data to an archive
DB).
>
> We are using Informix Enterprise Replication to
replicate the
> database on a remote server via a T1 line.
>
> I am unsure how to address the replication issue.
>
> Questions:
>
> Do I need to drop replication in order to perform the
archive
process?
> Do I need to turn of logging as well?
> Are there any existing methods that would allow me to
perform
> the arhcive process with replication and logging
running?
>
> Any help would be greatly appreciated.
>
> Thanks in advance!

Development Tools Forum is maintained by Administrator with WebBBS 5.12.