[Building Sakai] using c3po

[Thomas Amsler]

You have to modify sakai.properies, components.xml, and pom.xml files.
I have attached some patches that we have used for our 2.5.x
environment.

Our sakai properties looked something like this. NOTE, the property
names are different for c3p0 than they are for DBCP:


## Oracle settings - make sure to alter as appropriate
user at javax.sql.BaseDataSource=
password at javax.sql.BaseDataSource=
vendor at org.sakaiproject.db.api.SqlService=oracle
driverClass at javax.sql.BaseDataSource=oracle.jdbc.driver.OracleDriver
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
jdbcUrl at javax.sql.BaseDataSource=
preferredTestQuery at javax.sql.BaseDataSource=select 1 from DUAL
initialPoolSize at javax.sql.BaseDataSource=100
minPoolSize at javax.sql.BaseDataSource=100
maxPoolSize at javax.sql.BaseDataSource=100

I hope this helps.

Best,
-- Thomas

On Mon, Nov 29, 2010 at 3:55 PM, Joshua Swink <joshua.swink at gmail.com> wrote:
> If I wanted to use c3po as my connection pooler, how would I go about
> setting that up?
>
> Thanks for any help.
>
> Josh
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: c3p0-db.patch
Type: application/octet-stream
Size: 8892 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101129/0e96b05b/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: c3p0-warehouse.patch
Type: application/octet-stream
Size: 1437 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101129/0e96b05b/attachment-0001.obj