Prob with store and retrieve binary data to/from remote sqlserver's image field

[Askar]

Sorry Mr.Wysota
Its my mistake, i should post my thread with clear codes and explanations. sorry once again.

the retrieved value from xml file is in binary base64 encoded, so i created another one byte array (byte) to store the base64 decoded binary data, for that i used the following syntax...

QByteArray byte(QByteArray::fromBase64(wBData1));

QByteArray byte(QByteArray::fromBase64(wBData1));

To copy to clipboard, switch view to plain text mode 

then im storing the contents of the variable byto into a already opened file, code given below

fil.write(byte);
        fil.close();

fil.write(byte);
        fil.close();

To copy to clipboard, switch view to plain text mode 

fil is file object already opened,

after doing all these things i could not get the original file (for eg image) what im stored before into the server.

[wysota]

How does your xml parser look like? If the code you pasted is complete, it means that you don't have a parser and you "forgot" to read QXmlStreamReader documentation which you should now do.

[Askar]

sorry
i didnt pasted here the code for xml parsing .
now i gave the complete code for retrieving data from remote sql server & parsing the retrieved xml file.

QEventLoop loop;
QNetworkReply *reply;
QFile fil("testsnd");
    if(!fil.open(QIODevice::WriteOnly))
    {
        qDebug() << "cannot open file for writing"<<qPrintable(fil.errorString()) <<endl;
        return 0;
    }
reply=net.get("http://192.168.0.220/clancor?sql=select+photo+from+blob+where+sno+=+4+F OR+XML+RAW,+BINARY+BASE64&root=blobinsert&contentt ype=text/xml")
connect(reply, SIGNAL(finished()),&loop,SLOT(quit()));
loop.exec(); //entering event loop until reply object's finished() signal gets activated
 
QXmlStreamReader xml(reply->readAll()); //storing retrieved xml file content xmlstreamreader object 
while (!xml.atEnd())
        {
            xml.readNext();
            if (xml.tokenType() == QXmlStreamReader::StartElement)
 
                if (xml.name() == "row")
                {                     
                        wBData1.append(xml.attributes().value("photo").toString());
                }
         }	
QByteArray byte(QByteArray::fromBase64(wBData1));
fil.write(byte);
fil.close();

QEventLoop loop;
QNetworkReply *reply;
QFile fil("testsnd");
    if(!fil.open(QIODevice::WriteOnly))
    {
        qDebug() << "cannot open file for writing"<<qPrintable(fil.errorString()) <<endl;
        return 0;
    }
reply=net.get("http://192.168.0.220/clancor?sql=select+photo+from+blob+where+sno+=+4+F OR+XML+RAW,+BINARY+BASE64&root=blobinsert&contentt ype=text/xml")
connect(reply, SIGNAL(finished()),&loop,SLOT(quit()));
loop.exec(); //entering event loop until reply object's finished() signal gets activated

QXmlStreamReader xml(reply->readAll()); //storing retrieved xml file content xmlstreamreader object 
while (!xml.atEnd())
        {
            xml.readNext();
            if (xml.tokenType() == QXmlStreamReader::StartElement)

                if (xml.name() == "row")
                {                     
                        wBData1.append(xml.attributes().value("photo").toString());
                }
         }	
QByteArray byte(QByteArray::fromBase64(wBData1));
fil.write(byte);
fil.close();

To copy to clipboard, switch view to plain text mode 

[wysota]

now i gave the complete code for retrieving data from remote sql server & parsing the retrieved xml file.

You could have done that 12 posts ago...

Are you sure "photo" is an attribute and not an element?

[Askar]

ya sure............

[wysota]

What does this return?

qDebug("%d", wBData1.size());
qDebug("%d", byte.size());

qDebug("%d", wBData1.size());
qDebug("%d", byte.size());

To copy to clipboard, switch view to plain text mode 

[Askar]

wBData1.size() returns-----------12
byte.size() returns------------------7

[wysota]

Somehow I doubt you can fit an image with all its headers in 7 bytes...

[Askar]

dear Wysota,

while inserting binary value into the remote server database table with the following code

QString str;
QFile fileIn ("Sunset.jpg");
    QByteArray wBData;
    net   = new QNetworkAccessManager();
    if (fileIn.open (QIODevice::ReadOnly))
    {
        wBData.append(fileIn.readAll());
 
    }
    qDebug()<<wBData.size();          //returns 59129 
   str.append(wBData)
net.get("http://192.168.0.220/clancor?sql=insert+into+blob+(sno,photo)+values+(4 ,'"+ str +"')&root=blobinsert"

QString str;
QFile fileIn ("Sunset.jpg");
    QByteArray wBData;
    net   = new QNetworkAccessManager();
    if (fileIn.open (QIODevice::ReadOnly))
    {
        wBData.append(fileIn.readAll());

    }
    qDebug()<<wBData.size();          //returns 59129 
   str.append(wBData)
net.get("http://192.168.0.220/clancor?sql=insert+into+blob+(sno,photo)+values+(4 ,'"+ str +"')&root=blobinsert"

To copy to clipboard, switch view to plain text mode 

qDebug returns value 59129

but while retrieving same binary data value from remote server qdebug returns

wBData1.size() returns-----------12
byte.size() returns------------------7

which is entered in the previous thread

[wysota]

What's the whole xml you get from the server? Also how do you know the image is stored correctly? You are not encoding the data here anywhere...

[Askar]

Dear Wysota;
yes im not encoding the data while storing, but im storing the contents of byte array contents into a QString object while inserting the binary value into the remote server ( the code i gave in previous thread).

the whole xml contents which im retrieving are given below,

<?xml version="1.0" encoding="utf-8" ?><blobinsert><row photo="w7/DmMO/w6A="/></blobinsert>

<?xml version="1.0" encoding="utf-8" ?><blobinsert><row photo="w7/DmMO/w6A="/></blobinsert>

To copy to clipboard, switch view to plain text mode 

from the xml file i retrieved from the server the base64 encoded binary contents are
w7/DmMO/w6A=

Please let me know, where im getting wrong ? and what is the correct way to do this process

Thanks,

[Askar]

Dear Wysota;
yes im not encoding the data while storing, but im storing the contents of byte array contents into a QString object while inserting the binary value into the remote server ( the code i gave in previous thread).

the whole xml contents which im retrieving are given below,

<?xml version="1.0" encoding="utf-8" ?><blobinsert><row photo="w7/DmMO/w6A="/></blobinsert>

<?xml version="1.0" encoding="utf-8" ?><blobinsert><row photo="w7/DmMO/w6A="/></blobinsert>

To copy to clipboard, switch view to plain text mode 

from the xml file i retrieved from the server the base64 encoded binary contents are
w7/DmMO/w6A=

Please let me know, where im getting wrong ? and what is the correct way to do this process

Thanks,