aspose file tools
The moose likes JDBC and Relational Databases and the fly likes prepared statement and DB field char Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "prepared statement and DB field char" Watch "prepared statement and DB field char" New topic
Author

prepared statement and DB field char

Rajni Patel
Ranch Hand

Joined: Sep 03, 2009
Posts: 84
Hi,

I have a field in Database which is of CHAR(11) type. I am using
prepared statement to set parameter value in this field in Java in DAO class. I used
setString method of prepared statement for this purpose but i didnt get
any success in it.

Can any one help me which prepared statement method should I use to set
parameter in this field.

thanks
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31634
    
189

setString() is correct. What error did you get?


[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
Rajni Patel
Ranch Hand

Joined: Sep 03, 2009
Posts: 84
Thanks for reply.

My query is like this:

sql = "select empname from employ where empno = ?";


Here empno is char(11) in DB.

and then I set value

ps.setString(1,"101");

Originally, there is record which has empno=101 in DB. but in my case there is no data fetch from DB and also not any error is coming.

Thanks
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 19357
    
  10

That just means your query selected zero records, then.

Perhaps you think there is a row in the table containing "101" in the empno column? Is it not possible that row actually contains "101 " or " 101"?
Rajni Patel
Ranch Hand

Joined: Sep 03, 2009
Posts: 84
Thanks for reply.

there is DB field char(11) so in db there is 11 size for that field.

so I have write querey like this.

select empname from emp where trim(empno)= '101';

now its working.

thanks again.
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 2028
    
  19

Use VARCHAR or VARCHAR2 instead of CHAR as your column data-type, to avoid the trailing blanks on your data.


No more Blub for me, thank you, Vicar.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: prepared statement and DB field char