User Profile

Collapse

Profile Sidebar

Collapse
mattynott
mattynott
Last Activity: Apr 17 '07, 04:41 PM
Joined: Mar 26 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • mattynott
    started a topic JSP Database Connection Problem
    in Java

    JSP Database Connection Problem

    Hi

    I've got a section of code that needs to run a few queries. I'm trying to run the addBatch and executeBatch methods as shown below:

    conn6 = ods.getConnecti on();
    stmt6 = conn6.createSta tement();

    stmt6.addBatch( QueryString);

    stmt6.addBatch( AnotherQueryStr ing);

    stmt6.addBatch( YetAnotherQuery String);
    ...
    See more | Go to post

  • mattynott
    started a topic JSP Problem
    in Java

    JSP Problem

    Hi

    I'm creating a site that uses JSP. I'm going to use a third party text messging site such as bulksms. I need to send out multiple messages at a time.

    Does anyone know how/or if its possible to pass a url through jsp without actually navigating to that page if that makes sense?

    Thanks

    Matt
    See more | Go to post

  • mattynott
    replied to Oracle 10g Sequence Help please?
    Hi

    Thanks for you help mate

    I tried your test and it worked fine

    I had a look at my table sql and it seems that when it was created it created a trigger to increment the id automatically so when i was calling nextval it was incrementing it twice if you see what i mean.

    Thanx for your help and problem is sorted now
    See more | Go to post

    Leave a comment:


  • mattynott
    started a topic Oracle 10g Sequence Help please?

    Oracle 10g Sequence Help please?

    Hi

    I've created a sequence on a table using oracle 10g express edition by using the following code:

    create sequence referee_seq START WITH 1 INCREMENT BY 1

    I then add a row to my table by using the following code:

    insert into referee values(referee_ seq.NEXTVAL,'', '','','','','', '','','','')

    For some reason its skipping values so my primary keys are goin up in 2's like 2, 4,...
    See more | Go to post
No activity results to display
Show More
Working...