Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Retreiving data from another db.

Retreiving data from another db.

Retreiving data from another db.

I am trying to pull data from another db and it is of the long type (in oracle).  Whenever I pull in data from more than one long type my app freezes.  How can i pull data from multiple long type fields?  Do I have to convert the type of field before i pull the data and if so how?  I am using a business object to run my query.

RE: Retreiving data from another db.


If you don't mind i want to see the code where you pull them in.
Not the BO.
If there is now error in it it my be your BO. I can send you mime.


RE: Retreiving data from another db.

In my code I have a select statement like this "SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM TABLE@DBLINK WHERE FIELD1 = 1".  Field 1 is a varchar2 and Field 2 through Field 4 are long.  When I run this query it just hangs.  I am invoking this query through the BO.  All seems to work fine if I only query with Field1 and 2, but I need to import all of the data.  Thanks for the help.


RE: Retreiving data from another db.

Do you bind the data to a dataview ???
if so try this.

in your general put :
final static COLUMNNAMES[] = {"FIELD1","FIELD2","FIELD3"}
as many fields you are retrieving.

Bind the results to your dataview and see i it works.
If you allready done this let my know...

something like this.

      boolean bINSITE = agpdata1.gotoFirst();            

            while (bINSITE  )
              Object objRecord3[] = new Object[2];            
                for (int i = 0; i < objRecord3.length; i++)

                    objRecord3  = agpdata1.getProperty(i);
                    bINSITE = agpdata1.gotoNext();


            AgoTreeDataManager treeData = new AgoTreeDataManager(vctRecords3, COLUMN_NAMES3);
            AgiRowCursor rowCursor2 = treeData.getRootRowCursor();
            agDataMgr.bind(Label2, "Text", "getText", "setText", rowCursor2, "l1");    
            agDataMgr.bind(Label3, "Text", "getText", "setText", rowCursor2, "l2");    
            agDataMgr.bind(Label4, "Text", "getText", "setText", rowCursor2, "l3");    

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close