Accessing Schema Information from the Database Server

Accessing a schema from the server (Java)

 
EOAdaptor myAdaptor = EOAdaptor.adaptorWithName("OpenBaseLite"); 
EOAdaptorContext myContext = myAdaptor.createAdaptorContext(); 
EOAdaptorChannel myChannel = myContext.createAdaptorChannel(); 
 
/* The connection dictionary is adaptor and database dependent */ 
NSMutableDictionary connDict = new NSMutableDictionary(); 
connDict.setObjectForKey("Movies","DATABASENAME"); 
connDict.setObjectForKey("/Local/Library/Databases","PATH"); 
 
myAdaptor.setConnectionDictionary(connDict); 
try { 
    myAdaptor.assertConnectionDictionaryIsValid(); 
} catch (NSException exception) { 
    /* handle bad connection dictionary */ 
} 
 
myChannel.openChannel(); 
 
NSArray tableNames = myChannel.describeTableNames(); 
EOModel myModel = myChannel.describeModelWithTableNames(tableNames); 
 
NSArray storedProcNames = myChannel.describeStoredProcedureNames(); 
myChannel.addStoredProceduresNamed(storedProcNames,myModel); 
 
myChannel.closeChannel();

The code first builds a connection dictionary to connect to the database with. Then it attempts to verify the connection dictionary using assertConnectionDictionaryIsValid . If the connection attempt fails, the method raises an exception. Otherwise the code opens the connection to the database and gets the table names and stored procedures.

Note that the keys for the connection dictionary depend on the particular adaptor and database server you are using. You can view the connection dictionary for a database using EOModeler in the following way.

Build a model for your database in EOModeler by invoking the File->New menu item.

1. When you are finished, inspect the model by selecting it in the tree view and clicking the inspector button.