This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes how to insert byte[] into mysql database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to insert byte[] into mysql database" Watch "how to insert byte[] into mysql database" New topic
Author

how to insert byte[] into mysql database

Moiez Gohar
Greenhorn

Joined: Mar 26, 2009
Posts: 8
i want to store byte[] array in the first column (length of this byte array is always 16) and a BigInteger value (<10^78) in the second column. i used this code to create the table:


the table gets created successfully.

i have used this code to insert a row in this table :


i get the following error on executing the insert query:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_binary'Ç♥♦♣♠\"╨↑ºåà8K',1)' at line 1

i am using Connector/J JDBC on MySQL5.0 database..
please tell me why am i getting this error, and what should i do to remove this error, and achieve my objective of storing a byte[] array in the first field and a BigInteger value in the second field.
please guide me.
also, what are the corresponding SQL queries for inserting a byte[] array and a BigInteger?? what datatypes should i use??
please help me.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to insert byte[] into mysql database
 
Similar Threads
convert Double to BigInteger and retrieving byte array
java.sql.SQLException-Need help to resolve.
how to insert a byte array into an MS Access database
Inserting image to MySQL Database
inserting byte[] into MS Access Database...