public void populate(DatabaseSession session) {
Employee instance;
PopulationManager manager = PopulationManager.getDefaultManager();
instance = Employee.example1();
session.writeObject(instance);
manager.registerObject(instance, "example1");
manager.registerObject(instance.computer, "example1");
manager.registerObject(instance.shipments.firstElement(), "example1");
manager.registerObject(
((Shipment) instance.shipments.firstElement()).orders.firstElement(), "example1");
instance = Employee.example2();
session.writeObject(instance);
manager.registerObject(instance, "example2");
manager.registerObject(instance.computer, "example2");
manager.registerObject(instance.shipments.firstElement(), "example2");
manager.registerObject(
((Shipment) instance.shipments.firstElement()).orders.firstElement(), "example2");
instance = Employee.example3();
session.writeObject(instance);
manager.registerObject(instance, "example3");
manager.registerObject(instance.computer, "example3");
manager.registerObject(instance.shipments.firstElement(), "example3");
manager.registerObject(
((Shipment) instance.shipments.firstElement()).orders.firstElement(), "example3");
}
public void reset() {
// Remove the transport added for this test
DatabaseSession session = (DatabaseSession) getSession();
UnitOfWork uow = session.acquireUnitOfWork();
ExpressionBuilder transport = new ExpressionBuilder();
Expression expression = transport.get("id").equal(transportId);
uow.deleteAllObjects(uow.readAllObjects(Transport.class, expression));
uow.commit();
}
public void test() {
transport = Transport.example6();
UnitOfWork uow = getSession().acquireUnitOfWork();
uow.registerObject(transport);
uow.commit();
transportId = transport.getId();
DatabaseSession session = (DatabaseSession) getSession();
ExpressionBuilder exp = new ExpressionBuilder();
Expression expression = exp.get("id").equal(transportId);
transport = (Transport) session.readObject(Transport.class, expression);
}
/**
* Initialize and return this.database object.
*
* @return SQLiteDatabase properly initialized.
* @throws IOException on error.
*/
@Override
protected SQLiteDatabase getDatabase() throws IOException {
Debug.enter();
final SQLiteDatabase database = DatabaseSession.getDatabase(Android.App.INSTANCE);
Debug.leave();
return database;
}
/**
* Called when a background process have already been terminated and the current foreground
* applications are still low on memory. Override this method to clear caches or release
* unnecessary resources.
*/
@Override
public void onLowMemory() {
super.onLowMemory();
{
Debug.print("lowMemory");
DatabaseSession.close(); // to free buffers
}
}
/**
* Called when the application object is terminated. There is no guarantee of this method being
* called.
*/
@Override
public void onTerminate() {
{
Debug.print("terminate");
DatabaseSession.close();
}
super.onTerminate();
}
public void createTables(DatabaseSession session) {
dropTableConstraints(session);
new InheritanceTableCreator().replaceTables(session);
SchemaManager schemaManager = new SchemaManager(session);
if (session.getLogin().getPlatform().isOracle()) {
schemaManager.replaceObject(Computer.oracleView());
schemaManager.replaceObject(Vehicle.oracleView());
} else if (session.getLogin().getPlatform().isSybase()) {
schemaManager.replaceObject(Computer.sybaseView());
schemaManager.replaceObject(Vehicle.sybaseView());
// CREATE VIEW statement was added in MySQL 5.0.1. Uncomment it when we support MySQL 5
// } else if (session.getLogin().getPlatform().isMySQL()) {
// schemaManager.replaceObject(Computer.sybaseView());
// schemaManager.replaceObject(Vehicle.mySQLView());
}
}
public void addDescriptors(DatabaseSession session) {
if (project == null) {
project =
XMLProjectReader.read(
"org/eclipse/persistence/testing/models/employee/eis/xmlfile/employee-ns-project.xml",
getClass().getClassLoader());
}
session.addDescriptors(project);
}
public void updateProject(Project project, Session session) {
verifySession(session);
if (generator == null) {
generator =
new StoredProcedureGeneratorForAdapter(new SchemaManager((DatabaseSession) session));
generator.setUseTableNames(true);
}
removeOptimisticLocking(project);
((DatabaseSession) session).addDescriptors(project);
generator.generateStoredProceduresDefinitionsForProject(project);
generator.amendDescriptors();
}
public void addDescriptors(DatabaseSession session) {
// Oracle has bug in outjoins that require outerjoin of inheritance type.
// This should really be handled by the platform during expression normalization...
// Id for Entomologist can be negative (millis cast to int wraps...)
project.getDescriptor(Entomologist.class).setIdValidation(IdValidation.NONE);
session.addDescriptors(project);
// For using read all subclasses views.
DatabasePlatform platform = session.getLogin().getPlatform();
if (platform.isOracle() || platform.isSybase()) {
ClassDescriptor computerDescriptor = session.getDescriptor(Computer.class);
ClassDescriptor vehicleDescriptor = session.getDescriptor(Vehicle.class);
computerDescriptor.getInheritancePolicy().setReadAllSubclassesViewName("AllComputers");
vehicleDescriptor.getInheritancePolicy().setReadAllSubclassesViewName("AllVehicles");
}
// Enable outer-join on AnimalMatt hierarchy.
session
.getDescriptor(Animal_Matt.class)
.getInheritancePolicy()
.setShouldOuterJoinSubclasses(true);
}
public void addDescriptors(DatabaseSession session) {
if (project == null) {
if (getAdapter().isOriginalSetupRequired()) {
try {
// If called twice, method TestSystem.addDescriptors(Session)
// may behave wrong during the second call
// (typically because during the second call project value is no longer null,
// which causes problems in case more than one project is used).
// Therefore another instance of TestSystem is created - not to spoil the original.
TestSystem tempTestSystem = getTestSystem().getClass().newInstance();
tempTestSystem.addDescriptors(session);
try {
tempTestSystem.createTables(session);
} catch (Exception ex2) {
throw new TestProblemException(
"Exception thrown by "
+ Helper.getShortClassName(tempTestSystem)
+ ".createTables() ",
ex2);
}
} catch (Exception ex1) {
throw new TestProblemException(
"Failed to create an instance of " + getTestSystem().getClass() + " ", ex1);
}
}
// This trick stores all descriptors used by testSystem into project
DatabaseSession dummyDatabaseSession =
new Project((Login) session.getLogin().clone()).createDatabaseSession();
getTestSystem().addDescriptors(dummyDatabaseSession);
project = dummyDatabaseSession.getProject();
getAdapter().updateProject(project, session);
}
(session).addDescriptors(project);
afterAddDescriptors(session, getTestSystem());
}
public void test() {
Vector sessions = new Vector();
try {
for (int i = 0; i < stressLevel; i++) {
Session session =
new Project(getSession().getDatasourceLogin().clone()).createDatabaseSession();
((DatabaseSession) session).login();
sessions.addElement(session);
}
getSession().readObject(Address.class);
} finally {
for (Enumeration sessionEnum = sessions.elements(); sessionEnum.hasMoreElements(); ) {
((DatabaseSession) sessionEnum.nextElement()).logout();
}
}
getSession().readObject(Address.class);
}
public void test() {
EmployeeProjectForIntegrityChecker project = new EmployeeProjectForIntegrityChecker();
project.setDatasourceLogin(getSession().getDatasourceLogin());
DatabaseSession session =
new Project(getSession().getDatasourceLogin()).createDatabaseSession();
session.dontLogMessages();
boolean caughtError = false;
try {
session.login();
session.setIntegrityChecker(new IntegrityChecker());
session.getIntegrityChecker().dontCatchExceptions();
session.addDescriptors(project);
} catch (DescriptorException exception) {
caughtError = true;
} finally {
session.logout();
}
if (!caughtError) {
throw new TestErrorException("Test is Failed, no exception was thrown");
}
}
public void setup() {
oldSession = getSession();
DatabaseLogin login = (DatabaseLogin) oldSession.getLogin().clone();
if (login.getConnector() instanceof JNDIConnector) {
login.setConnector(new JNDIConnector("jdbc/OracleCoreAQ"));
} else {
login.setUserName("aquser");
login.setPassword("aquser");
}
DatabaseSession session = new Project(login).createDatabaseSession();
session.setSessionLog(getSession().getSessionLog());
try {
session.login();
} catch (Exception exception) {
throw new TestProblemException(
"Database needs to be setup for AQ, with the aquser", exception);
}
/**
* to setup aquser, need to execute, 1 - login as sys (default password is password) - login as
* scott tiger connect sys/password@james as sysdba
*
* <p>2 - might need to install aq procesures? - in sqlplus
* - @@<orahome>\ora92\rdbms\admin\catproc.sql
*
* <p>3 - create a aq user (i.e aquser) grant connect, resource , aq_administrator_role to
* aquser identified by aquser grant execute on dbms_aq to aquser grant execute on dbms_aqadm to
* aquser grant execute on dbms_lock to aquser connect aquser/aquser
*/
try {
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.STOP_QUEUE (queue_name => 'order_queue'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.DROP_QUEUE (queue_name => 'order_queue'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'order_queue_table'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.STOP_QUEUE (queue_name => 'order_topic'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.DROP_QUEUE (queue_name => 'order_topic'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'order_topic_table'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.STOP_QUEUE (queue_name => 'raw_order_queue'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.DROP_QUEUE (queue_name => 'raw_order_queue'); end;"));
} catch (Exception notThere) {
}
try {
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'raw_order_queue_table'); end;"));
} catch (Exception notThere) {
}
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'order_queue_table', multiple_consumers => FALSE, queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE'); end;"));
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.CREATE_QUEUE (queue_name => 'order_queue', queue_table => 'order_queue_table'); end;"));
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.START_QUEUE (queue_name => 'order_queue'); end;"));
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'order_topic_table', multiple_consumers => TRUE, queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE'); end;"));
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.CREATE_QUEUE (queue_name => 'order_topic', queue_table => 'order_topic_table'); end;"));
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.START_QUEUE (queue_name => 'order_topic'); end;"));
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'raw_order_queue_table', multiple_consumers => FALSE, queue_payload_type => 'RAW'); end;"));
session.executeNonSelectingCall(
new SQLCall(
"begin DBMS_AQADM.CREATE_QUEUE (queue_name => 'raw_order_queue', queue_table => 'raw_order_queue_table'); end;"));
session.executeNonSelectingCall(
new SQLCall("begin DBMS_AQADM.START_QUEUE (queue_name => 'raw_order_queue'); end;"));
session =
XMLProjectReader.read(
"org/eclipse/persistence/testing/models/order/eis/aq/order-project.xml",
getClass().getClassLoader())
.createDatabaseSession();
session.setSessionLog(getSession().getSessionLog());
// String url = oldSession.getLogin().getConnectionString();
String url;
try {
url = ((AbstractSession) getSession()).getAccessor().getConnection().getMetaData().getURL();
} catch (java.sql.SQLException se) {
se.printStackTrace();
throw new TestErrorException("There is SQLException");
}
EISLogin eisLogin = (EISLogin) session.getDatasourceLogin();
eisLogin.setConnectionSpec(new AQEISConnectionSpec());
eisLogin.setProperty(AQEISConnectionSpec.URL, url);
eisLogin.setUserName("aquser");
eisLogin.setPassword("aquser");
session.login();
getExecutor().setSession(session);
}
/**
* Change language for this application only (not system-wide).
*
* @param locale the new {@link Locale} instance.
* @throws IOException on error.
*/
@Override
protected void setLocale(final Locale locale) throws IOException {
Debug.enter(locale);
DatabaseSession.setLocale(Android.App.INSTANCE, locale);
Debug.leave(locale);
}
public void test() {
DatabaseSession session = (DatabaseSession) getSession();
session.getEventManager().addListener(new StoredProcedureOutputListener(this.events));
session.writeObject(this.employee);
}
public void populate(DatabaseSession session) {
PopulationManager manager = PopulationManager.getDefaultManager();
Cat cat = Cat.example1();
session.writeObject(cat);
manager.registerObject(cat, "catExample1");
Dog dog = Dog.example1();
session.writeObject(dog);
manager.registerObject(dog, "dogExample1");
cat = Cat.example2();
session.writeObject(cat);
manager.registerObject(cat, "catExample2");
dog = Dog.example2();
session.writeObject(dog);
manager.registerObject(dog, "dogExample2");
cat = Cat.example3();
session.writeObject(cat);
manager.registerObject(cat, "catExample3");
dog = Dog.example3();
session.writeObject(dog);
manager.registerObject(dog, "dogExample3");
Company company = Company.example1();
session.writeObject(company);
manager.registerObject(company, "example1");
manager.registerObject(((Vector) company.getVehicles().getValue()).firstElement(), "example1");
company = Company.example2();
session.writeObject(company);
manager.registerObject(company, "example2");
company = Company.example3();
session.writeObject(company);
manager.registerObject(company, "example3");
Person person = Person.example1();
session.writeObject(person);
manager.registerObject(person, "example1");
// populate the data for duplicate field testing
session.writeObject(A_King2.exp1());
session.writeObject(A_King2.exp2());
session.writeObject(A_1_King2.exp3());
session.writeObject(A_2_King2.exp4());
session.writeObject(A_2_1_King2.exp5());
UnitOfWork unitOfWork = session.acquireUnitOfWork();
person = Person.example2();
unitOfWork.registerObject(person);
unitOfWork.commit();
manager.registerObject(person, "example2");
manager.registerObject(person.bestFriend, "example5");
manager.registerObject(person.representitive, "example4");
person = Person.example3();
session.writeObject(person);
manager.registerObject(person, "example3");
Computer computer = Computer.example1();
session.writeObject(computer);
manager.registerObject(computer, "example1");
computer = Computer.example2();
session.writeObject(computer);
manager.registerObject(computer, "example2");
computer = Computer.example3();
session.writeObject(computer);
manager.registerObject(computer, "example3");
computer = Computer.example4();
session.writeObject(computer);
manager.registerObject(computer, "example4");
computer = Computer.example5();
session.writeObject(computer);
manager.registerObject(computer, "example5");
JavaProgrammer JP = JavaProgrammer.example1();
session.writeObject(JP);
manager.registerObject(JP, "example1");
JP = JavaProgrammer.example2();
session.writeObject(JP);
manager.registerObject(JP, "example2");
// Added to test bug 3019934.
unitOfWork = session.acquireUnitOfWork();
Alligator alligator = new Alligator();
alligator.setFavoriteSwamp("Florida");
alligator.setLatestVictim(JavaProgrammer.steve());
unitOfWork.registerObject(alligator);
manager.registerObject(alligator, "example1");
unitOfWork.commit();
// Added to test bug 6111278
unitOfWork = session.acquireUnitOfWork();
Entomologist bugguy = new Entomologist();
bugguy.setId((int) System.currentTimeMillis());
bugguy.setName("Gary");
bugguy = (Entomologist) unitOfWork.registerObject(bugguy);
Insect insect = new GrassHopper();
insect.setIn_numberOfLegs(4);
insect.setEntomologist(bugguy);
bugguy.getInsectCollection().add(insect);
unitOfWork.commit();
}
public void populate(DatabaseSession session) {
Object instance;
PopulationManager manager = PopulationManager.getDefaultManager();
instance = LockInCache.example1();
session.writeObject(instance);
manager.registerObject(instance, "Cache example1");
instance = LockInCache.example2();
session.writeObject(instance);
manager.registerObject(instance, "Cache example2");
instance = LockInCache.example3();
session.writeObject(instance);
manager.registerObject(instance, "Cache example3");
instance = LockInObject.example1();
session.writeObject(instance);
manager.registerObject(instance, "Object example1");
instance = LockInObject.example2();
session.writeObject(instance);
manager.registerObject(instance, "Object example2");
instance = LockInObject.example3();
session.writeObject(instance);
manager.registerObject(instance, "Object example3");
instance = TimestampInCache.example1();
session.writeObject(instance);
manager.registerObject(instance, "Cache TS example1");
instance = TimestampInCache.example2();
session.writeObject(instance);
manager.registerObject(instance, "Cache TS example2");
instance = TimestampInCache.example3();
session.writeObject(instance);
manager.registerObject(instance, "Cache TS example3");
instance = TimestampInObject.example1();
session.writeObject(instance);
manager.registerObject(instance, "Object TS example1");
instance = TimestampInObject.example2();
session.writeObject(instance);
manager.registerObject(instance, "Object TS example2");
instance = TimestampInObject.example3();
session.writeObject(instance);
manager.registerObject(instance, "Object TS example3");
instance = ChangedRow.example1();
session.writeObject(instance);
manager.registerObject(instance, "ChangedRow example1");
instance = ChangedRow.example2();
session.writeObject(instance);
manager.registerObject(instance, "ChangedRow example2");
instance = ChangedRow.example3();
session.writeObject(instance);
manager.registerObject(instance, "ChangedRow example3");
instance = TimestampInAggregateObject.example1();
session.writeObject(instance);
manager.registerObject(instance, "Aggregate Object TS example1");
instance = TimestampInAggregateObject.example2();
session.writeObject(instance);
manager.registerObject(instance, "Aggregate Object TS example2");
instance = TimestampInAggregateObject.example3();
session.writeObject(instance);
manager.registerObject(instance, "Aggregate Object TS example3");
instance = LockInAggregateObject.example1();
session.writeObject(instance);
manager.registerObject(instance, "Lock Object TS example1");
instance = LockInAggregateObject.example2();
session.writeObject(instance);
manager.registerObject(instance, "Lock Object TS example2");
instance = LockInAggregateObject.example3();
session.writeObject(instance);
manager.registerObject(instance, "Lock Object TS example3");
UnitOfWork uow = session.acquireUnitOfWork();
instance = uow.registerObject(RockBand.example1());
manager.registerObject(instance, "RockBand example1");
instance = uow.registerObject(RockBand.example2());
manager.registerObject(instance, "RockBand example2");
uow.commit();
}
