×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Jobs

Retreiving data from another db.

Retreiving data from another db.

Retreiving data from another db.

(OP)
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.

Hello..

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.

rr.abdulhamid@spijkenisse.nl

RE: Retreiving data from another db.

(OP)
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.

Alex

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.

     agpdata1.setDataSource("dsoISQL");
     agpdata1.invokeQuery(hshQueryInfo);
            
      
      boolean bINSITE = agpdata1.gotoFirst();            

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

                {
                    
                    objRecord3  = agpdata1.getProperty(i);
                    vctRecords3.addElement(objRecord3);                                
                }                
                                        
                    bINSITE = agpdata1.gotoNext();

            }


            vctRecords3.toArray();            
    
            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");    
        
            view1.setDataProvider(rowCursor2);



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