View Poll Results: Do you use PL/SQL or Java?

Voters
1. You may not vote on this poll
  • Java

    1 100.00%
  • PL/SQL

    0 0%
  • Other

    0 0%
  • None

    0 0%
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Question Unanswered: Help?! -> ROWID Java and stuff.

    I am doing some java stuff in oracle; basically i am getting the rowid from a resultset and Java is converting the rowid into ASCI stuff...

    SQL+ AAAH...........
    Java 41414149........

    this is really confusing me! I don't know why.

    I am doing this;
    Code:
    resultset="select rowid from blahtable where x=y"
    loop
    {
      update x set x=y where blah=resultset.rowid
    }
    but as java or something is changing it on the way, the constraint returns no records...

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    FYI - I have solved this problem now ;

    Basically it's something todo with incompatibilty between java/oracle and the driver used and the mode of the connection;

    so if you just change this
    Code:
    Statement read=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
    ResultSet.CONCUR_READ_ONLY);
    to this
    Code:
    Statement read= connection.createStatement();
    it works...

    strange, no?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •