java, byte, images, database

[poymode]

first..kinsa nakagamit ug digital persona pro nga software? biometrics ni siya


anyway, unsaon man pag store ug byte array sa database, mao man gud ni ang representation sa template sa fingerprint nga makuha gikan sa device. unique combination jud ni siya?

ang gamiton diay kay Java nya MsSql express...sakto ba?

[poymode]

Bumpy Xd........

[eax]

Try blob ang datatype sa imong db.

[poymode]

Hello...bump!

kanang byte array ni akong i store sa DB, unsa akong gamiton nga data type sa SQL? kanang inig fetch sad gikan sa SQL same format ghapon?

[eax]

Quote: Originally Posted by poymode Hello...bump! kanang byte array ni akong i store sa DB, unsa akong gamiton nga data type sa SQL? kanang inig fetch sad gikan sa SQL same format ghapon?

Use BLOB na data type.

[poymode]

ahh..thanks ha

ask lang ko, have you tried this out?

[eax]

Quote: Originally Posted by poymode ahh..thanks ha ask lang ko, have you tried this out?

Yup. Mao man na ang recommended kung mag-save ka ug binary sa database.

[sideon]

Agreed. Use blob datatype in your mysql.

Below is the code snippet ...

-----------------------
byte b[] = yourByteArrayHere;

ByteArrayInputStream fis = new ByteArrayInputStream(b);
con = SQLConnection.getConnection();

PreparedStatement ps = con.prepareStatement(YOUR_INSERT_STATEMENT)
ps.setBinaryStream(1, fis);
ps.executeUpdate();

-----------------------

[poymode]

Ahh...ako gi gamit una kay Image nga data type sa MS SQL 2005. Wa man gud blob, mag ilis ra cguro to MySQL..tnx


ang blob wala nay size needed?

[sideon]

there's no need to specify its length but you can initialze it if you want to....

imo, why not save your image as a file as an alternative if your database dont have blob datatype!?

[poymode]

Im sorry to misinform everyone but It is not an image i am trying to store. It is of type byte[] (byte array)

Maybe I said image because some say byte[] can be an image

how can i store a byte[] into a database?

[eax]

It is still the same, byte[] can be either a executable file, image, docs, etc.

[bcasabee]

An array in java is an object. So to persist it on a database, insert it as a blob. research about object serialization and object persistence on a database if you want to know more.