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
[email protected]<mailto:[email protected]>
www.tecnalia.com
[cid:[email protected]]<http://www.facebook.com/Tecnalia>[cid:[email protected]]<http://twitter.com/tecnalia>[cid:[email protected]]<http://www.flickr.com/photos/tecnalia/sets/>[cid:[email protected]]<http://www.linkedin.com/company/tecnalia-research-&-innovation>[cid:[email protected]]<http://www.slideshare.net/tecnalia>[cid:[email protected]]<http://www.youtube.com/user/tecnaliaTV>[cid:[email protected]]<http://www.tecnalia.com/rss.php?lang=es>
[cid:[email protected]]<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:[email protected]]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.
