Hi Max,
A couple of suggestions that address the deployment but not the build
processes. Also, we don't use the run_production.sh here.
1) Your repository.xml file that is deployed to ${sling.home} also has
to have oracle connection entries so that is one area to check.
2) You only get one chance to connect sling/jackrabbit to Oracle, IOW to
build workspaces that are backed by Oracle. That chance is the very
first time you start the application.
If you have started it and it connects to Derby, you need to clean out
the server and start again after making sure that the config files, both
repository.xml and JDBCStorageClientPool have the correct entries and
are in the correct runtime locations. See [1].
HTH and good luck!
[1]
https://confluence.sakaiproject.org/display/KERNDOC/KERN-692+Configuring+Nakamura
John K
On 5/11/12 9:49 AM, Max Whitney 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
--
John King
Applications Programmer
Learning Systems Group
Educational Technology Services
9 Dwinelle Hall - Mail
117 Dwinelle Hall - Office
University of California
Berkeley, CA 94720-2535
Phone: 510-529-5074
Email: [email protected]
_______________________________________________
oae-dev mailing list
[email protected]
http://collab.sakaiproject.org/mailman/listinfo/oae-dev
