[Geotools-gt2-users] Mysql large database

[<rm...@st...>]

Hi,

Using geotools2 v2.4-M0, in kubuntu edgy, I was able to insert 
dynamically features into a mysql database. I will send  the code for 
those who also need to do it.
For testing purposes I am using only one FeatureType, and I will store 
3000000 objects (3000000 rows in the mysql table). This is where I have 
problems again...
My computer, a centrino dothan 1.6 with 1GB ram, has been working for 
about one hour, then I killed the process and inspected my database. 
There were only about 10000 rows inserted.
Does anyone worked with a db system and geotools with such a large 
number of objects? The problem comes from mysql or from geotools? 
Otherwise, is it my computer?

Thanks,
Rui Lopes


CODE:

public class Main {

	private MySQLDataStore datastore;

	Main(){}

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Main main = new Main();
		main.createDataStore();
		main.populateDB();
	}

	private void populateDB() {
		AttributeType pWidth = AttributeTypeFactory.newAttributeType("width", 
Integer.class);
		GeometryAttributeType pLoc =
		      
(GeometryAttributeType)AttributeTypeFactory.newAttributeType("location", 
Point.class);
		AttributeType pElevation = 
AttributeTypeFactory.newAttributeType("elevation", Integer.class);
		try {
			FeatureType ftPatch = FeatureTypeFactory.newFeatureType(
					new AttributeType[] { pWidth, pLoc, pElevation  }, "patches");

//			 instances
			DefaultFeatureCollection fcol = new 
DefaultFeatureCollection("patches", ftPatch);
			Feature tempF = null;
			GeometryFactory gf = new GeometryFactory();
			Point locGeom = null;
			for(int i = 1 ;i == 1 ;i++ /*i < patches.length; i++*/)
				for(int j = 0 ; j < patches[0].length; j++){

					locGeom = gf.createPoint( new Coordinate(i,j));
					tempF = ftPatch.create(new Object[] { 1 ,locGeom, i+j },
					"Patch-"+i+"-"+j); 					fcol.add(tempF);
				}

			JDBCFeatureSource fsrcPatches = 
(JDBCFeatureSource)datastore.getFeatureSource("patches");
			JDBCFeatureStore fsPatches = new 
JDBCFeatureStore(fsrcPatches.getJDBCDataStore(), ftPatch );
			//FeatureReader aReader = DataUtilities.reader( altemp );
			fsPatches.addFeatures( fcol );

		} catch (FactoryConfigurationError e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SchemaException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAttributeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}




	}

	private void createDataStore() {

		MySQLDataStoreFactory factory = new MySQLDataStoreFactory();
		Map<String,String> params = new HashMap<String,String>();
		params.put( "database", "mater" );
		params.put( "dbtype", "mysql");
		params.put( "host", "localhost");
		params.put( "port", "3306");
		params.put( "user", "ruya");
		params.put( "passwd", "");

		try {
			this.datastore = (MySQLDataStore) factory.createDataStore( params );
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println("DataStore created!");
	}

	private void loadGISData( Patch[][] patches ) {
		loadTopo( patches, _TOPO_PATH );
		loadHidro( patches, _HIDRO_PATH );
		/*
		for( int i = 0 ; i < getWorldXSize(); i++ ){
			for( int j = 0 ; j < getWorldYSize(); j++ ){
				//patches[i][j].setAgentCapacity();
				space.putObjectAt( i , j , patches[i][j] );
			}
		}
		*/
	}

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.