padde wrote:But give an example that involves DB storing too would put the example for a rather simple question to an unnecessary level of complexity.

padde wrote:And what i meant with "Large XML Files will always end up with an OOME" was that the android sax parser itself does not really like large xml files.

rigeltrue wrote:

bstubbs wrote:Artur79, did you ever figure out how to solve the missing string?

I'm getting the same results:

ExtractedString =
ExtractedInt = 1337

Anyone else getting this, found a solution? Thanks

Hi
I meet the same proplem.

Chnage the xml file from

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using xml Syntax Highlighting

1. <mytag>
2. anddev.org rulez =)
3. </mytag>

Parsed in 0.000 seconds, using GeSHi 1.0.8.4

to

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using xml Syntax Highlighting

1. <mytag>anddev.org rulez =)</mytag>

Parsed in 0.000 seconds, using GeSHi 1.0.8.4

That works.

java.net.SocketTimeoutException: The operation timed out
at org.apache.harmony.luni.net.PlainSocketImpl.read(PlainSocketImpl.java:557)
at org.apache.harmony.luni.net.SocketInputStream.read(SocketInputStream.java:87)
at org.apache.http.impl.io.AbstractSessionInputBuffer.fillBuffer(AbstractSessionInputBuffer.java:103)
at org.apache.http.impl.io.AbstractSessionInputBuffer.read(AbstractSessionInputBuffer.java:134)
at org.apache.http.impl.io.ContentLengthInputStream.read(ContentLengthInputStream.java:174)
at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:159)
at java.io.InputStreamReader.read(InputStreamReader.java:438)
at java.io.BufferedReader.fillbuf(BufferedReader.java:130)
at java.io.BufferedReader.read(BufferedReader.java:316)
at java.io.Reader.read(Reader.java:162)
at org.apache.harmony.xml.ExpatParser.parseFragment(ExpatParser.java:488)
at org.apache.harmony.xml.ExpatParser.parseDocument(ExpatParser.java:477)
at org.apache.harmony.xml.ExpatReader.parse(ExpatReader.java:317)
at org.apache.harmony.xml.ExpatReader.parse(ExpatReader.java:273)

ggomeze wrote:Jeff,

could you try with this instead?. Let me know if it works:

InputStream is = resEntity.getContent();
SAXParserFactory spf = SAXParserFactory.newInstance();
SAXParser sp = spf.newSAXParser();
XMLReader xr = sp.getXMLReader();
xr.setContentHandler(new CustomizedHandler());
xr.parse(new InputSource(is));

padde wrote:For me it sounds like your timeout settings are to restrictive.
Please try to ease them.

To test my theory try:

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using java Syntax Highlighting

1. client.getParams().setParameter("http.socket.timeout", 100000);
2. client.getParams().setParameter("http.connection.timeout", 100000);
3.  

Parsed in 0.035 seconds, using GeSHi 1.0.8.4

ggomeze wrote:Yep, it sounds like an issue on the server side. Do you have access to server side?.

Ger

Code: Select all

SQLiteDatabase myDB = null;
myDB = openOrCreateDatabase("ZET", MODE_PRIVATE, null);

Code: Select all

   public String toString(){
      return this.extractedString;
   }

Code: Select all

/* Our ExampleHandler now provides the parsed data to us. */
         ParsedExampleDataSet parsedExampleDataSet = myExampleHandler.getParsedData();

         String result= parsedExampleDataSet.toString();
         String[] array = result.split(",");
                  
         int id= Integer.parseInt(array[0]);
         String name = array[1];
         
           SQLiteDatabase myDB= null;
           myDB = openOrCreateDatabase("SomeDatabaseName", MODE_PRIVATE, null);
           myDB.execSQL("INSERT INTO SomeTable (id, name) VALUES (" + id+ ", '" + name + "');");
           if (myDB != null)
              myDB.close(); // Zatvori databazu

Code: Select all

<?xml version="1.0"?>
<outertag>
   <innertag sampleattribute="innertagAttribute">
      <mytag>666,Test</mytag>
      <mytag>667,Test2</mytag>
      <tagwithnumber thenumber="1337"/>
   </innertag>
</outertag>

Code: Select all

package com.svebee.prijevoz;

import java.util.Vector;

import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.TextView;

public class Update extends Activity {
    private Vector<Person> friends;
   
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.update);
       
        friends = PersonParser.parse(getResources().openRawResource(R.raw.test));
       
        TextView tv = (TextView) findViewById(R.id.output);
        for(Person p : friends) {
           
           String rezultat = p.toString();
         String[] array = rezultat.split(",");
                  
         int id= Integer.parseInt(array[0]);
         String name= array[1];
         
           SQLiteDatabase myDB= null;
           myDB = openOrCreateDatabase("SomeDatabaseName", MODE_PRIVATE, null);
           myDB.execSQL("INSERT INTO SomeTable (id, name) VALUES (" + id+ ", '" + name+ "');");
           if (myDB != null)
              myDB.close();

           
           tv.append(p.toString());
        }
    }
}


Code: Select all

package com.svebee.prijevoz;

import java.io.IOException;
import java.io.InputStream;
import java.util.Vector;

import javax.xml.parsers.ParserConfigurationException;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;

import org.xml.sax.Attributes;
import org.xml.sax.InputSource;
import org.xml.sax.SAXException;
import org.xml.sax.XMLReader;
import org.xml.sax.helpers.DefaultHandler;

public class Person {
    private String name;
   
    public void setName(String n) { this.name = n; }
    public String getName() { return this.name; }
   
    public String toString() {
        return this.name;
    }
}

class PersonParser {
    public static Vector<Person> parse(InputStream in) {
        SAXParserFactory spf = SAXParserFactory.newInstance();
        SAXParser sp;
        try {
            sp = spf.newSAXParser();
            XMLReader xr = sp.getXMLReader();
            PersonHandler ch = new PersonHandler();
            xr.setContentHandler(ch);
            xr.parse(new InputSource(in));
            return ch.getParsedPersons();               
        } catch (ParserConfigurationException e) {
        } catch (SAXException e) {
        } catch (IOException e) {}
        return null;
    }
}

class PersonHandler extends DefaultHandler {
    private enum TAGS { friends, person, name}   
    private StringBuffer tempString;
    private Person tempPerson;
    private Vector<Person> friends;
   
    public PersonHandler() {
        super();
        this.friends = new Vector<Person>();
        this.tempString = new StringBuffer();
    }
   
    public Vector<Person> getParsedPersons() { return friends; }

    public void startDocument() { }
    public void endDocument() { }
   
    public void characters(char ch[], int start, int length) {
       tempString.append(ch,start,length);
    }
   
    public void startElement(String n, String l, String q, Attributes a) {
        switch(TAGS.valueOf(l)) {
            case person: tempPerson = new Person(); break;   
            default: tempString.setLength(0); break;
        }
    }
     
    public void endElement(String n, String l, String q) {
        switch(TAGS.valueOf(l)) {
            case name: tempPerson.setName(tempString.toString()); break;     
            case person: friends.add(tempPerson); break;
            default: break;
        }   
    }
}

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<friends>
    <person><name>610,Test1</name></person>
    <person><name>611,Test2</name></person>
</friends>