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
    Posts
    4

    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<=?
    2=insurance.group(salesMan)
    3=A2.sort(~.len())
    4=A3.m([-1,1])
    5=A4.(salesMan)

    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
    Location
    Hanover Germany
    Posts
    20,396

    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
  •  





Click Here to Expand Forum to Full Width

Featured