dbcp « Database « Spring Q&A





1. DBCP connection validation problem    stackoverflow.com

I decided to use DBCP mainly because I was getting timeouts on my database connections. In theory, once you define a "validation query", DBCP will by default run that ...

2. Get number of free connections in connection pool    stackoverflow.com

In my project Spring manages connection pool with org.apache.commons.dbcp.BasicDataSource class. Is possible to get how many connections are free or used in current time? Thanks.

3. Connection Pool hangs using Glassfish and Apache DBCP with Spring    stackoverflow.com

We have a Spring application that uses Apache DBCP for connection pooling. Our app has been in production for almost a year with no problems. However, during the past ...

4. What's the proper way to handle JDBC connections with Spring and DBCP?    stackoverflow.com

I'm using the Spring MVC to build a thin layer on top of a SQL Server database. When I began testing, it seems that it doesn't handle stress very well :). ...

5. Spring DBCP connection pooling | configuring the retry count    stackoverflow.com

Is there any way to specify the 'retry' count in Spring - DBCP connection pooling? If the connection is not obtained for the first time, I want to try it atleast 3 ...

6. Spring JDBC with Tomcat DBCP and multiple datasources    stackoverflow.com

I am using spring with have multiple datasources (catering to multiple mysql dbs) and using tomcat dbcp. I am getting some weird exceptions like

  • procedure not found - when the proc ...

7. Refresh DataSource using Spring+dbcp    stackoverflow.com

I'm using Spring with DBCP and need to refresh my datasource when some configuration on operation environment changes, without restart all application. Without DBCP, I force this refresh closing and starting another ...

8. How to specify schema for SQL Server in JDBC Spring configuration    stackoverflow.com

We are using the org.apache.commons.dbcp.BasicDataSource as parent class for our datasources in Spring. Is it possible to specify which schema to use in either the "url" or in another property in the ...

9. Spring CallableStatementCreator    stackoverflow.com

Hi I m new to spring.I ve tried accessing a stored proc using CallableStatementCreator ,but i get foll error.

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ...





10. Setting connection timezone with Spring and DBCP and MySQL    stackoverflow.com

My Enviroment

  • Java 5
  • Spring 2.5.5
  • DBCP DataSource (org.apache.commons.dbcp.BasicDataSource)
  • MySQL
Similar posts Links My Problem
  • I need to set on my connection the timezone, aiming to prevent the conversions when ...

11. Connections not closed Spring with tomcat 5.5    stackoverflow.com

We are using a j2ee application with spring framework 2.0. The server used is tomcat 5.5. The database used is mysql. We are using a VPS for hosting our application and ...

12. DBCL message on console    stackoverflow.com

I am creating a database connection pool with following properties.

<bean id="complianceCCRDataSource" class="org.apache.commons.dbcp.BasicDataSource" 
        destroy-method="close" lazy-init="false" >

    <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" /> 
 ...

13. tomcat dbcp and mysql connection pooling    stackoverflow.com

I am using a tomcat dbcp along with spring jdbc. When I start the server for first time and try to load the web-page it fetches the data from database and ...

14. Stored Proc slower from application than Management Studio    stackoverflow.com

We have a stored proc which runs pathetically when called from application (Spring - DBCP - jtds) infact timesout after 10 minutes, but runs in 30 seconds when executed from SQL ...

15. DBCP + IBATIS inserts do not work    forum.springsource.org

DBCP + IBATIS inserts do not work Is anyone out there using IBATIS + DBCP (I am using with an oracle 9 database). When i use Spring to define my DBCP ...

16. How do I create a org.apache.commons.dbcp.PoolableConnection    forum.springsource.org

I've written a web application using spring/hibernate/tapestry to talk to MS SQL server 7. It does not use connection pooling and the resulting performance is very poor. I know I need ...





17. pooling: ConnectionPoolDataSource & dbcp    forum.springsource.org

i want to use connection pooling in my application. should i use javax.sql.ConnectionPoolDataSource or commons dbcp? what are the pros/cons of each approach?

18. defaultautocommit in dbcp datasource    forum.springsource.org

I am using a dbcp BasicDataSource and a TransactionInterceptor. For some reason it is autocommiting even though the log says Switching JDBC connection [org.apache.commons.dbcp.PoolableConnection@3a0ab1] to manual commit. My inserts into the ...

19. DBCP & tomcat leave connections upon redeploy.    forum.springsource.org

DBCP & tomcat leave connections upon redeploy. We have an app which defines JNDI resources inside spring [dataAccess.xml] as Code: org.springframework.jndi.JndiObjectFactoryBean and uses both JDBC template and StoreProcedure data access. In ...

20. Establishing JDBC Connection pooling with commons dbcp    forum.springsource.org

Hello Everyone, I have been looking around for a datasource implementation using Pooling DataSource. Now i am pretty familiar with the BasicDataSource and its use and configuration in spring xml files. ...

21. connection pooling error with dbcp    forum.springsource.org

Hai braniees i am using commons.dbcp.basicdatasource.I am getting the error org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.oracleDriver' while i am using ds.getConnection(username,password); have placed all the jars,even i extracted the class ...

22. junit problem with commons dbcp    forum.springsource.org

Sep 2nd, 2005, 03:47 AM #1 silly_me View Profile View Forum Posts Private Message Member Join Date Jun 2005 Location San Mateo, CA Posts 34 junit problem with commons dbcp When ...

23. Help with DBCP    forum.springsource.org

Help with DBCP I am converting my app to use dbcp instead of DriverManagerDataSource, and i do not know where to set the "driverClassName" in dbcp. Here is what my old ...

24. Database connection lost when using apache dbcp    forum.springsource.org

Database connection lost when using apache dbcp Hi, I have an application that uses a BasicDataSource bean from apache dbcp, like this: com.mysql.jdbc.jdbc2.optional.MysqlDataSour ce ...

25. Spring can't find DBCP in Ant    forum.springsource.org

Spring can't find DBCP in Ant Hello, all I wrote the following codes, but it failed to work: org.postgresql.Driver ...... ...

26. Spring JDBC, DBCP and Oracle ARRAY type interaction    forum.springsource.org

Spring JDBC, DBCP and Oracle ARRAY type interaction I'm writing a standalone Java application that uses Commons-DBCP for connection pooling. My connection pool is talking to an Oracle 9i database and ...

27. Configuring DBCP with eXist in Tomcat using Spring XML:DB    forum.springsource.org

Configuring DBCP with eXist in Tomcat using Spring XML:DB Hi All, I am a newbie to the Spring XMLDB framework. I want to set up DBCP with eXist in Tomcat using ...

28. DBCP vs. C3PO.    forum.springsource.org

DBCP vs. C3PO. Hello Everyone, We have a multithreaded database application using the DBCP BasicDataSource. However we are having a problem where the number of connections run out after a few ...

29. dbcp Problem!    forum.springsource.org

dbcp Problem! Hi, I am getting this exception when i run my JSP. Could someone please look into it. It is sort of urgent! Code: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; ...

30. Spring, DBCP connection pool and MySQL application slowdown problem    forum.springsource.org

Aug 28th, 2006, 12:02 PM #1 getbymail View Profile View Forum Posts Private Message Junior Member Join Date Aug 2006 Posts 1 Spring, DBCP connection pool and MySQL application slowdown problem ...

31. Enquiry: Commons DBCP    forum.springsource.org

32. Enquiry: Commons DBCP - @DB-DRIVERNAME@    forum.springsource.org

appContext-resources.xml . . . I dont understand what does mean. What is the value of driverClassName? I'm only know if using ...

33. Setting up DBCP with Tomcat 5.5.x    forum.springsource.org

Oct 27th, 2006, 03:01 AM #1 snike View Profile View Forum Posts Private Message Junior Member Join Date Aug 2006 Location Australia Posts 7 Setting up DBCP with Tomcat 5.5.x I ...

34. DBCP and Spring StoredProcedure - Could not close JDBC Statement    forum.springsource.org

DBCP and Spring StoredProcedure - Could not close JDBC Statement Hi , i am getting following error when multiple users start using the system.we use spring StoredProcedure class to retrieve the ...

35. Spring, Ibatis and Apache DBCP Commons Pool    forum.springsource.org

Sep 13th, 2007, 09:23 AM #1 TraceyAnnison View Profile View Forum Posts Private Message Member Join Date Nov 2006 Posts 31 Spring, Ibatis and Apache DBCP Commons Pool We are using ...

36. Error with WAS 6.1 + commons-pool1.3 + dbcp 1.2.1    forum.springsource.org

Error with WAS 6.1 + commons-pool1.3 + dbcp 1.2.1 Hi All, I have created a datasource with below entru in application context: com.ibm.db2.jcc.DB2D river jdbc:db2://[SERVER]:50000/[DB]/value> ...

37. Set max lifetime for connections in DBCP pool?    forum.springsource.org

Set max lifetime for connections in DBCP pool? Hi, I'm working with an Oracle 10g that seems to leak memory, e.g. each connection slowly but constantly allocates more and more memory ...

38. dbcp.Sql Exception :Wrong Database file    forum.springsource.org

Hi, I'm using Spring framework 2.5, hibernate 3, hsqldb 1.7.3 and respective jars in my project, It is building successfully but when I try to run it is giving Error: Wrong ...

39. ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection    forum.springsource.org

ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection Hi I'm getting java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection, when i try to call the Stored Procedure with Oracle Types. In my method, total there are 4 parameters. 1 OUT parameter and 3 ...

40. Too many connections in dbcp pool    forum.springsource.org

Too many connections in dbcp pool Hai all, i got the following error when using dbcp datasource in tomcat5. org.springframework.jdbc.UncategorizedSQLException : (Hibernate operation): encountered SQLException [Cannot create PoolableConnectionFactory (Data source rejected ...

41. DBCP following code was never closed    forum.springsource.org

DBCP following code was never closed I am getting following error DBCP object created 2008-10-16 16:58:32 by the following code was never closed: Environment is Spring 2.5.4 ,Hibernate3.1.3 Struts 1.2.8 with ...

42. DBCP - Keep alive    forum.springsource.org

Hi All, How to keep the DBCP connection pool alive for indefinite period of time, in spring? When the connection is idle, the connection is closed and so while trying to ...

43. commons-dbcp and "referenced pointcut"    forum.springsource.org

commons-dbcp and "referenced pointcut" hi there: When spring read my "datasource" in the xml, which refers to "org.apache.commons.dbcp.BasicDataSource", it throws an error: : Cannot resolve reference to bean 'dataSource' while setting ...

44. dbcp data source and validation queries    forum.springsource.org

I'm using the dbcp BasicDataSource that Roo ships with and notice that, with MySQL, connections time out after 8 hours of inactivity, but dbcp does not check the connection status before ...

45. dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection    forum.springsource.org

Feb 25th, 2010, 05:01 AM #1 Dacheng View Profile View Forum Posts Private Message Junior Member Join Date Feb 2010 Posts 3 dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection Hi, I am ...

46. Additional DBCP settings    forum.springsource.org

Thanks Rod unfortunately most of my daily work are other (not spring enabled) projects so sometimes "you don't to see the wood for the trees" when switching from complicated to easy. ...

47. org.apache.commons.dbcp.SQLNestedException:Cannot create JDBC driver:No suitable driv    forum.springsource.org

Jul 28th, 2010, 05:33 PM #1 winifred View Profile View Forum Posts Private Message Junior Member Join Date Jul 2010 Posts 6 org.apache.commons.dbcp.SQLNestedException:Cannot create JDBC driver:No suitable driv Hi, All I ...

48. Problem with commons.dbcp    forum.springsource.org

Problem with commons.dbcp Hi... Im working on a project where i want to convert an existing Spring MVC application to a set of bundles. So far i've managed to move most ...

49. osgi+dbcp connection    forum.springsource.org

osgi+dbcp connection just now I'm trying to get connection to mysql db in springDM osgi environment.then I come accross strange problems.my project stucks,niether it runs other jobs nor throws exceptions. I ...

50. org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class ''    forum.springsource.org

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' Hi all I am working on a web based project using spring ,hybernate +jpa .I am trying to configure JTA Transactions with Atomkios ...