Content Services (ECM)
Process Services (BPM)
Application Development Framework
Digital Business Platform
Announcements & Opportunities
Alfresco Ambassador Program
Alfresco Content Services (ECM)
to create and rate content, and to follow, bookmark, and share content with other members. Not a member?
Oracle OCI Driver
Question asked by
on Jun 25, 2009
on Jun 25, 2009 by pbkoob
Show 0 Likes
Is it possible to use Oracle OCI driver for alfresco 3.x?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Jun 25, 2009 2:53 PM
I am able to connect to Alfresco with an Oracle OCI driver.
This is what I did.
Install the Oracle client on the server. Do not install a "Quick Client", it has to be the full client with all the JDBC libraries. Then edit the sqlnet.ora and the tnsnames.ora, found at \ORACLE\product\10.2.0\client_1\NETWORK\ADMIN\, to connect to your database. Verify it connects to your database with SqlPlus.
Copy \oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14_g.jar to \Alfresco\tomcat\lib
Comment out the Derby hibernate dialect
Add to the bottom the Oracle hibernate dialect:
# Oracle dialect
Comment out the Derby connection
Add the Oracle Connection
Edit db.name to be your database
(as specified in your Oracle tnsnames.ora)
Edit db.username to be your database id
Edit db.password to be your database password
Add to the bottom the Oracle connection:
# Oracle Connection
I cannot testify as to whether this kosher, only an Alfresco Engineer can do that, but it does work.
A note here; if your database externally identifies users ( RADIUS ) you cannot use the thin client, you have to use OCI.
Show 0 Likes
Retrieving data ...
Deploying and Running Alfresco Content Services 6.0
Determine which sandbox is previewed
Creating your first application with ADF
Deploying Alfresco Content Services Community Edition 201806 GA
Running and using the application