User Profile

Collapse

Profile Sidebar

Collapse
izy25
izy25
Last Activity: Apr 20 '07, 06:08 AM
Joined: Jan 31 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • izy25
    replied to ORA-01008: not all variables bound
    in Java
    Commit is not required because we got only one sql statment. If we have more sql INSERT, DELETE,.., a method commit confirm the whole transaction....
    See more | Go to post

    Leave a comment:


  • izy25
    replied to ORA-01008: not all variables bound
    in Java
    Now I figure out what was wrong:

    while (xmlStreamReade r.hasNext()) {

    li_count++;
    int eventCode = xmlStreamReader .next();
    switch (eventCode) {
    case XMLStreamConsta nts.START_ELEME NT :
    if ((xmlStreamRead er.getLocalName ()=="Error") && (xmlStreamReade r.getAttributeC ount()>0))
    ls_description = xmlStreamReader .getAttributeVa lue(0);...
    See more | Go to post

    Leave a comment:


  • izy25
    replied to ORA-01008: not all variables bound
    in Java
    Even If put lprepstmPhonebo okError.execute Update(ls_sql); after
    ...
    case XMLStreamConsta nts.END_ELEMENT :

    lprepstmPhonebo okError.setInt (1, li_phone_book_i d);
    lprepstmPhonebo okError.setStri ng (2, ls_description) ;
    lprepstmPhonebo okError.execute Update(ls_sql);

    is stil not working. Result of this code:
    2007-01-31 11:49:17,857 INFO...
    See more | Go to post

    Leave a comment:


  • izy25
    replied to ORA-01008: not all variables bound
    in Java
    I think so....
    See more | Go to post

    Leave a comment:


  • izy25
    started a topic ORA-01008: not all variables bound
    in Java

    ORA-01008: not all variables bound

    I'm trying to INSERT datas from XML file into table. I'dont know what is wrong with code below that I don't insert datas into the table. Please help


    String ls_sql;
    Integer li_phonebook_id = null;
    String ls_description = null;
    int li_count = 0;
    Connection lconnPhonebookE rror...
    See more | Go to post
No activity results to display
Show More
Working...