How to convert string type to Binary type in insert query in Java servlet

Question

Here i am inserting data into sql server table in one column data type is binary type data it stores i am taking

When i trying to pass data it shows error message and how to insert this

String ins="insert into Users(ID,Name,Password)     values(?,?,?)";

ps.setString(1,id); 
ps.setString(2,Name); 
ps.setString(3,password);

What is the error message?

Andrei Olar
– Andrei Olar

2017-03-27 11:54:26 +00:00
Commented Mar 27, 2017 at 11:54 — Andrei Olar
– Andrei Olar, Commented Mar 27, 2017 at 11:54
@Olar Anddrei, I Edited my question with error

Jhon
– Jhon

2017-03-27 11:58:58 +00:00
Commented Mar 27, 2017 at 11:58 — Jhon
– Jhon, Commented Mar 27, 2017 at 11:58
See @javaguy answer then.

Andrei Olar
– Andrei Olar

2017-03-27 11:59:27 +00:00
Commented Mar 27, 2017 at 11:59 — Andrei Olar
– Andrei Olar, Commented Mar 27, 2017 at 11:59
@Jhon why are you removing the code/errors from question?

Vasu
– Vasu

2017-03-27 12:16:00 +00:00
Commented Mar 27, 2017 at 12:16 — Vasu
– Vasu, Commented Mar 27, 2017 at 12:16

Vasu · Accepted Answer · 2017-03-27 12:12:59Z

4

You need to convert your password String object to byte[] and use preparedStatement.setBytes method as shown below:

byte[] passwordBytes = password.getBytes();
ps.setBytes(9,passwordBytes);

I am getting this error now:: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value 'SuperUser' to data type int

The problem with your code is that you are using preparedStatement.setString for all datatypes. You need to use preparedStatement.setInt or other suitable methods (look here for API) according to the database table's column design.

Also, I strongly recommend to close the preparestatement object in the finally block or use try with resources, otherwise you will run out of resources.

edited Mar 27, 2017 at 12:12

answered Mar 27, 2017 at 11:57

Vasu

22.6k11 gold badges54 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert string type to Binary type in insert query in Java servlet

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related