Thursday, April 30, 2009

c3p0.properties


#c3p0.acquireIncrement
#Default: 3
#Determines how many connections at a time c3p0 will try to acquire
#when the pool is exhausted. [See "Basic Pool Configuration"]

c3p0.acquireRetryAttempts=3
#Default: 30
#Defines how many times c3p0 will try to acquire a new Connection
#from the database before giving up. If this value is less than or
#equal to zero, c3p0 will keep trying to fetch a Connection
#indefinitely. [See "Configuring Recovery From Database Outages"]

#c3p0.acquireRetryDelay
#Default: 1000
#Milliseconds, time c3p0 will wait between acquire attempts.
#[See "Configuring Recovery From Database Outages"]

#c3p0.autoCommitOnClose
#Default: false
#The JDBC spec is unforgivably silent on what should happen to
#unresolved, pending transactions on Connection close. C3P0's
#default policy is to rollback any uncommitted, pending work.
#(I think this is absolutely, undeniably the right policy, but
#there is no consensus among JDBC driver vendors.) Setting
#autoCommitOnClose to true causes uncommitted pending work to be
#committed, rather than rolled back on Connection close. [Note:
#Since the spec is absurdly unclear on this question, application
#authors who wish to avoid bugs and inconsistent behavior should
#ensure that all transactions are explicitly either committed or
#rolled-back before close is called.] [See "Configuring Unresolved
#Transaction Handling"]

#c3p0.automaticTestTable
#Default: null
#If provided, c3p0 will create an empty table of the specified name,
#and use queries against that table to test the Connection. If
#automaticTestTable is provided, c3p0 will generate its own test
#query, therefore any preferredTestQuery set will be ignored. You
#should not work with the named table after c3p0 creates it; it
#should be strictly for c3p0's use in testing your Connection. (If
#you define your own ConnectionTester, it must implement the
#QueryConnectionTester interface for this parameter to be useful.)
#[See "Configuring Connection Testing"]

#c3p0.breakAfterAcquireFailure
#Default: false
#If true, a pooled DataSource will declare itself broken and be
#permanently closed if a Connection cannot be obtained from the
#database after making acquireRetryAttempts to acquire one. If
#false, failure to obtain a Connection will cause all Threads
#waiting for the pool to acquire a Connection to throw an Exception,
#but the DataSource will remain valid, and will attempt to acquire
#again following a call to getConnection(). [See "Configuring
#Recovery From Database Outages"]

#c3p0.checkoutTimeout
#Default: 0
#The number of milliseconds a client calling getConnection() will
#wait for a Connection to be checked-in or acquired when the pool
#is exhausted. Zero means wait indefinitely. Setting any positive
#value will cause the getConnection() call to time-out and break
#with an SQLException after the specified number of milliseconds.

#c3p0.connectionTesterClassName
#Default: com.mchange.v2.c3p0.impl.DefaultConnectionTester
#The fully qualified class-name of an implememtation of the
#ConnectionTester interface, or QueryConnectionTester if you would
#like instances to have access to a user-configured preferredTestQuery.
#This can be used to customize how c3p0 DataSources test Connections,
#but with the introduction of automaticTestTable and preferredTestQuery
#configuration parameters, "rolling your own" should be overkill for
#most users. [See "Configuring Connection Testing"

#c3p0.factoryClassLocation
#Default: null
#DataSources that will be bound by JNDI and use that API's
#Referenceable interface to store themselves may specify a URL
#from which the class capable of dereferencing a them may be
#loaded. If (as is usually the case) the c3p0 libraries will
#be locally available to the JNDI service, leave this set as null.

#c3p0.forceIgnoreUnresolvedTransactions
#Default: false
#Strongly disrecommended. Setting this to true may lead to subtle
#and bizarre bugs. This is a terrible setting, leave it alone
#unless absolutely necessary. It is here to workaround broken
#databases / JDBC drivers that do not properly support transactions,
#but that allow Connections' autoCommit flags to go to false
#regardless. If you are using a database that supports transactions
#"partially" (this is oxymoronic, as the whole point of transactions
#is to perform operations reliably and completely, but nonetheless
#such databases are out there), if you feel comfortable ignoring the
#fact that Connections with autoCommit == false may be in the middle
#of transactions and may hold locks and other resources, you may
#turn off c3p0's wise default behavior, which is to protect itself,
#as well as the usability and consistency of the database, by either
#rolling back (default) or committing (see c3p0.autoCommitOnClose above)
#unresolved transactions. This should only be set to true when you
#are sure you are using a database that allows Connections'
#autoCommit flag to go to false, but offers no other meaningful
#support of transactions. Otherwise setting this to true is just
#a bad idea. [See "Configuring Unresolved Transaction Handling"]

#c3p0.idleConnectionTestPeriod=
#Default: 0
#If this is a number greater than 0, c3p0 will test all idle, pooled
#but unchecked-out connections, every this number of seconds.
#[See "Configuring Connection Testing"]

c3p0.initialPoolSize=10
#Default: 3
#Number of Connections a pool will try to acquire upon startup.
#Should be between minPoolSize and maxPoolSize. [See "Basic Pool
#Configuration"]

c3p0.maxIdleTime=600
#Default: 0
#Seconds a Connection can remain pooled but unused before being
#discarded. Zero means idle connections never expire. [See "Basic
#Pool Configuration"]

c3p0.maxPoolSize=128
#Default: 15
#Maximum number of Connections a pool will maintain at any given
#time. [See "Basic Pool Configuration"]

#c3p0.maxStatements
#Default: 0
#The size of c3p0's global PreparedStatement cache. If both
#maxStatements and maxStatementsPerConnection are zero, statement
#caching will not be enabled. If maxStatements is zero but
#maxStatementsPerConnection is a non-zero value, statement
#caching will be enabled, but no global limit will be enforced,
#only the per-connection maximum. maxStatements controls the total
#number of Statements cached, for all Connections. If set, it
#should be a fairly large number, as each pooled Connection
#requires its own, distinct flock of cached statements. As a
#guide, consider how many distinct PreparedStatements are used
#frequently in your application, and multiply that number by
#maxPoolSize to arrive at an appropriate value. Though maxStatements
#is the JDBC standard parameter for controlling statement caching,
#users may find c3p0's alternative maxStatementsPerConnection
#more intuitive to use. [See "Configuring Statement Pooling"]

#c3p0.maxStatementsPerConnection
#Default: 0
#The number of PreparedStatements c3p0 will cache for a single
#pooled Connection. If both maxStatements and
#maxStatementsPerConnection are zero, statement caching will
#not be enabled. If maxStatementsPerConnection is zero but
#maxStatements is a non-zero value, statement caching will be
#enabled, and a global limit enforced, but otherwise no limit
#will be set on the number of cached statements for a single
#Connection. If set, maxStatementsPerConnection should be set
#to about the number distinct PreparedStatements that are used
#frequently in your application, plus two or three extra so
#infrequently statements don't force the more common cached
#statements to be culled. Though maxStatements is the JDBC
#standard parameter for controlling statement caching, users
#may find maxStatementsPerConnection more intuitive to use.
#[See "Configuring Statement Pooling"]

c3p0.minPoolSize=5
#Default: 3
#Minimum number of Connections a pool will maintain at any
#given time. [See "Basic Pool Configuration"]

#c3p0.numHelperThreads
#Default: 3
#c3p0 is very asynchronous. Slow JDBC operations are generally
#performed by helper threads that don't hold contended locks.
#Spreading these operations over multiple threads can
#significantly improve performance by allowing multiple
#operations to be performed simultaneously.

#c3p0.preferredTestQuery
#Default: null
#Defines the query that will be executed for all connection
#tests, if the default ConnectionTester (or some other
#implementation of QueryConnectionTester) is being used.
#Defining a preferredTestQuery that will execute quickly
#in your database may dramatically speed up Connection tests.
#(If no preferredTestQuery is set, the default ConnectionTester
#executes a getTables() call on the Connection's
#DatabaseMetaData. Depending on your database, this may
#execute more slowly than a "normal" database query.) NOTE:
#The table against which your preferredTestQuery will be run
#must exist in the database schema prior to your initialization
#of your DataSource. If your application defines its own schema,
#try automaticTestTable instead. [See "Configuring Connection
#Testing"]

#c3p0.propertyCycle
#Default: 300
#Maximum time in seconds before user configuration constraints
#are enforced. c3p0 enforces configuration constraints continually,
#and ignores this parameter. It is included for JDBC 3 completeness.

#c3p0.testConnectionOnCheckin
#Default: false
#If true, an operation will be performed asynchronously at every
#connection checkin to verify that the connection is valid. Use
#in combination with idleConnectionTestPeriod for quite reliable,
#always asynchronous Connection testing. Also, setting an
#automaticTestTable or preferredTestQuery will usually speed
#up all connection tests. [See "Configuring Connection Testing"]

#c3p0.testConnectionOnCheckout
#Default: false
#Use only if necessary. Expensive. If true, an operation will
#be performed at every connection checkout to verify that the
#connection is valid. Better choice: verify connections periodically
#using idleConnectionTestPeriod. Also, setting an automaticTestTable
#or preferredTestQuery will usually speed up all connection tests.
#[See "Configuring Connection Testing"]

#c3p0.usesTraditionalReflectiveProxies
#Default: false
#c3p0 originally used reflective dynamic proxies for implementations
#of Connections and other JDBC interfaces. As of c3p0-0.8.5,
#non-reflective, code-generated implementations are used instead.
#As this was a major change, and the old codebase had been
#extensively used and tested, this parameter was added to allow
#users to revert of they had problems. The new, non-reflexive
#implementation is faster, and has now been widely deployed and
#tested, so it is unlikely that this parameter will be useful.
#Both the old reflective and newer non-reflective codebases are
#being maintained, but support for the older codebase may (or may not)
#be dropped in the future.

47 comments:

  1. Java Training Institutes Java Training Institutes
    Java Spring Hibernate Training Institutes in Chennai J2EE Training Institutes in Chennai J2EE Training Institutes in Chennai Core Java Training Institutes in Chennai Core Java Training Institutes in Chennai

    ReplyDelete
  2. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    Selenium training in Chennai
    Selenium training in Bangalore
    Selenium training in Pune
    Selenium Online training

    ReplyDelete

  3. Thanks for sharing this blog. This very important and informative blog.Tableau Training in Bangalore

    ReplyDelete
  4. ATN Worldwide offers a comprehensive line of maintenance, repair, and operations (MRO) products for various application in Machine Tool MRO supplier in dubai and MRO supplier in dubai .

    ReplyDelete
  5. nice post
    aws training in Hyderabad

    https://360digitmg.com/amazon-web-services-aws-training-in-hyderabad

    ReplyDelete
  6. Are you searching for Best MRO supplier in Dubai ? ATN Worldwide,LLC(ATN) is MRO supplier in Dubai. who place orders with MRO suppliers on an as-needed basis. We value our relations with our Clients and our Suppliers.

    ReplyDelete
  7. We provide influencer marketing campaigns through our network professional African Bloggers, influencers & content creators.

    ReplyDelete
  8. "Nice post! Thanks for sharing valuable article.
    Please Visit our Website supply chain"

    ReplyDelete
  9. Talk with Strangerstalk to strangers in Online Free Chat rooms where during a safe environment.
    Many users checking out free chat withomegle kids strangers look for their matches online on each day to day .Having an interview with
    strangers helps people overcome their anxiety, loneliness, and over-stressed lives.So as to
    speak with strangers, the users talk to strangersshould skills to protect themselves from online scams and frauds.
    Chat with random people online anonymously is becoming common as fast because the technology and
    web are advancing.Talking to strangerschat random and having random conversations with random people is great
    especially if it's no login and requires no check in chat in our international chat rooms.
    Our aim isfree chat to form your chatting experience as fast, easy and best by using our random text chat,
    as pleasant, fun and successful as possible.dirty chat Chat with random people online with none log in.

    ReplyDelete
  10. SSC Result 2020 Published Date & Time by ssc result 2020
    ssc result 2020
    Education Board of Bangladesh.
    Many of You Search For SSC Result Kobe Dibe on Internet
    as Well as Facebook. The results of Secondary School Certificate
    (SSC)—and its equivalent examinations—for 2020 have been published.
    SSC & Dakhil Result 2020 Published Date is Very Important For T
    he Students Who Attend The SSC Exam 2020.

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. Your article was perfect had helped me alot in finding the right thing i had searching this stuff thank you so much for provding me this information.me been very sad after reading this announcement…


    jantar mantar in delhi


    insectsight


    womens cardigans

    tour to kodaikanal

    places to visit in naintal

    places to visit in delhi

    ReplyDelete
  13. thank you for this great work. The online Turkey entry visa platform offer the fast e visa services. And you get the all information related to visa easily online. you just need to follow some easy steps such as fill visa application form, upload documents & photos, make online payement for your e visa.

    ReplyDelete
  14. 와! 놀랍고 유용한 게시물입니다. 정말 좋아요. 너무 좋고 너무 멋져요. 나는 단지 놀랐다. 앞으로도 이런 일을 계속 해주시길 바랍니다 먹튀검증

    ReplyDelete
  15. 와! 놀랍고 유용한 게시물입니다. 정말 좋아요. 너무 좋고 너무 멋져요. 나는 단지 놀랐다. 앞으로도 이런 일을 계속 해주시길 바랍니다 먹튀검증

    ReplyDelete
  16. examresultub.com is an extensive educational portal. Students, parents,
    teachers and educational institute can get Board Exam Result,
    Admission, Academic Result, Career, Study Material for Assignments,
    Institutes and latest Educations News in Bangladesh.


    Exam Result:
    BPSC is published the bcs exam result 2021 on bpsc.gov.bd result website- https://examresulthub.com/

    Bangladesh Education Board is published the hsc exam result 2021 online on examresulthub.com.
    Download the full marksheet with number from here- https://examresulthub.com/hsc-result/


    The Ministry of Education has published hsc admission result 2021 for admission in higher secondary level in Bangladesh.


    Full Resources:
    https://examresulthub.com/sitemap/


    official website:
    examresulthub.com

    ReplyDelete
  17. I’m still learning from you, while I’m improving myself. I certainly enjoy reading everything that is written on your website.Keep the posts coming. I loved it!
    먹튀검증

    ReplyDelete
  18. DSHE is published the All Subject Class 10 Assignment Answer 2022 for all week on assignment.examresulthub.com.
    Want to check the all assignment work and answer, make sure to follow the below subjectwise links:

    DSHE is published the SSC Assignment Answer 2021 for Class 10 for three weeks. lets check the assignment work with answer.

    ReplyDelete
  19. I am heartily impressed by your blog and learn more from your article. Thank you so much for sharing with us. I find another blog as like it. If you want to look visit here Wikipedia for more information.

    ReplyDelete
  20. Nice article thank you for this. Check the Kenya visa requirements before you apply for the Kenya visa through online visa application. The e visa application offers the fast visa services. Thank you

    ReplyDelete
  21. Thanks for sharing this fantastic blog, really very informative. Your writing skill is very good, you must keep writing this type of blogs
    salon at home near me
    home salon services near me
    Waxing Salon At home in Noida
    beauty services at home near me

    ReplyDelete
  22. Fast-track your data analytics and machine learning course with guaranteed placement opportunities. Most extensive, industry-approved experiential learning program ideal for future Data Scientists.

    ReplyDelete
  23. Such a very informative article... I appreciate your work, keep it up... Is India issuing tourist visas? Great news for international travelers India started issuing tourists visas again and travelers have more time to explore India because the Indian government restored long-term visas.

    ReplyDelete
  24. Hello guys , You can fill your India visa online application form yourself within 5 to 10 minutes. You can visit our website and read all the procedures related to India Visa…

    ReplyDelete
  25. As a freelancer, your advice on productivity in this blog is gold. It's helping me streamline my work and achieve better results. Azerbaijan Airlines merges with Buta Airways, enhancing travel options.

    ReplyDelete
  26. I thoroughly enjoyed reading your article on c3p0 properties. The detailed insights you provided are immensely valuable for anyone working with Hibernate and looking to optimize database connections. Your clear explanations and examples make it easy for readers to understand and implement these concepts effectively.

    On a related note, I recently came across Imarticus Learning's Data Science Course, and I must say it's an excellent resource for those aspiring to delve into the field of data science. The comprehensive curriculum, hands-on projects, and industry-relevant training set it apart. The course not only covers the fundamentals but also delves into advanced topics, providing a well-rounded learning experience. It's great to see educational platforms like Imarticus Learning contributing to the growth of professionals in the data science domain. I appreciate the valuable content you share, and I look forward to exploring more from both your blog and Imarticus Learning.

    ReplyDelete