I can't say for sure, but this is consistent with something wrong with the config file. Try setting up the JDBCStorageClient using the web console. When it writes the config file, you can check that against the one you're using.
Avoid using the bundle location property if you do copy a config file produced by the console, because it's the one that will become obsolete if your bundle file name ever changes. I hope we can find a way for bundles to fail more loudly if they find a problem with configuration. As it is, they quietly start up with all the defaults, which is almost never what you want. Zach On May 11, 2012, at 11:49 AM, Max Whitney <[email protected]> wrote: > Continuing with the theme of "Max Whitney, making mistakes so newbies don't > have to" > > I'm at a loss on how to get OAE 1.2 to appropriately build sparsemapcontent > objects in an Oracle 10.2.0.5 database. > Here are my steps: > > (1) Grab the OAE nakamura zip from > https://github.com/sakaiproject/nakamura/tree/nakamura-1.2.0 > (2) Unzip and head down to the contrib/oracle-jdbc directory > (3) Grab ojdbc14.jar for 10.2.0.5 from Oracle at > http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html. > Put the ojdbc14.jar file in contrib/oracle-jdbc directory > (4) in contrib/oracle-jdbc do a mvn clean install. This succeeds, and > appears to load the needed material into my maven repository > (5) Edit list.xml in app/src/main/bundles/ replacing > <artifactId>org.sakaiproject.nakamura.postgreswrapper</artifactId> with > <artifactId>org.sakaiproject.nakamura.ojdbc</artifactId> > (6) Create JDBCStorageClientPool.config in > sling/config/org/sakaiproject/nakamura/lite/storage/jdbc/ (creating the > directories as well, since this is the very first run. > Contents of the config file are akin to > > service.pid="org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool" > jdbc-driver="oracle.jdbc.driver.OracleDriver" > jdbc-url="jdbc:oracle:thin:@example.edu:1521:SID0" > password="pass" > username="user" > store-base-dir="store" > Where jdbc-url, password and username are customized for my location, > and service.pid, jdbc-drive and store-base-dir are exactly as configured for > the app. > > (7) Run OAE with ./tools/run_production.sh & > (8) sling/log/error.log shows nakamura resolving and starting ojdbc[1], > but subsequently initializing Apache for sparsemap usage [2]. The system > never even tries to reach oracle. > > Any pointers would be gratefully received. > -- Max > > > > [1] ============== > 11.05.2012 12:32:56.675 *INFO* [FelixDispatchQueue] > org.sakaiproject.nakamura.ojdbc BundleEvent RESOLVED > 11.05.2012 12:32:56.682 *INFO* [FelixDispatchQueue] > org.sakaiproject.nakamura.ojdbc BundleEvent STARTED > > [2] ============== > 11.05.2012 12:33:03.438 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency not satisfied: > clientPool > 11.05.2012 12:33:03.439 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency not satisfied: > principalValidatorResolver > 11.05.2012 12:33:03.445 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.RepositoryImpl] Not all dependencies > satisified, cannot activate > 11.05.2012 12:33:03.460 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency Manager: Service > principalValidatorResolver registered, activate component > 11.05.2012 12:33:03.462 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency not satisfied: > clientPool > 11.05.2012 12:33:03.463 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.RepositoryImpl] Not all dependencies > satisified, cannot activate > 11.05.2012 12:33:03.474 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core Service > [org.sakaiproject.nakamura.lite.accesscontrol.PrincipalValidatorResolverImpl,44] > ServiceEvent REGISTERED > 11.05.2012 12:33:03.499 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core Service > [org.sakaiproject.nakamura.lite.http.SparseSessionTrackerImpl,45] > ServiceEvent REGISTERED > 11.05.2012 12:33:03.500 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] > Dependency not satisfied: repository > 11.05.2012 12:33:03.501 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] > Dependency not satisfied: propertyMigratorTracker > 11.05.2012 12:33:03.501 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] > Not all dependencies satisified, cannot activate > 11.05.2012 12:33:03.526 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] > Dependency Manager: Service propertyMigratorTracker registered, activate > component > 11.05.2012 12:33:03.526 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] > Dependency not satisfied: repository > 11.05.2012 12:33:03.526 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core > [org.sakaiproject.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] > Not all dependencies satisified, cannot activate > 11.05.2012 12:33:03.540 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.core Service > [org.sakaiproject.nakamura.lite.storage.jdbc.migrate.PropertyMigratorTrackerService,46] > ServiceEvent REGISTERED > 11.05.2012 12:33:03.651 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Loaded > Driver Class class org.apache.derby.jdbc.EmbeddedDriver with classloader 48.0 > 11.05.2012 12:33:04.336 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Created > Driver Instance as org.apache.derby.jdbc.EmbeddedDriver@16f21478 > 11.05.2012 12:33:04.336 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Loaded > Database Driver org.apache.derby.jdbc.EmbeddedDriver as class > org.apache.derby.jdbc.EmbeddedDriver > 11.05.2012 12:33:04.337 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool JDBC Driver > Registration [org.apache.derby.jdbc.AutoloadedDriver@513b8f62] [class > org.apache.derby.jdbc.AutoloadedDriver] [48.0] > 11.05.2012 12:33:07.348 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool No SQL > configuation at > org/sakaiproject/nakamura/lite/storage/jdbc/config/client.ApacheDerby.10.6.sql > > 11.05.2012 12:33:07.348 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool No SQL > configuation at > org/sakaiproject/nakamura/lite/storage/jdbc/config/client.ApacheDerby.10.sql > 11.05.2012 12:33:07.352 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Using SQL > configuation from > org/sakaiproject/nakamura/lite/storage/jdbc/config/client.ApacheDerby.sql > 11.05.2012 12:33:08.073 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Starting > Sparse Map Content database > 11.05.2012 12:33:08.074 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Database > Vendor: Apache Derby 10.6.2.1 - (999685) > 11.05.2012 12:33:08.074 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Database > Driver: org.apache.derby.jdbc.EmbeddedDriver > 11.05.2012 12:33:08.074 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool Database > URL : jdbc:derby:sling/sparsemap/db;create=true > 11.05.2012 12:33:08.115 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient Schema does not > exist Schema 'SA' does not exist > 11.05.2012 12:33:08.117 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient No Schema found > at > org/sakaiproject/nakamura/lite/storage/jdbc/config/client.ApacheDerby.10.6.ddl > > 11.05.2012 12:33:08.118 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient No Schema found > at > org/sakaiproject/nakamura/lite/storage/jdbc/config/client.ApacheDerby.10.ddl > 11.05.2012 12:33:08.356 *INFO* [FelixStartLevel] > org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient SQL OK > org/sakaiproject/nakamura/lite/storage/jdbc/config/client.ApacheDerby.ddl:7 > CREATE TABLE css ( id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START > WITH 1, INCREMENT BY 1), rid varchar(32) NOT NULL, ci > d varchar(64) NOT NULL, v varchar(780) NOT NULL, primary key(id)) > > > > _______________________________________________ > oae-dev mailing list > [email protected] > http://collab.sakaiproject.org/mailman/listinfo/oae-dev
_______________________________________________ oae-dev mailing list [email protected] http://collab.sakaiproject.org/mailman/listinfo/oae-dev
