thanks. it works, it's really my fault!
liufengyi2006123
From: Rick Curtis [via OpenJPA]
Date: 2013-05-14 20:44
To: fengyi
Subject: Re: i have some trouble use the third-party datasource
Change the property name from openjpa.connectionProperties to openjpa.C
onnectionProperties.
Thanks,
RIck
On Mon, May 13, 2013 at 10:16 PM, fengyi <[hidden email]> wrote:
> Hi everyOne:
> openJpa version :2.2.1
> i want to use c3p0 as my datasourcePool
>
> this is my configuration fragment
> <property name="openjpa.ConnectionDriverName"
> value="com.mchange.v2.c3p0.ComboPooledDataSource"/>
> <property name="openjpa.connectionProperties"
>
> value="driverClass=com.mysql.jdbc.Driver,jdbcUrl=jdbc:mysql://
> 127.0.0.1:3306/test?zeroDateTimeBehavior=round,user=root,password=root,initialSize=10,maxIdle=20,minIdle=5,maxActive=50,MaxWait=10000,timeBetweenEvictionRunsMillis=3600000,minEvictableIdleTimeMillis=18000000
>
> "/>
>
>
> and the error is
>
> No cache marshaller found for id
> org.apache.openjpa.conf.MetaDataCacheMaintenance.
> 2013-05-14 11:10:11,824 DEBUG [openjpa.MetaData] - Using metadata factory
> "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1a4dbed".
> 2013-05-14 11:10:11,851 INFO [openjpa.jdbc.JDBC] - Using dictionary class
> "org.apache.openjpa.jdbc.sql.MySQLDictionary".
> 2013-05-14 11:10:12,088 DEBUG [openjpa.jdbc.JDBC] -
> createConnectionFactory:
> DataSource=com.mchange.v2.c3p0.ComboPooledDataSource@1afbff[
> acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay ->
> 1000, autoCommitOnClose -> false, automaticTestTable -> null,
> breakAfterAcquireFailure -> false, checkoutTimeout -> 0,
> connectionTesterClassName ->
> com.mchange.v2.c3p0.impl.DefaultConnectionTester, description -> null,
> driverClass -> null, factoryClassLocation -> null,
> forceIgnoreUnresolvedTransactions -> false, identityToken -> 1afbff,
> idleConnectionTestPeriod -> -1, initialPoolSize -> 3, jdbcUrl -> null,
> loginTimeout -> 0, maxIdleTime -> 0, maxPoolSize -> 15, maxStatements -> 0,
> maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3,
> preferredTestQuery -> null, properties -> {}, propertyCycle -> 300,
> testConnectionOnCheckin -> false, testConnectionOnCheckout -> false,
> usesTraditionalReflectiveProxies -> false ]
> 2013-05-14 11:10:12,118 DEBUG [openjpa.jdbc.JDBC] - DataSource connection
> setAutoCommit to "false"
> 2013-05-14 11:10:41,257 ERROR [AppLogger] - SYS99999
> <openjpa-2.2.1-runknown nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: There were errors
> initializing your configuration: <openjpa-2.2.1-runknown fatal user error>
> org.apache.openjpa.util.UserException: A connection could not be obtained
> for driver class "com.mchange.v2.c3p0.ComboPooledDataSource" and URL
> "null".
> You may have specified an invalid URL.
>
>
> i follow the manual guide. but the driverClass and jdbcUrl cann't set to
> the
> pool。
> so ,is there any wrong with my configuration
>
> btw,when a config a slice with c3p0 .it works
>
> any one can give me some help
>
>
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/i-have-some-trouble-use-the-third-party-datasource-tp7583896.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>
--
*Rick Curtis*
If you reply to this email, your message will be added to the discussion below:
http://openjpa.208410.n2.nabble.com/i-have-some-trouble-use-the-third-party-datasource-tp7583896p7583900.html
To start a new topic under OpenJPA Users, email
[email protected]
To unsubscribe from OpenJPA Users, click here.
NAML
--
View this message in context:
http://openjpa.208410.n2.nabble.com/i-have-some-trouble-use-the-third-party-datasource-tp7583896p7583905.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
