CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Question How to take cross database computing with Java codes?

    I find two solutions with SQL and esProc on cross database computing, like belows, hope for a Java solution.

    With SQL:
    SELECT salesMan
    FROM (SELECT salesMan,
    row_number() OVER (ORDER BY isrCount DESC) descOrder,
    row_number() OVER (ORDER BY isrCount ASC) ascOrder
    FROM (SELECT salesMan,
    COUNT(*) isrCount
    FROM insurance where salesDate>= ? and salesDate<=?
    GROUP BY salesMan
    WHERE descOrder=1 OR ascOrder=1 ORDER BY descOrder

    With esProc solution,

    A B
    1 $select*from insurance where salesDate>=? And salesDate<=?

    Can anyone give me a solution with Java code?

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Hanover Germany

    Re: How to take cross database computing with Java codes?

    How about using JDBC?
    Victor Nijegorodov

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

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.