This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes updateString() is inserting numbers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "updateString() is inserting numbers" Watch "updateString() is inserting numbers" New topic
Author

updateString() is inserting numbers

Ravi Tiruvaipati
Greenhorn

Joined: Aug 27, 2003
Posts: 13
Hi,
I am using jdbc odbc bridge to update a table in Oracle database using JDBC 2.0 specifications. When I try to insert a row using

I see that numbers are inserted in the table instead of string. The datatype for field 1 and field 2 in the table is VARCHAR2(11). Can someone help me what I am missing here...

thanks & regards
ravi
[ August 18, 2004: Message edited by: Ravi Tiruvaipati ]
Ravi Tiruvaipati
Greenhorn

Joined: Aug 27, 2003
Posts: 13
!!! Update !!!

When I change my ODBC driver from Oracle ODBC driver to Microsoft ODBC Driver it works fine and I got exact string values in the database. I dont know why the same updateString() call is inserting hex numbers in the columns?

regards
ravi
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30586
    
154

Ravi,
I'm glad you have it working. My only thought is that maybe the Oracle one is using Unicode values.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
GeeCON Prague 2014
 
subject: updateString() is inserting numbers