empire db possible bug: blob data type is not working under queries execution commands

["Frias Inchausti, Jon" <jo...@tecnalia.com>]

Hi all,

My name is Jon Frias and I am working under the version 2.3.1-SNAPSHOT of empire db and posgresql driver. (I have already created a bug issue, you can find it at: https://issues.apache.org/jira/browse/EMPIREDB-147 )

The possible bug I have detected is the following:
When I execute a query on a data table which contains a blob data type, it returns this error message:

140 [main] INFO org.apache.empire.exceptions.EmpireException - An Error occured. Message is: The database operation failed. Native error is: Bad value for type long : \x01000100


For example: I have a data table with 3 data fields (Integer, String and BLOB).

The database is created correctly with different data types.

The code I use to execute a query command is the following:

/**
* Gets the address books.
*
* @return the address books
*/
public List<addressBookBean> getAddressBooks(){
List<addressBookBean> myABs = new ArrayList<addressBookBean>();

DBCommand cmd = db.createCommand();
cmd.select(db.ADDRESSBOOK.ADDRESS_BOOK_ID, db.ADDRESSBOOK.LOCATION, db.ADDRESSBOOK.INFORMATION);

DBReader reader = new DBReader();
reader.open(cmd, conn);
while(reader.moveNext()){
myABs.add(new addressBookBean(
reader.getInt(db.ADDRESSBOOK.ADDRESS_BOOK_ID),
reader.getString(db.ADDRESSBOOK.LOCATION),
(byte[]) reader.getValue(db.ADDRESSBOOK.INFORMATION)));
}

return myABs;
}


Thanks a lot for your time and if any further information is required, don't hesitate and let me know.

Best Regards,

Jon

PS: I opened an issue about a bug with the BLOB data type when the sql script is generated for creating the database. the error message was very similar and it was totally fixed. Maybe it can help. The issue is the following:
https://issues.apache.org/jira/browse/EMPIREDB-146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13288425#comment-13288425

Jon Frias Inchausti
Investigador
Researcher

UNIDAD DE SISTEMAS INDUSTRIALES /
INDUSTRIAL SYSTEMS UNIT

División Industria y Transporte /
Industry and Transport Division

TECNALIA
Paseo Mikeletegi 7 - Parque Tecnológico
E-20009 Donostia - San Sebastián (Gipuzkoa, Spain)
Telf Industry & Transport Division: (+34) 943 105115 or 902 760 002
Telf Tecnalia Research & Innovation: (+34) 946 430 850 or 902 760 000
Fax: (+34) 946 460 900 or 901 706 009
jon.frias@tecnalia.com<ma...@tecnalia.com>
www.tecnalia.com

[cid:image002.gif@01CC6E28.23D46110]<http://www.facebook.com/Tecnalia>[cid:image003.gif@01CC6E28.23D46110]<http://twitter.com/tecnalia>[cid:image004.gif@01CC6E28.23D46110]<http://www.flickr.com/photos/tecnalia/sets/>[cid:image005.gif@01CC6E28.23D46110]<http://www.linkedin.com/company/tecnalia-research-&-innovation>[cid:image006.gif@01CC6E28.23D46110]<http://www.slideshare.net/tecnalia>[cid:image007.gif@01CC6E28.23D46110]<http://www.youtube.com/user/tecnaliaTV>[cid:image008.gif@01CC6E28.23D46110]<http://www.tecnalia.com/rss.php?lang=es>
[cid:image009.jpg@01CC6E28.23D46110]<http://www.tecnalia.com/>
Este mensaje puede contener información confidencial o privilegiada. Si no eres el destinatario de este mensaje, notifícaselo por favor al remitente y bórralo sin reenviarlo o guardarlo dado que está legalmente prohibido.
Mezu honek daukan informazioa isilpekoa edo pribilegiatua izan daiteke. Zuri zuzendua ez badago emaiozu, mesedez,  horren berri igorleari eta ezaba ezazu bidali edo gorde gabe, legalki debekatua dago eta.
This message may contain confidential, proprietary or legally privileged information. If you are not the intended recipient of this message, please notify it to the sender and delete without resending or backing it, as it is legally prohibited.
[cid:image010.jpg@01CC6E28.23D46110]Por favor, piensa en el medio ambiente antes de imprimir este e-mail.
Mesedez pentsatu ingurugiroan e-mail hau imprimatu baino lehen.
Please, consider the environment before printing this e-mail.