hazelcast mysql,Mapstore无法从数据库Hazelcast加载数据
I am using Hazelcast and mysql.
I created a mapstore for my table in mysql. What i am trying to do is to populate data using map.loadAll from data base. My Map store implementation is this
public class CityMapStore
implements MapStore
{
private final Connection con;
public CityMapStore() {
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/hazel", "root", "root123");
con.createStatement().executeUpdate(
"create table if not exists City (id bigint, name varchar(45), primary key (id))");
} catch (SQLExpublic synchronized void delete(Long key) {
System.out.println("Delete:" + key);
try {
con.createStatement().executeUpdate(
String.format("delete from City where id = %s", key));
} catch (SQLException e) {
throw new RuntimeException(e);
}
}ception e) {
throw new RuntimeException(e);
}
}
public synchronized void delete( Long key )
{
System.out.println( "Delete:" + key );
try
{
con.createStatement().executeUpdate( String.format( "delete from City where id = %s", key ) );
}
catch ( SQLException e )
{
throw new RuntimeException( e );
}
}
public synchronized void deleteAll( Collection keys )
{
for ( Long key : keys )
delete( key );
}
public synchronized void storeAll( Map map )
{
for ( Map.Entry entry : map.entrySet() )
store( entry.getKey(), entry.getValue() );
}
public synchronized Map loadAll( Collection keys )
{
Map result = new HashMap();
for ( Long key : keys )
result.put( key, load( key ) );
return result;
}
public Set loadAllKeys()
{
return null;
}
}
My Load Class is this
public class LoadAllCity
{
public static void main( String[] args )
{
final Long numberOfEntriesToAdd = 1000l;
final String mapName = LoadAllCity.class.getCanonicalName();
final Config config = createNewConfig( mapName );
final HazelcastInstance node = Hazelcast.newHazelcastInstance( config );
final IMap map = node.getMap( mapName );
populateMap( map, numberOfEntriesToAdd );
System.out.printf( "# After populating map size\t: %d\n", map.size() );
System.out.printf( "# Map store has %d elements\n", numberOfEntriesToAdd );
map.evictAll();
System.out.printf( "# After evictAll map size\t: %d\n", map.size() );
map.loadAll( true );
System.out.printf( "# After loadAll map size\t: %d\n", map.size() );
}
private static void populateMap( IMap map, Long itemCount )
{
for ( long i = 0; i < itemCount; i++ )
{
City city = new City( "Viren" + i );
// map.put(i, city);
}
}
private static Config createNewConfig( String mapName )
{
final CityMapStore cityStore = new CityMapStore();
XmlConfigBuilder configBuilder = new XmlConfigBuilder();
Config config = configBuilder.build();
MapConfig mapConfig = config.getMapConfig( mapName );
MapStoreConfig mapStoreConfig = new MapStoreConfig();
mapStoreConfig.setClassName( CityMapStore.class.getCanonicalName() );
mapStoreConfig.setImplementation( cityStore );
mapStoreConfig.setWriteDelaySeconds( 0 );
mapConfig.setMapStoreConfig( mapStoreConfig );
return config;
}
}
解决方案
To load data at start up override loadAllKeys method first or if you do not want it than use selected keys to load with oveloaded loadAll method
相关文章