aspose file tools
The moose likes JDBC and Relational Databases and the fly likes updateString() is inserting numbers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "updateString() is inserting numbers" Watch "updateString() is inserting numbers" New topic

updateString() is inserting numbers

Ravi Tiruvaipati

Joined: Aug 27, 2003
Posts: 13
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
[ August 18, 2004: Message edited by: Ravi Tiruvaipati ]
Ravi Tiruvaipati

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?

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 31680

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

[OCA 8 book] [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
Have you tried LearnNowOnline?
subject: updateString() is inserting numbers