User Profile

Collapse

Profile Sidebar

Collapse
meru
meru
Last Activity: Jul 26 '07, 04:46 AM
Joined: Jun 21 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • meru
    replied to Protocol violation, Bigger than maximum error
    in Java
    Its the very basics to go through stack trace and trying to find out what error it is before posting it in a forum.

    This works perfectly well from weblogic domain in my local system but fails in the weblogic domain on the actual application machine... I read about some drivers issue related to Oracle 10g and wanted to know if anybody in here had faced something like that....
    See more | Go to post

    Leave a comment:


  • meru
    started a topic Protocol violation, Bigger than maximum error
    in Java

    Protocol violation, Bigger than maximum error

    Hi

    The highlighted below is the sample code I used for calling my stored procedure.

    Callable statement cstmt = conn.prepareCal l( BEGIN STOREDPROCNAME( ?,?,?);END;);
    ArrayDescriptor arrayDescriptor = new ArrayDescriptor (Name of type,cstmt.getC onnection());
    ARRAY acctList = new ARRAY(arrayDesc riptor,conn, flrList.toArray ());

    cstmt.setInt(1, 10);
    ...
    See more | Go to post

  • meru
    started a topic Class cast exception
    in Java

    Class cast exception

    The following is a piece of code to calla stored procedure in oracle from java

    ArrayList arrList = new ArrayList();
    arrList.add(new Integer("10"));
    arrList.add(new Integer("7"));
    cstmt = conn.prepareCal l("BEGIN PRM_SMART_FIXTU RE_SEQ1(?,?,?); END;");

    ArrayDescriptor arrayDescriptor = new ArrayDescriptor (
    "FLOORPLAN_LABE L_LIST",...
    See more | Go to post

  • meru
    started a topic SIMPLE but SLOW SELECT query!!!
    in DB2

    SIMPLE but SLOW SELECT query!!!

    Hi,

    I have the following query which is running very slow

    SELECT D.STORE_FACILIT Y_ID,D.PRIMARY_ ACCT_NUM FROM DS_STORE D
    WHERE D.PRIMARY_ACCT_ NUM IN(SELECT W.COMPONENT1_ID FROM WK_FILTER_CMPNT W
    WHERE W.COMPONENT1_ID = 1)FOR FETCH ONLY

    can anyone help?
    See more | Go to post
No activity results to display
Show More
Working...