How to take cross database computing with Java codes?
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

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

  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 online now Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Wallisellen (ZH), Switzerland
    Posts
    17,358

    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
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center