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.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
